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