MyBB Community Forums

Full Version: need help to reinstall forum
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hi

i have re install forum on new server and i have a backup of database around 600 kb

how to install database again to retain old posts and member database
pl help its 12.45 mid night at here and i want to finish my forum today
i just wanted to know where i have to upload database backup
phpmyadmin

getting error

SQL query:

-- MyBB Database Backup
-- Generated: 28th August 2010 at 03:58
-- -------------------------------------
CREATE TABLE mybb_attachments (
aid int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
pid int( 10 ) NOT NULL DEFAULT '0',
posthash varchar( 50 ) NOT NULL DEFAULT '',
uid int( 10 ) unsigned NOT NULL DEFAULT '0',
filename varchar( 120 ) NOT NULL DEFAULT '',
filetype varchar( 120 ) NOT NULL DEFAULT '',
filesize int( 10 ) NOT NULL DEFAULT '0',
attachname varchar( 120 ) NOT NULL DEFAULT '',
downloads int( 10 ) unsigned NOT NULL DEFAULT '0',
dateuploaded bigint( 30 ) NOT NULL DEFAULT '0',
visible int( 1 ) NOT NULL DEFAULT '0',
thumbnail varchar( 120 ) NOT NULL DEFAULT '',
PRIMARY KEY ( aid ) ,
KEY posthash ( posthash ) ,
KEY pid ( pid , visible ) ,
KEY uid ( uid )
) ENGINE = MYISAM AUTO_INCREMENT =4 DEFAULT CHARSET = utf8;

MySQL said: Documentation
#1050 - Table 'mybb_attachments' already exists
READ THE MESSAGE

Table 'mybb_attachments' already exists



Please don't make duplicate threads.

http://community.mybb.com/thread-75751.html