MyBB Community Forums

copy files, copy database, change dns, done.

i took backup now can i upload through phpmyadmin import sql database section?

that's how it is done

got the following error

SQL query:

-- MyBB Database Backup
-- Generated: 28th August 2010 at 03:58
-- -------------------------------------
CREATE TABLE mybb_announcements (
aid int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
fid int( 10 ) NOT NULL DEFAULT '0',
uid int( 10 ) unsigned NOT NULL DEFAULT '0',
subject varchar( 120 ) NOT NULL DEFAULT '',
message text NOT NULL ,
startdate bigint( 30 ) NOT NULL DEFAULT '0',
enddate bigint( 30 ) NOT NULL DEFAULT '0',
allowhtml int( 1 ) NOT NULL DEFAULT '0',
allowmycode int( 1 ) NOT NULL DEFAULT '0',
allowsmilies int( 1 ) NOT NULL DEFAULT '0',
tw_id varchar( 20 ) NOT NULL DEFAULT '0',
fb_id varchar( 50 ) NOT NULL DEFAULT '0',
fb_uid varchar( 50 ) NOT NULL DEFAULT '0',
PRIMARY KEY ( aid ) ,
KEY fid ( fid )
) ENGINE = MYISAM AUTO_INCREMENT =2 DEFAULT CHARSET = utf8;

MySQL said: Documentation
#1050 - Table 'mybb_announcements' already exists

READ THE MESSAGE

Table 'mybb_attachments' already exists

Delete the tables in mysql then upload the backup.

i uploaded but my posts, forums , members database still missed