We’re back with another new guide to make it easier for you in case you need to backup your database in PHPMyAdmin. A step-by-step guide to safely backup your database for WordPress, Joomla or applications. The following database backup guide is useful when you need to make a quick backup using PHPMyAdmin.
Step 1 – Login PHPMyAdmin
Login to your PHPMYAdmin with your MySQL database username & password and you can access all the features in PHPMyAdmin.
Step 2 – Export Database
Click on the Database name on the left and will shows all the tables. Then click on “Export” on the top menu shown above to enter next screen to export database.
Step 3 – Select Export Method
Select “Quick” or “Custom” method to export your database. We preferred using “Custom” option because you can manually select the tables you want to backup. If not, choose “Select All” to fully backup your database. Select gzipped from the Compression dropdown menu. This will compress your backup file to *.gz file format. Scroll down and click “Go”!
It’s all done in just 3 simple steps! If you’re using CPanel you can use the database backup tool made available.