[mythtv-users] Backing up mysql database.
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 at dwf.com
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
if you want to do that too.
More information about the mythtv-users