Tag: import

  • 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

    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.