MySQL Databases

How do I backup my MySQL database?

If you have telnet (SSH) access then you can back up your MySQL database quite simply from the command line as using the following command.

mysqldump -u username -p password databasenamedb > backup.sql

Remember to replace 'username', 'password' and 'databasenamedb' with your settings. This will create a file called backup.sql which contains information from your database. You can now use FTP to transfer the file to your local computer.

If you do not have SSH access, then email our support team with the username, password, database name, and your domain name, and they will be able to run this command for you.