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
