How to Restore a Database

Websites used to be very different in the past. They consisted primarily of simple HTML documents that made use of strikingly colorful backgrounds and low-resolution GIF animations.

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 have a collection of static HTML documents. Instead, you have an application that runs on the server and uses a database to deliver the correct content to the correct user.

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

Restoring databases in SPanel

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

SPanel, the all-in-one hosting platform that comes with your Scala Hosting VPS, will create daily backups of your files and databases 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.

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

How to Restore a Database

Was this helpful?

What’s your goal today?

1. Find the right Managed VPS solution

If you’re looking for industry-leading speed, ease of use and reliability Try ScalaHosting with an unconditional money-back guarantee.

2. Make your website lighting fast

We guarantee to make your WordPress site load in less than 2 seconds on a managed VPS with ScalaHosting or give your money back. Fill out the form, and we’ll be in touch.

Please enter a valid name
Please enter a valid website
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

3. Streamline your clients’ hosting experience

If you’re a web studio or development agency hosting more than 30 websites, schedule a call with Vlad, our co-founder and CTO, and see how we can deliver unmatched value to both your business and your clients.

Photo

Need a custom cluster or professional advice?

Book a meeting and get a free 30-minute consultation with Vlad, co-founder & CTO of Scala Hosting, who will help you select, design and build the right solution - from a single data center cluster to a multi-region & multi-datacenter high availability cluster with hundreds of servers.

Book a free consultation

4. Learn how to grow your website in 2024

An all-star team of SEO and web influencers are sharing their secret knowledge for the first time in years. Learn about the future of SEO, Web Design best practices and the secrets to getting the foundation for your website to thrive. Watch the exclusive webinar.

An Exclusive Insiders Look Behind The SEO and Web Development Curtain

Rado
Author

Working in the web hosting industry for over 13 years, Rado has inevitably got some insight into the industry. A digital marketer by education, Rado is always putting himself in the client's shoes, trying to see what's best for THEM first. A man of the fine detail, you can often find him spending 10+ minutes wondering over a missing comma or slightly skewed design.