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

[Jon Boehm]

Mike

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 >
~path/to/mythtvv_backup.sql.bz2

Thanks,
Jon

---------------------------------------------

> 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
mythtv-users[at]mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users