Big WordPress MySQL Database : Various Ways to Export and Import

Big WordPress MySQL Database Dump is a headache to Export and Import. Here are various Ways to Export and Import your big WordPress MySQL Database easily. Exporting is not really a problem. If you have PHPMyAdmin (most has), then in tar format Big WordPress MySQL Database Dump  becomes relatively smaller. But the problem with such  Big WordPress MySQL Database Dump is Importing. If you try from PHPMyAdmin, a compressed  Big WordPress MySQL Database Dump of 200 MB can not be uploaded. So here here are all the ways to Import and Export  Big WordPress MySQL Database Dump.

Planning to Import and Export Big WordPress MySQL Database

Planning is needed for bigger sized ones. For the smaller ones, its quite easy. You can follow our Moving WordPress Blog or Website guide for smaller databases. We are talking about over 150 MB sized databases.

Understand which Tables and Rows are making the  Big WordPress MySQL Database : Probably its the comment meta, if so, follow this guide to make the big WordPress MySQL Database smaller. If Posts making it bigger, other planning needed.

Always Optimize a Big WordPress MySQL before Importing : Simple thing, Check All the Tables and select to optimize :

Drop the Tables of some deleted Plugins : Some Plugins, even after deletion, remains there. These are reasons behind a big WordPress MySQL Database Size. Simply drop them.

Optimize or Delete Data not Essential : 404 plugins, Redirection Plugins keep data in their tables, you can reduce some size of your big WordPress MySQL database by deleting the logs from WordPress those plugin’s page.

Plan whether it is possible to import the optimized but still big WordPress MySQL database : If you have Shell access or even you know how to run cronjob, it is possible to bypass this size limit. But if you can not (sometimes the old server is a crap server, it will fail to export and tar), then think to import and export table by table.

Ways to import and export Big WordPress MySQL database

1. Shell / Terminal : Easiest way. Ask your webhosting company about details of the OS they are running and run command to tar the big WordPress MySQL database. Then from the new server’s Shell, use wget command to pull that big WordPress MySQL on your new server. Untar it. Run command to restore it. Your big WordPress MySQL database is not any headache.
2. Table by Table : Select one Table each time and export it as gzip from PHPMyAdmin. Restore / Import in the same way in new server.
3. All fails to import my big WordPress MySQL database : It might happen, due to very old PHPMyAdmin, the gzip version can not import properly your table by table plan to import big WordPress MySQL database. In this case, to import that big WordPress MySQL database, you have to run SQL queries table by table. Simply export that big WordPress MySQL database’s one table at one time as SQL – it will open in any text editor. Do not touch a single line. Select the full thing and Copy it. Go to New server’s PhpMyAdmin and click the SQL tab. Paste the whole thing and hit go. The table will be created.

Comments on importing big Big WordPress MySQL database

• The best way to restore a big WordPress MySQL database is using shell.
• The worst way to restore a big WordPress MySQL database is running SQL  queries.

Incoming search terms:

Visitors Read This Post Also Read:

1. Optimize WordPress Blog from the database for smoother performance WordPress needs some special tweak to run perfectly. We need to optimize WordPress Blog from...
2. Reduce WP_commentmeta Table Database Size in WordPress …...
3. Moving WordPress Blog or Website : Full Guide For Every Situation Moving WordPress Blog or Website can be one of the toughest job, if you think...
4. Indispensable MySQL queries for custom fields in WordPress WordPress stores the data (articles, pages, categories, etc) in a MySQL database. It is therefore...
5. Change the password of a user via phpMyAdmin WordPress The MySQL database for WordPress stores all user passwords in the table wp_users. With phpMyAdmin,...
6. Tips to Optimize WordPress Running on Dedicated Server This is a comprehensive guide or bunch of tips to Optimize WordPress Running on Dedicated...
7. MySQL Persistent Connection to Optimize WordPress MySQL Persistent Connection can be used to Optimize WordPress Page Loading Speed. It depends on...
8. Clean Up Weird Characters Plugin : Get Rid Off Odd Charecters in WordPress …...
9. Install WordPress on Free Web Server Helio Host : Step by Step Guide As we have written in our previous article, Helio Host gives fully free cPanel enabled...
10. LAMP : Linux, Apache, MySQL, PHP Combination to Drive Websites LAMP is an acronym for the combined use of programs based on Linux to provide...
11. 500 Internal Server Error WordPress – How To Fix 500 Error If you are facing 500 Internal Server Error for your WordPress after migration from one...
12. PHP : Server-Side Programming Language for Dyanamic Websites Almost all of has heard of PHP. But, what is this PHP ? PHP is a...
13. WordPress Tutorial Series : Must Have WordPress Plugins …...
14. Install Magento on Rackspace Cloud Sites : Step by Step Guide Install Magento on Rackspace Cloud Sites by following this easy Step by Step Guide. Install...
15. Reasons to use WordPress for business or a blog website Presentation of features a WordPress Blogging platform   WordPress is the blogging platform used most...