Importing and Exporting MySql databases using command line

Every office has those useful commands which, inexplicably, nobody can remember when actually needed. In my last office, for some reason, it was MySql database imports and dumps. For nostalgic reasons I’m going to leave this here:


mysql -u username -p [database_name] < [path_to_file.sql]


mysqldump -u [username] -p [database_name] > [name_of_file.sql]

An easy trick for remembering this is to notice the direction of the less than and greater than signs. Greater than points away from the database (exporting) whereas less than points towards the database (importing).

Join the discussion!

You might like: