[mythtv-users] Problem with latest run of optimize_mythdb.pl

Hika van den Hoven hikavdh at gmail.com
Sun Dec 27 17:45:27 UTC 2015


Hoi Hika,

Sunday, December 27, 2015, 6:35:35 PM, you wrote:

> Hoi Craig,

> Sunday, December 27, 2015, 6:29:57 PM, you wrote:

>> I've never tried phpmyadmin.  I'm assuming it is an installable package?
>> Probably a better approach (simpler?), but for now I'd probably stick with
>> command-line operations.

>> --
>> Craig.

> You have to set it up on a webserver, so not something to do fast.
> I'll lookup the commands. I believe they call it truncating. Emtying
> the table but keeping the structure.

> Tot mails,
>   Hika                            mailto:hikavdh at gmail.com

The command is described here:
http://dev.mysql.com/doc/refman/5.6/en/truncate-table.html
so if you log in on the mythconverg database with sufficient rights:
TRUNCATE TABLE 'recordedseek'
should do the job.

Tot mails,
  Hika                            mailto:hikavdh at gmail.com

"Zonder hoop kun je niet leven
Zonder leven is er geen hoop
Het eeuwige dilemma
Zeker als je hoop moet vernietigen om te kunnen overleven!"

De lerende Mens



More information about the mythtv-users mailing list