If you have SSH or telnet access to your server, run this:
mysqldump --opt -u DBUSERNAME -p DBNAME > /path/to/backup/directory/backup.sql
It will then ask for your db's password. enter it.
To restore:
mysql -u DBUSERNAME -p DBNAME < /path/to/backup/backup.sql
it will then ask you for your db's password.
You shouldn't need to restore, but i'm just keeping on the safe side, you know? The queries to run have no potential danger really, they're just adding fields.
|