dump mysql record into a txt file - under linux

step 1 : create a sql file wg.sql

SELECT signature FROM sig_db.signatures  ;

Step 2: create shell script file: wg.sh

mysql -N -u yourusername -pyourpassword sig_db < wg.sql > wg.rules

Step 3: run wg.sh
./wg.sh