Thanks... I'm kind of surprised that there isn't wildcard functionality, you'd think it would make things a lot easier. ::shrug:: I did a quick
copy *.sql 2006-12-19.sql
And then
source c:\2006-12-19\2006-12-19.sql
And it seemed to restore fine. Thanks for the help... I thought it might be useful to post the specifics back in case any other non-linux fossils like myself come looking for an answer in the future ;-).
I assume there's a comparable command in linux to concatenate the files into a single .sql so that you can restore from a backup without going through (in the case of my particular DB) 182 source commands?
Adding a backup to single file option might be helpful, though I can see how having each table individually would be useful too...
Anyway, thx for the help!
|