Empty set error in MySQL while Importing DB?

Empty set error in MySQL while Importing DB?

Error:
MariaDB [(none)]> use exampledb
Database changed
MariaDB [exampledb]> show tables;
Empty set (0.00 sec)



Solution:

1. Import the database

mysql -u root -p -Dexampledb < /home/exampledb.sql

2. Then login to the Database.

mysql -u root -p -Dexampledb

3. At MySQL Prompt Enter Following Command.

mysql> source /home/exampledb.sql

Output Would be Like this:

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 17 rows affected (0.00 sec)
Records: 17  Duplicates: 0  Warnings: 0

4. Now  you can check tables under that Database.

MariaDB [(none)]> use exampledb
Database changed
MariaDB [exampledb]> show tables;

0 Comments