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]

Reply via email to