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. #1067 – Invalid default value for ‘post_date’ when trying to create a new column
  2. Split WP install between 2 databases?
  3. Inserting Post Meta From SQL
  4. How to execute mulitple statement SQL queries using $wpdb->query?
  5. Delete duplicate rows from wordpress database where a column is duplicate in phpmyadmin
  6. Database with mixed collation (utf8mb4 & utf8_general_ci)
  7. Query WordPress database by registered date and role
  8. Size article thumbnails and retrieve them directly from database
  9. wpdb_prepare with multiple or condition
  10. WordPress mysql table double prefixes
  11. SQL Error wp_commentmeta – incorrect table definition
  12. WordPress and MySQL: how to transfer Meta_key and Meta_Value from one post_id to another
  13. How do I get the posts within a certain year/date(with sql query)?
  14. Create table from array with prepare
  15. Query multiple tables at once?
  16. Why this query is not showing any result on wordpresss home page?
  17. SQL query to set posts in bulk based on the post content
  18. $wpdb->get_var – What value is returned when zero records are found?
  19. DB prefix not updating
  20. I wanted to Know that how can I give ingore to 0000-00-00 in my config file
  21. How to edit custom table data in frontend
  22. How to map data on CSV to web pages?
  23. How to create index (sql) to a meta_key?
  24. Delete all users meta that named: user_avatar
  25. The MySQL Connection could not be established., before it was joomla but i have change it into worpress
  26. Hang Up Followed By Can’t select database
  27. Migrated to Namecheap, now Trouble with Database & wp-config [closed]
  28. export individual posts to text files or a single csv file
  29. SQL query : Select a thumbnail for a media
  30. why you don’t Implement PDO for access every thing to database
  31. SQL Query to get post_id from wp_posts and and meta_key(s) from wp_postmeta
  32. Have WordPress Use a Different Database for users
  33. Deleting WordPress posts and media files based on author via MYSQL database
  34. Database table prefix different between wp-config.php and in database
  35. Count views without get_post_meta
  36. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  37. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  38. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  39. Rename a table in MySQL
  40. How should I tackle –secure-file-priv in MySQL?
  41. What is “Advanced” SQL?
  42. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  43. Case statement in MySQL
  44. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  45. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  46. How do I restore a dump file from mysqldump?
  47. MySQL SELECT increment counter
  48. Error Code: 2013. Lost connection to MySQL server during query
  49. how to drop partition without dropping data in MySQL?
  50. 1052: Column ‘id’ in field list is ambiguous
  51. 1052: Column ‘id’ in field list is ambiguous
  52. difference between primary key and unique key
  53. Creating a search form in PHP to search a database?
  54. Oracle SQL query for Date format
  55. phpMyAdmin – Error > Incorrect format parameter?
  56. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)
  57. MySQL equivalent of DECODE function in Oracle
  58. How to do a batch insert in MySQL
  59. Error: Duplicate entry ‘0’ for key ‘PRIMARY’
  60. Data is not constantly loading from custom wordpress table
  61. Using wpdb to connect to a separate database
  62. MySQL Database User: Which Privileges are needed?
  63. Why is my database import losing text widget data?
  64. WPDB Insert or if exists Update
  65. Multiple developers / editors working on a site in progress
  66. Will it break my site if I delete all transient records in wp_options table?
  67. Checking if Database Table exists
  68. WordPress (MyISAM) database is slow, should I switch to InnoDB?
  69. Please explain how WordPress works with MySQL character set and collation at a low level
  70. The MySQL alternatives: Do Percona Server and MariaDB work well with WordPress, and do they make WordPress go better?
  71. How to fetch Data in WordPress using MySQLi or $wpdb
  72. WordPress Database lost auto increment
  73. Connect to database using wordpress wp-config file
  74. wpdb->insert multiple record at once
  75. Reset Post IDs to less than 64bit integer
  76. How To Export/Import WordPress (MySQL) Database Properly Via Command-Line?
  77. Restoring WordPress posts from database only
  78. WordPress database scalability from the code perspective
  79. WordPress Unit Testing – Cannot Create Tables
  80. How to define composite keys with dbDelta()
  81. Insert data in database using form
  82. Is it possible to define two databases for one installation?
  83. Does WordPress use the InnoDB engine for MySQL by default?
  84. Where are image paths to product category images stored in WordPress database
  85. When is it appropriate to create a new table in the WordPress database?
  86. Has parent field in the table wp_term_taxonomy has term_id or term_taxonomy_id
  87. Getting wrong relationship value in $args in wp_Query?
  88. Slow wp_term_relationships query
  89. How to use “TRUNCATE TABLE” MySQL statement?
  90. Sharing database for collaborative development
  91. Can I use MariaDB instead of MySQL in wordpress?
  92. Display data from a non wordpress database on a page template
  93. How to monitor server for error establishing a database connection
  94. Organizing WP Pages based on old website database
  95. Using Dynamic Data Pulled from a MySQL Table in a WordPress Page
  96. How To Make Connection To WordPress Data Base In A Plugin?
  97. WordPress for a very large website
  98. What are conventions about the schema of the $table_prefix
  99. WooCommerce with thousands of products – site is very slow – optimize db queries? [closed]
  100. Migrating non-WordPress CMS to WordPress, lots of data to move — possible solutions?
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)