Monday, August 12, 2013

Import Sql file from Command Prompt in xampp

first copy your sql file and paste to bin directory of xampp/mysql

Then go to your xampp location->mysql->bin in command prompt and write.

mysql -u username -p (here 'username' is the username of the database) then press enter

It will ask a password of your database. Enter your password and hit enter. Then write

use database_name (here 'database_name' is the name of the database)

Then give the path of your source sql file.

source filename.sql

No comments:

Post a Comment