Community Forums
Connect with us on LinkedIn
+ Reply to Thread
Results 1 to 3 of 3
  1. #1
    Member
    Join Date
    Mar 2002
    Posts
    297

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

    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. #2
    Member
    Join Date
    Mar 2002
    Posts
    297

    Default

    come on this cant be that hard...


  3. #3
    Member dafut's Avatar
    Join Date
    Dec 2005
    Posts
    75

    Default

    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.

Similar Threads & Tags
Similar threads

  1. Success in database CONNECTION.....no TABLE created.
    By Scotty13 in forum Database Discussions
    Replies: 2
    Last Post: 01-19-2011, 08:21 AM
  2. Transferring a Database with an Innodb Table
    By rking in forum Database Discussions
    Replies: 3
    Last Post: 09-09-2010, 12:26 PM
  3. Transferring a Database with an Innodb Table
    By rking in forum cPanel and WHM Discussions
    Replies: 3
    Last Post: 09-09-2010, 12:26 PM
  4. how to dump a database using phpmyadmin
    By 10101 in forum cPanel and WHM Discussions
    Replies: 1
    Last Post: 06-17-2004, 08:18 AM
Linkedin       Facebook       Twitter       RSS       Flickr       YouTube