Easy way to dump the table names from every database in every account ?

[Silver_2000]

Im looking to update backupscripts and Im sure there is an easy way to dump out just the table names

Would love to see a text file that shows
Account1
----- Database1
----------Table1
----------Table2
------Database2
----------Table1
Account2

Etc etc

Any sql gurus want to help ??

Thanks in advance
Doug

 

[Silver_2000]

come on this cant be that hard...

:D

 

[dafut]

Can't you log into mysql as root and run "show databases;"? (do this through SSH)

That will give you a list of all of the DB's on the server; you'll have to parse out by account, but that's pretty easy given the naming convention.