Support Center
  • knowledgebase
  • announcements
  • home
  • contact us
Search

Most Popular
Recently Added
Recently Updated

Backup and Restore of MySql database with phpMyAdmin

We install phpMyAdmin on our VPS/Dedicated serverd upon request.
If your account uses Plesk, Plesk provides phpMyAdmin as: DBadmin
Log onto your Plesk Control Panel, click on your domain name, then on Services/Databases
Select the database you want to work with, then DB WebAdmin.
(You need to allow pop-ups as this will open a new Window in your browser.)

Backup of Mysql database.

  1. Open phpMyAdmin/DBadmin.
  2. Click Export in the Menu to get to where you can backup you MySql database.
  3. Make sure that you have selected the database to export and to export your entire database, and not just one table. There should be as many tables in the export list as showing under the database name.
  4. Select"SQL"-> for output format, Check "Structure" and "Add AUTO_INCREMENT" value. Check "Enclose table and field name with backquotes". Check "DATA", check use "hexadecimal for binary field". Export type set to "INSERT".
  5. Check "Save as file", do not change the file name, use compression if you want. Then click "GO" to download the backup file.

Restoring a backup of a MySql database

  1. To restore a database, you click the SQL tab in phpMyadmin/DBadmin.
  2. On the "SQL"-page , unclick the show query here again.
  3. Browse to your backup of the database.
  4. Click Go.

Properties ID: 000170   Views: 3676   Updated: 12 years ago
Filed under:
Web Hosting
VPS/Shell Web Hosting » MySQL Databases
For news and system status updates, check: status.his.com
Open a ticket in our Support Center
For telephone support, call 301-255-0500 or 1-888-818-0500, option 2
HIS tech support hours: 24/7/365

Heller Information Services
30 West Gude Drive - Suite 220 Rockville, MD 20850-1161
Tel: 301-255-0500 fax: 301-637-3449 Toll-free: 1-888-818-0500
Email: support@his.com