Am 05.10.2014 um 21:29 schrieb Tim Johnson:
I have a dual-boot OS X/Ubuntu 12.04 arrangement on a mac mini. The ubuntu system has failed and I am unable to boot it.I have one database on the ubuntu partition that was not backed up. I am able to mount the ubuntu partion with fuse-ext2 from Mac OS X, thus I can read and copy the mysql data files at /var/lib/mysql on the ubuntu partition. I presume that I should be able to retrieve the database by just copying it to /opt/local/var/db/mysql5 - the location of the mysql datafiles on the mac partition - and setting ownership and permissions. So, this is a "Help me before I hurt myself" sort of question: Are there any caveats and gotchas to consider?
in case of MyISAM a no-brainer * stop the db server * copy the folder there * set permissions * start the server * run "mysql_upgrade --force -u root -p"well, in case of replication you might want to rebuild the slave(s) from scratch but that was it - doing this regulary to rsync whole databases from stopped replication slaves as well as the document root on testing machines
signature.asc
Description: OpenPGP digital signature
