[thelist] MySQL search everywhere?

[Bob Meetin]

Stephen,

If this is MySQL then you should be able to dump the database, then, 
worse comes to worse, using your favorite editor such as 'vi', visually 
inspect it. 

As a shell script:

-----------------------------------------------------
#!/bin/sh

u="username"
p="password"
db="database"
mysqldump -hlocalhost -u$u -p$p --all-databases > alldatabases.sql
mysqldump -hlocalhost -u$u -p$p $db > database.sql

-----------------------------------------------------

You could do something similar by making up a for loop of database 
tables that look promising.  Will this help?

-Bob

Stephen Rider wrote:
> On Oct 15, 2009, at 9:53 AM, r937 wrote:
>
>   
>> "the real WTF" is this whole idea of searching every
>> column in every table
>>     
>
> Short version:  Site built by another developer.  I'm trying to get a  
> handle on how he put it together by identifying where certain things  
> are located in a database with *lots* of tables and lots of fields in  
> each table.  It appears his page templates are all in the database  
> somewhere instead of being PHP files....
>
> Thanks for the info.
>
> Stephen
>