[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
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
More information about the mythtv-users
mailing list