MyBB Community Forums

I have the backup file, but I don't know how to install it. I have seen the mybb backup tutorials on various sites as well.

You need to restore it using phpMyAdmin.

If it's the database backup, you'll have to import it via phpMyAdmin as what Paul H. mentioned above.

And how do you do that?

---

I tried to import it and got this error.
SQL query:

-- MyBB Database Backup
-- Generated: 11th December 2011 at 21:05
-- -------------------------------------
CREATE TABLE access (

userid INT( 10 ) UNSIGNED NOT NULL DEFAULT '0',
forumid SMALLINT( 5 ) UNSIGNED NOT NULL DEFAULT '0',
accessmask SMALLINT( 5 ) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY ( userid , forumid )
) ENGINE = MYISAM DEFAULT CHARSET = latin1;

MySQL said:

#1046 - No database selected

---

I try to open it in notepad and it doesn't seem to load or it's just taking forever.

Quote:#1046 - No database selected

Select a database first before you import the backup. Create one if you didn't and then select it.

Create it where?

---

I clicked the database on the table on the left and I tried to upload it and it still showed the same error.

---

This is the error I got after uploading to that database.

SQL query:

-- MyBB Database Backup
-- Generated: 11th December 2011 at 21:05
-- -------------------------------------
CREATE TABLE access (

userid INT( 10 ) UNSIGNED NOT NULL DEFAULT '0',
forumid SMALLINT( 5 ) UNSIGNED NOT NULL DEFAULT '0',
accessmask SMALLINT( 5 ) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY ( userid , forumid )
) ENGINE = MYISAM DEFAULT CHARSET = latin1;

MySQL said:

#1050 - Table 'access' already exists

Quote: #1050 - Table 'access' already exists

Delete the DB's tables first.

How do you delete those?

---

What do I do after I got the tables imported? I have them all imported now.

---

Nevermind. I think I got it. Thank you! (: