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 . Quote Link to comment https://forums.phpfreaks.com/topic/4450-problem-with-phpmyadminplease-help/ Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.