|
|
10.5: Control MySQL server with launchd
How did you install that MySQL version on Leopard? I just tried and it completely destroyed my database, now none of my (small sites hosted on my comp) work at all.
10.5: Control MySQL server with launchd
Unless you have a backup of your mysql data directory or have .sql dumps (you do, don't you?), you are pretty well hosed.
10.5: Control MySQL server with launchd
I had a ~30 hour old complete SQL dump so I was able to quickly get back online after removing all traces of the new installation and then installing the older version again. Lost some data though. The .MYI files all disappeared during the installation project.
10.5: Control MySQL server with launchd
Look in /usr/local/ for directories named 'mysql*'. All the installers I have used create a new directory named after that version and link 'mysql' to the new directory.
Your data will still exist in your old directory. See http://www.entropy.ch/software/macosx/mysql/ for more detailed instructions. The good news is that unless you have deleted something, your data is probably still there.
10.5: Control MySQL server with launchd
That is what I expected would happen as is has before (when I used 10.4) but no old SQL folder was present, only the newly created one.
10.5: Control MySQL server with launchd
Actually what I did, before installing leopard I made a full backup of my tiger machine. On Leopard I did a fresh mySQL Install without the old databases present. Then when this new copy was installed and running, I copied my old databases from the tiger backup into /usr/local/mysql/data. Don't forget to set the right file permissions, mysql likes it's database files to be owned by the _mysql user and read and writeable only by this user.
10.5: Control MySQL server with launchd
I have to add something I forgot in the last comment. As mentioned in the hint itself after the succesfull install I moved my data directory to a different location, in my case /Library/mySQL/data (this is because I do a daily backup of the /Library Folder, but not the system folders). |
SearchFrom our Sponsor...Latest Mountain Lion HintsWhat's New:HintsNo new hintsComments last 2 daysNo new commentsLinks last 2 weeksNo recent new linksWhat's New in the Forums?
Hints by TopicNews from Macworld
From Our Sponsors |
|
Copyright © 2014 IDG Consumer & SMB (Privacy Policy) Contact Us All trademarks and copyrights on this page are owned by their respective owners. |
Visit other IDG sites: |
|
|
|
Created this page in 0.21 seconds |
|