Probably a bit like telling you to bolt the stables door after the horses have escaped... but you should always do regular backups of your databases even if you are using the most reliable host in the world. Even more so if your database contains valuable information.
Use a SSH/Telnet Client, such as PuTTy ( you will need SSH or Telnet installed on the server ).
You can download putty from -
http://www.tucows.com/preview/195286.html
Then usually something like this will work - Open Putty and log into your website. The command line prompt you will see will vary by OS.
For most hosting companies, this will bring you into the FTP root folder.
Type in the following:
Quote:
|
mysqldump --opt -Q -u dbusername -p databasename > /path/to/backupname.sql
|
You will be prompted for the database password. Enter it and the database should backup.
If you run into problems or are not sure if this is working then contact your host and ask them how to best back up your database as this may not work with all databases or setups.