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:
- Log in 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.
How do I create a MySQL backup? Print
- mysql, export
- 3
Was this answer helpful?
Related Articles
What is Web Hosting?
To state it quickly - Web hosting is the act of putting a website online to be accessed by...
What is Bandwidth?
Bandwidth, which is also referred to as transfer, is the amount of data your web host allows...
How do I prevent WordPress from overloading my shared server?
WordPress blogs can be extremely resource intensive if you happen to experience a surge in...
Can I change my cPanel username?
Unfortunately, our system does not allow a change of username as the system uses your current...
How long does it take for my DNS to resolve?
It can take as little as 1 hour for your DNS to resolve, however, we state between 24-48 hours...
