I think I've puzzled out most of the details, thanks for pointing me towards the relevant commands. The one thing I haven’t been able to get working yet is the use of a wildcard for the source command? In a windows environment (my testbed) I dropped a copy of the backup folder created by this mod at the root of c:\ I connected and logged into the mysql utility with my target database active.
Then I tried:
source c:\2006-12-19\%.sql
but that threw an error.
I tried:
source c:\2006-12-19\*.sql
just for the heck of it but that threw an error as expected too.
IS there a way to feed in multiple files? Doing it individually works but that’s a LOT of files to run though. O.o
I’m quite sure I’m missing something very basic here, but it’s the dead bone simple things that are the hardest to figure out as none of the references mention them ;-). I really appreciate the help… I’m TRYING to get a handle on the command line vs GUI as I need to move in that direction to effectively work in Linux (my production server) but I’m not quite there yet.
|