MyBB Community Forums

Full Version: Install DB Backup
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
I had to redo my forum, but now I do not know how to reinstall the forum database. Can someone please help?
Do you use cPanel or phpMyAdmin or something similar?
I have cpanel and phpmyadmin. I
Go into phpMyAdmin, make a new database, click "Import", and upload the file.
got the following error

localhost - kdtechno_mybb864
Error

SQL query:

-- MyBB Database Backup
-- Generated: 30th March 2012 at 15:42
-- -------------------------------------
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
[ Back ]

You need to delete any mybb tables already there.
Now I get

MyBB SQL Error

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1146 - Table 'kdtechno_mybb864.mybb_sessions' doesn't exist
Query:
SELECT * FROM mybb_sessions WHERE sid='00cd77edaec489f70149e8b0864e4a2c' AND ip='76.77.238.159' LIMIT 1

Please contact the MyBB Group for support.
You're going to have to clear your cookies.