newman Posted March 8, 2006 Share Posted March 8, 2006 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 . Link to comment https://forums.phpfreaks.com/topic/4450-problem-with-phpmyadminplease-help/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.