MyBB Community Forums

Full Version: DB Import
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Here is how it goes.

I wanted to switch hosts, so I installed MyBB over my new servers using an autoinstaller.

Then I imported the Database using phpMyAdmin. I got the error:
SQL query:
-- MyBB Database Backup
-- Generated: 10th March 2012 at 22:12
-- -------------------------------------
CREATE TABLE `mybb_adminlog` (
`uid` int( 10 ) unsigned NOT NULL DEFAULT '0',
`ipaddress` varchar( 50 ) NOT NULL DEFAULT '',
`dateline` bigint( 30 ) NOT NULL DEFAULT '0',
`module` varchar( 50 ) NOT NULL DEFAULT '',
`action` varchar( 50 ) NOT NULL DEFAULT '',
`data` text NOT NULL ,
KEY `module` ( `module` , `action` )
) ENGINE = MYISAM DEFAULT CHARSET = utf8;

MySQL said: Documentation
#1050 - Table 'mybb_adminlog' already exists 
[/size]

I tried uploading it over a blank SQL DB and succeeded. When the import was done, I edited my config.php and still I get a blank forum. The DB seems to be blank but it has the contents.

My host allows a max of 8192KB DB. And I had to use a .sql.zip.

Help would be appreciated.