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
-
Login into phpMyAdmin.
-
On the left of the page, select database name that you want to backup, as an example:
my_database
. Clickmy_database
.. -
Click Export on the above tab, beside Query.
-
On the Export Window, there are two export methods which are Quick and Custom. Select Custom.
-
On the Tables, choose Select all with Structure and Data.
-
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.
-
On Format-specific options, check the Display comments (includes info such as export timestamp, PHP version, and server version).
-
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.
-
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.
No comments yet
Wanna write a response?
You have to login before write a comment to this post.