There are about 250 tables in my database and they all have InnoDB engine. I imported them into a server.
They were imported and were displayed in the tree structure of phpmyadmin (under the database name), but when I clicked on them
MySQL reported the
error that table doesn't exist!!
From this link ,I find out that database engine and tables engine are not the same. is it possible to set engine for database itself (not the tables)? if yes how ?
I also tried to create tables manually (by SQL Query and InnoDB engine) but reported the error that can't create table, I changed
MyISAM and problem solved!