wordpress database backup

  • bestofboth333

    (@bestofboth333)


    16 years, 11 months ago

    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

    (@figaro)

    16 years, 11 months ago

    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

    Thread Starter bestofboth333

    (@bestofboth333)

    16 years, 11 months ago

    Thanks!

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

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