Knowledgebase



 Categories





 Currency Converter


  • Currency
  • US$ Amount

How can I restore a database backup



 

How can I restore a database backup?

You can restore a database backup in case of enabling MySQL add-on, or in case the backup was for the partition that contains the database directory.

Restoring using MySQL Add-on:

  1. Login to the control panel

  2. Explore recovery points

  3. Choose the required database or table by checking the box besides it

  4. Press Restore Selected to start restore

A new dialogue box will appear

  1. Introduction: Information about the box and what it do, press Next

  • Host:

  • Restore to Original Host: To restore to the original server(the default)

  • Restore to Alternate Agent: To restore to another server

  • Authentication:

  • Use Original Authentication Credentials: Use the same recorded data for MySQL root password (the default).

  • Specify Alternate Authentication Credentials: Use another authentication data to access the database server.

  • Temporary Instance:

  • Use Default Temp Directory: Use the default database server tmp directory (the default).

  • Specify an Alternate Temp Directory: Use another tmp directory.

  • Data Directory/Base Directory:

  • Use Discovered Base/ Data Directory: Use the default Base/Data directory, it will be automatically retrieved from the database server settings

  • Specify a Base/Data Directory to use: Manually specify the database server Base/Data directory path

  1. Press Restore

In case of restoring database backup from database directory backup, use the regular way of Restoring Files Backup

 


Was this answer helpful?

Add to Favourites Add to Favourites    Print this Article Print this Article

Also Read

Can I link more than one server using only one backup plan (Views: 7061)

  Can I link more than one server using only one backup plan? Sorry, this cannot...


During the backup preparation, will the server resources be heavily used (Views: 7679)

During the backup process, will the server resources be used heavily? No, especially...


How can I login to the backup control panel (Views: 6857)

  How can I login to the backup control panel? You can login to the backup...


How can I restore files backup (Views: 6656)

  How can I restore files backup?  Please visit the following link, it...


How can I download a backup (Views: 7557)

  How can I download a backup? Login to the control panel...



Online