Monday, 20 January 2014

MYSQL - Import Large Amount of Database using Command Prompt

To Import Database using command prompt, First we have to move into mysql > bin folder.
then we need to execute below command.


TO IMPORT DATABASE:
MYSQL -u USERNAME -p DB_NAME  < PATH\importfilename.sql


 Example:
  In my case, i am using XAMPP. So, my MYSQL folder Path Would be XAMPP\MYSQL\BIN

  1. Open Command Prompt (WINDOW + R -> cmd)
  2. cd\
  3. E:
  4. cd xampp\mysql\bin
  5. mysql -u root -p DB_NAME < C:\Users\MYNAME\Downloads\importfilename.sql
  6. Screen will Prompt for a Password. Enter your password and press enter.
We can able see the updated database.

No comments:

Post a Comment

Thank you so much for providing your valuable feedback. I will will look into them and update my skills & technologies accordingly.