Import the database using the CMD prompt on Windows

Step 1:
Go to Run Command [Win+R] and type CMD and click on OK to open CMD prompt
Step 2:
Navigate to following folder path “wamp\bin\mysql\mysql5.5.24\bin” using command line [ex: cd D:\wamp\bin\mysql\mysql5.5.24\bin]
Step 3:
Type this mysql -u username -p -h localhost DATA-BASE-NAME < data.sql with your updated data on command prompt
Step 4:
Finally click on the Enter

Leave a Reply

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