Need help?

Our experts have had an average response time of 13.14 minutes in February 2024 to fix urgent issues.

We will keep your servers stable, secure, and fast at all times for one fixed price.

Fixing “No Database selected” error during the SQL file import

by | Oct 4, 2021

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.

Solution 1

  1. First, use the command below to mention the name of the database before creating the table:
     USE database_name;
  2. 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.

Solution 2
You can also select the database to be used with the following command:

mysql -u example_user -p --database=work < ./work.sql

Solution 3
If you are using MySQL workbench, our Support Engineers recommend these steps:

  1. First, navigate to the welcome window’s left pane and go to Object Browser.
  2. Then, select a database from the drop-down list.
  3. After that, navigate to SQL Development in the Workbench splash screen and click Manage Connections.

Solution 4
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:

  1. First, ensure that you already have a new MySQL database on Live Site.
  2. After that, go to phpMyAdmin on the live site and log in to the database.
  3. Next, select the database from the list.
  4. Then, click Import from the top bar.
  5. After that, click the Browse button located near the
  6. Then, browse and locate the local SQL file and click Open. Remember to unzip of first if it is a zipped file.
  7. Next, choose SQL as the format and click Go.
  8. 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.

Solution 5
This solution involves importing the database only after creating it.

  1. First, use MySQL phpMyAdmin and create a new database.
  2. Then, use the database by running the following command:
    use database_name

[ Require assistance? Try our Server Management Services.]

Conclusion

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.

PREVENT YOUR SERVER FROM CRASHING!

Never again lose customers to poor server speed! Let us help you.

Our server experts will monitor & maintain your server 24/7 so that it remains lightning fast and secure.

GET STARTED

0 Comments

Submit a Comment

Your email address will not be published. Required fields are marked *

Categories

Tags

Privacy Preference Center

Necessary

Necessary cookies help make a website usable by enabling basic functions like page navigation and access to secure areas of the website. The website cannot function properly without these cookies.

PHPSESSID - Preserves user session state across page requests.

gdpr[consent_types] - Used to store user consents.

gdpr[allowed_cookies] - Used to store user allowed cookies.

PHPSESSID, gdpr[consent_types], gdpr[allowed_cookies]
PHPSESSID
WHMCSpKDlPzh2chML

Statistics

Statistic cookies help website owners to understand how visitors interact with websites by collecting and reporting information anonymously.

_ga - Preserves user session state across page requests.

_gat - Used by Google Analytics to throttle request rate

_gid - Registers a unique ID that is used to generate statistical data on how you use the website.

smartlookCookie - Used to collect user device and location information of the site visitors to improve the websites User Experience.

_ga, _gat, _gid
_ga, _gat, _gid
smartlookCookie
_clck, _clsk, CLID, ANONCHK, MR, MUID, SM

Marketing

Marketing cookies are used to track visitors across websites. The intention is to display ads that are relevant and engaging for the individual user and thereby more valuable for publishers and third party advertisers.

IDE - Used by Google DoubleClick to register and report the website user's actions after viewing or clicking one of the advertiser's ads with the purpose of measuring the efficacy of an ad and to present targeted ads to the user.

test_cookie - Used to check if the user's browser supports cookies.

1P_JAR - Google cookie. These cookies are used to collect website statistics and track conversion rates.

NID - Registers a unique ID that identifies a returning user's device. The ID is used for serving ads that are most relevant to the user.

DV - Google ad personalisation

IDE, test_cookie, 1P_JAR, NID, DV, NID
IDE, test_cookie
1P_JAR, NID, DV
NID
hblid

Security

These are essential site cookies, used by the google reCAPTCHA. These cookies use an unique identifier to verify if a visitor is human or a bot.

SID, APISID, HSID, NID, PREF
SID, APISID, HSID, NID, PREF