If you wish to export a MySQL database, It is a good idea to export your data often as a backup.

To Export MySQL using Terminal.
1. Run the terminal (Ctrl+Alt+T).
2. Enter the following command.

mysqldump -u {your-database-username} -p {database-name} > {sql-file}

3. Hit enter and you will be prompted for your MySQL password.
4. Hit enter again and your database will then be exported.

Importing a MySQL database is used basically to restore data from your backup. In importing, you may start at uploading .sql file to your chosen server where you wish to run this command and then put on the necessary information needed to complete the importing process then follow the code below.

To Import MySQL using Terminal.
1. Run the terminal (Ctrl+Alt+T).
2. Enter the following command.

mysql -u {your-database-username} -p {database-name} < {sql-file}
Note: Drag your .sql file to terminal to get the full file path.

3. Hit enter and...

Read more...