[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