List:MySQL on Win32« Previous MessageNext Message »
From:Jim Date:September 14 2007 7:19am
Subject:Re: List all databases from command line
View as plain text  
Thanks.  I figured out that I could also loop over subfolders in the MySQL 
data directory to give me each of the database names.


----- Original Message ----- 
From: "Bonnett, John" <John.Bonnett@stripped>
To: <jj@stripped>; <win32@stripped>
Sent: Friday, September 14, 2007 12:31 AM
Subject: RE: List all databases from command line


Something like

mysql -u root -p --execute="SHOW Databases" mysql

Should get you what you want. There may be some other options to give
you the output in a form and place that suits you.

John Bonnett

-----Original Message-----
From: Jim [mailto:jj@stripped]
Sent: Friday, 14 September 2007 3:38 PM
To: win32@stripped
Subject: List all databases from command line

We use a simple batch file for backups that does a mysqldump on each
database on our MySQL 5.0 server.  When we create a new database on the
server, though, we need to modify the batch file, which is easy to
forget.

Is there a way, using a command-line program, that I can get a list of
all databases on the server so that I can loop over the list and backup
each one?

Thread
List all databases from command lineJim14 Sep
  • RE: List all databases from command lineJohn Bonnett14 Sep
    • RE: List all databases from command lineScott C Harrison14 Sep
  • Re: List all databases from command lineJim14 Sep