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. What is “Advanced” SQL?
  11. Oracle SQL query for Date format
  12. WPDB Insert or if exists Update
  13. WordPress Unit Testing – Cannot Create Tables
  14. Insert data in database using form
  15. Where are image paths to product category images stored in WordPress database
  16. When is it appropriate to create a new table in the WordPress database?
  17. Has parent field in the table wp_term_taxonomy has term_id or term_taxonomy_id
  18. Sharing database for collaborative development
  19. Display data from a non wordpress database on a page template
  20. Organizing WP Pages based on old website database
  21. Inserting Post Meta From SQL
  22. BuddyPress: What’s the use of wp_bp_xprofile_data table and how does it get updated? [closed]
  23. Bulk Update of Custom Post Type Post Status through SQL
  24. How do I add indexes to WordPress Database?
  25. Moving an entire wordpress site from one domain to a new domain and database
  26. Change SQL get_results to search for posts with custom term in custom taxonomy
  27. Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
  28. Delete all post meta except featured image
  29. Block search SQL from happening
  30. wpdb query on custom table not working [closed]
  31. How to execute mulitple statement SQL queries using $wpdb->query?
  32. stdObject stored in database. How does one convert it to usable format?
  33. Delete duplicate rows from wordpress database where a column is duplicate in phpmyadmin
  34. Database with mixed collation (utf8mb4 & utf8_general_ci)
  35. Query WordPress database by registered date and role
  36. Using table lock with wp_insert_post?
  37. How to Move Local Singlesite Database to Remote Multsite Database?
  38. Scheduling posts in database
  39. Set Display Name to first and last name (phpmyadmin SQL Query)
  40. Size article thumbnails and retrieve them directly from database
  41. Emojis getting converted to “?”
  42. How to replace values in WordPress DB using phpMyAdmin
  43. How to query the WordPress database to get posts of a certain custom post type, taxonomy and field?
  44. Delete all post meta except featured image Using SQL
  45. wpdb_prepare with multiple or condition
  46. Accidentally deleted active_plugins portion of the wp_options DB table
  47. Uppercase to sentence case for post titles
  48. Moving to another host; which tables to move in a database
  49. WordPress mysql table double prefixes
  50. SQL Error wp_commentmeta – incorrect table definition
  51. phpMyAdmin displays error when importing database
  52. WordPress and MySQL: how to transfer Meta_key and Meta_Value from one post_id to another
  53. Change WordPress prefix for only one table?
  54. How do I get the posts within a certain year/date(with sql query)?
  55. WordPress database import: Row size too large
  56. Export / import WordPress database
  57. WordPress is not creating table in database after activating plugin,
  58. Bulk-create posts from SQL database
  59. input data and output table [closed]
  60. Difficulty importing my live site to local
  61. Retrieve data from the database to table such as comments in the admin control panel
  62. Create table from array with prepare
  63. Setup private content for specific users with daily updates [closed]
  64. Connection refused on locahost after importing database?
  65. Which data is written and stored in the database when read-only (non-posting, non-commenting) users visit the site?
  66. Change options table prefix only
  67. Insert Query not working in the form
  68. WPDB SQL query with prepare() returning variable, not db value
  69. Query multiple tables at once?
  70. Problems with moving my WordPress site to another domain/server
  71. Changing root password in PHPMyAdmin for WordPress Database when going live
  72. Can’t update WordFence Options, clear data manually
  73. Post Views / Hit Counter Problem?
  74. Why this query is not showing any result on wordpresss home page?
  75. Is it possible to have more than 1 MySQL database in my WordPress blog?
  76. pull data from a remote wordpress database
  77. Clear Terms from Taxonomy for Specific Post IDs?
  78. Is my way to change WordPress server is correct?
  79. Options on how to Display member specific data from a MS SQL database
  80. Delete/Replace words from X to Y in post content
  81. SQL query to set posts in bulk based on the post content
  82. How to delete a particular row in a database table
  83. Delete all posts that do NOT have a specific tag
  84. Location of WP default mySQL tables creation file?
  85. Can I customised default WP table
  86. SELECT SQL_CALC_FOUND_ROWS with wordpress search
  87. Files on Localhost, Database on Server
  88. Backing up WordPress database and files
  89. Should I use an additional column in the DB?
  90. $wpdb->get_var – What value is returned when zero records are found?
  91. How to display data from db in select list [closed]
  92. wp_option table error while importing
  93. Installing local to live WP into subdirectory
  94. WordPress SQL – How to Check for Category?
  95. Getting value from database table depending on field value
  96. Will adding & modifying default WordPress table index break future WordPress update
  97. What is wrong here? Issue with post_id and meta_value
  98. Delete user with only subscriber role
  99. custom tables in wordpress Database? (can i just create them with sql?)
  100. Can’t log into wordpress site – I have made a new user and still cant access
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)