Title: wordpress database backup
Last modified: August 19, 2016

---

# wordpress database backup

 *  [bestofboth333](https://wordpress.org/support/users/bestofboth333/)
 * (@bestofboth333)
 * [16 years, 11 months ago](https://wordpress.org/support/topic/wordpress-database-backup-1/)
 * Hi,
 * I have a few questions about the .sql file that is produced when one uses the
   WordPress database backup plugin:
 * 1) Can one extract information from this file? The comments appear to be buried
   within hard-to-parse tags. Is there any way to get a plain text dump of all the
   comments?
    2) It does not appear that the attachments are backed up into this
   file. One would have to backup the “uploads” directory separately, but how does
   one associate those attachments with their original contents? Does one have to
   reinstall wordpress on a new computer (let’s assume the first one melted) in 
   order to make any use of this data backup?
 * Thanks!

Viewing 2 replies - 1 through 2 (of 2 total)

 *  [figaro](https://wordpress.org/support/users/figaro/)
 * (@figaro)
 * [16 years, 11 months ago](https://wordpress.org/support/topic/wordpress-database-backup-1/#post-1125456)
 * 1. You could dump just the comments table and get a pretty clean result.
 * 2. Correct…the attachments are stored in the uploads directory…the db just stores
   info to relate these to the posts, pages, media, locations. If you backup the
   uploads directory, then you have all your “files”. If you want to know which 
   posts/pages they are associated with, then installing (copying) you install on
   a local machine would do the trick.
 * See the following videos for creating a local copy of your blog using XAMPP.
 * [http://educhalk.org/blog/?tag=xampp](http://educhalk.org/blog/?tag=xampp)
 *  Thread Starter [bestofboth333](https://wordpress.org/support/users/bestofboth333/)
 * (@bestofboth333)
 * [16 years, 11 months ago](https://wordpress.org/support/topic/wordpress-database-backup-1/#post-1125627)
 * Thanks!

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘wordpress database backup’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 2 participants
 * Last reply from: [bestofboth333](https://wordpress.org/support/users/bestofboth333/)
 * Last activity: [16 years, 11 months ago](https://wordpress.org/support/topic/wordpress-database-backup-1/#post-1125627)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics