The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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

Discussion in 'General Discussion' started by Silver_2000, Jan 1, 2007.

  1. Silver_2000

    Silver_2000 Well-Known Member

    Joined:
    Mar 31, 2002
    Messages:
    338
    Likes Received:
    1
    Trophy Points:
    18
    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
     
  2. Silver_2000

    Silver_2000 Well-Known Member

    Joined:
    Mar 31, 2002
    Messages:
    338
    Likes Received:
    1
    Trophy Points:
    18
    come on this cant be that hard...

    :D
     
  3. dafut

    dafut Well-Known Member

    Joined:
    Dec 14, 2005
    Messages:
    75
    Likes Received:
    0
    Trophy Points:
    6
    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.
     
Loading...

Share This Page