Pages

Monday, September 16, 2013

How to import Huge SQL Script on mysql

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

ShareThis