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.

Ha estat útil la resposta?

 Imprimeix aquest Article

Llegir també

The FTP account management table

This table allows you to perform several functions on existing FTP accounts. To search for...

Remove an FTP account

Click Delete next to the FTP account you wish to remove. Confirm that you wish to delete the...

Manage User Privileges To MySQL Database

Manage User Privileges:cPanel allows you to provide certain privileges to the user.Select the all...

Add user to a particular MySQL Database

Add user to a particular MySQL DatabaseSelect the user whom you want to add to the database.Then...

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...

Powered by WHMCompleteSolution