If you’re looking for a specific value:
awk '$2==1 {print $3}' file
If you’re looking for a string, you have to use quotes otherwise awk will assume it’s a variable name:
awk '$1 == "findtext" {print $3}' file
MySQL: database backup, compression and restore
The easier and quicker way to backup a database is using mysqldump command.
The syntax is as follows:
backup:
mysqldump –u [uname] –p [pass] [dbname] > [backupfile.sql]
restore:
mysql –u [uname] –p [pass] [dbname] < [backupfile.sql]