Page 1 of 1

Searching a database via command prompt

Posted: Mon May 22, 2006 12:13 pm
by Luke
I need to do a sweeping search of an entire database for a particular word via the ssh command prompt... is that possible?

Managers

Posted: Fri May 26, 2006 7:31 pm
by tr0gd0rr
Ha ha, My manager asked me to do that last year.

The only thing I've ever heard to do it is phpmyadmin. You may be able to run that from lynx, i don't know.

You also might try

Code: Select all

grep -Hni 'SEARCH_STR'
but your database may not store char/varchar columns as text. :| hairy problem, that is!