Moving to a new host, Database will not upload..

[Brody]

Code Select Expand

Error
SQL query:

INSERT INTO  `smf_log_search_subjects` (
`word` ,
`ID_TOPIC`
)
VALUES ( 30, 1770 ) , ( 30, 2560 ) , ( 30, 2683 ) , ( 30, 3317 ) , ( 30, 3441 ) , ( 300, 1990 ) , (
'30th', 837
), (
'30th', 1203
), ( 31, 2304 ) , (
'31-may-06', 1251
), (
'31st', 1164
), ( 320, 2586 ) , ( 320, 2588 ) , ( 320, 2591 ) , ( 320, 2592 ) , ( 320, 2594 ) , ( 320, 2605 ) , ( 320, 2616 ) , ( 320, 2627 ) , ( 320, 2632 ) , ( 320, 2662 ) , ( 320, 2677 ) , ( 320, 2680 ) , ( 320, 2844 ) , ( 320, 2902 ) , (
'3rd', 761
), (
'3rd', 806
), (
'3rd', 2722
), ( 4, 675 ) , ( 4, 737 ) , ( 4, 805 ) , ( 4, 830 ) , ( 4, 858 ) , ( 4, 859 ) , ( 4, 913 ) , ( 4, 1668 ) , ( 4, 1730 ) , ( 4, 2156 ) , ( 4, 2168 ) , ( 4, 2796 ) , ( 4, 2860 ) , ( 4, 2921 ) , ( 4, 2965 ) , ( 4, 3045 ) , ( 4, 3670 ) , ( 4, 3712 ) , ( 4, 3753 ) , ( 4, 3811 ) , ( 4, 3869 ) , ( 4, 3988 ) , ( 4, 4012 ) , (
'4-day', 3669
), (
'4-year-old', 3620
), ( 40, 2124 ) , ( 40, 3381 ) , (
'40th', 2800
), (
'41st', 4332
), ( 42, 1336 ) , (
'43-pound', 3284
), ( 47, 3565 ) , (
'48th', 2132
), (
'4th', 277
), (
'4th', 2405
), (
'4th', 3314
), (
'4th-5th', 3858
), (
'4tus', 2168
), (
'4tus', 4018
), ( 5, 356 ) , ( 5, 871 ) , ( 5, 872 ) , ( 5, 916 ) , ( 5, 925 ) , ( 5, 1136 ) , ( 5, 1698 ) , ( 5, 1760 ) , ( 5, 2298 ) , ( 5, 2356 ) , ( 5, 2844 ) , ( 5, 2868 ) , ( 5, 2885 ) , ( 5, 3021 ) , ( 5, 3140 ) , ( 5, 3472 ) , ( 5, 3751 ) , ( 5, 3779 ) , ( 5, 3935 ) , ( 5, 4019 ) , ( 5, 4029 ) , ( 5, 4112 ) , ( 50, 3400 ) , ( 50, 3401 ) , ( 50, 3423 ) , ( 50, 3455 ) , ( 50, 3456 ) , ( 50, 3814 ) , ( 53, 3564 ) , ( 54, 990 ) , ( 55, 4179 ) , ( 59, 3926 ) , (
'5m', 3126
), (
'5th', 267
), (
'5th', 2406
), (
'5th', 3145
), ( 6, 926 ) , ( 6, 971 ) , ( 6, 1695 ) , ( 6, 1869 ) , ( 6, 2187 ) , ( 6, 2201 ) , ( 6, 2905 ) , ( 6, 3065 ) , ( 6, 3186 ) , ( 6, 3576 ) , ( 6, 3850 ) , ( 6, 4047 ) , ( 6, 4101 ) , (
'6-6-06', 1292
), ( 60, 1759 ) , ( 60, 4244 ) , ( 67, 2824 ) , (
'67-year-old', 3484
), (
'6th', 290
), (
'6th', 2403
), (
'6th', 2437
), (
'6th', 2742
), (
'6th', 3343
), (
'6th', 3491
), ( 7, 321 ) , ( 7, 984 ) , ( 7, 985 ) , ( 7, 1005 ) , ( 7, 1066 ) , ( 7, 1790 ) , ( 7, 1921 ) , ( 7, 1960 ) , ( 7, 2401 ) , ( 7, 3112 ) , ( 7, 3230 ) , ( 7, 3262 ) , ( 7, 3557 ) , ( 7, 3925 ) , ( 7, 3972 ) , ( 7, 4110 ) , (
'7-20-91', 478
), (
'7-30-88', 456
), (
'7-8', 1527
), ( 70, 2824 ) , ( 7000, 2850 ) , ( 74, 2697 ) , ( 77, 4426 ) , (
'7th', 947
), (
'7th', 1338
), (
'7th', 2411
), ( 8, 285 ) , ( 8, 384 ) , ( 8, 610 ) , ( 8, 1065 ) , ( 8, 1128 ) , ( 8, 1199 ) , ( 8, 1231 ) , ( 8, 1646 ) , ( 8, 2013 ) , ( 8, 2061 ) , ( 8, 2136 ) , ( 8, 2141 ) , ( 8, 2143 ) , ( 8, 3167 ) , ( 8, 3306 ) , ( 8, 3990 ) , ( 8, 4174 ) , (
'8-13-88', 474
), (
'8-30-87', 397
), (
'8-5-06', 2021
), ( 80, 2769 ) , ( 80, 3268 ) , ( 80, 3310 ) , ( 80, 3364 ) , (
'80\'s', 1588
), (
'80s', 3314
), ( 81, 35 ) , ( 81, 4365 ) , ( 83, 3664 ) , (
'85-88', 3532
), ( 86, 1040 ) , ( 86, 1041 ) , ( 86, 1042 ) , ( 86, 1043 ) , ( 86, 1355 ) , ( 86, 1543 ) , ( 86, 1590 ) , ( 87, 1431 ) , (
'87-\'90', 1159
), (
'87-93', 732
), (
'87-93', 3414
), ( 88, 345 ) , ( 88, 1277 ) , ( 88, 1790 ) , ( 89, 1589 ) , ( 89, 1598 ) , ( 89, 3408 ) , (
'8th', 2352
), (
'8th', 4089
), (
'8th-graders', 4409
), ( 9, 1127 ) , ( 9, 1312 ) , ( 9, 1487 ) , ( 9, 1791 ) , ( 9, 2107 ) , ( 9, 2218 ) , ( 9, 2298 ) , ( 9, 2373 ) , ( 9, 2683 ) , ( 9, 3222 ) , ( 9, 3536 ) , ( 9, 3811 ) , ( 9, 4044 ) , ( 9, 4209 ) , (
'9-1-2006', 2763
), ( 90, 3892 ) , (
'90s', 4270
), ( 91, 610 ) , ( 91, 1271 ) , ( 91, 2844 ) , ( 91, 2902 ) , ( 911, 4223 ) , ( 92, 914 ) , ( 92, 1095 ) , ( 92, 1879 ) , ( 92, 1880 ) , ( 92, 1893 ) , ( 92, 1943 ) , ( 92, 2685 ) , ( 93, 536 ) , ( 93, 1084 ) , ( 93, 1878 ) , ( 93, 3442 ) , (
'93x', 4205
), ( 94, 2124 ) , ( 94, 4148 ) , ( 95, 1868 ) , ( 989, 4390 ) , ( 99, 1770 ) , ( 99, 3682 ) , ( 999, 4419 ) , (
'9th', 952
), (
'9th', 1342
), (
'a', 45
), (
'a', 117
), (
'a', 207
), (
'a', 262
);


MySQL said:

#1062 - Duplicate entry '6-2201' for key 1

this is the error i get.. can someone please help!

[IchBin]

I would suggest you direct your question to simplemachines.org as they can help you with their software more than we can.

[Brody]

I would suggest you direct your question to simplemachines.org as they can help you with their software more than we can.

oh, ok thanks. Its just that you guys seem to be much more helpful, I also use tinyportal!

[IchBin]

I understand that. But as TP keeps getting bigger and bigger we are unable to do support for anything but TP.

http://www.tinyportal.net/index.php?topic=14457.0

[Brody]

I understand that. But as TP keeps getting bigger and bigger we are unable to do support for anything but TP.

http://www.tinyportal.net/index.php?topic=14457.0

understood, thanks for all your help in the past. maybe smf will be able to help..

[knat]

go to SMF and search for Restore_database.php and Repair_settings.php

These two scripts are written by [UNKNOWN] and they saved my forum when i needed to move database 

[IchBin]

http://www.simplemachines.org/community/index.php?topic=18350.msg168327#msg168327
create/backup script