[thelist] MySQL search everywhere?

Bob Meetin bobm at dottedi.biz
Sun Oct 18 16:57:57 CDT 2009


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:


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?


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

More information about the thelist mailing list