extract table names from sql log file
1 2 grep "from " /var/log/mysql/mysqld.log | awk -Ffrom '{print $2}' | awk '{print $1}' | cat > /home/shantanu/testing.txt
DZone Snippets > shantanuo > grep
13463 users tagging and storing useful source code snippets
Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world
shantanu oak http://oksoft.blogspot.com
1 2 grep "from " /var/log/mysql/mysqld.log | awk -Ffrom '{print $2}' | awk '{print $1}' | cat > /home/shantanu/testing.txt
1 2 egrep "\w+([._-]\w)*@\w+([._-]\w)*\.\w{2,4}"