How do I restore a Mysql database backup?

Procédure

Before restoring your MySQL database, [PERSON_NAME] Backup policy for your shared web hosting to check what is backed up according to your plan.

Objective

This documentation explains how to download or restore a backup of your MySQL database from the LWS Panel.
This operation can be useful if you want to recover an older version of your site after an error, content deletion, a mistaken action, or a recent malfunction.

This documentation applies to

This procedure is intended for customers with LWS Linux shared hosting, managed from the LWS Panel.

The hosting must support MySQL database management, which excludes domain-only plans.

Before you begin

Make sure you have the following:

• an idea [PERSON_NAME] date on which you want to recover your database;
• the certainty that you want to replace the current state of the database with an older version.

It is also important to understand that a MySQL database may contain essential elements of your site, [PERSON_NAME], settings, user accounts, orders or forms depending on the tool used. Restoring this database can therefore significantly change the behavior of the site.

What you need to know before restoring a backup

Restoring a database does not always return a complete site to the expected state on its own.
In fact, a website often relies on two separate elements:

• its web files ;
• its MySQL database.

If you restore only the database, but the site files are newer, you may end up with a partially inconsistent site. You need [PERSON_NAME]/a/108">to restore the web files to the same date.

Check that MySQL restoration is available on your plan

The LWS Panel offers a one-click restore feature for different services, including web data, MySQL and mail. [PERSON_NAME] plan: some offers allow access to backups from the last 30 days, others to those from the last 90 days.

Before going any further, make sure your hosting plan includes the backup retention level you need.

Access MySQL backups in the LWS Panel

Step 1 : Start by logging into your LWS account with your usual credentials.

[PERSON_NAME]> : Once logged in, access the shared hosting where the database you want to view, [PERSON_NAME] restore, is located.

[ADDRESS]> : In the LWS Panel, find the Files section, [PERSON_NAME] Backups / Restores.

Step 4 : On the backup page, click the MySQL Backups tab.

You will then see the list of backups available for your hosting plan.

Download a MySQL database backup

Downloading a backup is recommended if you want to keep a copy before making a sensitive change, or simply retrieve a database file from a specific date.

Step 1 : In the MySQL Backups tab, look for the backup date you are interested in.

[PERSON_NAME]> : On the line corresponding to the selected backup, click the actions button on the right (1).

Step 3 : In the available actions, click Download database (2).

[PERSON_NAME] 4 : The download starts automatically through your web browser.
The file will be saved in the download folder usually used by your browser.

Expected result

At the end of this operation, you will have a local copy of your MySQL backup on your computer.
You can keep it as a backup or use it for a technical intervention.

Restore a MySQL database backup

Restoring allows you to return your database to its previous state on the selected date.

Warning before continuing

Restoring replaces the data currently present in the database with the data contained in the selected backup.
In other words, changes made after this date may be lost.

Before confirming the restore, take a few seconds to make sure you have selected the correct date.

Step 1 : In the MySQL Backups tab, [PERSON_NAME] backup corresponding to the desired date.

Step 2 : Click the button on the right (1) of the relevant backup to display the available actions.

Step 3 : Click Restore database (2).

Step 4 : A confirmation window opens.

Read the displayed message carefully, then confirm only if you are sure you want to start the restore.

Step 5 : After confirming, open the History tab to track the progress of the operation.

This section lets you view progress and check the restore status.

You can refresh the page regularly to see whether the status changes.

Step 6 : The restore may take several minutes.

The delay mainly depends on the size of the database to be restored.

Check that the restore worked correctly

Once the restore status is complete in the History tab, perform the following checks:

First, check that the operation no longer appears as in progress.

Then, open your website or the relevant tool in your browser, as you normally do.

It is recommended to clear the cache or refresh the page if the expected result does not appear [PERSON_NAME]>

Then check the problematic element in practice. For example:

• a page that had disappeared;
• content that was modified by mistake;
• settings that changed;
• a part of the site that no longer worked correctly.

Expected result

If the restore [PERSON_NAME], your database has returned to the state it was in on the selected date.

Important point

If the site remains inconsistent after the restore, [PERSON_NAME] mean that only the database contents were restored, but not the site files. In this case, it may be necessary to also restore the web files to the same date to recover a consistent site state.

Common issues and solutions

What should I do if the desired backup does not appear?

If the backup you are looking for is not visible in the list, several cases are possible.

Case 1: the date you are looking for is beyond the period included in your plan: you may have backups for 30 days or for 90 days. [PERSON_NAME] sought is older than the period included in your plan, [PERSON_NAME] displayed.

Case 2: your plan does not provide access to a sufficient retention period: subscribing to the Business support option allows access to backups for up to 90 days instead of 30 days.

Case 3: you need a specific search or intervention: [PERSON_NAME] backup date, a service such as backup search, carried out by a technician, is required to retrieve the backup.

Case 4: the date is too old: beyond 90 days, backups are deleted. In this case, they can no longer be restored.

I can't find [ADDRESS] backup

Start by checking whether your plan provides access to 30 or 90 days of retention.
[PERSON_NAME] older than the included duration, it cannot be displayed.

The backups offered correspond to the last 7 daily backups and then one weekly backup over a maximum period of 3 months.

The restore seems to be taking a long time

This may be normal. The operation can take several minutes depending on the volume of data. [PERSON_NAME] the History tab and refresh the page before concluding that there is a malfunction.

My site does not seem to have changed after the restore

Clear your browser cache, then reload the page.
Then check a specific element of the site.
If the site remains inconsistent, [PERSON_NAME] a restoration of the web files on the same date as the database.

An error appears during or after the restore

In the event of an error, you must contact technical support so that a technician can analyze the problem and intervene if the action is possible.

When contacting support, prepare the following information if possible:

• the name of the site or hosting concerned;
• the selected backup date;
• the time when the error occurred;
• a screenshot of the displayed message.

Conclusion

You now know how to:

• access MySQL backups from the LWS Panel ;
• download a database backup;
• restore a database to an earlier date;
• track the progress of the restore from the History tab ;