Sometimes you need to import a large database that exceeds the size limits imposed by phpMyAdmin. You can change some settings in your php.ini file to allow that, or you can just do it real quick from the command line. Here’s how:

1. Export

mysqldump -u user -p my_database > my_database.sql

2. Import

mysql -u user -p my_database < my_database.sql