How does the WXR file differ from the WPDB?

There’s not a one-to-one relationship between the WordPress database and the .wxr file.

We can find this line in the exported .wxr file:

<!-- This file is not intended to serve as a complete backup of your site. -->

Skimming through the export_wp() function, we can see what’s excluded, for example:

  • The data stored in the wp_options table isn’t included, so we would loose the widgets, among other things in there. Only few rows from this table are included, like the site’s title, url, language and description and if a given post is sticky.

  • The data for the user meta in the wp_usermeta table is also missing.

  • Some plugins create extra database tables that are not included.

  • Auto draft posts are not included.

  • It looks like some database fields might not be preserved in the restoring process, like the term_taxonomy_id field.

  • … probably some more data that I missed.

One could try to add the missing data to the .wxr file, through the rss2_head action, but then we would have to modify the import part accordingly. You might need to dig further on that, so in the meanwhile I would stick to the .sql dumps for restoring full backups.

Related Posts:

  1. wpdb->insert: do I need to prepare against SQL injection?
  2. How do I check for a duplicate record before inserting using wpdb
  3. WPDB prepare – like % – placeholders?
  4. $wpdb->update multiple rows, like IN in normal SQL
  5. Matching database content types to PHP types
  6. Avoiding “Usage of a direct database call is discouraged”
  7. dbDelta does not create Table, but returns success
  8. passing variables as parameters to stored procedures via wpdb from php-script
  9. Quotes in table name
  10. How Can I Use $wpdb in PayPal IPN file?
  11. $wpdb->query() multiple query support
  12. Is there a (better) way to access $wpdb results?
  13. Set media metadata (i.e. “dimensions” field) on SVG file after extracting it with a filter
  14. Use $wpdb in wordpress theme files
  15. how to execute different sql query in non-sanitized $wpdb->get_results function
  16. $wpdb not returning data
  17. $wpdb Query Result not coming but in phpmyadmin it works [closed]
  18. WPDB update row with != in where clause
  19. Problem in creating table through plugin code
  20. How to email user after inserting the username in database in WordPress
  21. Join inside a wpdb query.. confused!
  22. How to fetch an array in $wpdb?
  23. $wpdb – do you have to use foreach even if there will always only be one result?
  24. Why doesn’t my insert query work?
  25. Need help writing a $wpdb query
  26. How to prevent $wpdb->prepare stripping a leading zero in variable value?
  27. Generate a unique hash/number for tracking on $wpdb insert
  28. $wpdb->insert query changes to SHOW COLUMNS query Output
  29. Rolling Back from current WordPress version to previous one
  30. Modify the structure of data returned by $wpdb
  31. What is wrong with this wpdb update?
  32. using $wpdb to insert a form into a post
  33. Programmatically Creating Page using $wpdb and getting 404 error
  34. wp_create_user not properly entering password
  35. Constructing a dynamic WPDB query with multiple LIKEs
  36. Foreach loop not working as expected – custom tables and references while submitting a form
  37. Query insert query executing multiple times
  38. Undefined offset: 0
  39. Connect to separate database using $wpdb and authenticate user
  40. How to access PostgreSQL using WPDB?
  41. how to use $wpdb->prepare to update a custom table
  42. Counting posts with argument without retrieving the posts
  43. how to assign content to a different author while loading content
  44. $wpdb->insert inserting only f character in custom table
  45. Getting variable from Database
  46. Create new database through static page code
  47. Custom $wpdb returns unexpected time based results
  48. Register custom table for WP to use in a plugin
  49. wpdb->get_row is selecting the variable as a column name
  50. WordPress “wpdb->update” – Append Text Value
  51. Display category names on edit user profile using $wpdb
  52. Need help converting get_user_meta [keys] into own array
  53. Can’t call WPDB inside RSS template
  54. wpdb and acf via wp rest api
  55. WPDB SQL Ignore `post_status` Parameter
  56. Save sql file after doing insert wpdb
  57. wpquery properties last_query and last_result : should these be public or private?
  58. Can I use wpdb to insert query results into a post?
  59. $wpdb->prepare error after WordPress update [duplicate]
  60. Query and get meta as object(stdClass) on wp postmeta table?
  61. How do I query a table?
  62. check that the data exists before sending it to wpdb
  63. How to pass an input value into wpdb->Prepare
  64. wpdb->insert with special chars failing with collation utf8mb4_unicode_520_ci
  65. no result returns when using $wpdb->get_results with where clause
  66. SQL queries to another wordpress site
  67. PHP | left join avg query give me Array()
  68. update not working using wpdb
  69. get_posts() SQL Injection
  70. og:image functions.php
  71. wpdb replace returning 1 where delete and insert is expected
  72. How to work with constraints on wordpress user metadata?
  73. $wpdb select returns empty array
  74. Show error messages to a user when database insert fails
  75. Debugging db calls: $wpdb->insert works on test site, not on identical production site
  76. Intermittent problem writing update_user_meta
  77. How to use WHERE NOT EXISTS query to avoid duplicate entry using $wpdb to save in custom table?
  78. Combine posts and postmeta
  79. wpdb get_row database query inquiry
  80. Depreciated Call -> Function wpdb::escape()
  81. How do I update post based on meta_key in another table?
  82. wpdb insert working in one function, but not another
  83. Inserting and updating rows with wpdb indreases integer fields by 1 point sometimes
  84. Retrieve a list of users based on some conditions
  85. wp_commentdata: error in documentation?
  86. Echo only gives me the first part of string
  87. wp-postratings: list current user’s unrated posts
  88. esc_sql inserting weird chars to DB
  89. Error inserting row into table
  90. Retriving array size from serialized data
  91. How to update user profile or inputing any data to the wp db from external site?
  92. Can’t get expected result from a wpdb query
  93. Get comments after specific date
  94. get only 1 wpdb and get taxonomy, post to next page [closed]
  95. Query Problem in Clustom Plugin
  96. $wpdb The query does not contain the correct number of placeholders
  97. Get count of rows based if column exists in two different tables
  98. Table wont load into WPDB
  99. $wpdb:insert, more arguements in $format array than in $data
  100. WPDB prepare – like % – placeholders?
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)