I installed XAMPP (version ) a few months ago, the going is smooth except for a few things:
the MySQL that comes with my XAMPP is 4.1.13. It seems to not support transactions/commit/rollback.
When I try to do an export of the data via phpMyAdmin (version 2.6.3-pl1) , it does so succesfully, but for the create table statements, it appends :
ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=30 ;
after the closing bracket.
I want the engine to be InnoDB. I have the windows MySQL Administrator Tool (v 1.0.19). I checked the box which says Support InnoDB under Server features under Configure Service tab under Service Control.
Apart from that, my initial scripts by which I load my database, have all got TYPE=INNODB; at the end of create table(). Still it does not support innodb. any clues?
In the data export file created by phpMyAdmin, the order of the tables is wrong . e.g. Table A has column L, Table B has a column M, which references as a froeign key A.L. Yet, the SQL for B comes first and for A after that. So I have to manually change the order everytime I want to reload the database. Any place in phpMyAdmin to tell it to check for foreign key and set the order accordingly?