-->
  • Recent Articles

    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;

    No comments