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.configura tion 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")
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
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")
Code:
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
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
Comment