MySQL: Import database via command line

import-sql.md

Import large database to MySql ⚡

cd /path/to/backups
mysql -u root -p --default-character-set=utf8
# Switch to database 
USE database_name;
SET names 'utf8';
SET autocommit=0 ;
SOURCE backup.sql;
COMMIT ;

• Note: database_name should exists
• Source

mysql-import-export-all.md

Import/Export all databases in one command

Export

mysqldump -u root -p --all-databases > all_db.sql

Import

mysql -u root -p < all_db.sql

• Source