View Single Post
  #5  
Old 11-12-2010, 05:47 AM
WarDave522
Fire Beetle
 
Join Date: Aug 2010
Posts: 5
Default

Ok so I tried to find something that would let me source in all sql files in one folder and someone pointed me to this

http://stackoverflow.com/questions/2...in-mysql-batch

But on my windows machine it doesnt work for some reason

I tried

for %S in (*.sql) do mysql -u user_name database_name < %S

and

mysql -u user_name -p password database_name < file.sql

with the correct info in the username, and db and all of that


What I'm trying to do is have mysql souce in all the sql files with one command so I don't have to do it 139 times from the svn folder. Also yes I changed over to the correct folder in a dos box before trying this and did,

mysql -u root -p
(did password)
use peq;

then tried those lines
Reply With Quote