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
To export the database, just enter this command in the terminal.
mysqldump -u dbUser -p dbName > dbFile.sql
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’.
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…