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. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  33. Case statement in MySQL
  34. Oracle SQL query for Date format
  35. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)
  36. Error: Duplicate entry ‘0’ for key ‘PRIMARY’
  37. Using wpdb to connect to a separate database
  38. WPDB Insert or if exists Update
  39. Checking if Database Table exists
  40. The MySQL alternatives: Do Percona Server and MariaDB work well with WordPress, and do they make WordPress go better?
  41. wpdb->insert multiple record at once
  42. How to monitor server for error establishing a database connection
  43. WordPress for a very large website
  44. WooCommerce with thousands of products – site is very slow – optimize db queries? [closed]
  45. How to Join two tables from separate databases within WordPress
  46. Change SQL get_results to search for posts with custom term in custom taxonomy
  47. Error establishing a database connection – with Debug Data
  48. wpdb query on custom table not working [closed]
  49. stdObject stored in database. How does one convert it to usable format?
  50. Using table lock with wp_insert_post?
  51. Set Display Name to first and last name (phpmyadmin SQL Query)
  52. Migrating database / content of non-CMS site to WordPress
  53. Does WordPress ever need multiple databases?
  54. Why are no posts showing despite my apparently correct DB restoration?
  55. How to query the WordPress database to get posts of a certain custom post type, taxonomy and field?
  56. Delete all post meta except featured image Using SQL
  57. Adding new row to wp_post table
  58. How do I find which articles are missing a featured image in The WordPress database?
  59. WordPress database error – Error in SQL syntax – I can’t identify any error?
  60. Change WordPress prefix for only one table?
  61. Database Tables Lost Indexes? How to Recover?
  62. Using GROUP CONCAT in my-sql query with wp_usermeta table
  63. How to move the WordPress site Layout from test site to Production site?
  64. Retrieve data from the database to table such as comments in the admin control panel
  65. Setup private content for specific users with daily updates [closed]
  66. Migration: Copying database content to a different server
  67. Call to undefined function get_user_meta() – trying to access data in MySQL from custom fields
  68. Have working sql query… trying to adjust it to use $wpdb
  69. creating new field on mysql
  70. Remove empty rows from the database
  71. Error message on blog posts only on my local environment [closed]
  72. Custom WordPress Table wpdb
  73. How can I detect right db type?
  74. Files on Localhost, Database on Server
  75. Second ezSQL initialization for MSSQL
  76. Fetch a single row from a custom table for to a given ID
  77. Database create or redirect
  78. How to escape percentage sign(%) in sql query with $wpdb->prepare?
  79. Recovery – Restore Database after moving folder location locally
  80. Replacing javascript link in WordPress database without getting mysql syntax errors
  81. Performing CRUD operations on front end in wordpress
  82. What is my error trying to create a new table in the database?
  83. Job and Employee Performance Tracking with Product Safety
  84. how to access 2nd Mysqli Database from different server for wordpress
  85. Error establishing a database connection – WordPress setup, everything else is working
  86. Is there a way for two deferent themes to consume two different DB on a same WP instance?
  87. Search and Replace in Windows XAMPP site
  88. The function is deprecated; use mysql_real_escape_string() instead
  89. How can i syn wordpress user table with a stand-alone php script?
  90. insert data from a form:: Warning Empty query mysqli::query()
  91. How can I get $wpdb to show MySQL warnings?
  92. How to get specific table by current user login
  93. WordPress Database Posts Table query
  94. How to extract some part of WordPress full source code
  95. Mysql Queries per Visit – Crazy High
  96. MySQL swap one table for another?
  97. using same mysql user with many databases
  98. Insert double entry in DB
  99. Why are my WordPress post queries so slow?
  100. Custom wordpress SQL statement for a website