View Single Post

  #4 (permalink)  
Old 03-29-2008
Ana C. Dent
 
Posts: n/a
Default Re: mysql -u root -p db < script1.sql script2.sql

gert <gert.cuykens@gmail.com> wrote in news:22bb1196-397b-4a79-9ca4-
2b8d8146a2f1@z38g2000hsc.googlegroups.com:

> is it possible to run multiple sql script files at once ?
>
> mysql -u root -p db < script1.sql script2.sql


put all the file names into a master-file.dat file

for file in `cat master-file.dat`
do
mysql -u root -p db < ${file}
done

cat master-file.dat
script1.sql
script2.sql
script3.sql
script4.sql

Reply With Quote