How to back up and restore database using phpMyAdmin – Guide
WordPress hosts, including Kinsta, have automated backups that you can use to restore in case of a disaster. However, there may be times when you need to manually restore and/or upload your own MySQL database. This could be because you are migrating hosts or perhaps want to do local development. Anyway, you can follow this quick and easy tutorial below to restore the MySQL database using phpMyAdmin. If a web GUI fits your admin skills better, Jack Wallen would like to show you how to back up and restore your MySQL / MariaDB databases using one of the easiest tools out there. Many of your business processes depend on databases. If one of these databases fails, your workflow can stop. ..
It would be expensive to avoid this. You need to go back up the databases. I already explained how to do this from the command line. However, there are times when you want to work a little more efficiently, for example with a web GUI like phpMyAdmin.
Back up a database with phpMyAdmin
The first thing we’re going to do is go back up the database. Log into phpMyAdmin and select the database to return up in the left navigation. ..
Select the Export tab and enter the following information into the fields: Database name: mydatabase Filename: mydatabase.sql Export Type: SQL
In the next window, select Quick and SQL format.
You will be prompted to save the export .sql file. Save the file and the backup is complete.
Recover from a backup
If something goes wrong with your database, you can restore it from the most recent backup, but it’s not as easy as backing it up. ..
Delete the failed phpMyAdmin backup by entering this query: DELETE FROM backup WHERE filename=‘failed.sql’ ..
After doing this, you need to create a new database with the same name. Go to the main phpMyAdmin window and go to the Databases tab. Enter the name of the new database and click Create.
In the Import window, click the Browse button and locate the .sql backup file that you downloaded from the export.
Final note
This guide will show you how to back up and restore your database using phpMyAdmin. If you have any query about this article, you may ask us. Additionally, please share your love by sharing this article with your friends.
