List Databases from shell script - Linux, Apache, PHP, MySQL Administrators Forums

php_newbie · #1 (**permalink**) 03-18-2009, 11:43 AM

hello again guys

I need a little help with a bash script I am trying to make o backup our databases. What I need is to list all databases from my MySQL server and with that resulting list I can loop through and backup each database directory

.

I know its easy for the gurus, but I can login to mysql server from my script but its not listing properly to loop thru

TIA

swordfish · #2 (**permalink**) 03-18-2009, 01:56 PM

Code:

DBS=`echo "show databases;" | mysql -u root -pmypassword | tail -n +2`

I think this is what you need, $DBS will contain a list you can loop through and do you stuff.

HTH

php_newbie · #3 (**permalink**) 03-20-2009, 06:53 PM

as always, thanks swordfish

wcervini · #4 (**permalink**) 04-16-2009, 11:45 AM

Quote:

Originally Posted by swordfish

Code:

DBS=`echo "show databases;" | mysql -u root -pmypassword | tail -n +2`

I think this is what you need, $DBS will contain a list you can loop through and do you stuff.

HTH

Or use this one

Code:

DBS=`mysql -u root -pmypassword -e 'show databases' | tail -n +2`

swordfish · #5 (**permalink**) 04-16-2009, 12:02 PM

Quote:

Originally Posted by wcervini

Or use this one

Code:

DBS=`mysql -u root -pmypassword -e 'show databases' | tail -n +2`

Another neat way to do it wcervini

BTW, welcome aboard!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)