mysql question

ripper · 07-30-2012, 10:14 AM

in multiple databases how can i extract only the emails from all?

Code:

mysqldump -u root -p --all-database | egrep -i "\b[A-Z0-9._%+-]+@[A-Z0-9.-]+\.[A-Z]{2,4}\b" >> all.txt

i saw something like this but it didnt worked
thanks

Kustom42 · 07-30-2012, 11:43 AM

If you know what tables the emails are in you can just dump those and make your own grep statement. Its hard for us to give you some help as we don't know your table structure, data structure, etc..

chrism01 · 07-30-2012, 10:49 PM

Indeed; use SQL statements, not mysqldump.