Apache Friends Support Forum

Can someone please tell me why when I export my datbase from XAMPP Phpmyadmin and run the SQL into a live PHPmyAdmin I keep getting an error message saying error in SQL line... blah blah.

The line that keeps messing it up is:

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;



I've messed about with it loads and got it working when I took out the DEFAULT CHARSET=Latin1 part of it, but how can i change it in XMAPP so it works? Without having to manually delete it everytime?

is the live version of phpmyadmin a different version from your version? is the mysql version different on the live version? i've exported from xampp phpmyadmin and had to modify the code a little to be able to import it on another site.