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.

هل استفدت من هذا الجواب؟

 أطبع هذا المقال

اقرأ أيضا

The FTP account management table

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

Change an FTP account's password

Click Change Password for the FTP account whose password you wish to change. In the Password...

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

Login to an FTP account

To login to an FTP account: Enter your username in the username field Note: If you are not...

Add New User To The MySQL Database

Add New User: To add a new user to your MySQL users list then,Enter username and password iin the...

Powered by WHMCompleteSolution