Show:
Import and export MySQL dump
February 14, 2024
Programming
Another simple task that’s often hard for beginners is importing and exporting MySQL dump. Here is quick rundown on how to do it.
To export data you need to use mysqldump:
mysqldump -u db_user -p db_name > dump_name.sql
Options given to mysqldump are:
-u db_user– connect as userdb_userto database-p– use password, it will ask you to enter your passworddb_nameis the name of MySQL database you want to dump> dump_name.sql– by defaultmysqldumpwill print out the dump to terminal, but simple output redirect with>will instead write it to given filename, in this casedump_name.sql
Now that you have dump_name.sql file with all SQL queries needed to replicate your database you can import it using general-purpose mysql client:
mysql -u db_user -p db_name < dump_name.sql
User, password, and database name options are the same as for mysqldump. Since mysql reads input from terminal this time we can use < to read input from given file instead.
As always for more information you can consult manual using man mysqldump and man mysql.
Return to Previous Page
