I am trying to write a PHP Utility to backup MySQL databases.

I have a working app, however the downside is that I need to either manually create a list of dbs to backup or I need to keep a seperate database of all databases.

MSSQL hase a sysdatabases table in the master database.

It would be nice to do something like:

select name from sysdatabases
order by name

and get a complete list of all my databases to then process from.

Thanks in advance

Matt.

Does that work from PHP or from the command line?

Not sure how it is achieved on the db side, but PHP has a function "mysql_list_dbs" that returns all dbs on the server.