Advertisement:

Author Topic: Restoring Database  (Read 1447 times)

Offline Shwat

  • Semi-Newbie
  • *
  • Posts: 16
Restoring Database
« 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: phpmyadmin
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.

Offline Shwat

  • Semi-Newbie
  • *
  • Posts: 16
Re: Restoring Database
« Reply #1 on: May 26, 2008, 06:46:11 AM »
Anyone have any ideas at all?

Offline Dragooon

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 6,738
  • Gender: Male
  • I'm bIn
    • ShitizGarg on Facebook
    • Dragooon on GitHub
    • dragooon on LinkedIn
    • SMF-Media
Re: Restoring Database
« Reply #2 on: May 26, 2008, 06:51:24 AM »
While backing up, did you selected "Save table structure"?

Offline Rumbaar

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 15,805
  • Gender: Male
  • Inherent Omniscience
    • Rumbaar.net
Re: Restoring Database
« Reply #3 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.
"An important reward for a job well done is a personal sense of worthwhile achievement."

[ Themes ]