Import large DB in MySQL using command in MAMP

Sometimes using phpmyadmin, it’s kind of impossible to import DB from the import section. So below is the command to import large DB into MySQL.

Step-1 Login to MySQL using following command

/Applications/MAMP/Library/bin/mysql --host=localhost -uroot -proot

Step-2 Select DB in which you want to import DB

use DB_NAME;

Step-3 Import DB

SET autocommit=0 ; source PATH_TO_YOUR_SQL_FILE.sql ; COMMIT ;

That’s it.

Don’t forget to change path!!!

How to Import – Export WordPress Database using WP-CLI | WP-CLI | WordPress

I’ve made a video for this tutorial. Because that’s the easiest way to show how we can use WP-CLI to import/export database.

And if you like the video then subscribe my channel and share this with others who want to learn WordPress.