Tuesday, May 11, 2010

Executing SQL statements from a text file

From mysql console
mysql>source [file_path]

From command line:
shell>mysql -u [user_name] -p[password] -h [host] -- verbose <  [file_path]
notes:
"--verbose" is required to display the sql statements before it is executed
make sure to add "use [database_name]" statement in the script file

Reference:
http://dev.mysql.com/doc/refman/5.0/en/batch-commands.html
 

Tuesday, January 5, 2010

linux startup commands

To run commands automatically on starting Linux machine ( Redhat build ), add the commands to /etc/rc.d/rc.local

Friday, September 25, 2009

Thursday, September 24, 2009

Fixing Aventail VPN software failure to connect

Aventail VPN frequently fails to connect to vpn network after starting and stopping couple of time.
The only solution was to restart the computer.

in order to fix that try the following commands in DOS session:
ipconfig /release
ipconfig /renew

Other solution ( not verified )
The solution is to restart the "Network Location Awareness (NLA)" and "Aventail" services

You can save run the following commands in a batch file and run it:
net STOP Nla
net START Nla
net STOP NgVpnMgr
net START NgVpnMgr
ipconfig /release
ipconfig /renew