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
Select the ‘Export’ tab on the top set of tabs.
Ensure that the Quick option is selected, and click ‘Go’ downloading may take a few moments depending on the database size.
Choose “Custom” option to export data of WordPress
From format section choose format of the file.
Select tables from Tables section if you want to export selected 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.
7.Export tables as separate files.
8.View output as text.
9.Skip tables larger than.
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.
10.Database system or older MySQL server to maximize output compatibility with.
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)
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)
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)
That is all you need to know about exporting WordPress data. If you want further help, you can contact us here.