Importing/exporting data with MySQL

This is more of a note-to-myself entry to dig it up later easily, but the syntax to import dump file to MySQL is:

mysql -p -h database_server -u mysql_user mysql_dbname < file_dbname.sql

The same way mysql dump can be created:

mysqldump -p -h database_server -u mysql_user mysql_dbname > dump_file.sql

Good resource with more on this is here.

Leave a Reply