Jump to content


This topic is now archived and is closed to further replies.


problem with phpmyadmin+please help

Recommended Posts

Hi all .

i've got a problem with phpmyadmin . i exported my whole database with phpmyadmin into a sql file . but when i import it into another mysql server using phpmyadmin , i get an error with encoding types. this's the error :

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=1' at line 30

is it related to mysql server versions?
i deleted all the [DEFAULT CHARSET ...] in my sql file but all the characters have turned to some strange characters . all my important entries are in this sql file , what can i do to revover these all .
has anybody know what's the solution for this prob ?

thanks .

Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.