Client Login

How can I backup and restore my MySQL databases?

There are two main ways to back up or restore a MySQL database on our servers: via SSH or the phpMyAdmin interface.

If you need SSH Telnet access, just send us a ticket with your request to be enabled for it. To access the phpMyAdmin interface, click on the "phpMyAdmin" icon in your control panel.


How to backup a MySQL database using SSH:

Log into your account on our server and issue the following command:

/usr/bin/mysqldump DATABASENAME -u USER -p PASSWORD > /home/user/file.sql

Enter your actual username and password where we have indicated user and password. This will create a file called "file.sql" that contains your entire database. (You can name it whatever you want as long as it ends as ".sql".)


How to restore a database using SSH :

Log into your account on our server and issue the following command:

mysql DATABASENAME -u USER -p PASSWORD < /home/user/file.sql (change file.sql to your filename)


How to backup a MySQL database using phpMyAdmin:

Click on your database name shown on the upper left.

Go to the section called "View dump (schema) of database" and choose options for backing up structure only, structure and data, or adding drop tables. To view what your backup file will look like, click on the "Go" button. When you're ready to send your back up to a file, check the send box and click "Go", then follow the prompts for how to name the file and where to send it.



Was this answer helpful?

Add to Favourites Add to Favourites

Print this Article Print this Article

Also Read
What is MySQL? (Views: 3305)