Searching For Modules In a DB

I have a database called 'gaming' and with in that database there are
several tables and data. I was asked to find a module called 'ako
ldap' and disable it (setting it from 1 to 0). My question is how in
MySQL do I search for a string if I don't even know what table to
search in? I know how to search using the 'select' statement as long
as I know where the table data is. In this case I only know which
database but nothing more except what I am looking for.

Can anyone please point me in the right direction?

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Searching For Modules In a DB

--000e0cd174ee4c7998048d9933bd
Content-Type: text/plain; charset=ISO-8859-1

Recently I went through a link related to this question. check the below
link.
I haven't checked the script, hope it will be useful.

http://tequilaphp.wordpress.com/2010/07/05/searching-strings -in-a-database-and-files/

Regards,
Jay
MySQL DBA

On Thu, Aug 12, 2010 at 2:31 AM, Carlos Mennens wrote:

> I have a database called 'gaming' and with in that database there are
> several tables and data. I was asked to find a module called 'ako
> ldap' and disable it (setting it from 1 to 0). My question is how in
> MySQL do I search for a string if I don't even know what table to
> search in? I know how to search using the 'select' statement as long
> as I know where the table data is. In this case I only know which
> database but nothing more except what I am looking for.
>
> Can anyone please point me in the right direction?
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=jbharathj@gmail.com
>
>

--000e0cd174ee4c7998048d9933bd--

Re: Searching For Modules In a DB

Carlos Mennens schrieb:
> I have a database called 'gaming' and with in that database there are
> several tables and data. I was asked to find a module called 'ako
> ldap' and disable it (setting it from 1 to 0). My question is how in
> MySQL do I search for a string if I don't even know what table to
> search in? I know how to search using the 'select' statement as long
> as I know where the table data is. In this case I only know which
> database but nothing more except what I am looking for.
>
> Can anyone please point me in the right direction?
>


hi Carlos,

put your tables in one file each (dont remember the option)
then you can do

grep -l "string" /*

every file where "string" is in will be shown.

re,
wh

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org