-
Archives
- January 2012
- December 2011
- September 2011
- August 2011
- June 2011
- January 2011
- December 2010
- November 2010
- October 2010
- August 2010
- July 2010
- June 2010
- May 2010
- April 2010
- March 2010
- January 2010
- December 2009
- November 2009
- October 2009
- September 2009
- January 2009
- November 2008
- September 2008
- August 2008
- July 2008
- March 2008
- February 2008
- January 2008
-
Meta
Category Archives: Bash script
Removing outdated ssh fingerprints from known hosts
REMOTE HOST IDENTIFICATION HAS CHANGED! $ sed -i “46 d” ~/.ssh/known_hosts Removing outdated ssh fingerprints from known hosts
Extract particular table from a mysqldump file
$ awksqldump dbname.dump.sql tblname #!/bin/bash ### check parameter E_NO_ARGS=65 if [ $# -eq 2 ] then # Outputs string of specified table only awk “/Table structure for table .$2./,/UNLOCK TABLES/{print}” $1 > $1.EXTRACTED.sql elif [ $# -eq 3 ] then … Continue reading
Posted in Bash script, Database, Linux Administration, MySQL
Tagged awksqldump, bash
Leave a comment
SQL Show Log
#!/bin/bash # —————————————————- # # SQL Show Log version 1.0 # @author Raymond S. Usbal # @usage sqlshowlog # # —————————————————- ### check parameter E_NO_ARGS=65 if [ $# -eq 0 ] then echo “SQL Show Log version 1.0 Usage: sqlshowlog … Continue reading
Posted in Bash script
Leave a comment