MySQL Table does not exist error, but it does exist

by

This just happened to me and after a while I found the answer on a blog article, and wanted to put it here as well.

If you copy the MySQL data directory from /var/lib/mysql to /path/to/new/dir, but only copy the database folders (i.e. mysql, wpdb, ecommerce, etc) AND you do have InnoDB tables, your innodb tables will show up in ‘show tables’ but queries on them (select and describe) will fail, with the error Mysql error: table db.tableName doesn't exist. You’ll see the .frm file in the db directory, and wonder why.

For InnoDB tables, it’s important to copy over the ib* files, which in my case were ibdata1, ib_logfile0, and ib_logfile1. Once I did the transfer making sure to copy those over, everything worked as expected.

If your my.cnf file contains innodb_file_per_table the .ibd file will be present in the db directory but you still need the ib* files.

More Related Contents:

  1. How to create codeigniter dynamic menu from single table
  2. Return the latest 10 records from a mysql query [closed]
  3. How Secure Is This Login System? (Using Cookies In PHP)
  4. Commands out of sync; you can’t run this command now
  5. How to get numeric types from MySQL using PDO?
  6. PHP & mySQL: Year 2038 Bug: What is it? How to solve it?
  7. Get table column names in MySQL?
  8. MySQL and PHP: UTF-8 with Cyrillic characters [duplicate]
  9. Use bound parameter multiple times
  10. Are mysql_real_escape_string() and mysql_escape_string() sufficient for app security?
  11. how safe are PDO prepared statements
  12. Secure files for download
  13. Hiding true database object ID in url’s
  14. Mysql No connection could be made because the target machine actively refused it
  15. Replacing mysql_* functions with PDO and prepared statements
  16. Laravel 5.4 field doesn’t have a default value
  17. org.json.JSONException: Value
  18. PHP Check for NULL
  19. How to store .pdf files into MySQL as BLOBs using PHP?
  20. Fatal error: Uncaught exception ‘mysqli_sql_exception’ with message ‘No index used in query/prepared statement’
  21. PDO MySQL: Insert multiple rows in one query
  22. Outputting all PHP errors to database not error_log
  23. Laravel nested relationships
  24. getting the value of an extra pivot table column laravel
  25. php sample script for pagination [closed]
  26. How to select rows where column value IS NOT NULL using CodeIgniter’s ActiveRecord?
  27. MySQL Query IN() Clause Slow on Indexed Column
  28. How to convert MySQL time to UNIX timestamp using PHP?
  29. MySQL ORDER BY rand(), name ASC
  30. Insert non-English decimal points in mysql

Leave a Comment