[Guide]Database Back-Up & Restore

[Stabatha]

I just noticed there is no guide here yet how to back up your data and I know a lot don't understand how to. So....

log into ssh..

To back up your database type:
mysqldump --opt -Q -umy-username-here -p database-name-here > database-name-mm-dd-08.sql (hit enter key).

Of course change "my-username-here" to your ssh login name, be sure to leave -u in front of the name still. "database-name-here" to the database name. If your not sure of the name look in your world or logon config and "database-name-mm-dd" to the name of the database and date it.

You will now be prompted to enter a password. Enter your ssh password not the database password, well unless they are the same of course.

Let it run til you get the bash prompt again and your done. It takes about 10 seconds per 100MB of size.

Restore from a database backup..

In ssh type the following to wipe the saved tables in your database backup and restore the information from it.

mysql -umy-username-here -p database-name-here < database-name-mm-dd-08.sql

Of course change "my-username-here" to your ssh login name, be sure to leave -u in front of the name still. "database-name-here" to the database name. If your not sure of the name look in your world or logon config and "database-name-mm-dd" to the name of the database sql file you want to restore your data from.

You will now be prompted to enter a password. Enter your ssh password not the database password, well unless they are the same of course.

Let it run til you get the bash prompt again and your done. It takes about 10 seconds per 100MB of size.

Remember you can also use the restore method for importing to a new database for the firs time. Just simply upload the .sql files and then follow the restore steps.

[TheNlghtmare]

+REP. This is needed for any person who is running a server.

[Rusmar]

Cool guide