If table not found errors occur on target db after transferring database then do the following:
1. check permissions on the folders and files under /var/lib/mysql (esp if you copied as root). Files should be mysql:mysql, as a rule. 2. On the source db, mysql> select table_name,table_type,engine from information_schema.tables where engine='InnoDB'; +--------------+------------+--------+ | table_name | table_type | engine | +--------------+------------+--------+ | crypto | BASE TABLE | InnoDB | +--------------+------------+--------+ x rows in set (5.80 sec) The convert the db to ISAM mysql> alter table crypto engine=MyISAM; Query OK, 0 rows affected (0.12 sec) Records: 0 Duplicates: 0 Warnings: 0
