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: 7838)

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


What is meant by Bare-Metal Restore (BMR) (Views: 9996)

What is meant by Bare-Metal Restore (BMR)? BMR stands for Bare-Metal Restore, it...


How can I download a backup (Views: 8350)

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


My server is from another provider, can I use the service (Views: 9013)

  My server is from another provider, can I use the service?  Sure, all you...


My server had been hacked, will the intruder be able to access the backup (Views: 9690)

My server had been hacked, will the intruder be able to access the backup? No, the...



Online