Export .XML vs using phpMyAdmin to export .SQL

  • I would like to hear from moderators or administrators, but if developers have some opinions, please share them.

    When moving or copying a working WordPress installation, or backing it up, what is the practical difference between these two methods:

    1) Exporting the database as an .xml file from within the WordPress Dashboard

    2) using a tool such as phpMyAdmin to export the database as an .sql file

    Does WordPress 3.2.1 “prefer” one method over the other? What do you recommend?

    Of course, on the other end, when migrating to a new hosting situation, it’s necessary to create a blank, pristine WordPress installation and then

    1) use the WordPress Dashboard’s Import command to read in the .xml file

    or

    2) use phpMyAdmin to import the .sql database to overwrite the existing .sql database that the site was created with.

    I have successfully used the .sql method with phpMyAdmin with my site. Would it be easier, better or more reliable to use the .xml method?

    Why do both methods exist in the first place?

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

  • I have this same question. I am confused about the difference between the two.

    Method 1 copies only content from one site to another.
    Method 2 copies everything (themes settings, plugin settings, urls etc)

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Export .XML vs using phpMyAdmin to export .SQL’ is closed to new replies.