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

[moltendorf]

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

[r035198x]

Use mysqldump for backing up the database.

[moltendorf]

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?

[r035198x]

Moving databases by moving files is not the way to go. Check the MySQL site for migration options for your versions and platform.