SQL problem

Next topic

Author	Message
Steph A	Thursday 17 March 2005 7:59:15 am I am moving to a new provider. But I cant insert my existing database into the new one. I get error code #1064 when trying with both phpadmin and MySQL administrator. Can anyone help?
Ł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?
Łukasz Serwatka	Monday 21 March 2005 5:09:15 am Hi, 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 Personal website -> http://serwatka.net Blog (about eZ Publish) -> http://serwatka.net/blog