Every time I export a database using the Export Tool in wp-admin. There are two things left out: The category 'checked' (I have to do that all over again every time I export the posts). Also I can't download the pictures because I usually work in my localhost.

How to export absolutely everything (100%) from the database of a Wordpress site?

1 Answer 1


To export everything in the database, go to your hosting provider's control panel such as CPanel and find out how to do "an SQL dump". An SQL dump is a text file containing the SQL script to rebuild your database on your local computer. You can often do that in software your host may provide named phpMyAdmin.

Alternately you could use a desktop SQL tool; if you are on Windows one of my favorites is the free HeidiSQL; on Mac I used the commercial software Navicat for MySQL which I also used on Windows because of advanced features that HeidiSQL did not have. If you use a desktop tool you will probably have to enable remote access to MySQL from your IP address.

After you've imported your SQL dump, you can consider using this plugin to "fix up" all your URL references.

Hope this helps.


P.S. You'll need to use FTP to download all of your photos and other files you may have uploaded.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.