[mythtv-users] Backing up mysql database.

[jack snodgrass]

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
and
mysqldump --skip-opt -hhost -uuser -ppasswd mythconverg >
mythconverg.simple.dump

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.

jack