How to backup/restore your MySQL database

To backup the databases please do the following:

  1. Login to your YucaHost control panel and click Backups.
  2. Under Download a MySQL Database Backup, click the name of the database.
  3. Click Save As.
  4. Select a destination for where you would like the back up to be saved, locally.

Once you have a backup, if you ever inadvertently lose your data, then you can restore the database easily and quickly.

To restore a database, please do the following:
  1. Login to your control panel and click Backups.
  2. Click the Browse button next to the option which says Restore a MySQL Database.
  3. Select the .sql.gz file which you want restored.
  4. Click the Open button and click the Upload button.

Your database driven website should be working again.

Byla tato odpověď nápomocná?

 Tisknout tento článek

Také čtěte

Creating MySQL Database

Creating Database:        Login to your cPanel, then click on MySQL...

Edit an FTP account's quota

The quota limits the amount of data that a user can upload to your server. To change an FTP...

Redirects

Learn how to make a specific web page redirect to another page and display the contents of that...

How do I restore my own backup?

A full backup must be restored by the root user for the server. We will restore your full backups...

How to generate/download a full backup

A full backup is a backup of all of your files, e-mail, databases, etc. To run a full backup, you...

Powered by WHMCompleteSolution