Import multiple db files from folder into mysql db

Hello friends,

Welcome back

In the previous article, we've seen how to export database by table files, not the entire db file. Now in this article, here we're going to see the sample code for importing multiple sql files into same db.

This also has been achieved by using a simple shell script. In this script, applied a for loop on list of files in a directory and by using that file name, mysql's import command is executed. The code is simple, you'll learn in just few minutes.

Linux shell script:

Execute above code in linux terminal to import all files into the given db.

Hope this would help you.

Thanks.