open xampp Control Panel
click / open : shell
on shell type this commands:
1. command : "MYSQL -U USERNAME -H LOCALHOST -P PASSWORD"
USERNAME : your database username
PASSWORD : your database password 
(if no password, then don't use "-P PASSWORD")
2. command : "USE NAME_OF_DATABASE"
 NAME_OF_DATABASE : name of your database
3. command : "SOURCE PATH_TO_SQL_FILE" 
PATH_TO_SQL_FILE : location to script.sql 
(ex. "source d:/myscript.sql")
4. done
No comments:
Post a Comment