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, May 11, 2010
Tuesday, March 2, 2010
Showing IP addresses and physical MAC addresses connected to active network interface
DOS utility ( Address Resolution Protocol ):
arp -a
arp -a
Thursday, February 4, 2010
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
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
Subscribe to:
Posts (Atom)