Hi David,
Why not use a FOR loop in a batch file?
This post seems to be doing the same thing, using MS SQL Server:
http://bytes.com/topic/windows/answers/647680-xp-batch-file-loop-help
Andy
David Scott wrote:
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 <[email protected]>
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 <[email protected]>
Date: Thu, 19 Mar 2009 11:08:28
To: <[email protected]>
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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[email protected]
