Quick backup process
When you backup all tables in the WordPress database without compression, you can use simple method. To restore this backup, your new database should not have any tables.
1.Log into phpMyAdmin on your server
2.From the left side window, select your WordPress database. In this example, the name of database is “wp”.
3.The right side window will show you all the tables inside your WordPress database. Click the ‘Export’ tab on the top set of tabs.
4. Ensure that the Quick option is selected, and click ‘Go’ and you should be prompted for a file to download. Save the file to your computer. Depending on the database size, this may take a few moments.
