Restore problem

[thuree]

Hej,

I am having a problem when I do a RESTORE.

PROBLEM: Can not go on.
COMMAND WAS REJECTED:

INSERT INTO `ee_uncookied` VALUES ('1',

Duplicate entry '1' for key 1

PLEASE CHECK FIRST THAT THE CHOSEN READING DELIMITER (|EE|BACKUP|) IS CORRECT.


I am having the correct Delimiter, and have no clue what to do next.
Do I need to restore this table or? I checked the backup file, and as far as I can see there is no duplicated '1' for key 1.
The PhotoGallery seems to have been restored fine anyway, but do not know for sure (it is not my own)

-Bengt

p.s.
Sorry for posting twice, but I thought that this one deserved its own topic.

[Pekka]

ee_uncookied table is not essential in restore. You can delete those rows manually from restore file. You can deselect the uncookied tables when doing backup.

The "Duplicate entry '1' for key 1" problem is quite odd as restore drops the table and recreates a new empty one - there is nothing there before the first insert command is done. Only thing I can think of is that you do not have DROP privileges in MySQL but this would give errors on other tables, too...

Can you PM me address/passes to your editor so I can have a look?

[thuree]

Hej Pekka,

I have PMed you the details. Really appreciate this.

Also, it seems that there have been 7000 pages with pictures shown, but that looks very very high.
Anyway, perhaps it will be better values after the import is ok.

/Bengt

[thuree]

Hej Pekka,

Thanks again for all the help.
After removing the entries for ee_uncookied in the sql file, the database restore worked fine.

Also, I run the extra script (which you provided) to make sure that one row exists in ee_uncookied

/Bengt