Simple Machines Community Forum

SMF Support => SMF 1.1.x Support => Topic started by: Shwat on May 25, 2008, 11:36:42 AM

Title: Restoring Database
Post by: Shwat on May 25, 2008, 11:36:42 AM
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
Quote from: phpmyadminError

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.
Title: Re: Restoring Database
Post by: Shwat on May 26, 2008, 06:46:11 AM
Anyone have any ideas at all?
Title: Re: Restoring Database
Post by: Dragooon on May 26, 2008, 06:51:24 AM
While backing up, did you selected "Save table structure"?
Title: Re: Restoring Database
Post by: Rumbaar on June 20, 2008, 07:23:19 PM
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.