importing MYsql database to SMF 1.1.8 (SOLVED)

[Neighbours-Unite]

I've tried to upgrade from SMF 1.1.4 to 1.1.8 and import the original database
but I've run in to a problem I can't figure out.

Code Select Expand

SQL query:

--
-- Table structure for table `attachments`
--
CREATE TABLE `attachments` (

`ID_ATTACH` int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
`ID_THUMB` int( 10 ) unsigned NOT NULL default '0',
`ID_MSG` int( 10 ) unsigned NOT NULL default '0',
`ID_MEMBER` mediumint( 8 ) unsigned NOT NULL default '0',
`attachmentType` tinyint( 3 ) unsigned NOT NULL default '0',
`filename` tinytext NOT NULL ,
`size` int( 10 ) unsigned NOT NULL default '0',
`downloads` mediumint( 8 ) unsigned NOT NULL default '0',
`width` mediumint( 8 ) unsigned NOT NULL default '0',
`height` mediumint( 8 ) unsigned NOT NULL default '0',
PRIMARY KEY ( `ID_ATTACH` ) ,
UNIQUE KEY `ID_MEMBER` ( `ID_MEMBER` , `ID_ATTACH` ) ,
KEY `ID_MSG` ( `ID_MSG` )
) ENGINE = MYISAM AUTO_INCREMENT =4 DEFAULT CHARSET = latin1;



MySQL said:

#1050 - Table 'attachments' already exists
I've put my forum in maintenance mode atm.
I hope someone can understand what I would have to do so I can use
my old sql database and keep everyone's account and all the posts.

GMax 

[Zagrom]

what web host are you using?
If you cant directly add it via
SMF that you can try to do it
with your web host

[Neighbours-Unite]

I noticed a day later that I had posted this in the wrong board, sorry for that.

After several attempts I had to reinstall a backup of the original forum
and had to put the themes back to it's original state (basicly over write with original)
After that I had everything back again and was also able to update my forum.

Thank god it all worked and the problem is solved.


GMax 

[welllyn07]

I think, the solution here is to have a connection pool on each node, initialized lazily by the first task that needs it, and stored and accessed in the node through NodeRunner.setPersistentData() and NodeRunner.getPersistentData(). Right?




_________________
Multivariate testing