How to import the sql file in mysql using command line

Microsoft Windows [Version 10.0.22000.675]

(c) Microsoft Corporation. All rights reserved.

C:\Users\PC\Downloads>mysql -u root -p Databasename < databasefile.sql 
'mysql' is not recognized as an internal or external command, operable program, or batch file.

Solution: Simply type in the command prompt :

C:\Users\PC\Downloads>set path=%PATH%;C:\xampp\mysql\bin;

C:\Users\PC\Downloads>mysql -u root -p Databasename < databasefile.sql Enter password:

C:\Users\PC\Downloads>
 

Database Successfully import

Sharecodepoint

Sharecodepoint is the junction where every essential thing is shared for college students in the well-defined packets of codes. We are focused on providing you the best material package like Question papers, MCQ'S, and one NIGHT STUDY MATERIAL. facebook twitter youtube instagram

Post a Comment

Previous Post Next Post

Contact Form