Tutorials

Backup Database WordPress with PHPMyAdmin

Posted by I. B. Gd Pramana A. Putra, 13 Jul 22, last updated 24 Sep 22

Backing up a WordPress database can be done in many ways, such as using a free plugin that can be downloaded via wordpress.org, another way is through cPanel, the WP-CLI command line, and so on.

This tutorial will explain briefly and straightforwardly how to backup WordPress database with phpMyAdmin.

Step by step to Backup Database WordPress with PHPMyAdmin

  1. Login into phpMyAdmin.

  2. On the left of the page, select database name that you want to backup, as an example: my_database. Click my_database..

  3. Click Export on the above tab, beside Query.

  4. On the Export Window, there are two export methods which are Quick and Custom. Select Custom.

  5. On the Tables, choose Select all with Structure and Data.

  6. On the Output part, click Rename exported database/tables/columns if you wish to use another name when importing this database later on, but if not, leave it empty.

  7. On Format-specific options, check the Display comments (includes info such as export timestamp, PHP version, and server version).

  8. On Object creation options, in its sub option Add statements, check Add DROP TABLE / VIEW / PROCEDURE/ FUNCTON / EVENT / TRIGGER statement, also check IF NOT EXIST, AUTO_INCREMENT value, Add CREATE VIEW, Add CREATE PROCEDURE / FUNCTION / EVENT, Add CREATE TRIGGER. Enclose table and column names with backquotes.

  9. On Data creation options, choose Function INSERT, and enable: both of the above.

After following the steps above, click Go to export your WordPress database based this configuration.

Answer & Responses
    No comments yet

Wanna write a response?

You have to login before write a comment to this post.