Hi, I need to import a dump from a mysql-4.1 to mysql-4.0. I have already read the MySQL Manual page but I didnīt find the answer, even importing the data with the option --default-character-set=latin1.
When executed mysql < dump.sql, it happend an error because mysql-4.1 generates the dump including: CREATE TABLE xyz { } ENGINE=MyISAM DEFAULT CHARACTER SET=latin1; but when I import this dump, mysql-4.0 gives an error with this sintaxe. So, to import the dump I had to remove the text " DEFAULT CHARACTER SET=latin1" from the CREATE TABLE statements. It imported the dump file successfully but now we having accentuation problems. It seems that the words were recorded with a wrong accentuation character. Any help would be appreciated. thanks, Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]