Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.
By opello on
Hi everybody
I have a little problem copying my database in myPhpAdmin. When I try to copy the database under "Operations" the "Users" table seems to have a dublicate that prevents the database from being copied, it returnes the following error message: (in danish ;o)
Fejl
SQL-forespørgsel: DokumentationRet
INSERT INTO `testdb`.`users`
SELECT *
FROM `test`.`users`
MySQL returnerede: Dokumentation
#1062 - Duplicate entry '1' for key 1
This is on a new and clean drupal 6.4 installation so i'm pretty shure I haven't ruined anything so far ;o)
Have anyone experienced anything like this?
/Carsten
Comments
I have experienced something
I have experienced something like that once. I don't remember exactly what caused it, but I do remember what did work for me: exporting to a sql file and importing again into the new db.
If the table already exists
If the table already exists drop it first, or truncate it then import the new data.
James T
Action Medical Research - www.action.org.uk
James T
Action Medical Research - www.action.org.uk