snippetsqlMajor
How to search whole MySQL database for a particular string
Viewed 0 times
searchwholedatabasemysqlforhowparticularstring
Problem
is it possible to search a whole database tables ( row and column) to find out a particular string.
I am having a Database named A with about 35 tables,i need to search for the string named "hello" and i dont know on which table this string is saved.Is it possible?
Using MySQL
i am a linux admin and i am not familiar with databases,it would be really helpful if u can explain the query also.
I am having a Database named A with about 35 tables,i need to search for the string named "hello" and i dont know on which table this string is saved.Is it possible?
Using MySQL
i am a linux admin and i am not familiar with databases,it would be really helpful if u can explain the query also.
Solution
$ mysqldump -pPASSWORD database --extended=FALSE | grep pattern | less -SMore: http://winashwin.wordpress.com/2012/08/28/mysql-search/
Code Snippets
$ mysqldump -pPASSWORD database --extended=FALSE | grep pattern | less -SContext
StackExchange Database Administrators Q#34856, answer score: 28
Revisions (0)
No revisions yet.