Phpmyadmin database import error

Question

I am trying to import a MySQL database on localhost via phpmyadmin and I am getting this error. what does it mean? and how can i solve this? any ideas?

SQL query:

--
-- Database: `casasdl_mag`
--
--
-- Database: `casasdl`
--
-- --------------------------------------------------------
--
-- Table structure for table `admin_assert`
--
CREATE TABLE IF NOT EXISTS  `admin_assert` (

 `assert_id` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT  'Assert ID',
 `assert_type` VARCHAR( 20 ) DEFAULT NULL COMMENT  'Assert Type',
 `assert_data` TEXT COMMENT  'Assert Data',
PRIMARY KEY (  `assert_id` )
) ENGINE = INNODB DEFAULT CHARSET = utf8 COMMENT =  'Admin Assert Table' AUTO_INCREMENT =1;

MySQL said: Documentation

#1046 - No database selected  

Answer 1

When creating a table, you need to select the database for this table to insert into

USE databaseName;

run this before the script

USE casasdl;
CREATE TABLE IF NOT EXISTS  `admin_assert` (

 `assert_id` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT  'Assert ID',
 `assert_type` VARCHAR( 20 ) DEFAULT NULL COMMENT  'Assert Type',
 `assert_data` TEXT COMMENT  'Assert Data',
PRIMARY KEY (  `assert_id` )
) ENGINE = INNODB DEFAULT CHARSET = utf8 COMMENT =  'Admin Assert Table' AUTO_INCREMENT =1;

Answer 2

As you can read by mistake, you need to select your database.

Add USE yourDatabase;to the beginning of the code.

Answer 3

mysql db , db, mysql:

use mydbname;

:

mysqladmin -uroot -p create mydbname
mysql -uroot -p mydbname < mysqlfile.sql

Answer 4

php, use database mysql-select_db("database");. mysqli_connect, .

Answer 5

USE db_name MySQL db_name () . , USE.

: http://dev.mysql.com/doc/refman/5.6/en/use.html

Answer 6

phpmyadmin DB , .