Upload backup db issue

[funcouldron]

while i tried to upload my database it gave me error  1062 copy 1 to 1  ..


i installed frees 2.0 beta 4 thn droped al lthe tables ...thn tried to upload the db but got this error

[funcouldron]

Error

SQL query:

-- -- Dumping data for table `smf_attachments` -- INSERT INTO `smf_attachments` (`ID_ATTACH`, `ID_THUMB`, `ID_MSG`, `ID_MEMBER`, `attachmentType`, `filename`, `size`, `downloads`, `width`, `height`) VALUES (1, 0, 0, 15, 0, 'avatar_15.png', 4635, 255, 65, 48), (2, 0, 0, 31, 0, 'avatar_31.png', 9120, 267, 58, 65), (3, 0, 0, 2, 0, 'avatar_2.png', 7464, 913, 65, 64), (25, 0, 0, 5, 0, 'avatar_5.png', 4982, 582, 65, 48), (5, 0, 0, 29, 0, 'avatar_29.png', 7960, 256, 49, 65), (6, 0, 0, 51, 0, 'avatar_51.png', 10241, 67, 65, 64), (8, 0, 0, 53, 0, 'avatar_53.png', 6218, 45, 48, 65), (9, 0, 0, 59, 0, 'avatar_59.png', 7062, 1223, 65, 48), (14, 0, 0, 71, 0, 'avatar_71.png', 6753, 52, 48, 65), (15, 0, 0, 72, 0, 'avatar_72.png', 8650, 79, 47, 65), (17, 0, 0, 65, 0, 'avatar_65.png', 8645, 103, 65, 48), (18, 0, 0, 80, 0, 'avatar_80.png', 7120, 97, 43, 65), (19, 0, 0, 70, 0, 'avatar_70.png', 10029, 35, 65, 65), (20, 0, 0, 18, 0, 'avatar_18.png', 7042, 90, 53, 65), (21, 0, 0, 73, 0, 'avatar_73.png', 1[...]

MySQL said: Documentation
#1062 - Duplicate entry '1' for key 1

[khamseen]

Did you do a complete backup of the SQL? As in including table structure and data?

[funcouldron]

yes

[funcouldron]

okie now i success fuly uploaded the db but when i run the upgread thn i get the unknown error


Executing: "Updating and creating indexes..." (1 of 19 - of this script).

Database Updates Complete! Click Continue to Proceed.
Updating indexes on "messages"...
!!
Error!
Unknown Error!

[funcouldron]

okie ,,, i have done ,,, it wos bit tedious  to do many things ,, but finaly done ,,,

[Breaked]

And how did you do this?
I have the self problem ..

Pls help me

[funcouldron]

i have done the following steps

1st i created one new database

then using forum maintainence i saved the backup of my database with table structure.
i was using smf1.1.5 in www.mydomain.com/funcouldron

then i made one more forum using my new database account as www.mydomian.com/fc
i installed smf1.1.7

then go to new database - drop all the tables - import the saved backup.
done now smf1.1.7 is running at www.mydomain.com/fc

now extracted smf2.0b4_upgrade in fc folder
and also uploaded repair_settings.php file

from the funcouldron folder i copied following folder
themes
attachments
avatars
smileys

i uploaded the folders into fc folder.

then i run repair settings.php file and made all the values to recommended values(b4 u do this please check the pats i mean u should have uploaded the all above folders i mentioned otherwise forum will not work properly)

after that delete repair settings.php

then run upgrade.php
and continue ..
it will as for admin user name and password give it and ur done..