I have a db schema with 10 tables in mysql. some of table has innodb engine, and some of table with myisam.
However, when using phpmyadmin exporting the schema in SQL format, it converts all tables engine to mysiam.
So why phpmyadmin automatically change the tables engine?
How can I keep my tables engine the same when export with phpmyadmin?
Asked
Active
Viewed 728 times
0
-
Check if you are dumping the data as "structure and data" selected option when exporting using "Custom - display all possible options" – swapnesh Oct 09 '12 at 03:50
-
i did check the 'structure and data' option! – bourneli Oct 09 '12 at 04:06
-
if possible can you please share the screenshot of settings of "Custom - display all possible options" – swapnesh Oct 09 '12 at 04:44
1 Answers
0
Check if you are dumping the data as "structure and data" selected option when exporting using "Custom - display all possible options".
Mu Mind
- 10,935
- 4
- 38
- 69