News:

Want to get involved in developing SMF, then why not lend a hand on our github!

Main Menu

Restoring Database

Started by Shwat, May 25, 2008, 11:36:42 AM

Previous topic - Next topic

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
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.

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

[ Themes ]

Advertisement: