News:

SMF 2.1.4 has been released! Take it for a spin! Read more.

Main Menu

Database Restore Issue

Started by ryche2x, November 08, 2008, 01:44:35 PM

Previous topic - Next topic

ryche2x

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.

Deprecated

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?

godboko

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.
Thank you,
Robert aka godboko

ryche2x

#3
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 hxxp:123.abc.com [nonactive] running 1.16 SMF.  I want to move to a new host ( hxxp:123.def.com [nonactive] ) 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'


Deprecated

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.

ryche2x

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?

greyknight17

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.

Deprecated

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.

ryche2x

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.

Rumbaar

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.
"An important reward for a job well done is a personal sense of worthwhile achievement."

[ Themes ]

Advertisement: