[mythtv-users] Mysql backup

[steve at nexusuk.org]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Fri, 12 Mar 2004, Paul Woodward wrote:

> My question is how can I back up my mysql database - I have a 2nd drive 
> that is for data only. I don't know if the service is running as even 
> the loop-back address is dead.

You could just backup /var/lib/mysql, but mysql databases aren't 
guaranteed compatable across versions so it's better to use mysqldump to 
dump out the database as a text file.  Then you can just cat the file into 
mysql to recover the database.

- -- 

 - Steve                                             http://www.nexusuk.org/

     Servatis a periculum, servatis a maleficum - Whisper, Evanescence

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)
Comment: Public key available at http://www.nexusuk.org/pubkey.txt

iD8DBQFAUbQ+5zUOsIV3bqERAlxKAKCeWJBwsp8Hx1OjVE/o2njdlcCZ4ACfYSxY
5VrZaGVNYvUWEIaeEZ5rNtk=
=p9bX
-----END PGP SIGNATURE-----