Forums / Install & configuration / SQL problem
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
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