Time Machine and MySQL -- restore from backup

Discussion in 'Web Design and Development' started by dmmcintyre3, Aug 17, 2009.

  1. dmmcintyre3 macrumors 68020

    Mar 4, 2007
    Is there a way to restore a mysql database from a time machine backup?

    PS: This did not work
  2. angelwatt Moderator emeritus


    Aug 16, 2005
    That article looks pretty good. What didn't go right?
  3. dmmcintyre3 thread starter macrumors 68020

    Mar 4, 2007
    MySQL will not start after I did it.
  4. SrWebDeveloper macrumors 68000


    Dec 7, 2007
    Alexandria, VA, USA
    Maybe not. Someone commented at the end of the article that step 5 was wrong - i.e. backwards actually, not sure if true, but if so - that would explain why MySQL won't start properly. It might be nothing, but I noticed so worth checking out.

    Regardless, it's time to check the error log and see what mysqld generated during startup, then post that here or Google search for advice and go from there.

    The log can be found via "locate mysql.error.log" - once you find it, look for startup errors. If nothing found, you can use mysqlbinlog to read the binary log files in /usr/local/mysql/data/ (in my installation not all were binary). But most importantly, some errors are simply directed to stderr so you may want to check /var/log/system.log as well, i.e. "cat /var/log/system.log | grep -i 'mysql'"


Share This Page