Why does changing Database Table Prefixes result in loss of content?

You should have not searched the field and replaced all the references to wp_ with anything.
For example : the value of the entry with meta_key wp_page_for_privacy_policy will be change to wp_addtionnal_prefix page_for_privacy_policy.
Hence there could be a lot of misfitted values in your table.

A better way would have been to :

  • export the DB
  • import the DB as a new DB
  • rename all tables with the new prefixes
  • export it again
  • import it in you old DB
  • rename prefix in wp_config.php
  • check if everything is allright

Related Posts:

  1. Split WP install between 2 databases?
  2. Inserting Post Meta From SQL
  3. How to execute mulitple statement SQL queries using $wpdb->query?
  4. Delete duplicate rows from wordpress database where a column is duplicate in phpmyadmin
  5. Database with mixed collation (utf8mb4 & utf8_general_ci)
  6. Query WordPress database by registered date and role
  7. Size article thumbnails and retrieve them directly from database
  8. wpdb_prepare with multiple or condition
  9. WordPress mysql table double prefixes
  10. SQL Error wp_commentmeta – incorrect table definition
  11. WordPress and MySQL: how to transfer Meta_key and Meta_Value from one post_id to another
  12. How do I get the posts within a certain year/date(with sql query)?
  13. Create table from array with prepare
  14. Query multiple tables at once?
  15. Why this query is not showing any result on wordpresss home page?
  16. SQL query to set posts in bulk based on the post content
  17. $wpdb->get_var – What value is returned when zero records are found?
  18. DB prefix not updating
  19. I wanted to Know that how can I give ingore to 0000-00-00 in my config file
  20. How to edit custom table data in frontend
  21. How to map data on CSV to web pages?
  22. How to create index (sql) to a meta_key?
  23. Delete all users meta that named: user_avatar
  24. The MySQL Connection could not be established., before it was joomla but i have change it into worpress
  25. Hang Up Followed By Can’t select database
  26. Migrated to Namecheap, now Trouble with Database & wp-config [closed]
  27. export individual posts to text files or a single csv file
  28. SQL query : Select a thumbnail for a media
  29. why you don’t Implement PDO for access every thing to database
  30. SQL Query to get post_id from wp_posts and and meta_key(s) from wp_postmeta
  31. Have WordPress Use a Different Database for users
  32. Deleting WordPress posts and media files based on author via MYSQL database
  33. Database table prefix different between wp-config.php and in database
  34. Count views without get_post_meta
  35. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  36. MySQL SELECT increment counter
  37. how to drop partition without dropping data in MySQL?
  38. MySQL equivalent of DECODE function in Oracle
  39. WordPress (MyISAM) database is slow, should I switch to InnoDB?
  40. WordPress Database lost auto increment
  41. Restoring WordPress posts from database only
  42. Getting wrong relationship value in $args in wp_Query?
  43. Slow wp_term_relationships query
  44. How to use “TRUNCATE TABLE” MySQL statement?
  45. Organizing WP Pages based on old website database
  46. Using Dynamic Data Pulled from a MySQL Table in a WordPress Page
  47. What are conventions about the schema of the $table_prefix
  48. Migrating non-WordPress CMS to WordPress, lots of data to move — possible solutions?
  49. BuddyPress: What’s the use of wp_bp_xprofile_data table and how does it get updated? [closed]
  50. Is deleting orphaned wp_options entries safe?
  51. How to solve slow WordPress site caused by attachment_metadata
  52. Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
  53. Delete all post meta except featured image
  54. WooCommerce – Query for ordered products
  55. Large database causes slow load
  56. Database slowdown after update to 3.4.1
  57. Tons of Twitter rows in my database
  58. How to insert data into MySQL database from the form created in WordPress site
  59. Select Multiple meta_value from WP DB; Single Query
  60. Which is more efficient? Using usermeta, or creating a new MySQL table?
  61. What happens if I overwrite the current wp_options table with a backup from a week ago?
  62. CRUD operations using WordPress database API
  63. Handling large N data in WordPress
  64. How to Mirror WordPress database from Remote server to Local server
  65. WordPress is not creating table in database after activating plugin,
  66. Is MariaDB’s Aria storage engine suitable for WordPress?
  67. Difficulty importing my live site to local
  68. A MySQL DB within a MySQL DB
  69. Is there a way to recover the table wp_term_relationships?
  70. Trouble Migrating all data blog from WordPress.com to WordPress.org
  71. Change options table prefix only
  72. Insert Query not working in the form
  73. Problems with moving my WordPress site to another domain/server
  74. pull data from a remote wordpress database
  75. Clear Terms from Taxonomy for Specific Post IDs?
  76. Trouble running $wpdb->query() with last_insert_id
  77. Moving WordPress site to new domain – database import [duplicate]
  78. Location of WP default mySQL tables creation file?
  79. Can I customised default WP table
  80. How to display data from db in select list [closed]
  81. Will adding & modifying default WordPress table index break future WordPress update
  82. Data is not constatntly loading from custom wordpress table
  83. How can I find user role in Mysql?
  84. Bulk find & replace on WordPress posts/pages (minus image paths)
  85. How do I loop/iterate through posts to edit all img tags?
  86. Featured image from custom to WordPress database
  87. WordPress Database Query works in phpMyAdmin but not in the code
  88. Correct and secure way to access a custom SQL database in a custom PHP template file
  89. How to retrieve user data based on role using SQL?
  90. spambot registering without providing email or password, bypassing registration process
  91. Possible to restore wordpress database from mysql56 and sqlite files?
  92. Missing latest posts and options after DB migration via phpMyAdmin
  93. Widgets with *internal* links do not display after database migration
  94. How do i get value from wp_postmeta?
  95. Restoring .sql backup results in “Error establishing a database connection”
  96. “MySQL server has gone away” since update to 3.8
  97. featured image not showing up with mysql_connect
  98. Getting deleted users in database
  99. Importing Concrete5 content to WordPress
  100. Uploading to WordPress Database