bash script to access multiple mysql databases

Question

I all,

I have a series of MYSQL databases with different users and passwords, nevertheless the DB structure is the same for all databases. I can't create a user with the same username and password to all of them and I need to quickly perform operations on all of them.

I was thinking about a bash script to run via cron.

Any suggestion? I was thinking to something like this but it is not working :(

#!/bin/bash
uconn=(
            'mysql -u user_db1         --password=pass_db1      db1      '
            'mysql -u user_db2         --password=pass_db2      db2      ' 

             )

for f in "${uconn[@]}"
do
    exec ${f}
    echo `mysql show tables`
    echo `mysql exit`
done
exit

Ansgar Wiechers · Accepted Answer · 2012-09-02 00:57:49Z

1

Why not use the documented way?

do
  ${f} <<EOF
show tables
\\q
EOF
done

answered Sep 2, 2012 at 0:57

Ansgar Wiechers

202k27 gold badges286 silver badges363 bronze badges

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

Comments

danfreak · Accepted Answer · 2012-09-02 08:55:03Z

0

Just pasting the full code taking into consideration @Ansgar Wiechers:

#!/bin/bash
uconn=(
            'mysql -u user_db1 --password=pass_db1  db1'
            'mysql -u user_db2 --password=pass_db2  db2' 

             )

for f in "${uconn[@]}"
    do
      ${f} <<EOF
    show tables
    \\q
    EOF
    done
exit

To execute the code from the local machine to the remote one this works for me:

ssh [email protected] 'bash -s' < /local/path/to/multiple_db_connections.sh

where the content of multiple_db_connections.sh is the code above

answered Sep 2, 2012 at 8:55

danfreak

4151 gold badge8 silver badges16 bronze badges

Collectives™ on Stack Overflow

bash script to access multiple mysql databases

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related