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;
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