Command Line And Friends

February 24, 2011 Posted in: Side Notes by mikhail

Import Multiple SQL Files Into Database

So we have multiple files exported from db. In fact we have so many it will take a day to inport them one by one. If on Windows, you probably have nifty tool that will let you drag and drop them into db. I could not find one for linux or Mac, so command line to rescue: cat *.sql | mysql -u USERNAME -pPASSWORD DATABASENAME To be continued...
 

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>