I have a bunch of .sql files in a directory that I need to import. Although I can do it manually, for scripting purposes I need to be able to apply them in bulk. How can I do that though? What combination of options and commands do I need?
The mysqlimport command goes like this:
mysqlimport [options] db_name textfile1 [textfile2 ...]
I need to be able to add all the text files to the end. I would prefer a command than a convoluted for loop if possible.