Backing up and Restoring MySQL Databases

To backup a MySQL Server database:

  1. Login to WebsitePanel. Learn How.
  2. Click Database icon and select MySQL Server
  3. Click the Database Name
  4. Select Maintenance Tools
  5. Click the Backup button
  6. Specify backup name and select preferred method for storing backup. You could download it immediately or copy to a folder within your hosting space.
  7. The panel produces MySQL Server backups in SQL format. The resulting file could be very large, but you have an option to compress it by selecting the "Zip Backup" option.
  8. Click the Backup button

To Restore a MySQL Server Database:

  1. Follow steps 1-4 in backup procedure above.
  2. Click the Restore button
  3. Click Browse button to select backup file from your local file system or select "Hosting Space File" option and then pick the backup file from the hosting space file system. If your database backup file is > 5MB, it is recommended to upload the file using FTP and then use the "Hosting Spce File" option to restore it.
  4. Click the Restore button
  • 9 Users Found This Useful
Was this answer helpful?

Related Articles

Why don't I have any IP addresses allocated to my hosting space?

IP Addresses are allocated to a hosting space only if that space requires it's own unique IP...

What is the name of my server?

Your server's name is used to identify the server and connect to it for various tasks. You can...

Assigning a Host Header to Your Web Site

If you have already created a domain, sub-domain, or domain alias, follow these instructions to...

WebsitePanel Tutorial Videos

How to add a domain in WebsitePanel How to add Scheduled Tasks in WebsitePanel How to use the...

How to use a domain on a site when the DNS is not hosted by i7MEDIA

If you have a domain for which you manage the DNS on servers other than i7MEDIA but you want the...