472,143 Members | 1,134 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,143 software developers and data experts.

"Table Does Not Exist" (But It Does?)

I copied the files from my "test" database on my old server (MySQL was not running) to my new server ("./mysql/data/test" folder), and after starting the server, SHOW TABLES; shows all of the tables that are supposed to be there, but running a SELECT * FROM `configuration`; (for example) returns "test.configuration does not exist).

I've tried the following repair statement since I'm not too familiar with backing up and restoring data.

(Note that I removed my password after "-p")

Expand|Select|Wrap|Line Numbers
  1. sudo ./bin/mysqlcheck -r test -uroot -p
  2. test.configuration
  3. Error    : Table 'test.configuration' doesn't exist
  4. error    : Corrupt
  5. test.module_navigation_buttons                     OK
  6. test.module_register_fields                        OK
  7. test.module_register_steps                         OK
  8. test.modules
  9. Error    : Table 'test.modules' doesn't exist
  10. error    : Corrupt
  11. test.modules_auto
  12. Error    : Table 'test.modules_auto' doesn't exist
  13. error    : Corrupt
  14. test.modules_streams
  15. Error    : Table 'test.modules_streams' doesn't exist
  16. error    : Corrupt
  17. test.servers
  18. Error    : Table 'test.servers' doesn't exist
  19. error    : Corrupt
  20. test.session_identifiers
  21. note     : The storage engine for the table doesn't support repair
  22. test.session_keys
  23. note     : The storage engine for the table doesn't support repair
  24. test.styles
  25. Error    : Table 'test.styles' doesn't exist
  26. error    : Corrupt
  27. test.users
  28. Error    : Table 'test.users' doesn't exist
  29. error    : Corrupt
  30. test.users_activity
  31. Error    : Table 'test.users_activity' doesn't exist
  32. error    : Corrupt
  33. test.users_logins
  34. Error    : Table 'test.users_logins' doesn't exist
  35. error    : Corrupt
EDIT: The ones that did not properly move are using the FALCON engine. I do have access to the full installation of the old MySQL server. I just can't run it as the Operating System will not run under the new hardware I have on this system.

Also, I believe the files are definitely not corrupt as they ran fine on the system last time I used them. Maybe I need to move a few more files besides the entire test directory, or update something in the mysql table?

MySQL 6.0.8-alpha
Jan 14 '09 #1
3 10163
13,262 8TB
Use mysqldump for backing up the database.
Jan 15 '09 #2
I'm just wondering as to how I can do that on the old install I have of it (which is 32-bit, not 64-bit)?

Do I copy the new file to the old installation, or is mysqldump not dependent on either?
Jan 15 '09 #3
13,262 8TB
Moving databases by moving files is not the way to go. Check the MySQL site for migration options for your versions and platform.
Jan 16 '09 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Alanoly J. Andrews | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.