Re: hard disk crash: how to discover the db?
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 While this sounds like an idea, does anyone know if there are actual version idiosyncrasies that need to be looked at first, such as which version of mysql was run on the failed system vs which is running on the rescue system? 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: hard disk crash: how to discover the db?
On Fri, 2010-09-10 at 15:57 +0200, Uwe Brauer wrote: On Fri, 10 Sep 2010 04:43:39 -0400, Mike McMullin mwmcm...@mnsi.net wrote: On Thu, 2010-09-09 at 18:02 -0400, George Larson wrote: Good luck! G While this sounds like an idea, does anyone know if there are actual version idiosyncrasies that need to be looked at first, such as which version of mysql was run on the failed system vs which is running on the rescue system? Precisely like some information say written in /etc/mysql.conf or something like this. I was thinking version of mysql, but yes where things are installed to as well, I know that the openSuSE version puts stuff in a different location than the Ubuntu version of the same software version. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org