I have a MySQL database. The default storage engine is MyISAM.
I want to change it to InnoDB.
I can change it table by table , but i want to change it one time that affect all the tables .
How can I change the database storage engine? I tried it but seems there is no option in phpmyadmin.
the best answer i got was
The easiest way is just to go to the mysql config file (my.ini in windows, my.cnf in Linux) and just add this: [mysqld] default-storage-engine=InnoDB .
i think that will do the trick easily .
thanks for the help........... :D
Click on the table name, then click on operations, there you can change the server engine one table at a time.
A+ Computer Solutions- Belize