Schrödingers MySQL table: exists, yet it does not

by

I’ve seen this issue when the data file is missing in the data directory but the table definition file exists or vise-versa. If you’re using innodb_file_per_table, check the data directory to make sure you have both an .frm file and .ibd file for the table in question. If it’s MYISAM, there should be a .frm, .MYI and a .MYD file.

The problem can usually be resolved by deleting the orphaned file manually.

More Related Contents:

  1. how to get result form mysql query in specific ids [closed]
  2. How to do a regular expression replace in MySQL?
  3. How to solve “Error: MySQL shutdown unexpectedly”?
  4. Count the number of occurrences of a string in a VARCHAR field?
  5. What is the ideal data type to use when storing latitude / longitude in a MySQL database?
  6. How to import a CSV file into a MySQL table
  7. How to store arrays in MySQL?
  8. MySQL high CPU usage [closed]
  9. Most efficient way to get table row count
  10. How do I select between the 1st day of the current month and current day in MySQL?
  11. Subqueries with EXISTS vs IN – MySQL
  12. Is there an ANSI SQL alternative to the MYSQL LIMIT keyword?
  13. MySQL Cross Server Select Query
  14. How do I generate nested json objects using mysql native json functions?
  15. MySQL TEXT vs BLOB vs CLOB
  16. Getting data for histogram plot
  17. How accurately should I store latitude and longitude?
  18. Using reserved words in column names
  19. MySQL INNER JOIN select only one row from second table
  20. How to select only date from a DATETIME field in MySQL?
  21. UPDATE all records with a random number from a range
  22. mysql sorting of version numbers
  23. Get Insert Statement for existing row in MySQL
  24. Defining Composite Key with Auto Increment in MySQL
  25. mysql Failed to read auto-increment value from storage engine
  26. Alter table if exists or create if doesn’t
  27. How to use Table output from stored MYSQL Procedure
  28. Update multiple rows with multiple ‘where’ clauses for each individual row
  29. WHERE datetime older than some time (eg. 15 minutes)
  30. Is there a way to use ON DUPLICATE KEY to Update all that I wanted to insert?

Leave a Comment