NineChime forum

I'm kind of surprised that no one's asked about this yet.  Perhaps they have, but I ran through pretty much everything, and no go.  I'm using the latest Wacintaki, upgraded (but not from poteto).

Um.  I'm trying to migrate from one server to another.  I've been trying to import to the correct subdomain I want the board to be moved to, and this comes up:

CREATE TABLE `op_oekaki` (
`ID` int( 11 ) NOT NULL AUTO_INCREMENT ,
`usrname` varchar( 255 ) NOT NULL default '',
`usrpass` text,
`usrflags` varchar( 10 ) default 'G',
`email` varchar( 255 ) default NULL ,
`name` varchar( 25 ) default NULL ,
`comment` text,
`url` text,
`aim` varchar( 30 ) default NULL ,
`icq` varchar( 20 ) default NULL ,
`urltitle` text,
`joindate` date NOT NULL default '0000-00-00',
`lastlogin` datetime NOT NULL default '0000-00-00 00:00:00',
`MSN` text,
`Yahoo` text,
`IRCNick` text,
`IRCServer` text,
`location` text,
`piccount` int( 11 ) NOT NULL default '0',
`IRCchan` text,
`templatesel` varchar( 255 ) NOT NULL default '',
`commcount` int( 11 ) NOT NULL default '0',
`age` text,
`gender` text,
`picview` tinyint( 11 ) NOT NULL default '0',
`language` text,
`thumbview` tinyint( 4 ) NOT NULL default '0',
`screensize` mediumint( 9 ) NOT NULL default '800',
`rank` tinyint( 4 ) NOT NULL default '0',
`avatar` varchar( 128 ) NOT NULL default '',
PRIMARY KEY ( `ID` ) ,
UNIQUE KEY `usrname` ( `usrname` )
) ENGINE = InnoDB DEFAULT CHARSET = latin1 AUTO_INCREMENT =5;

MySQL said: Documentation
#1050 - Table 'op_oekaki' already exists

It's not visible from this, but in my panel, there's a big fatty red X by the url selector thing.  I have no idea what it means, either.

I didn't notice it during my first time attempting the import, but I was kind of curious as to why the database wouldn't show up on the list on the new server. D<  If it helps, both use phpMyadmin. Perhaps when I downloaded it from the original server I missed something?  (Sorry, I'm learning a little bit about php, but I still have a lot of trouble understand the database workings.  Unfortunately, this is the first of more than a few php-driven subsites that need to migrated before the old server expires.)

Mostly, I'm curious as to whether I'm going to need to do a re-install, or if there's something like your usual config.php where I can change the database/root/whatev info.  Above all, I don't want to break anything. :3  Also, the new server I'm on gives me the choice of php 4 or 5.  Will Wacintaki work with 5, or should I stick to 4 to be safe?

Thanks for the time!

Last edited by miriya (09-07-2006 19:17:58)