How to export data of WordPress using phpMyAdmin?

Export data of WordPress using phpMyAdmin

Why do we need to export data of WordPress using phpMyAdmin?

There many reasons to export data of WordPress. Some of them are the server of host gets old with many other aspects like provider become unreliable, insecure disk space runs out, the host starts charging high etc. There are many other reasons that you have to export data of WordPress.

Log into phpMyAdmin on your server and select database from left side window

 Login database

Select the ‘Export’ tab on the top set of tabs.

Select Export

Ensure that the Quick option is selected, and click ‘Go’ downloading may take a few moments depending on the database size.

Select Custom or Quick option

Choose “Custom” option to export data of WordPress

From format section choose format of the file.

Select Custom option

Select tables from Tables section if you want to export selected tables.

Select tables

You can customize output file from Output section:

1.Rename exported databases/tables/columns.
2.Use LOCK TABLES statement.
3.Save output to a file.
4.File name template.
5.The character set of the file.
6.Compression.
7.Export tables as separate files.
8.View output as text.
9.Skip tables larger than.

Customize output

Format-specific options

1.Display comments (includes info such as export timestamp, PHP version, and server version).
2.Additional custom header comment (\n splits lines).
3.Include a time stamp of when databases were created, last updated, and last checked.
4.Display foreign key relationships.
5.Display MIME types.
6.Enclose export in a transaction.
7.Disable foreign key checks.
8.Export views as tables.
9.Export metadata.
10.Database system or older MySQL server to maximize output compatibility with.

Format-specific options

Object creation options

1.Add CREATE DATABASE / USE statement
2.Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT / TRIGGER statement
3.IF NOT EXISTS (less efficient as indexes will be generated during table creation)
4.AUTO_INCREMENT value
5.Add CREATE VIEW statement
6.Add CREATE PROCEDURE / FUNCTION / EVENT statement
7.Add CREATE TRIGGER statement
8.Enclose table and column names with backquotes (Protects column and table names formed with special characters or keywords)

Object creation options

Data creation options

1.Truncate table before insert
2.INSERT DELAYED statements
3.INSERT IGNORE statements
4.Function to use when dumping data:
5.include column names in every INSERT statement
Example: INSERT INTO tbl_name (col_A,col_B,col_C) VALUES (1,2,3)
6.insert multiple rows in every INSERT statement
Example: INSERT INTO tbl_name VALUES (1,2,3), (4,5,6), (7,8,9)
7.both of the above
Example: INSERT INTO tbl_name (col_A,col_B,col_C) VALUES (1,2,3), (4,5,6), (7,8,9)
8.neither of the above
Example: INSERT INTO tbl_name VALUES (1,2,3)
9.Maximal length of created query
10.Dump binary columns in hexadecimal notation (for example, “abc” becomes 0x616263)
11.Dump TIMESTAMP columns in UTC (enables TIMESTAMP columns to be dumped and reloaded between servers in different time zones)

Data creation options

That is all you need to know about exporting WordPress data. If you want further help, you can contact us here.

Posted on February 15, 2017 in WordPress Development, WordPress For Beginners, WordPress Freebies, WordPress Tips

Share the Story

Back to Top