Stuck with “No Database selected” error during the SQL file import? Our Support Engineers are here with an easy solution.
At Bobcares, we offer solutions to problems like these as a part of our Server Management Services. Let’s find out what our Support Team recommends when faced with “No Database selected” error during the SQL file import.
Resolving “No Database selected” error during the SQL file import
As the error name suggests, the reason behind the error is not selecting a database before importing the SQL file. Our Support Engineers offer five different ways to resolve this error. Let’s take a look at each of these solutions.
- First, use the command below to mention the name of the database before creating the table:
- In case, the database does not exist, create a new one with the command below:
CREATE DATABASE database_name;
Then use the database with the command mentioned in the previous step.
You can also select the database to be used with the following command:
mysql -u example_user -p --database=work < ./work.sql
If you are using MySQL workbench, our Support Engineers recommend these steps:
- First, navigate to the welcome window’s left pane and go to Object Browser.
- Then, select a database from the drop-down list.
- After that, navigate to SQL Development in the Workbench splash screen and click Manage Connections.
If you have an SQL database file, you can also import it to PhpMyAdmin and resolve the “No Database selected” error during the SQL file import as seen below:
- First, ensure that you already have a new MySQL database on Live Site.
- After that, go to phpMyAdmin on the live site and log in to the database.
- Next, select the database from the list.
- Then, click Import from the top bar.
- After that, click the Browse button located near the
- Then, browse and locate the local SQL file and click Open. Remember to unzip of first if it is a zipped file.
- Next, choose SQL as the format and click Go.
- You will have to wait for a few minutes, depending on the size of the database.
Our Support Engineers would like to remind you that the created database needs to have the same name as mentioned in the file.
This solution involves importing the database only after creating it.
- First, use MySQL phpMyAdmin and create a new database.
- Then, use the database by running the following command:
[ Require assistance? Try our Server Management Services.]
At the end of the day, the Support Engineers introduced five different ways to resolve “No Database selected” error during the SQL file import with ease.