Re: List all databases from command line

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@vision.zeiss.com> To: <jj@zolx.com>; <win32@lists.mysql.com> 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@zolx.com]
Sent: Friday, 14 September 2007 3:38 PM
To: win32@lists.mysql.com
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?

-- 
MySQL Windows Mailing List
For list archives: 
http://lists.mysql.com/win32
To unsubscribe:    
http://lists.mysql.com/win32?unsub=lists@pantek.com

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related lists.mysql.com Links announce benchmarks bugs certification cluster commits dotnet gui-tools internals java maxdb myodbc mysql mysqldoc packagers perl plusplus replication win32 Request more information about Pantek