I did a backup of my OS X Leopard system. Somehow, this has totally screwed up my MySQL installation. I can't start a MySQL session via the terminal. The really bizarre thing, however is that I can still do MySQL queries through PHP code via a web browser pointed to my localhost. I'm relatively new at mysql, so I would have thought if I could access it via the web browser, I should also be able to access it via the terminal. Can anyone tell me if there is a way via the terminal that I can find the actual MySQL databases that the localhost is using? Also, has anyone else experienced something similar and found a resolution? I'm going to upgrade to Snow Leopard soon, but I'd prefer not to have to recreate all the MySQL databases for Snow Leopard, and I'd love to be able to fix this installation. Any help, or constructive criticism would be greatly appreciated.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
MySQL "lost" in OS X Leopard backup
- Thread starter peterv12
- Start date
The location of the mysql info will depend on your php code. Its usually in some config file, but unless you have an out of the box program, there is no way to know exactly. You could try searching the php for the string "mysql_connect(". I'm not an OSX user, but I think the newer versions are very similar to *nix. My mysql files are located at /var/lib/mysql. I can check that MySQL is running by logging in as root and issuing the command "service mysqld status". I hope that helps.
-----------------------------------------
I cannot be bought. Find leasing information at
-----------------------------------------
I cannot be bought. Find leasing information at
- Status