Mysql : How to run batch of sql scripts from a folder

Question

I have a folder with o lot of sql scripts. I want to run all of them without specifying names of them. Just specify a folder name. Is it possible?

dev.mysql.com/doc/refman/5.0/en/batch-mode.html

Nagaraj S
– Nagaraj S

2013-12-27 10:12:20 +00:00
Commented Dec 27, 2013 at 10:12 — Nagaraj S
– Nagaraj S, Commented Dec 27, 2013 at 10:12

NobleUplift · Accepted Answer · 2023-02-23 23:29:39Z

16

You can not do that natively, but here's simple bash command:

for sql_file in `ls -d /path/to/directory/*`; do mysql -uUSER -pPASSWORD DATABASE < $sql_file ; done

here USER, PASSWORD and DATABASE are the corresponding credentials and /path/to/directory is full path to folder that contains your files.

If you want to filter, for example, only sql files, then:

for sql_file in `ls /path/to/directory/*.sql`; do mysql -uUSER -pPASSWORD DATABASE < $sql_file ; done

edited Feb 23, 2023 at 23:29

NobleUplift

6,0738 gold badges51 silver badges93 bronze badges

answered Dec 27, 2013 at 10:08

Alma Do

37.4k10 gold badges81 silver badges106 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

JayRizzo Over a year ago

Here is why ls might be bad as listed here stackoverflow.com/a/2152795/1896134 Please look at momer's comment. mywiki.wooledge.org/ParsingLs

NobleUplift Over a year ago

The ls command as it was previously written wasn't functional. It would list off the files in the directory but without the /path/to/ prefix, thus it wouldn't run anything.

eduardocurva · Accepted Answer · 2016-10-17 20:03:10Z

2

That was what worked for me: 1. Created a shell script in the folder of my scripts

for f in *.sql
  do
   echo "Processing $f file..."

   mysql -u user "-pPASSWORD" -h HOST DATABASE < $f

 done

answered Oct 17, 2016 at 20:03

eduardocurva

212 bronze badges

Collectives™ on Stack Overflow

Mysql : How to run batch of sql scripts from a folder

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related