MyBB Community Forums

Hello,

Trying to restore database backup using method suggested on the mybboard wiki using phpMyAdmin SQL. Browsed to the backup file, unchecked the box "Show query box" as told.

And I get this error:

Error

SQL query:

-- MyBB Database Backup
-- Generated: 03rd March 2010 at 12:00
-- -------------------------------------
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

I know the table exists, so where do I go from here?

Regards,
George.

You need to drop the existing tables before you can import tables with the same name as them. Make sure you don't need the tables that are there before you drop them.

Done that, I screwed up a bit to start with..
MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1045 - Access denied for user 'hyperfor_efdbuse'@'jag.boxsecured.com' (using password: YES)
Query:
[READ] Unable to connect to MySQL server


www.eforums.co.cc

(Yes, I know it's called hyperfor, I had a domain change a while back)

Check your mysql login details are correct in /inc/config.php

[Wiki: Help:Common_Error_Messages] (Broken link, head over to docs.mybb.com instead)

Thanks guys, Fixed