Thanks for responding Gary I get: ----------------------------------- Volume in drive D has no label. Volume Serial Number is C45F-3341
Directory of D:\data\03\09 03/19/2009 05:45 PM 389,305 sessions-20090309-00.sql 03/19/2009 05:45 PM 402,264 sessions-20090309-01. sql 03/19/2009 05:45 PM 417,579 sessions-20090309-02. sql 03/19/2009 05:45 PM 402,084 sessions-20090309-03. sql <etc> 220 File(s) 50,149,425 bytes 0 Dir(s) 116,891,242,496 bytes free ----------------------------------- How should I edit this? -- Dave 2009/3/19 Gary Smith <g...@primeexalia.com> > Dir *.sql > my.bat > > Edit batch file for each line to append "| mysql" > > Call batch file > > > Sent via BlackBerry by AT&T > > -----Original Message----- > From: David Scott <critt...@desktopcreatures.com> > > Date: Thu, 19 Mar 2009 11:08:28 > To: <mysql@lists.mysql.com> > Subject: Multiple batch files > > > HeyaI have folders of sql files which, when there were a few, I executed > using "source d:\folder\file.sql"I now I have 100's, so is there a way to > do > "source d:\folder\*.sql" (which sadly does not work) ? > How would you go about automating this? > > The DB is running on a windows box. > > Thanks for any suggestions you may have. > -- > David Scott > >
