How to Backup and Restore MySQL/MariaDB Databases by phpmyadmin

******how to Backup and Restore MySQL/MariaDB Databases*****

A) using phpMyAdmin

***backup process***

//server must be running


2. Select the database to be backed up from the list in the left navigation pane

3. Select the "Export" command in the top navigation bar

4. select "Quick" as the export method and "SQL" as the output format. Click "Go" to proceed.

5. the browser will prompt you to download it

6. This text file is your backup, so store it safely!

7. removing database for this tutorial

***restore process***


2. Select the "New" command in the left navigation pane

3. create new database(same as previous if not then you have to configure wp config file)

Select the collation "utf8_general_ci".

4. select the database you have just created and select the

"Import" command in the top navigation bar.

5. browse your backup file









- MySQL/MariaDB Tutorials
















How to Backup and Restore MySQL/MariaDB Databases by phpmyadmin