var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Does MySQL have a sysdatabases equiv?
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
Re: Does MySQL have a sysdatabases equiv?
Originally posted by jdierking
.. get a complete list of all my databases to then process from..
Does that work from PHP or from the command line?
Found the answer...
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.