MAMP PRO mysql database issues

[sydneyshan]

Hi all,

I've installed MAMP PRO and want to get my databases that were recovered from a crashed system imported in to the MAMP PRO MySQL environment. I thought 'it should be as simple as dropping the database folders in to the /Applications/MAMP/db/mysql directory...' - this proved fruitless despite restarting the server several times and restarting my machine just in case... The databases just would not appear in the phpMyAdmin list. Additionally, any new databases I created within phpMyAdmin could not be found anywhere on my hard drive using the Finder Search facility (with invisible & visible files toggle on).

Cooincidentally, when I run ./Applications/MAMP/Library/libexec/mysqlmanager from the Terminal all of my databases appear within phpMyAdmin...

Can anybody help me work out either a) where the databases are stored when created using MAMP's phpMyAdmin interface, or b) how to get MAMP to read in all my databases stored within the /Applications/MAMP/db/mysql directory ?

Any help would be greatly appreciated!

Kind regards,
-Shannon

[al3]

Hi all,

I've installed MAMP PRO and want to get my databases that were recovered from a crashed system imported in to the MAMP PRO MySQL environment. I thought 'it should be as simple as dropping the database folders in to the /Applications/MAMP/db/mysql directory...' - this proved fruitless despite restarting the server several times and restarting my machine just in case... The databases just would not appear in the phpMyAdmin list. Additionally, any new databases I created within phpMyAdmin could not be found anywhere on my hard drive using the Finder Search facility (with invisible & visible files toggle on).

Cooincidentally, when I run ./Applications/MAMP/Library/libexec/mysqlmanager from the Terminal all of my databases appear within phpMyAdmin...

Can anybody help me work out either a) where the databases are stored when created using MAMP's phpMyAdmin interface, or b) how to get MAMP to read in all my databases stored within the /Applications/MAMP/db/mysql directory ?

Any help would be greatly appreciated!

Kind regards,
-Shannon

Hmmm. Perhaps the databases are corrupted since you said they came from a crashed system. Not sure what you mean by "imported in the MAMP PRO environment."

I also don't understand the relationship between mysqlmanager and phpMyAdmin as you state above.

When you create a database in phpMyAdmin it is going to put them with all the others... in the /applicatons/mamp/db/mysql folder, just as you stated above. You should see a folder for each database in in that folder are all the tables... actually three files for each table. However, if you just dropped them in there, my guess is that the server software really does not know about them as they are not "registered" with the server. I don't know how you fix that.

That said, you can get these databases from the terminal? If so, see if you can do a mysqldump on them and then import them via phpMySQL. That would work, assuming you can access them via the terminal to dump them. You may have to do a google on "mysqldump" to see how it works.

Al

[sydneyshan]

Hi Al,

I found the magical location for MAMP's databases... it was not as expected (/Applications/MAMP/db/mysql/...) but in the following directory:

/Library/Application Support/living-e/MAMP PRO/db/mysql/...

Is there a way to get MAMP / MAMP PRO to store the databases in the 'correct' folder mentioned first?

[al3]

I guess MAMP PRO uses a different location. What happens if you just use MAMP and not PRO?

I don't use the PRO version so I have no idea how it works or what it does differently from MAMP.

Al

[sydneyshan]

Hi Al,

My understanding is that MAMP PRO is just an application that allows more advanced configuration of Virtual Hosts, Postfix, and a few other server related tasks... I'm not sure why it would configure MySQL to store data in a different directory - this seems like a bug to me... Is there a facility this can be flagged as an issue through?

Cheers,
-Shannon

[magi182]

Al is right. Some of the files are kept in different places in MAMP vs MAMP PRO, and the MySQL are handled this way too. For instance, php.ini and httpd.conf are hidden in the Application bundle of MAMP PRO. MAMP PRO maintains a lot of files separately from MAMP. For instance:

If you run MAMP PRO, Apache boots with the httpd.conf, and php.ini that is inside of
/Applications/MAMP PRO 1.7.2/MAMP PRO.app/Contents/Resources

If you run MAMP, Apache starts up with the httpd.conf in
/Applications/MAMP/conf/apache

MAMP PRO does *not* keep it's databases in
/Applications/MAMP/db/mysql

They are in the aforementioned location from shannon.

hope that helps.

[sydneyshan]

Thanks magi182 - that's helped me locate the elusive 'favicon' apache config line so I can see my own favicon.ico graphic appear in the URl bar when testing sites locally. I hope this thread benefits others looking for the MAMP PRO mysql databases location, and the MAMP PRO httpd.conf/php.ini.

Cheers,
-Shannon

[bradleyvance]

It seems like the db location has moved slightly:

/Library/Application Support/appsolute/MAMP PRO/db/mysql/...

Just in case anyone is having trouble finding it.

[elean]

THANK YOU bradleyvance!!!

I just couldn't find the f****ing folder. Seemed they changed the location alot since I found lots of different e-living folders but my DB was missing in all of them. Now I found it, thank you!