CODEWITHSUNDEEP
mysqlsqlbatch-file
Kanishka Panamaldeniya
Kanishka Panamaldeniya

Reputation: 17566

failed to run a MySQL file using a batch file in windows

I am trying to run MySQL files from a batch file .

I am currently using this code

mysql -u<root> -p<> -e "source C:/xampp/htdocs/internet_wk_1.7/db/master_db.sql" kani

When I run the batch file nothing happens. What am I doing wrong?

UPDATE

hi i solved it . this my new code 

CLS
C:
cd\xampp\mysql\bin
mysql -u root -e "source C:\xampp\htdocs\internet_wk_1.7\db\master_db.sql" kani

but i have more than one sql file in my folder , i want run them too. i tried like this but not working , please help

CLS
C:
cd\xampp\mysql\bin
mysql -u root -e "source C:\xampp\htdocs\internet_wk_1.7\db\master_db.sql" kani
source C:\xampp\htdocs\internet_wk_1.7\db\master_db_tracker.sql

Upvotes: 0

Views: 725

Answers (1)

Randy
Randy

Reputation: 16677

CLS
C:
cd\xampp\mysql\bin
mysql -u root -e "source C:\xampp\htdocs\internet_wk_1.7\db\master_db.sql" kani
mysql -u root -e "source C:\xampp\htdocs\internet_wk_1.7\db\master_db_tracker.sql" kani

Upvotes: 1

Related Questions