XAMPP NOT WORKING! - OS X Yosemite

问题:

I was working with XAMPP 1.8.3-3 on OS X Mavericks. After upgrading to Yosemite Mysql server stopped working. And an upgrade to XAMPP 1.8.3-5 fixed the problem and mysql server starts working.

Now the entire database list is showing on phpmyadmin, but no access to the tables. Its showing “#1146 - Table ‘DB_NAME.TABLE_NAME’ doesn’t exist”.

Unfortunately I don't have any DB backup!

I have the entire XAMPP folder backup. So how I can able to retrieve the mysql tables?

回答1:

just type /Applications/XAMPP/xamppfiles/bin/mysql.server start in terminal then start xampp

回答2:

you can restore if you have all the mysql folders from XAMPP folder. (check /XAMPP/xamppfiles/var/mysql in backup) if you have var/mysql folder, open and look for database names you had earlier.

there is a separate folder for each database you had earlier. open the folder and it will contain lots of files with table names.

if your old table engine is InnoDB you will see 2 files. with .frm and .ibd extensions.

or if you had MyISM it will contain three file per table which has .frm, .MYD and .MYI extensions.

after you verify you have all the required files in backup, you can start restoring them.

1. stop mysql
2. copy required database folder completely and paste it to currently installed folder. (/Applications/XAMPP/xamppfiles/var/mysql/)
3. start mysql

to restore web files, open htdocs folder in backup and copy required site folder to currentely xampp installed htdocs folder.

This solution worked for me. Good Luck !

回答3:

Do a clean install. See my answer for my own question. xampp mysql server not starting. The bad part is that I'm not sure if it will save your database the way I explained. What you might try is going to xampp > xamppfiles > var > mysql > 'your database name' and making a copy of the database folder on your desktop and moving it back once you reinstall it. I tried and I think it might have worked had I changed the file permissions. You can also try experimenting to see if it preserves the database if you do this. I would do some serious testing if you really want to save your database before doing this.