DEV Community

Ali Raza
Ali Raza

Posted on

MYSQL import export using cli

Export Import All Databases

Export:
mysqldump -u USERNAME -p -v --all-databases > alldb.sql

Import:
mysql -u USERNAME -p -v < alldb.sql

Export Import One Database

Export:
mysqldump -u USERNAME -p -v DBNAME> ExportSqlFile.sql

Import:
mysql -u USERNAME -p -v NEWDBNAME < ExportedSqlFile.sql

Note: Add --verbose or -v options to see how the dump is progressing.

Discussion (0)