Articles

Due to various circumstances, there is a need to restore data. With the help of cPanel, you can easily restore the databases you need. Here are the steps to guide you in restoring your databases in cPanel.

Steps to restore the MySQL database in cPanel:

• Login to your cPanel account.
• Click the backup option under the file section.
• In the next window, click the file under Restore a MySQL Database Backup.
• Navigate and select the.sql.gz file that you want to restore.
• Click the open button and click on upload, and it will take time to restore based on the databases.

Steps to restore the databases with phpMyAdmin in cPanel:

• Select phpMyAdmin under the “Database” section.
• From the left-hand sidebar, select the database where you wish to restore the data.
• Once you have selected the database, click on the import button, which is located at the top of the page.
• Under the file to import section, click on the choose file button to browse your computer and select the SQL backup file you want to restore.
• You can configure options for the import process, such as character and format, and you can also set them as default.
• Once you have finished with the SQL file and settings, click on the “Go” button to start the import process. It takes time to complete the process, and as said before, it depends on the size of the database you're restoring.
• If the restoration process is completed, you will be notified by a message that the databases have been imported.

Always perform database restoration with caution, and consider creating backups of your current data before attempting a restore.