Jump to content

Archived

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

newman

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.