How to export and import MySQL database?

I messed up one my forum during version upgrade and it is currently not accessible.

Luckily I have CodeGuard which it backup daily my web files and databases. So the restoration can be done right away.

But if you don’t have CodeGuard (which I really recommend you to have it), here is how to do the export and import of your website MySQL database just in case you need it.

But before that, you need to know this first.

• dbUser – Your database username
• dbName – Your database name
• dbFile – Your database filename

Export

To export the database, just enter this command in the terminal.

mysqldump -u dbUser -p dbName > dbFile.sql

Import

To import the database, just enter this command in the terminal.

mysqldump -u dbUser -p dbName < dbFile.sql

Note: Take note the direction of the ‘arrow’.

CodeGuard

Screenshot below is the CodeGuard Restore Progress Tracker. Based on the estimation, the forum will be ready in 1-hour.

Hope everything will be back to normal…