The following article will guide you, on how to create a database backup via the phpMyAdmin interface.
This article contains the following sections:
Steps To Log In To Your phpMyAdmin Account:
- Log in to your SiteControl Panel.
- Click on Website below the Manage Services menu.
- Scroll down, find, and click on MySQL below the Added Functionality menu.
- Select the appropriate domain name from within the Currently Managing: drop-down menu.
- Locate the Database that you need to backup and click on Edit Database.
- Scroll down, find, and click on the Administer button.
- This opens up the phpMyAdmin login page. You will need to enter the following information:
Server:
Username:
Password:
Note: The Server name and the Username can be seen on the previous page before you click on Administer. The password is not visible for security reasons, but it can still be updated in case you do not remember it.
To change the user's password or permissions click on Permissions.
Type in your new Password and Confirm the password. Once done click on Update User to save the changes.
Steps To Export (Backup) Your Database Via phpMyAdmin:
- Click on the Export button.
- From the Export method: menu select Custom - display all possible options. Make sure that
Save output to a file checkbox is also selected.
- Scroll down and click on Go to start downloading your Database Backup file.
- Once done, the database backup should be stored on your local machine and available to you.