Eeek. That's old =). Don't know if there's any SQL for that. Maybe you can either: 1. Make a perl/ruby/whatever script that calls show databases, then loops around the result to call show tables. 2. Make a perl/ruby/whatever script that goes through the contents of the mysql datadir. Each folder is one database. In Mysql 5 an empty database only has a db.opt file.
On Wed, Sep 22, 2010 at 2:48 PM, Allen Umlas <[email protected]> wrote: > Hi Johann, > > Im using old version of mysql Distrib 3.23.53 which this command is > not available. > > I tried another mysql which running version 5 and its working at that > version. > > Allen > > --- On *Wed, 9/22/10, Johann Vincent Paul Tagle <[email protected]>*wrote: > > > From: Johann Vincent Paul Tagle <[email protected]> > Subject: Re: [plug] how to check if databases has existing tables > To: "Philippine Linux Users' Group (PLUG) Technical Discussion List" < > [email protected]> > Date: Wednesday, September 22, 2010, 2:37 PM > > > I don't have the time to write the exact SQL right now, but use the > information_schema database/schema. Join the SCHEMATA table (which lists > all databases) and the TABLES table (which lists tables in the database), > just exclude the mysql and information_schema databases. > > On Wed, Sep 22, 2010 at 2:28 PM, Allen Umlas > <[email protected]<http://mc/[email protected]> > > wrote: > > > > Hi guys, > > I have shared web hosting using mysql database. I was referring > multiple databases. It will take time for me to use such common command like > > use <database>; > then > show <tables>; to verify if there's existing tables. > > I try to use this command > > select User,Db from mysql.db; > > to check the all databases but still i cannot get what i want > > How can i get information for the database with existing tables and those > database without tables? > > > > > > _________________________________________________ > Philippine Linux Users' Group (PLUG) Mailing List > http://lists.linux.org.ph/mailman/listinfo/plug > Searchable Archives: http://archives.free.net.ph > > > > -----Inline Attachment Follows----- > > > _________________________________________________ > Philippine Linux Users' Group (PLUG) Mailing List > http://lists.linux.org.ph/mailman/listinfo/plug > Searchable Archives: http://archives.free.net.ph > > > > _________________________________________________ > Philippine Linux Users' Group (PLUG) Mailing List > http://lists.linux.org.ph/mailman/listinfo/plug > Searchable Archives: http://archives.free.net.ph >
_________________________________________________ Philippine Linux Users' Group (PLUG) Mailing List http://lists.linux.org.ph/mailman/listinfo/plug Searchable Archives: http://archives.free.net.ph
