There are two ways to back up your MySQL databases. You can use the backup utility in your cPanel account or you can manually backup using phpMyAdmin.
To manually backup using phpMyAdmin follow these steps:
- Login to your control panel at www.yourdomain.com/cpanel
- Click on 'phpMyAdmin' under the 'Databases' menu
- From the dropdown list to the left, choose the database you wish to export the backup from.
- Click on the 'Export' Tab.
- Click the 'Select All' link shown in blue, then tick the 'Save as file' box and 'Go'.
- You will be asked to save the .sql file to the hard drive, click 'Save'.
- Choose the location to save to and click 'Save'.
Your database has now been exported.
Most Popular Articles
How to create my MySQL database?
After you are done with the database creation you can use the phpMyAdmin tool to manipulate the...
MySQL Database info: username, password, hostname, database name
Your MySQL database username - is the same as your Control Panel username. our MySQL database...
MySQL administration with phpMyAdmin
MySQL administration with phpMyAdmin NOTE: If You Have Purchased Hosting From Us Your...
MS Access
MS Access is typically used in conjunction with Windows servers running a MSSQL database. We do...
Maximum number of databases per hosting account
By default our hosting accounts come with a maximum of 50 databases per account. If for any...
