{"id":760,"date":"2020-10-15T08:52:41","date_gmt":"2020-10-15T05:52:41","guid":{"rendered":"https:\/\/www.scalahosting.com\/kb\/?p=760"},"modified":"2022-08-30T13:34:14","modified_gmt":"2022-08-30T10:34:14","slug":"how-to-restore-a-database","status":"publish","type":"post","link":"https:\/\/www.scalahosting.com\/kb\/how-to-restore-a-database\/","title":{"rendered":"How to Restore a Database"},"content":{"rendered":"\n

Websites used to be very different in the past. They consisted primarily of <\/span>simple HTML documents <\/b>that made use of<\/span> strikingly colorful backgrounds and low-resolution GIF animations<\/b>.<\/span><\/p>\n\n\n\n

We don’t really see these websites anymore. Even if you plan to launch something simple like a personal blog, you are much more likely to create it using WordPress rather than write the HTML code by hand. With WordPress, you no longer<\/span> have a collection of static HTML documents<\/b>. Instead, you have an application that runs on the server and <\/span>uses a database to deliver the correct content to the correct user.<\/b><\/p>\n\n\n\n

The<\/span> performance of the entire website<\/b> is dependent on the health of its databases, which is why many web hosts will give you tools for <\/span>managing and controlling<\/b> them. The most important ones are those that can ensure that your data can be<\/span> restored should the worst happen<\/b>.<\/span><\/p>\n\n\n\n

Restoring databases in SPanel<\/b><\/h2>\n\n\n\n

From a <\/span>cyberattack to a buggy plugin<\/b>, there are a number of things that could cause problems with your databases, which is why <\/span>it’s important to ensure <\/b>that the data is reliably backed up and ready to be restored at any time.<\/span><\/p>\n\n\n\n

SPanel, the <\/span>all-in-one hosting platform<\/b> that comes with your <\/span>Scala Hosting VPS<\/b><\/a>, will create daily <\/span>backups of your files and databases <\/b>and will keep them for a week. We also ensured that should you need to use these backups, you don’t need to restore everything. SPanel lets you choose what you want to restore exactly. Here’s what you need to do.
<\/span><\/p>\n\n\n\n

  1. Log into SPanel’s User Interface.<\/strong>
    The default login URL for SPanel’s User Interface is https:\/\/yourdomain.com\/spanel <\/em>(make sure you swap yourdomain.com for your actual domain).<\/li><\/ol>\n\n\n\n
    \"How<\/figure>\n\n\n\n
    1. Click Restore Backup.<\/strong>
      SPanel’s Restore Backup<\/strong> tool is available under the Files <\/strong>section on the homepage.<\/li><\/ol>\n\n\n\n
      \"How<\/figure>\n\n\n\n
      1. Pick a restore point.<\/strong>
        You’ll see a list of all the backups currently store for your account. You need to choose the date from which you’d like to restore the database.<\/li><\/ol>\n\n\n\n
        \"How<\/figure>\n\n\n\n
        1. Click Browse Databases and select the database you’d like to restore.<\/strong>
          The Browse Databases button displays a list of all the databases that were present and backed up on your selected date.<\/li><\/ol>\n\n\n\n
          \"How<\/figure>\n\n\n\n
          1. Open the Restore drop-down and choose what you want to do.<\/strong>
            Next to the database you want to restore, you’ll see the Restore <\/strong>drop-down menu. When you open it, you’ll see three options. You can Download<\/strong> the database to your local computer, restore it as the Original database <\/strong>or import the data into a New Database. <\/strong>If you choose the New database<\/strong> option, you’ll need to enter the name of the new database.<\/li><\/ol>\n\n\n\n
            \"How<\/figure>\n\n\n\n