Thanks, much better.I appended '| mysql' to each line but I am not sure what you mean by 'then call it' I ran the batch file and tried using source batch.bat but no joy. What am I missing?
Thanks again -- Dave 2009/3/19 Gary Smith <g...@primeexalia.com> > Dir /b > Sent via BlackBerry by AT&T > > -----Original Message----- > From: David Scott <critt...@desktopcreatures.com> > > Date: Thu, 19 Mar 2009 11:16:03 > To: <g...@primeexalia.com> > Cc: <mysql@lists.mysql.com> > Subject: Re: Multiple batch files > > > 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 > > > > > >