How to import a MAMP mysql database (bypassing phpmyadmin problems)
Recently I’ve being have a problem importing a large database in MAMP Mysql via phpmyadmin (and after altering various php variables in php.ini, I still couldn’t get it to import).
So I tried another approach to import it from the command line a quick google turned up this post on the MAMP site which got me started.
I managed to import the database fine from the command line like this:
1 | sudo /Applications/MAMP/Library/bin/mysql --host=localhost -uroot -proot your_database_name < your_sql_import_file.sql |
it might warn you about password being insecure via the command line.
I hope you find this helpful to overcome problems importing MAMP mysql databases using Phpmyadmin ( simply by using the command line).
Disclaimer: All content on this site, is use at your own risk (Always backup before changing anything in your software/database/servers etc). Techs change, go out of date etc...
I/we accept no liability if anything you use on this site adversely affects you.
Recent Comments