Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How to back up the WordPress database?

April 26, 2017database WordPress

0

Posted

How to back up the WordPress database?

1 Answer

0

Posted

1. login to the PhpMyAdmin and select the database being used by WordPress from the list of databases. 2. The next screen opened will show you the tables in the database and different tabs. Click on the tab “Export” 3. In the export section select SQL. In case more than one installation are using the same database select the tables with the prefix you mentioned while installing this WordPress instance 4. In the SQL section select the following * Structure * Add DROP TABLE * Add AUTO_INCREMENT * Enclose table and field names with back quotes 5. In the DATA section check the checkbox next to the DATA and leaving all checkboxes inside unchecked 6. Check the “Save as file” option and specify the file name template if you want else leave it like it is. 7.