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. WordPress Database Huge wp_usermeta Table
  2. How to migrate a database from a server to another
  3. Why does changing Database Table Prefixes result in loss of content?
  4. DB prefix not updating
  5. I wanted to Know that how can I give ingore to 0000-00-00 in my config file
  6. How to retrieve user data based on role using SQL?
  7. WordPress character set issue
  8. Deleting WordPress posts and media files based on author via MYSQL database
  9. What is “Advanced” SQL?
  10. WordPress Unit Testing – Cannot Create Tables
  11. Insert data in database using form
  12. Where are image paths to product category images stored in WordPress database
  13. When is it appropriate to create a new table in the WordPress database?
  14. Has parent field in the table wp_term_taxonomy has term_id or term_taxonomy_id
  15. Sharing database for collaborative development
  16. Display data from a non wordpress database on a page template
  17. Inserting Post Meta From SQL
  18. BuddyPress: What’s the use of wp_bp_xprofile_data table and how does it get updated? [closed]
  19. Bulk Update of Custom Post Type Post Status through SQL
  20. How do I add indexes to WordPress Database?
  21. Moving an entire wordpress site from one domain to a new domain and database
  22. Delete all post meta except featured image
  23. Block search SQL from happening
  24. Delete duplicate rows from wordpress database where a column is duplicate in phpmyadmin
  25. How to Move Local Singlesite Database to Remote Multsite Database?
  26. Scheduling posts in database
  27. Size article thumbnails and retrieve them directly from database
  28. Emojis getting converted to “?”
  29. wpdb_prepare with multiple or condition
  30. Accidentally deleted active_plugins portion of the wp_options DB table
  31. Uppercase to sentence case for post titles
  32. Moving to another host; which tables to move in a database
  33. WordPress mysql table double prefixes
  34. WordPress and MySQL: how to transfer Meta_key and Meta_Value from one post_id to another
  35. WordPress database import: Row size too large
  36. Export / import WordPress database
  37. Bulk-create posts from SQL database
  38. input data and output table [closed]
  39. Retrieve data from the database to table such as comments in the admin control panel
  40. Create table from array with prepare
  41. Which data is written and stored in the database when read-only (non-posting, non-commenting) users visit the site?
  42. Change options table prefix only
  43. Insert Query not working in the form
  44. Problems with moving my WordPress site to another domain/server
  45. Changing root password in PHPMyAdmin for WordPress Database when going live
  46. Can’t update WordFence Options, clear data manually
  47. Post Views / Hit Counter Problem?
  48. Is it possible to have more than 1 MySQL database in my WordPress blog?
  49. pull data from a remote wordpress database
  50. Clear Terms from Taxonomy for Specific Post IDs?
  51. Is my way to change WordPress server is correct?
  52. Options on how to Display member specific data from a MS SQL database
  53. Delete/Replace words from X to Y in post content
  54. How to delete a particular row in a database table
  55. Location of WP default mySQL tables creation file?
  56. SELECT SQL_CALC_FOUND_ROWS with wordpress search
  57. Files on Localhost, Database on Server
  58. Should I use an additional column in the DB?
  59. $wpdb->get_var – What value is returned when zero records are found?
  60. wp_option table error while importing
  61. Installing local to live WP into subdirectory
  62. WordPress SQL – How to Check for Category?
  63. Getting value from database table depending on field value
  64. What is wrong here? Issue with post_id and meta_value
  65. Delete user with only subscriber role
  66. custom tables in wordpress Database? (can i just create them with sql?)
  67. Can’t log into wordpress site – I have made a new user and still cant access
  68. Is there any way to monitor a MySQL db and check what has changed?
  69. Accidently changed the GUID
  70. Deleting empty meta key values
  71. I imported an restore an database and It shows #1067 – Invalid default value for ‘user_registered’
  72. How to edit custom table data in frontend
  73. I need to find posts that contain YouTube links without http:// or https:// prefix and add http:// to all of them
  74. Migrating meta_key and meta_value from old theme to new one
  75. What is recommended data type and encryption type for password in a database
  76. Help posting values to DB on submit using $wpdb->query
  77. What’s the easiest way to connect external database and display data on wordpress?
  78. Duplicate database to roll back theme & content changes
  79. How to map data on CSV to web pages?
  80. WP website showing blank page after moving from subdomain to main domain
  81. How to set posts to draft in bulk based on the content of the post
  82. How to create index (sql) to a meta_key?
  83. 2 $wpdb queries causing error Table ‘wp_postmeta’ is specified twice, both as a target for ‘UPDATE’
  84. Delete all users meta that named: user_avatar
  85. How to get specific table by current user login
  86. $wpdb not working
  87. Changed meta_key value in structures, now dashboard shows zero users
  88. Link wordpress with a SQl + MongoDB + .NET
  89. Options table – where does my values go?
  90. How to add data from wordpress tables to new database tables you have created
  91. Database question while Migrating from one domain to another on same WebHost [Bluehost]
  92. Install WordPress with SQL database
  93. Create hundreds of users with just ID in phpMyAdmin
  94. Migrated to Namecheap, now Trouble with Database & wp-config [closed]
  95. export individual posts to text files or a single csv file
  96. why you don’t Implement PDO for access every thing to database
  97. SQL query to rewrite all media URLs to end with .webp
  98. Weird WP -Cli Error Connection Refused
  99. Have WordPress Use a Different Database for users
  100. Count views without get_post_meta