Thursday 17 March 2005 7:59:15 am - 3 replies
Łukasz Serwatka
Thursday 17 March 2005 10:12:18 pm
Hi,
What versions of MySQL do you use? If you move from 4.1.x to 4.0.xx use --compatible=mysql40 for mysqldump. This is parse error. You can try manualy fix this in dump file, of course if is small enought ;)
Personal website -> http://serwatka.net Blog (about eZ Publish) -> http://serwatka.net/blog
Steph A
Friday 18 March 2005 2:13:50 am
CREATE TABLE `ezapprove_items` (
`collaboration_id` int( 11 ) NOT NULL default '0', `id` int( 11 ) NOT NULL AUTO_INCREMENT , `workflow_process_id` int( 11 ) NOT NULL default '0', PRIMARY KEY ( `id` ) ) ENGINE = MYISAM DEFAULT CHARSET = latin1 COLLATE = latin1_danish_ci AUTO_INCREMENT =1
This is the error I get. I also get a error when trying to use command "compatible=mysql40" in shell, errorcode #1064.
What is wrong?
Monday 21 March 2005 5:09:15 am
If you uses MySQL 4.1.x try
mysqldump --compatible=mysql40 --default-character-set=latin1 -u root -p database_name > dump.sql
Set your encoding for --default-character-set
You must be logged in to post messages in this topic!