Hello, I have an mysql error message when trying to import the dump file obtained from a backuped database into a new database. I use the command: mysql -u root otrs < mysql.sql I have the error message: error 1050: Table 'article' already exists. I have tried to make a new database and to drop down the dump file but I have the same error. Do you have any idea? Any help would be appreciated. Kind regards, Alina.
В сообщении от Четверг 02 Февраль 2006 20:32 Alina Florea написал(a): Hi Alina,
I use the command: mysql -u root otrs < mysql.sql I have the error message: error 1050: Table 'article' already exists. I have tried to make a new database and to drop down the dump file but I have the same error.
Look into that .sql file, are the table 'article' defined 2 or more times ? it looks like "create table article" -- Mike Lykov ISP Samtelecom, Administrator
Or perhaps did you accidentally missed the -h parameter to specify the proper db-host. you could have tried to dump the file to your backup-db-host instead of using the new host. Mike Lykov schrieb:
В сообщении от Четверг 02 Февраль 2006 20:32 Alina Florea написал(a):
Hi Alina,
I use the command: mysql -u root otrs < mysql.sql I have the error message: error 1050: Table 'article' already exists. I have tried to make a new database and to drop down the dump file but I have the same error.
Look into that .sql file, are the table 'article' defined 2 or more times ? it looks like "create table article"
participants (3)
-
Alexander Scholler -
Alina Florea -
Mike Lykov