MyBB Community Forums

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

One thread is enough.

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

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