MyBB Community Forums

Hello.
I've just changed my web-hosting, but before that, i had downloaded the database for my forums. I am on the new host now, in phpMyAdmin and when i import my database, using Import, i get this:

--
-- Database: `my database here`
--
-- --------------------------------------------------------
--
-- Table structure for table `mybb_adminlog`
--
CREATE TABLE IF NOT EXISTS `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 says: Documentation
#1046 - No database selected 

What am i doing wrong?

Thanx.

looks like you exported a database "table" and not the entire database.

Yes, i needed to make a new database_name (example) than import my database in the new database made. Now it wroks,tables imported, etc, but i get this wen going on forums:

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
    2002 - Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Query:
    [READ] Unable to connect to MySQL server 

You need to first CREATE a database. Then go to phpmyadmin -> Click on your dATABASE name & select IMPORT & then import it.

---

EDIT: never saw that you uploaded the database.

For the other problem, looks like your hosting problem, maybe?

I wouldn't try running off the imported database. I would install a new instance then use the merge tool to move the old data to the new set of tables.

I made a new database, imported my old database in it, than went in inc/config.php and added there the new database+user+pass, and it works perfectly! Thank you all!