Obtaining MySQL Database on Tiger

Before I upgraded to the latest version of Tiger, I had my localhost running flawlessly, with Apache running, and I installed MySQL and it was operating just fine. Recently I updated to 10.4.7 (literally the day before 10.4.8 was released) and it really messed up my MySQL. I've been trying to search and fix it ever since and I am fed up with it. I can't get it working. I keep getting a "Can't connect to local MySQL server through socket '/var/mysql' (2)" from a web-page and phpMyAdmin can't connect. I am sick of trying to rescue it.

So now I am to a point where I just want to get the database. Obviously, I can't Export it. But is there a file on my computer that has the databases and tables? I don't exactly know how it's stored, but I was wondering if I could salvage it to put it on my Windows comp which has MySQL running. Again, I've been searching for a while with no avail. I think I did it once on my Windows MySQL database, but MySQL spreads itself differently on OS X, and I don't remember how if I did do it correctly.

Thank you in advanced for your help.

#427560

copy data directory to another folder then reinstall mysql server. data folder stored database tables. When finish your new installation then restore that folder installation directory.

#427601

wizard, you want to point to any helpful tutorials on getting Apache and MySQL set up to begin with? I'm too lazy to find a nice one myself .

Thanks!

-NC

P.S: If you don't know of any, don't bother looking. I figure I can start looking myself .

#428050

copy data directory to another folder then reinstall mysql server. data folder stored database tables. When finish your new installation then restore that folder installation directory.

Really? Hmm, I don't have privileges to access it, and I can't change them. But for some reason, the MySQL Administrator program can see them, and I backed it up from there. Thank you for your help though .

@NC - IIRC, I was just installing them like normal. You need to enable the Personal Web Sharing (System Preferences - > Sharing -> check the box). Your web-space will be in Home -> Sites and the URL will be localhost/~user name/. Then I just downloaded and installed mySQL. After it's installed, open Terminal and execute this command: "sudo /Library/StartupItems/MySQLCOM/MySQLCOM start". Installing PHPmyAdmin is a little sketchy for me. I don't remember how I did it.

#428177

Hehe, that should teach me to read instructions thoroughly before I start . I was only entering in http://192.168.0.6/ and localhost, both of which kept directing me to the default Apache "Installation was a Success" page. Instead of reading your post and seeing that the URL was localhost/~nc, I mucked around with the Apache config file in the terminal, and set it so that localhost automatically redirected to my page .

Fortunately I'm the only user on this computer!

Thanks,

-NC

#428484