Jump to content


problem with phpmyadmin+please help

  • Please log in to reply
No replies to this topic

#1 newman

  • Members
  • PipPip
  • Member
  • 28 posts

Posted 08 March 2006 - 05:12 PM

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 .

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users