Sign Up

Have an account?

Sign In

Don't have account,

Forget Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Have an account?

You must login to ask question.

Need An Account,
Search
Ask a Question
Home / Questions / Q 247
In Process

Developers Map

Abhishek Mittal

Abhishek Mittal

  • abhishek
View Profile
  • 5
Asked:

HOW TO IMPORT DATABASE ON LOCALHOST USING CMD TERMINAL IN UBUNTU

  • 5
SETP 1 : Open you terminal and use this cmd.

CMD  :  /opt/lampp/bin/mysql -u root -p databaseName < filepath.sql //import database from terminal on local


EXAMPLE :  /opt/lampp/bin/mysql -u root -p DEMO_DB< /opt/lampp/htdocs/demo.sql

As we shows on above example DEMO_DB is a database name and demo.sql is a sql file.

For windows :
mysql -u root -p dbname < sql_file_name

/opt/lampp/htdocs/demo.sql  this is my sql file path. user can change sql file path according to your file.

NOTE : when you are doing this then cmd will ask to you enter your password so password will be blank.

IMPORTIMPORT DATABASEIMPORT DATABASE USING CMD
Share

1 Answer

  1. Manish Garg

    View Profile
    Added an answer on May 29, 2019 at 8:06 pm

    But In windows how to import data in MySQL

    My suggestion:

    Open the command line and trigger command given below

    mysql -u username -p database_name < file.sql

    And try this one also

    1. Open the MySQL command line.
2. Type the path of your mysql bin directory and press Enter.
3. Paste your SQL file inside the bin folder of mysql server.
4. Create a database in MySQL.
5. Use that particular database where you want to import the SQL file.
6. Type source databasefilename.sql and Enter.
Your SQL file upload successfully.
    • 2
Leave an answer

Leave an answer

Browse