How to import multiple database at once through PhpMyAdmin?

Question

Error

SQL query:

--
-- Database: `attend`
--

-- --------------------------------------------------------

--
-- Table structure for table `attend`
--

CREATE TABLE IF NOT EXISTS `attend` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `name` varchar(15) NOT NULL DEFAULT 'name',
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `timeing` time NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;

MySQL said: Documentation
#1046 - No database selected

I am shifting my databases. I exported all the database at once.
So during import I cannot select single database.
And by directly importing sql file i am getting the above error.

Possible solutions found on phpmyadmin import database error
But dont know how to implement this solution for about 30 database in .sql file
Please help me as i have deleted old database after exporting all database, and need to import mASAP.

BretHudson · Accepted Answer · 2014-03-02 06:36:18Z

6

The problem is that SQL needs to explicitly be told what database you're using, either on a global level or on each individual table create query. There's two things we need to do here:

A) If that database doesn't exist, you'll need to create it first. There's no way to put something in a database that isn't there.

B) Make sure you tell the query which database to use. The solution you linked uses this solution. You'll only want to use it if all the tables are going to one database. The line is:

USE `database_name`;

replacing database_name with the name of the database that you're going to use.

However, if each table belongs to a different database, you'll want to change the following:

CREATE TABLE IF NOT EXISTS `attend` (

to

CREATE TABLE IF NOT EXISTS `database_name`.`attend` (

replacing database_name with the name of the database that table is going to be a part of.

answered Mar 2, 2014 at 6:36

BretHudson

1261 silver badge8 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Akash Kumar Over a year ago

Finally I applied USE statement before every database in sql file, very exaushed work but WORKED

Marc Delisle · Accepted Answer · 2014-03-02 12:50:30Z

2

In the current 4.1 version of phpMyAdmin, when you export at the server level, if you open the Custom export options, you'll see a choice "Add CREATE DATABASE / USE statement". This option is what you need to select.

answered Mar 2, 2014 at 12:50

Marc Delisle

9,0253 gold badges32 silver badges29 bronze badges

1 Comment

Akash Kumar Over a year ago

I had older version of phpMyAdmin so, those options not present during EXPORT

Community · Accepted Answer · 2017-04-13 12:22:47Z

1

as stated at askubuntu.com, you can use:

-export using: mysqldump -u username -p –-all-databases > dump.sql
-import using: mysql -u username -p < dump.sql

edited Apr 13, 2017 at 12:22

CommunityBot

11 silver badge

answered Jan 6, 2017 at 17:14

T.Todua

57.1k22 gold badges261 silver badges266 bronze badges

Collectives™ on Stack Overflow

How to import multiple database at once through PhpMyAdmin?

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related