[mythtv-users] Mysql backup

Carlos Cordero ccstx at charter.net
Fri Mar 12 12:43:36 EST 2004


This is a different scenario:

>From Old System:

Have backup of database and .nuv files

New System:

Database has information I don't want to lose.  (shows info) + more and new
.nuv files

Problem:  What tables to use from old system to recover old shows info
without losing new info.

Thanks!! I hope it made sense.

C.


-----Mensaje original-----
De: mythtv-users-bounces at mythtv.org [mailto:mythtv-users-bounces at mythtv.org]
En nombre de Chris Petersen
Enviado el: Friday, March 12, 2004 10:14 AM
Para: mythtv-users at mythtv.org
Asunto: Re: [mythtv-users] Mysql backup

> 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.

service mysqld stop
tar jcf mysql.tar.bz2 /var/lib/mysql
service mysqld start

You can do this without stopping mysql, but you risk a corrupted archive
if the database is written to during the tar (we do this at work for a
system that can't be stopped, and I'd say about 1 in 10-20 hourly
backups gets corrupted)

to restore, just copy back to /var/lib/

All this, of course, is assuming that mandrake stores things in the same
place as redhat and the official mysql rpm.

-- 
Chris Petersen
Programmer / Web Designer
Silicon Mechanics:  http://www.siliconmechanics.com/
Blade Servers:      http://www.siliconmechanics.com/c292/blade-server.php
1U Servers:         http://www.siliconmechanics.com/c272/1u-server.php


_______________________________________________
mythtv-users mailing list
mythtv-users at mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users



More information about the mythtv-users mailing list