[zoe77]

I had to do a complicated Archive & Install of OS 10.2 and realised all MySQL files were moved to the Previous System Folder by the OS installer

can anyone tell me how to restore my original SQL setup from before? worried that my MovableType setup would be affected if I installed MySQL from scratch.

[suthercd]

There are several different MySQl install techniques available. How did you originally install MySQL? You data should be intact. On my machine the data is in /usr/local/mysql/data.

Read the MySQL manual. There is a comprehensive section of data transfer, backup, restore, etc that will give you a good background on what it is you will need to do.

HTH
Craig

[Gavin]

Originally posted by zoe77:
I had to do a complicated Archive & Install of OS 10.2 and realised all MySQL files were moved to the Previous System Folder by the OS installer

can anyone tell me how to restore my original SQL setup from before? worried that my MovableType setup would be affected if I installed MySQL from scratch.

It will be a real pain in the butt to fix everything by hand because there are several parts to a mysql installation and they can be in different places in the system depending on how you installed it.

As long as your data folder is OK and is where mysqld expects it to be then everything that uses mysql should work fine. So I'd install a fresh copy using the installer from mysql.org
http://www.mysql.com/get/Downloads/M...ysql.orst.edu/


then just copy over your old data folder. it's not to hard to do this in the terminal

cp -r /path to old/mysql/data/ /path to new/mysql/data/
edit this to your setup of course.

the main things to look out for are the permissions on the data folder and data files.

No matter what you end up doing I'd download the installer and read the readme file. it has a lot of good info.

Have fun

[zoe77]

thanks for all the info posted guys, restoring was a success and pretty stragithforward, all my data was indeed in the mentioned directory path.