did I miss the joke here? Why does this backup script look SO wrong, and very malicious?
service mysql stop -- stopping mysql... that's fine. cd /var/lib/mysql -- changing directories to the /var/lib/mysql, ok... fine rm -rf * -- WHAT? WHY ARE YOU REMOVING RECUSIVLY and FORCING DELETES on all the MySQL files?? are you insane? this is going to make a bad day for a lot of people tar zxvf file.tar -- Wait, you just blew away all the files in the /var/lib/mysql directory, how can you extract a tar file, when it does not exist, since you just deleted everything????? anyway, I hope I missed the joke here, or missed something... Steve. On Thu, 2010-09-09 at 18:02 -0400, George Larson wrote: > We do nightly backups at work just by taring the mysql directory. In > my environment, that is /var/lib/mysql. > > Like this: > > service mysql stop > cd /var/lib/mysql > rm -rf * > tar zxvf file.tar > rm -rf ib_logfile* > chown -R mysql.mysql > service mysql start > > Something similar might work for you. Somebody with more MySQL > expertise than me can probably help you customize the process to your > environment. > > Good luck! > G > > On 9 September 2010 17:08, Uwe Brauer <o...@mat.ucm.es> wrote: > > andrew.2.mo...@nokia.com wrote: > >> > >> Try using the failed hdd as a slave in a Linux machine. > > > >> You might find that the hdd won't boot to OS but may have enough in it to > >> access the file system. > > > > I have done that already and I have access. But I don't know how to extract > > the db (via dump) since the corresponding mysql server software is not > > running. how can i tell linux to use the mysql db of the Mac? > > > > Uwe Brauer > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > > http://lists.mysql.com/mysql?unsub=george.g.lar...@gmail.com > > > > > -- Steve Staples Web Application Developer 519.258.2333 x8414 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org