unix commands & unix scripts @ coolcommands.com - the search engine for unix sysadmins

LVOware PRATTICO Consulting

Tuesday May 21, 2013

Who's Online

Newest Member
nbewwmbxog

Hit Counter

11548242 Visitors

cool Statistics

Search coolcommands.com

	Submitted by: lvo
coolcommand how to do a mysqlimport from a text file delimited by a specific character
Description To do a mysqlimport using the default field seperator: # mysqlimport --user root --password --local dbname tablename.txt Note: dbname = name of your database tablename.txt = filename must be named the same as the name of your table. The extension of the filename is not important. To delete all records in table and set field seperator to ; character: # mysqlimport --user root --password -d --fields-terminated-by=";" --local dbname tablename.txt
Example mysqlimport --user root --password --local dbname tablename.txt

Random coolcommands

coolcommand: how to get network interface statistics in Linux
Example: cat /proc/net/dev
[show me the details]

coolcommand: how to match any three digits in ksh
Example: if [[ "$1" = {3}(d) ]];then echo Match; fi
[show me the details]

coolcommand: how to login to a Sybase database
Example: isql -U sa password
[show me the details]

coolcommand: how to use the loopmount in AIX v6 or AIX v7
Example: loopmount -i aixv7-base.iso -m /aix -o "-V cdrfs -o ro"
[show me the details]

coolcommands.com - the search engine for UNIX sysadmins :: unix commands and scripts