Import Database error - "DEFAULT CHARSET"

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Import Database error - "DEFAULT CHARSET"

Postby shack » 19. July 2004 22:49

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?
shack
 
Posts: 6
Joined: 30. June 2004 12:10

different version of phpmyadmin

Postby potatosalad » 20. July 2004 00:40

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.
Põtåtõ §ålåÐ - Ðelicious Image
User avatar
potatosalad
 
Posts: 13
Joined: 26. April 2004 02:44
Location: Kennesaw, GA, USA


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 42 guests