Take the 2-minute tour ×

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?

share|improve this question

1 Answer 1

up vote 2 down vote accepted

Hi @janoChen

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.

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

share|improve this answer

Your Answer


