[mythtv-users] Backing up mysql database.

jack snodgrass mrlinuxgroups at gmail.com
Wed Sep 5 08:51:03 UTC 2007

On 9/5/07, clemens at dwf.com <clemens at dwf.com> wrote:
> Is there any advantage in using one of the mysql backup programs over
> just taring up /var/lib/mysql/mysql and /var/lib/mysql/mythconverg ?
> --
>                                         Reg.Clemens
>                                         reg at dwf.com

I like:

mysqldump --opt -hhost -uuser -ppasswd mythconverg > mythconverg.dump
mysqldump --skip-opt -hhost -uuser -ppasswd mythconverg >

The 2nd one is used to be able to edit the dump file with an editor
and find stuff
easily. The first one is to do a restore if needed.

mysqldump lets you restore a single table or even a single record... you just
have to copy the sql statemet out of the file and run it on a mysql
server... if you
just copy the raw db files... all you can do us restore a raw db.  If
you dump the
data, you can do a lot more stuff with it and you can create a new db
from scratch
if you want to do that too.


More information about the mythtv-users mailing list