Database table prefix different between wp-config.php and in database

WordPress can only use the tables with the same prefix as listed in the wp-config.php file. Many times when a database has been used for sometime it will hold several version of the site in the same database by adding different table prefixes to the site versions.

This is likely what you are seeing. It seems a backup system or an older version of the site made those other tables but it would be the tables with the $table_prefix = 'wp75_'; that are holding the data for your live site.

Related Posts:

  1. #1067 – Invalid default value for ‘post_date’ when trying to create a new column
  2. WordPress Database Huge wp_usermeta Table
  3. How to migrate a database from a server to another
  4. Why does changing Database Table Prefixes result in loss of content?
  5. DB prefix not updating
  6. I wanted to Know that how can I give ingore to 0000-00-00 in my config file
  7. How to retrieve user data based on role using SQL?
  8. WordPress character set issue
  9. Deleting WordPress posts and media files based on author via MYSQL database
  10. Oracle SQL query for Date format
  11. WPDB Insert or if exists Update
  12. WordPress Unit Testing – Cannot Create Tables
  13. Insert data in database using form
  14. Where are image paths to product category images stored in WordPress database
  15. When is it appropriate to create a new table in the WordPress database?
  16. Has parent field in the table wp_term_taxonomy has term_id or term_taxonomy_id
  17. Display data from a non wordpress database on a page template
  18. Bulk Update of Custom Post Type Post Status through SQL
  19. How do I add indexes to WordPress Database?
  20. Change SQL get_results to search for posts with custom term in custom taxonomy
  21. Block search SQL from happening
  22. wpdb query on custom table not working [closed]
  23. How to execute mulitple statement SQL queries using $wpdb->query?
  24. stdObject stored in database. How does one convert it to usable format?
  25. Database with mixed collation (utf8mb4 & utf8_general_ci)
  26. Using table lock with wp_insert_post?
  27. Scheduling posts in database
  28. Set Display Name to first and last name (phpmyadmin SQL Query)
  29. Size article thumbnails and retrieve them directly from database
  30. Emojis getting converted to “?”
  31. How to query the WordPress database to get posts of a certain custom post type, taxonomy and field?
  32. Delete all post meta except featured image Using SQL
  33. wpdb_prepare with multiple or condition
  34. Accidentally deleted active_plugins portion of the wp_options DB table
  35. Uppercase to sentence case for post titles
  36. Moving to another host; which tables to move in a database
  37. SQL Error wp_commentmeta – incorrect table definition
  38. phpMyAdmin displays error when importing database
  39. WordPress and MySQL: how to transfer Meta_key and Meta_Value from one post_id to another
  40. Change WordPress prefix for only one table?
  41. How do I get the posts within a certain year/date(with sql query)?
  42. WordPress database import: Row size too large
  43. Bulk-create posts from SQL database
  44. input data and output table [closed]
  45. Retrieve data from the database to table such as comments in the admin control panel
  46. Create table from array with prepare
  47. Setup private content for specific users with daily updates [closed]
  48. Connection refused on locahost after importing database?
  49. Which data is written and stored in the database when read-only (non-posting, non-commenting) users visit the site?
  50. Query multiple tables at once?
  51. Changing root password in PHPMyAdmin for WordPress Database when going live
  52. Can’t update WordFence Options, clear data manually
  53. Post Views / Hit Counter Problem?
  54. Is it possible to have more than 1 MySQL database in my WordPress blog?
  55. pull data from a remote wordpress database
  56. Is my way to change WordPress server is correct?
  57. Delete/Replace words from X to Y in post content
  58. SQL query to set posts in bulk based on the post content
  59. How to delete a particular row in a database table
  60. Delete all posts that do NOT have a specific tag
  61. SELECT SQL_CALC_FOUND_ROWS with wordpress search
  62. Files on Localhost, Database on Server
  63. Backing up WordPress database and files
  64. Should I use an additional column in the DB?
  65. wp_option table error while importing
  66. Getting value from database table depending on field value
  67. What is wrong here? Issue with post_id and meta_value
  68. Delete user with only subscriber role
  69. custom tables in wordpress Database? (can i just create them with sql?)
  70. Can’t log into wordpress site – I have made a new user and still cant access
  71. Is there any way to monitor a MySQL db and check what has changed?
  72. Accidently changed the GUID
  73. Deleting empty meta key values
  74. Sql query to get all metadata for a post
  75. How to edit custom table data in frontend
  76. Job and Employee Performance Tracking with Product Safety
  77. Is there any defects for using same database prefix in WordPress for multiple sites?
  78. SQL database import #1046 error
  79. What is recommended data type and encryption type for password in a database
  80. syntax error for changing user role from database
  81. Help posting values to DB on submit using $wpdb->query
  82. What’s the easiest way to connect external database and display data on wordpress?
  83. How to map data on CSV to web pages?
  84. WP website showing blank page after moving from subdomain to main domain
  85. Is there a way for two deferent themes to consume two different DB on a same WP instance?
  86. How to set posts to draft in bulk based on the content of the post
  87. How to create index (sql) to a meta_key?
  88. 2 $wpdb queries causing error Table ‘wp_postmeta’ is specified twice, both as a target for ‘UPDATE’
  89. How to get specific table by current user login
  90. The MySQL Connection could not be established., before it was joomla but i have change it into worpress
  91. $wpdb not working
  92. Check if a database is well installed
  93. Changed meta_key value in structures, now dashboard shows zero users
  94. Link wordpress with a SQl + MongoDB + .NET
  95. Database question while Migrating from one domain to another on same WebHost [Bluehost]
  96. Create hundreds of users with just ID in phpMyAdmin
  97. Migrated to Namecheap, now Trouble with Database & wp-config [closed]
  98. export individual posts to text files or a single csv file
  99. SQL query : Select a thumbnail for a media
  100. Have WordPress Use a Different Database for users
deneme bonusu veren sitelerbahis casinomakrobetceltabetpinbahispolobetpolobet girişpinbahis girişmakrobet girişpulibet girişmobilbahis girişkolaybet giriş