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
1. go to Browse and type http://localhost/phpMyAdmin or http://127.0.0.1/phpMyAdmin.
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**
1. Browse to http://localhost/phpMyAdmin or http://127.0.0.1/phpMyAdmin.
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
Watch video How to Backup and Restore MySQL/MariaDB Databases by phpmyadmin online without registration, duration hours minute second in high quality. This video was added by user Linux Super User 20 September 2020, don't forget to share it with your friends and acquaintances, it has been viewed on our site 621 once and liked it like people.