Take the 2-minute tour ×
WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. It's 100% free, no registration required.

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
add comment

1 Answer

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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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