MyBB Community Forums

I created a full system backup in the Admin CP of my forum, which gave me a .sql file.

How do I restore my forum from this? I completely broke the site when trying to update.

I've tried uploading in phpMyAdmin, and even after deleting 'adminlog', I get the error message:

-- MyBB Database Backup
-- Generated: 01st August 2011 at 09:46
-- -------------------------------------

CREATE TABLE 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

Is uploading this to phpMyAdmin even the right thing to do? If so, how can I overcome this?

Many thanks.

You need to select Userid-mybb tables at the bottom is says DROP TABLES drop all tables and then use the import option and import the .sql file and all your tables will be recreated! hope this helps

make sure your export all tables 1st i case something goes wrong .

I've tried clearing the database (if that's what you meant), and still it doesn't work.

Also, will uploading this file into the database keep all of the plugins/themes?