Insert php database using cmd prompt

mysql data upload using cmd promp

step 1:

Go to xamp inside bin copy the  path
step 2:
Go to cmd and past the path

step 3:

-u root -p -h localhost databasename < path of database wants to upload

Example :

C:\xampp\mysql\bin\mysql -u root -p -h localhost test < c:\user\LSN!$\desktop\p\testweb