Coinbase

Author Topic: importing MYsql database to SMF 1.1.8 (SOLVED)  (Read 4018 times)

0 Members and 1 Guest are viewing this topic.

Offline Neighbours-Unite

  • Newbie
  • *
  • Posts: 4
    • Email
importing MYsql database to SMF 1.1.8 (SOLVED)
« on: February 19, 2009, 09:53:30 am »
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]
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  8)
« Last Edit: March 03, 2009, 07:25:16 am by Neighbours-Unite »

Offline Zagrom

  • Newbie
  • *
  • Posts: 7
  • Im an Otaku Dammit!
    • Otaku Unlimited
Re: importing MYsql database to SMF 1.1.8
« Reply #1 on: February 19, 2009, 05:45:04 pm »
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

Offline Neighbours-Unite

  • Newbie
  • *
  • Posts: 4
    • Email
Re: importing MYsql database to SMF 1.1.8
« Reply #2 on: March 02, 2009, 04:11:48 pm »
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  8)

Offline welllyn07

  • Newbie
  • *
  • Posts: 1
    • Email
Re: importing MYsql database to SMF 1.1.8 (SOLVED)
« Reply #3 on: October 10, 2009, 12:38:52 am »
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
« Last Edit: October 14, 2009, 09:11:25 am by welllyn07 »

SMF Ads Support Forum

Re: importing MYsql database to SMF 1.1.8 (SOLVED)
« Reply #3 on: October 10, 2009, 12:38:52 am »
.