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")
- sudo ./bin/mysqlcheck -r test -uroot -p
-
test.configuration
-
Error : Table 'test.configuration' doesn't exist
-
error : Corrupt
-
test.module_navigation_buttons OK
-
test.module_register_fields OK
-
test.module_register_steps OK
-
test.modules
-
Error : Table 'test.modules' doesn't exist
-
error : Corrupt
-
test.modules_auto
-
Error : Table 'test.modules_auto' doesn't exist
-
error : Corrupt
-
test.modules_streams
-
Error : Table 'test.modules_streams' doesn't exist
-
error : Corrupt
-
test.servers
-
Error : Table 'test.servers' doesn't exist
-
error : Corrupt
-
test.session_identifiers
-
note : The storage engine for the table doesn't support repair
-
test.session_keys
-
note : The storage engine for the table doesn't support repair
-
test.styles
-
Error : Table 'test.styles' doesn't exist
-
error : Corrupt
-
test.users
-
Error : Table 'test.users' doesn't exist
-
error : Corrupt
-
test.users_activity
-
Error : Table 'test.users_activity' doesn't exist
-
error : Corrupt
-
test.users_logins
-
Error : Table 'test.users_logins' doesn't exist
-
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