logoBrett Rawlins

Import a database from the command line

July 30, 2013

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