MyBB Community Forums

i am trying to import a database but i am getting the following error.

SQL query:

--
-- Database: `newmybb`
--
-- --------------------------------------------------------
--
-- Table structure for table `mybb_adminlog`
--
CREATE TABLE  `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 said: 

#1046 - No database selected 

you have to create a database with utf-8 character encoding and import the old database into created database.

there is a database and the collation is utf8_general_ci. so shouldnt the character encoding already be utf-8?

^ if that is newly created database then select it to import contents of the database backup.
that is, in the database manager (eg. phpMyAdmin) click on database then click on import button

i have already tried doing that. then i get the error.