Topic: Restoring Database

[Shwat]

I need to restore my database. I downloaded the database before I deleted the current forum, and now I am trying to reupload the database in phpmyadmin. I get an error while it is uploading and the whole process cancels. I was running SMF 1.1.4, and had uninstalled and deleted all mods I was running.

The error I get is

Error

SQL query:

# ==========================================================
#
# Database dump of tables in `alex_smf1`
# May 24, 2008, 09:07:03 PM
#
# ==========================================================
#
# Dumping data in `smf_attachments`
#
INSERT INTO `smf_attachments` (
`ID_ATTACH` ,
`ID_THUMB` ,
`ID_MSG` ,
`ID_MEMBER` ,
`attachmentType` ,
`filename` ,
`size` ,
`downloads` ,
`width` ,
`height`
)
VALUES ( 16, 17, 25, 0, 0, 'viewthreads.JPG', 41977, 3, 693, 343 ) , ( 17, 0, 25, 0, 3, 'viewthreads.JPG_thumb', 19452, 0, 200, 98 ) , ( 14, 0, 0, 1, 0, 'avatar_1.jpg', 35056, 2509, 82, 100 ) , ( 21, 0, 0, 3, 0, 'avatar_3.png', 17986, 998, 100, 75 ) , ( 15, 0, 0, 2, 0, 'avatar_2.jpg', 32118, 943, 84, 100 ) , ( 18, 0, 0, 6, 0, 'avatar_6.jpg', 43556, 1143, 90, 100 ) , ( 19, 0, 0, 8, 0, 'avatar_8.png', 21668, 321, 87, 100 ) , ( 31, 0, 0, 7, 0, 'avatar_7.jpg', 7345, 176, 100, 100 ) , ( 22, 23, 0, 0, 0, 'die63.jpg', 54062, 0, 433, 600 ) , ( 23, 0, 0, 0, 3, 'die63.jpg_thumb', 69311, 0, 144, 200 ) , ( 24, 25, 0, 0, 0, 'DEG Die 4.jpg', 73337, 0, 650, 714 ) , ( 25, 0, 0, 0, 3, 'DEG Die 4.jpg_thumb', 67592, 0, 182, 200 ) , ( 32, 0, 0, 16, 0, 'avatar_16.png', 16843, 50, 75, 100 ) , ( 29, 0, 0, 15, 0, 'avatar_15.png', 19312, 142, 85, 100 ) , ( 30, 0, 0, 22, 0, 'avatar_22.png', 15107, 144, 100, 75 ) , ( 34, 0, 0, 34, 0, 'avatar_34.png', 15359, 14, 79, 100 ) ;

MySQL said: Documentation
#1146 - Table 'alex_smf1.smf_attachments' doesn't exist

Any help would be great.

[Shwat]

Anyone have any ideas at all?

[Dragooon]

While backing up, did you selected "Save table structure"?

[Rumbaar]

Yeah your sql restore doesn't seem to have the CREATE part of the db creation process.  You might want to take the full install of the version of SMF sql file and use the CREATE part of the file to populate your db with an empty table structure to insert your DATA into.