Well for something so simple this has been a pain in the A**. I did't like where I had my board hosted, setup on a new host. Installed 1.16 fresh and tried to import my database backup and had error after error. Tried several variations with no luck. Decided that since 2b4 is out I would do a fresh install of that and try an import again errors. I have no real mods. I have one theme installed and thats the only mod of any kind. It shouldn't be this hard. Is there a good how to for importing the database. I am using myphpadmin to do the import. I have tried the complete backup, and the data backup and still run into issues. Some help would be greatly appreciated.
It is not possible to help you without a better description of what problem you encountered that prevents you from importing your data.
I suspect it might be a foreign key check failure, but that's guessing too far ahead of the scant information that you've supplied.
In other words, PITA does not constitute a full description of your problem. You should describe which errors you have encountered. :)
How do I ask support questions the smart way? (http://docs.simplemachines.org/index.php?topic=494)
Quote from: ryche2x on November 08, 2008, 01:44:35 PM
Well for something so simple this has been a pain in the A**. I did't like where I had my board hosted, setup on a new host. Installed 1.16 fresh and tried to import my database backup and had error after error. Tried several variations with no luck. Decided that since 2b4 is out I would do a fresh install of that and try an import again errors. I have no real mods. I have one theme installed and thats the only mod of any kind. It shouldn't be this hard. Is there a good how to for importing the database. I am using myphpadmin to do the import. I have tried the complete backup, and the data backup and still run into issues. Some help would be greatly appreciated.
When you say you installed it fresh, my first question would be, why are you doing a fresh install if you have a backup of the database. Normally you would just upload the files and change the settings so it knows how to connect to the database. You would then import the datatbase into your clean DB (IE no SMF installed, or no SMF installed with the same prefix.)
Like Deprecated said more information would be helpful.
Ok, I was lookign more for detailed guide lines than "hey fix my problem" But if you want to work on the problems here goes. Lets assume that the initial sit was 123.abc.com running 1.16 SMF. I want to move to a new host ( 123.def.com ) So I got the new host ready. Installed 1.16 as if it was new with the same databas name( as must as allowed) original database name was abc_ryche2x on the new host it's def_ryche2x I can't control the prefix only what comes after the _ Then I ran the install and configured everything. When into my php and did an import of the database-dataonly. and I got an error. Made a few different attempts and still had the issues. Decided to delete the new stuff, upload ver2 b4 and ran the initial setup. Again went into myphpadmin and tried an import, still have the same errors.
When I do the data import I get the following
Error
SQL query:
# ==========================================================
#
# Database dump of tables in `ryche2x_ham2008`
# November 08, 2008, 09:57:41 AM
#
# ==========================================================
#
# Dumping data in `ham_attachments`
#
INSERT INTO `ham_attachments` (
`ID_ATTACH` ,
`ID_THUMB` ,
`ID_MSG` ,
`ID_MEMBER` ,
`attachmentType` ,
`filename` ,
`size` ,
`downloads` ,
`width` ,
`height`
)
VALUES ( 2, 0, 0, 2, 0, 'avatar_2.png', 7111, 232, 65, 53 ) , ( 3, 246, 5, 0, 0, 'July
2 2005 034_640x480.jpg', 36370, 12, 640, 480 ) , ( 4, 0, 5, 0, 3, 'July 2 2005
034_640x480.jpg_thumb', 24632, 0, 150, 112 ) , ( 5, 247, 5, 0, 0, 'July 2 2005
027_640x480.jpg', 45277, 3, 640, 480 ) , ( 6, 0, 5, 0, 3, 'July 2 2005
027_640x480.jpg_thumb', 27030, 0, 150, 112 ) , ( 7, 248, 6, 0, 0, 'July 2 2005
028_640x480.jpg', 43203, 3, 640, 480 ) , ( 8, 0, 6, 0, 3, 'July 2 2005
028_640x480.jpg_thumb', 26958, 0, 150, 112 ) , ( 9, 249, 6, 0, 0, 'july 2 2005
037_558x480.jpg', 32493, 4, 558, 480 ) , ( 10, 0, 6, 0, 3, 'july 2 2005
037_558x480.jpg_thumb', 29568, 0, 150, 129 ) , ( 11, 250, 7, 0, 0, 'july 2 2005
043_564x480.jpg', 41446, 3, 564, 480 ) , ( 12, 0, 7, 0, 3, 'july 2 2005
043_564x480.jpg_thumb', 31820, 0, 150, 127 ) , ( 13, 251, 7, 0, 0, 'july 2 2005
042_516x480.jpg', 38343, 8, 516, 480 ) , ( 14, 0, 7, 0, 3, 'july 2 2005
042_516x480.jpg_thumb', 35558, 0, 150, 139 ) , ( 15, 252, 8, 0, 0, 'july 2 2005
044_530x480.jpg', 40589, 0, 530, 480 ) , ( 16, 0, 8, 0, 3, 'july 2 2005
044_530x480.jpg_thumb', 34431, 0, 150, 135 ) , ( 17, 253, 8, 0, 0, 'july 2 2005
045_536x480.jpg', 35928, 3, 536, 480 ) , ( 18, 0, 8, 0, 3, 'july 2 2005
045_536x480.jpg_thumb', 32357, 0, 150, 134 ) , ( 19, 254, 10, 0, 0, 'july 2 2005
046_547x480.jpg', 44466, 7, 547, 480 ) , ( 20, 0, 10, 0, 3, 'july 2 2005
046_547x480.jpg_thumb', 33820, 0, 150, 131 ) , ( 21, 255, 10, 0, 0, 'july 2 2005
047_502x480.jpg', 41246, 1, 502, 480 ) , ( 22, 0, 10, 0, 3, 'july 2 2005
047_502x480.jpg_thumb', 36559, 0, 150, 143 ) , ( 23, 256, 12, 0, 0, 'july 2 2005
049_524x480.jpg', 38435, 1, 524, 480 ) , ( 24, 0, 12, 0, 3, 'july 2 2005
049_524x480.jpg_thumb', 33837, 0, 150, 137 ) , ( 25, 257, 12, 0, 0, 'july 2 2005
050_581x480.jpg', 41777, 0, 581, 480 ) , ( 26, 0, 12, 0, 3, 'july 2 2005
050_581x480.jpg_thumb', 31624, 0, 150, 123 ) , ( 27, 258, 13, 0, 0, 'july 2 2005
055_525x480.jpg', 38481, 2, 525, 480 ) , ( 28, 0, 13, 0, 3, 'july 2 2005
055_525x480.jpg_thumb', 35075, 0, 150, 137 ) , ( 29, 259, 13, 0, 0, 'july 2 2005
057_561x480.jpg', 40202, 3, 561, 480 ) , ( 30, 0, 13, 0, 3, 'july 2 2005
057_561x480.jpg_thumb', 33255, 0, 150, 128 ) , ( 31, 221, 14, 0, 0,
'2003-11-08-032.jpg', 69663, 7, 600, 454 ) , ( 32, 0, 14, 0, 3,
'2003-11-08-032.jpg_thumb', 36455, 0, 150, 113 ) , ( 33, 222, 14, 0, 0,
'2003-11-08-034.jpg', 75116, 2, 600, 484 ) , ( 34, 0, 14, 0, 3,
'2003-11-08-034.jpg_thumb', 36970, 0, 150, 121 ) , ( 40, 0, 15, 0, 3, 'july 2 2005
061_592x480.jpg_thumb', 42857, 0, 150, 145 ) , ( 37, 260, 15, 0, 0, 'july 2 2005
060_475x480.jpg', 41985, 6, 475, 480 ) , ( 38, 0, 15, 0, 3, 'july 2 2005
060_475x480.jpg_thumb', 38892, 0, 148, 150 ) , ( 39, 261, 15, 0, 0, 'july 2 2005
061_592x480.jpg', 32658, 10, 481, 468 ) , ( 41, 262, 16, 0, 0, 'july 2 2005
062.jpg', 62195, 8, 538, 349 ) , ( 42, 0, 16, 0, 3, 'july 2 2005 062.jpg_thumb',
32419, 0, 150, 97 ) , ( 43, 263, 16, 0, 0, 'july 2 2005 063.jpg', 53364, 11, 543,
348 ) , ( 44, 0, 16, 0, 3, 'july 2 2005 063.jpg_thumb', 30305, 0, 150, 96 ) , ( 45,
264, 18, 0, 0, 'july 2 2005 064.jpg', 56898, 4, 534, 347 ) , ( 46, 0, 18, 0, 3, 'july 2
2005 064.jpg_thumb', 30805, 0, 150, 97 ) , ( 47, 265, 18, 0, 0, 'july 2 2005
065.jpg', 25802, 2, 525, 336 ) , ( 48, 0, 18, 0, 3, 'july 2 2005 065.jpg_thumb',
29238, 0, 150, 96 ) , ( 49, 223, 20, 0, 0, 'Sept 6 & 7 2008 Kodak 076.jpg', 42584,
5, 640, 725 ) , ( 50, 0, 20, 0, 3, 'Sept 6 & 7 2008 Kodak 076.jpg_thumb', 39858,
0, 132, 150 ) , ( 51, 224, 20, 0, 0, 'Sept 6 & 7 2008 Kodak 084.jpg', 31769, 6,
640, 500 ) , ( 52, 0, 20, 0, 3, 'Sept 6 & 7 2008 Kodak 084.jpg_thumb', 35624, 0,
150, 117 ) , ( 53, 204, 21, 0, 0, 'Sept 6 2008 011 postable.JPG', 33585, 12, 776,
434 ) , ( 54, 0, 21, 0, 3, 'Sept 6 2008 011 postable.JPG_thumb', 22224, 0, 150,
83 ) , ( 55, 205, 21, 0, 0, 'Sept 6 2008 012 postable.JPG', 29030, 11, 739, 379 ) ,
( 56, 0, 21, 0, 3, 'Sept 6 2008 012 postable.JPG_thumb', 20951, 0, 150, 76 ) , (
57, 206, 22, 0, 0, 'Sept 6 2008 016 postable.JPG', 30050, 9, 749, 382 ) , ( 58, 0,
22, 0, 3, 'Sept 6 2008 016 postable.JPG_thumb', 21312, 0, 150, 76 ) , ( 59, 207,
22, 0, 0, 'Sept 6 2008 021.jpg', 34047, 13, 640, 455 ) , ( 60, 0, 22, 0, 3, 'Sept 6
2008 021.jpg_thumb', 30926, 0, 150, 106 ) , ( 61, 208, 23, 0, 0, 'Sept 6 2008
022.jpg', 31453, 7, 640, 419 ) , ( 62, 0, 23, 0, 3, 'Sept 6 2008 022.jpg_thumb',
28726, 0, 150, 98 ) , ( 63, 209, 23, 0, 0, 'Sept 6 2008 023.jpg', 25900, 14, 640,
350 ) , ( 64, 0, 23, 0, 3, 'Sept 6 2008 023.jpg_thumb', 24265, 0, 150, 82 ) , ( 65,
226, 24, 0, 0, '2005-06-05-033.jpg', 68500, 2, 640, 480 ) , ( 66, 0, 24, 0, 3,
'2005-06-05-033.jpg_thumb', 35059, 0, 150, 112 ) , ( 67, 228, 24, 0, 0,
'2005-06-05-036.jpg', 76679, 3, 640, 480 ) , ( 68, 0, 24, 0, 3,
'2005-06-05-036.jpg_thumb', 31631, 0, 150, 112 ) , ( 69, 230, 28, 0, 0, 'Sept 25
2008 Ollie 002.jpg', 27638, 10, 640, 489 ) , ( 70, 0, 28, 0, 3, 'Sept 25 2008 Ollie
002.jpg_thumb', 31704, 0, 150, 114 ) , ( 71, 232, 28, 0, 0, 'Sept 25 2008 Ollie
108.jpg', 29231, 9, 640, 457 ) , ( 72, 0, 28, 0, 3, 'Sept 25 2008 Ollie
108.jpg_thumb', 30766, 0, 150, 107 ) , ( 79, 0, 0, 7, 0, 'avatar_7.png', 7391, 80,
65, 48 ) , ( 75, 210, 29, 0, 0, 'Sept 6 2008 029.jpg', 28330, 5, 640, 440 ) , ( 76, 0,
29, 0, 3, 'Sept 6 2008 029.jpg_thumb', 27872, 0, 150, 103 ) , ( 77, 211, 29, 0, 0,
'Sept 6 2008 031.jpg', 26987, 7, 640, 391 ) , ( 78, 0, 29, 0, 3, 'Sept 6 2008
031.jpg_thumb', 25654, 0, 150, 91 ) , ( 80, 212, 35, 0, 0, 'Sept 6 & 7 2008 Kodak
064.jpg', 21698, 7, 640, 418 ) , ( 81, 0, 35, 0, 3, 'Sept 6 & 7 2008 Kodak
064.jpg_thumb', 25917, 0, 150, 97 ) , ( 82, 213, 35, 0, 0, 'Sept 6 & 7 2008 Kodak
069.jpg', 23602, 9, 640, 494 ) , ( 83, 0, 35, 0, 3, 'Sept 6 & 7 2008 Kodak
069.jpg_thumb', 29301, 0, 150, 115 ) , ( 86, 0, 0, 9, 0, 'avatar_9.png', 8538, 74,
65, 55 ) , ( 87, 299, 36, 0, 0, 'IMG_0066 Chrome.jpg', 109733, 9, 800, 600 ) , (
88, 0, 36, 0, 3, 'IMG_0066 Chrome.jpg_thumb', 28487, 0, 150, 112 ) , ( 90, 0, 0,
11, 0, 'avatar_11.png', 8379, 157, 65, 48 ) , ( 91, 233, 43, 0, 0, 'mobile13.jpg',
44393, 6, 480, 640 ) , ( 92, 0, 43, 0, 3, 'mobile13.jpg_thumb', 32077, 0, 112, 150
) , ( 93, 234, 43, 0, 0, '100_0246.jpg', 36689, 3, 480, 360 ) , ( 94, 0, 43, 0, 3,
'100_0246.jpg_thumb', 34994, 0, 150, 112 ) , ( 95, 235, 43, 0, 0, 'b3.jpg', 15221,
4, 340, 255 ) , ( 96, 0, 43, 0, 3, 'b3.jpg_thumb', 31829, 0, 150, 112 ) , ( 97, 0, 0,
12, 0, 'avatar_12.png', 7724, 115, 65, 48 ) , ( 98, 214, 45, 0, 0, 'Sept 6 & 7 2008
Kodak 091.jpg', 29766, 10, 640, 499 ) , ( 99, 0, 45, 0, 3, 'Sept 6 & 7 2008 Kodak
091.jpg_thumb', 32802, 0, 150, 116 ) , ( 100, 215, 45, 0, 0, 'Sept 6 & 7 2008
Kodak 094.jpg', 30429, 6, 640, 605 ) , ( 101, 0, 45, 0, 3, 'Sept 6 & 7 2008 Kodak
094.jpg_thumb', 36821, 0, 150, 141 ) , ( 102, 236, 50, 0, 0, '2005-06-05-041.jpg',
72912, 3, 640, 480 ) , ( 103, 0, 50, 0, 3, '2005-06-05-041.jpg_thumb', 30234, 0,
150, 112 ) , ( 104, 237, 50, 0, 0, '2005-06-09-008.jpg', 70230, 2, 640, 480 ) , (
105, 0, 50, 0, 3, '2005-06-09-008.jpg_thumb', 33774, 0, 150, 112 ) , ( 106, 216,
52, 0, 0, 'M1.jpg', 96855, 18, 900, 856 ) , ( 107, 0, 52, 0, 3, 'M1.jpg_thumb',
40744, 0, 150, 142 ) , ( 108, 217, 53, 0, 0, 'hu30.jpg', 141095, 17, 451, 1080 ) , (
109, 0, 53, 0, 3, 'hu30.jpg_thumb', 21436, 0, 62, 150 ) , ( 110, 238, 67, 0, 0,
'Image17.jpg', 17762, 5, 320, 240 ) , ( 111, 0, 67, 0, 3, 'Image17.jpg_thumb',
36422, 0, 150, 112 ) , ( 112, 239, 67, 0, 0, 'Image27.jpg', 19773, 1, 320, 240 ) , (
113, 0, 67, 0, 3, 'Image27.jpg_thumb', 38512, 0, 150, 112 ) , ( 114, 240, 67, 0, 0,
'Image37.jpg', 17779, 1, 320, 240 ) , ( 115, 0, 67, 0, 3, 'Image37.jpg_thumb',
36663, 0, 150, 112 ) , ( 116, 241, 67, 0, 0, 'Image32.jpg', 12509, 1, 320, 240 ) , (
117, 0, 67, 0, 3, 'Image32.jpg_thumb', 29892, 0, 150, 112 ) , ( 118, 218, 68, 0, 0,
'fantastic.gif', 42410, 0, 428, 146 ) , ( 119, 0, 68, 0, 3, 'fantastic.gif_thumb',
14013, 0, 150, 51 ) , ( 120, 242, 69, 0, 0, 'hu28a.jpg', 116808, 10, 708, 453 ) , (
121, 0, 69, 0, 3, 'hu28a.jpg_thumb', 26979, 0, 150, 95 ) , ( 122, 0, 0, 32, 0,
'avatar_32.png', 5123, 111, 43, 65 ) , ( 123, 124, 0, 0, 0, 'Picture 1211.jpg',
63151, 0, 480, 640 ) , ( 124, 0, 0, 0, 3, 'Picture 1211.jpg_thumb', 33227, 0, 112,
150 ) , ( 125, 126, 0, 0, 0, 'Picture 1216.jpg', 61973, 0, 480, 640 ) , ( 126, 0, 0, 0,
3, 'Picture 1216.jpg_thumb', 33449, 0, 112, 150 ) , ( 127, 128, 0, 0, 0, 'Picture
1236.jpg', 58077, 0, 480, 640 ) , ( 128, 0, 0, 0, 3, 'Picture 1236.jpg_thumb',
32270, 0, 112, 150 ) , ( 129, 273, 76, 0, 0, 'a1.jpg', 42067, 1, 320, 240 ) , ( 130,
0, 76, 0, 3, 'a1.jpg_thumb', 32912, 0, 150, 112 ) , ( 131, 274, 76, 0, 0, 'a2.jpg',
44587, 1, 320, 240 ) , ( 132, 0, 76, 0, 3, 'a2.jpg_thumb', 33718, 0, 150, 112 ) , (
133, 275, 76, 0, 0, 'a3.jpg', 44516, 2, 320, 240 ) , ( 134, 0, 76, 0, 3,
'a3.jpg_thumb', 33926, 0, 150, 112 ) , ( 135, 276, 76, 0, 0, 'a4.jpg', 46088, 2,
320, 240 ) , ( 136, 0, 76, 0, 3, 'a4.jpg_thumb', 34972, 0, 150, 112 ) , ( 137, 279,
77, 0, 0, 'Picture 1211.jpg', 63151, 7, 480, 640 ) , ( 138, 0, 77, 0, 3, 'Picture
1211.jpg_thumb', 33227, 0, 112, 150 ) , ( 139, 280, 77, 0, 0, 'Picture 1217.jpg',
62466, 13, 480, 640 ) , ( 140, 0, 77, 0, 3, 'Picture 1217.jpg_thumb', 33114, 0,
112, 150 ) , ( 141, 281, 82, 0, 0, 'Picture 1235.jpg', 60967, 5, 480, 640 ) , ( 142,
0, 82, 0, 3, 'Picture 1235.jpg_thumb', 33557, 0, 112, 150 ) , ( 143, 282, 82, 0, 0,
'Picture 1249.jpg', 57663, 5, 480, 640 ) , ( 144, 0, 82, 0, 3, 'Picture
1249.jpg_thumb', 31495, 0, 112, 150 ) , ( 145, 283, 86, 0, 0, 'Hello 2 731.jpg',
47769, 9, 480, 640 ) , ( 146, 0, 86, 0, 3, 'Hello 2 731.jpg_thumb', 27205, 0, 112,
150 ) , ( 147, 284, 86, 0, 0, 'Hello 2 741.jpg', 49369, 8, 640, 480 ) , ( 148, 0, 86,
0, 3, 'Hello 2 741.jpg_thumb', 27186, 0, 150, 112 ) , ( 149, 285, 87, 0, 0,
'Pinkie.jpg', 122900, 8, 1240, 1238 ) , ( 150, 0, 87, 0, 3, 'Pinkie.jpg_thumb',
31868, 0, 150, 149 ) , ( 151, 286, 87, 0, 0, 'Picture 1243.jpg', 60238, 6, 480, 640
) , ( 152, 0, 87, 0, 3, 'Picture 1243.jpg_thumb', 32112, 0, 112, 150 ) , ( 153, 154,
0, 0, 0, 'Picture 1084.jpg', 79117, 0, 480, 640 ) , ( 154, 0, 0, 0, 3, 'Picture
1084.jpg_thumb', 34422, 0, 112, 150 ) , ( 155, 156, 0, 0, 0, 'Picture 1087.jpg',
66007, 0, 403, 640 ) , ( 156, 0, 0, 0, 3, 'Picture 1087.jpg_thumb', 26526, 0, 94,
150 ) , ( 157, 243, 94, 0, 0, 'Picture 1084.jpg', 79117, 5, 480, 640 ) , ( 158, 0, 94,
0, 3, 'Picture 1084.jpg_thumb', 34422, 0, 112, 150 ) , ( 159, 266, 100, 0, 0, 'june
13 2005 038.jpg', 41804, 7, 505, 335 ) , ( 160, 0, 100, 0, 3, 'june 13 2005
038.jpg_thumb', 28849, 0, 150, 99 ) , ( 161, 267, 100, 0, 0, 'june 13 2005
043.jpg', 49423, 10, 539, 348 ) , ( 162, 0, 100, 0, 3, 'june 13 2005
043.jpg_thumb', 29370, 0, 150, 96 ) , ( 163, 268, 101, 0, 0,
'P1010054_477x480.jpg', 44616, 4, 477, 480 ) , ( 164, 0, 101, 0, 3,
'P1010054_477x480.jpg_thumb', 43382, 0, 149, 150 ) , ( 165, 269, 101, 0, 0,
'P1010051.JPG', 56774, 4, 606, 768 ) , ( 166, 0, 101, 0, 3,
'P1010051.JPG_thumb', 35076, 0, 118, 150 ) , ( 167, 289, 102, 0, 0, 'Sept 6
2008 011 postable.JPG', 33585, 6, 776, 434 ) , ( 168, 0, 102, 0, 3, 'Sept 6 2008
011 postable.JPG_thumb', 22224, 0, 150, 83 ) , ( 169, 290, 102, 0, 0, 'Sept 6 & 7
2008 Kodak 056.jpg', 24851, 5, 640, 441 ) , ( 170, 0, 102, 0, 3, 'Sept 6 & 7 2008
Kodak 056.jpg_thumb', 28336, 0, 150, 103 ) , ( 171, 244, 103, 0, 0, 'Jan 25 2007
008.jpg', 40610, 5, 640, 448 ) , ( 172, 0, 103, 0, 3, 'Jan 25 2007 008.jpg_thumb',
31245, 0, 150, 105 ) , ( 173, 245, 108, 0, 0, 'Picture 248.jpg', 59118, 7, 480, 640
) , ( 174, 0, 108, 0, 3, 'Picture 248.jpg_thumb', 30072, 0, 112, 150 ) , ( 175, 287,
109, 0, 0, 'IM000140.JPG', 119698, 5, 650, 867 ) , ( 176, 0, 109, 0, 3,
'IM000140.JPG_thumb', 38517, 0, 112, 150 ) , ( 177, 288, 109, 0, 0,
'IM000243.JPG', 71270, 5, 480, 640 ) , ( 178, 0, 109, 0, 3,
'IM000243.JPG_thumb', 38592, 0, 112, 150 ) , ( 179, 219, 111, 0, 0, 'g26.jpg',
114665, 15, 796, 756 ) , ( 180, 0, 111, 0, 3, 'g26.jpg_thumb', 43459, 0, 150, 142
) , ( 181, 220, 117, 0, 0, 'g35.jpg', 122618, 8, 773, 1080 ) , ( 182, 0, 117, 0, 3,
'g35.jpg_thumb', 31486, 0, 107, 150 ) , ( 184, 0, 0, 1, 0, 'avatar_1.png', 8080,
137, 47, 65 ) , ( 185, 0, 0, 34, 0, 'avatar_34.png', 6736, 88, 65, 48 ) , ( 186, 187,
125, 0, 0, '10bgbkpa8.jpg', 16976, 0, 160, 120 ) , ( 187, 0, 125, 0, 3,
'10bgbkpa8.jpg_thumb', 30727, 0, 150, 112 ) , ( 188, 189, 125, 0, 0,
'21bgfntp12.jpg', 18334, 0, 160, 120 ) , ( 189, 0, 125, 0, 3,
'21bgfntp12.jpg_thumb', 31539, 0, 150, 112 ) , ( 190, 271, 125, 0, 0,
'DSC01068_edited_219x600.jpg', 23827, 0, 219, 600 ) , ( 191, 0, 125, 0, 3,
'DSC01068_edited_219x600.jpg_thumb', 17024, 0, 54, 150 ) , ( 192, 272, 125,
0, 0, 'DSC01071_edited_309x600.jpg', 24122, 0, 309, 600 ) , ( 193, 0, 125, 0, 3,
'DSC01071_edited_309x600.jpg_thumb', 20827, 0, 77, 150 ) , ( 194, 270, 133,
0, 0, 'camp14.jpg', 136478, 14, 900, 600 ) , ( 195, 0, 133, 0, 3,
'camp14.jpg_thumb', 39091, 0, 150, 100 ) , ( 196, 225, 141, 0, 0, 'march 12 2005
050.jpg', 35772, 2, 640, 586 ) , ( 197, 0, 141, 0, 3, 'march 12 2005
050.jpg_thumb', 39503, 0, 150, 137 ) , ( 198, 227, 141, 0, 0, 'march 12 2005
051.jpg', 39497, 2, 640, 597 ) , ( 199, 0, 141, 0, 3, 'march 12 2005
051.jpg_thumb', 40549, 0, 150, 139 ) , ( 200, 229, 142, 0, 0, 'march 12 2005
052.jpg', 32802, 1, 640, 474 ) , ( 201, 0, 142, 0, 3, 'march 12 2005
052.jpg_thumb', 33217, 0, 150, 111 ) , ( 202, 231, 142, 0, 0, 'march 12 2005
053.jpg', 22773, 3, 640, 390 ) , ( 203, 0, 142, 0, 3, 'march 12 2005
053.jpg_thumb', 26401, 0, 150, 91 ) , ( 204, 0, 21, 0, 3, 'Sept 6 2008 011
postable.JPG_thumb', 55987, 0, 250, 139 ) , ( 205, 0, 21, 0, 3, 'Sept 6 2008 012
postable.JPG_thumb', 53334, 0, 250, 128 ) , ( 206, 0, 22, 0, 3, 'Sept 6 2008 016
postable.JPG_thumb', 53613, 0, 250, 127 ) , ( 207, 0, 22, 0, 3, 'Sept 6 2008
021.jpg_thumb', 76903, 0, 250, 177 ) , ( 208, 0, 23, 0, 3, 'Sept 6 2008
022.jpg_thumb', 71073, 0, 250, 163 ) , ( 209, 0, 23, 0, 3, 'Sept 6 2008
023.jpg_thumb', 59950, 0, 250, 136 ) , ( 210, 0, 29, 0, 3, 'Sept 6 2008
029.jpg_thumb', 68956, 0, 250, 171 ) , ( 211, 0, 29, 0, 3, 'Sept 6 2008
031.jpg_thumb', 64003, 0, 250, 152 ) , ( 212, 0, 35, 0, 3, 'Sept 6 & 7 2008 Kodak
064.jpg_thumb', 62689, 0, 250, 163 ) , ( 213, 0, 35, 0, 3, 'Sept 6 & 7 2008 Kodak
069.jpg_thumb', 70640, 0, 250, 192 ) , ( 214, 0, 45, 0, 3, 'Sept 6 & 7 2008 Kodak
091.jpg_thumb', 78966, 0, 250, 194 ) , ( 215, 0, 45, 0, 3, 'Sept 6 & 7 2008 Kodak
094.jpg_thumb', 88927, 0, 250, 236 ) , ( 216, 0, 52, 0, 3, 'M1.jpg_thumb',
104637, 0, 250, 237 ) , ( 217, 0, 53, 0, 3, 'hu30.jpg_thumb', 56046, 0, 104, 250 ) ,
( 218, 0, 68, 0, 3, 'fantastic.gif_thumb', 32379, 0, 250, 85 ) , ( 219, 0, 111, 0, 3,
'g26.jpg_thumb', 115500, 0, 250, 237 ) , ( 220, 0, 117, 0, 3, 'g35.jpg_thumb',
82166, 0, 178, 250 ) , ( 221, 0, 14, 0, 3, '2003-11-08-032.jpg_thumb', 93464, 0,
250, 189 ) , ( 222, 0, 14, 0, 3, '2003-11-08-034.jpg_thumb', 94202, 0, 250, 201 ) ,
( 223, 0, 20, 0, 3, 'Sept 6 & 7 2008 Kodak 076.jpg_thumb', 97106, 0, 220, 250 ) ,
( 224, 0, 20, 0, 3, 'Sept 6 & 7 2008 Kodak 084.jpg_thumb', 87673, 0, 250, 195 ) ,
( 225, 0, 141, 0, 3, 'march 12 2005 050.jpg_thumb', 95885, 0, 250, 228 ) , ( 226,
0, 24, 0, 3, '2005-06-05-033.jpg_thumb', 88258, 0, 250, 187 ) , ( 227, 0, 141, 0,
3, 'march 12 2005 051.jpg_thumb', 100274, 0, 250, 233 ) , ( 228, 0, 24, 0, 3,
'2005-06-05-036.jpg_thumb', 79260, 0, 250, 187 ) , ( 229, 0, 142, 0, 3, 'march 12
2005 052.jpg_thumb', 81338, 0, 250, 185 ) , ( 230, 0, 28, 0, 3, 'Sept 25 2008
Ollie 002.jpg_thumb', 78005, 0, 250, 191 ) , ( 231, 0, 142, 0, 3, 'march 12 2005
053.jpg_thumb', 63352, 0, 250, 152 ) , ( 232, 0, 28, 0, 3, 'Sept 25 2008 Ollie
108.jpg_thumb', 75390, 0, 250, 178 ) , ( 233, 0, 43, 0, 3, 'mobile13.jpg_thumb',
78770, 0, 187, 250 ) , ( 234, 0, 43, 0, 3, '100_0246.jpg_thumb', 88380, 0, 250,
187 ) , ( 235, 0, 43, 0, 3, 'b3.jpg_thumb', 79431, 0, 250, 187 ) , ( 236, 0, 50, 0, 3,
'2005-06-05-041.jpg_thumb', 75344, 0, 250, 187 ) , ( 237, 0, 50, 0, 3,
'2005-06-09-008.jpg_thumb', 84361, 0, 250, 187 ) , ( 238, 0, 67, 0, 3,
'Image17.jpg_thumb', 88898, 0, 250, 187 ) , ( 239, 0, 67, 0, 3,
'Image27.jpg_thumb', 95480, 0, 250, 187 ) , ( 240, 0, 67, 0, 3,
'Image37.jpg_thumb', 89473, 0, 250, 187 ) , ( 241, 0, 67, 0, 3,
'Image32.jpg_thumb', 73446, 0, 250, 187 ) , ( 242, 0, 69, 0, 3, 'hu28a.jpg_thumb',
71218, 0, 250, 159 ) , ( 243, 0, 94, 0, 3, 'Picture 1084.jpg_thumb', 86874, 0, 187,
250 ) , ( 244, 0, 103, 0, 3, 'Jan 25 2007 008.jpg_thumb', 79855, 0, 250, 175 ) , (
245, 0, 108, 0, 3, 'Picture 248.jpg_thumb', 79105, 0, 187, 250 ) , ( 246, 0, 5, 0, 3,
'July 2 2005 034_640x480.jpg_thumb', 61964, 0, 250, 187 ) , ( 247, 0, 5, 0, 3,
'July 2 2005 027_640x480.jpg_thumb', 67439, 0, 250, 187 ) , ( 248, 0, 6, 0, 3,
'July 2 2005 028_640x480.jpg_thumb', 66779, 0, 250, 187 ) , ( 249, 0, 6, 0, 3,
'july 2 2005 037_558x480.jpg_thumb', 73082, 0, 250, 215 ) , ( 250, 0, 7, 0, 3, 'july
2 2005 043_564x480.jpg_thumb', 77716, 0, 250, 212 ) , ( 251, 0, 7, 0, 3, 'july 2
2005 042_516x480.jpg_thumb', 87739, 0, 250, 232 ) , ( 252, 0, 8, 0, 3, 'july 2
2005 044_530x480.jpg_thumb', 85622, 0, 250, 226 ) , ( 253, 0, 8, 0, 3, 'july 2
2005 045_536x480.jpg_thumb', 79301, 0, 250, 223 ) , ( 254, 0, 10, 0, 3, 'july 2
2005 046_547x480.jpg_thumb', 85204, 0, 250, 219 ) , ( 255, 0, 10, 0, 3, 'july 2
2005 047_502x480.jpg_thumb', 92369, 0, 250, 239 ) , ( 256, 0, 12, 0, 3, 'july 2
2005 049_524x480.jpg_thumb', 83831, 0, 250, 229 ) , ( 257, 0, 12, 0, 3, 'july 2
2005 050_581x480.jpg_thumb', 78278, 0, 250, 206 ) , ( 258, 0, 13, 0, 3, 'july 2
2005 055_525x480.jpg_thumb', 86767, 0, 250, 228 ) , ( 259, 0, 13, 0, 3, 'july 2
2005 057_561x480.jpg_thumb', 82036, 0, 250, 213 ) ;
MySQL said:
#1054 - Unknown column 'attachmentType' in 'field list'
Go back to your original database and make a new backup, but in phpMyAdmin set (check) "Disable foreign key checks." Download that database and try it in restoring your new database.
"Disable foreign key checks" tells phpMyAdmin to not create the labels like abc_ryche2x. Then when you import it to a database def_ryche2x it won't complain about the database names being different.
And don't do that "data only" thing. You need a full backup. If you're not using phpMyAdmin I think you should consider trying it.
Ok so if I do the export from myphpadmin, beside checking the Disable foreign key checks, what should be checked? I was origianally doing the export via SMF maintenence, and then the import via phpmyadmin. I'm guessing check SQL as the export, and Disable foreign key checks, and anything else?
Everything else could be left on the default values. I never had a restore issue like this. I usually go with SQL and then export it.
I would agree with Greyknight except that I've found the phpMyAdmin default values go all over the place depending on which hosting service and how they installed phpMyAdmin.
Here are my favorite settings:
- Disable foreign key checks
- Structure
- Enclose table and field names with backquotes
- Data
- Complete inserts
- Use hexadecimal for BLOB
- SQL
- Save as file
- "zipped"
I'm sure in many cases the check marks could go either way. Try it and see for yourself. If it works, just remember your settings and use the same ones every time.
Appreciate the recommendations. Still trying to get my original host to fix some problems. When I do the export, as recommended or otherwise I get a some kind of remote proxy error. I have asked the host to look into the problem for me. Will keep you updated.
You might want to try selecting Structure and drop tables. This should ensure that all the data matches all the tables/fields in the restored db.