Backing up and restoring your MySQL database is an essential part of keeping your website safe and recoverable in case of errors, updates, or unexpected issues. Using phpMyAdmin in your WPO portal, you can easily download a copy of your database for safekeeping or restore it from a backup when needed. This guide will walk you through the step-by-step process for both backing up and restoring your MySQL databases.
Backup MySQL Database
Login to your WPO portal using this link.
Click on 'My Sites', select your site, and under Site Details, click on 'phpMyAdmin'.
Under phpMyAdmin details, click on 'Open phpMyAdmin Portal'.
Now use the login details provided to access it, and click on 'Log In'.
Select the database you would like to backup from the left navigation.
Click the Export tab and Choose the 'Quick' export method, select the 'SQL' option and click 'Go'.
The database dump will be downloaded to your local machine's default download location.
Restore MySQL database from a Dump
Choose the database we want to restore from the left navigation.
The phpMyAdmin script that restores the database does not drop the tables so click the 'Check All' check box.
Select the 'With selected:' drop-down menu and choose 'Drop'.
Click the 'Import' tab and browse for the database backup.
Click Go to import the database.
Congratulations! You’ve successfully backed up and restored your MySQL database using phpMyAdmin.
If you have any questions, please don’t hesitate to contact our team via live chat.
For technical inquiries, please feel free to reach our support team by emailing support@bigscoots.com from your registered email or by submitting a support ticket.