[mythtv-users] How to: Recover 2GB from /var/log/mysql (Ubuntu, Mysql)

Jon Boehm boehm100 at comcast.net
Thu Mar 22 19:05:24 UTC 2007


At least in my setup the mythtv user does not have RELOAD privleges.  But
thanks for your suggestion. It shortens the command and specifies only the
myth db.

mysqldump -u root  --delete-master-logs mythconverg -c | bzip2 >



> This method, whilst it works is a bit of overkill for the required
> result. For instance, if you run more than one database, as I do, you
> get them all in the same dump file - not really convenient if you then
> need to edit the SQL before you reload one of them. You can get away
> with the following, which just uses the mythtv username, so can run in
> the maintenance overnight cron job (run as user mythtv):

> mysqldump --delete-master-logs mythconverg > /path/mythtv-backup.sql

> Works for me.

> Mike Perkins
mythtv-users mailing list

More information about the mythtv-users mailing list