MyBB Community Forums

Error


I did a fresh install on another host, then tried uploading my database in PHPmyAdmin (from my old host and forum) and got the below. (I know it is because tables were already created, just don't know what to do next.)
Side note: I also uploaded the "old" config.php and settings.php scripts and changed cookie settings. Not sure where to proceed from here....


SQL query:

-- MyBB Database Backup
-- Generated: 27th June 2007 at 06:53
-- -------------------------------------
CREATE TABLE mybb_adminlog (
uid int( 10 ) unsigned NOT NULL default '0',
dateline bigint( 30 ) NOT NULL default '0',
scriptname varchar( 50 ) NOT NULL default '',
action varchar( 50 ) NOT NULL default '',
querystring varchar( 150 ) NOT NULL default '',
ipaddress varchar( 50 ) NOT NULL default '',
KEY scriptname ( scriptname , action )
) ENGINE = MYISAM DEFAULT CHARSET = latin1;


MySQL said:
#1050 - Table 'mybb_adminlog' already exists

Delete your table mybb_adminlog

I did that, now I am getting:

Error

SQL query:

MySQL said:
#1050 - Table 'mybb_adminoptions' already exists

What do I have to do, delete ALL tables?


NEVER MIND, I GOT IT WORKING. For the benefit of others trying to do the same, just delete ALL tables from the "fresh install" and have your saved database fill in your "old" tables.