Database GUI Admin Tool
MySQL Admin, Import/Export Data, Query Builder, Report. Download Now
www.navicat.com
http://www.navicat.com/download.php3


Free MySQL Account
Free MySQL database web hosting Create your free MySQL db in sec
BizHostNet.com
http://free-mysql.bizhostnet.com
- posted by Chihchiang @ 1:14 AM

 
processlist
Show list of active threads in server, as with the SHOW PROCESSLIST statement. If the --verbose option is given, the output is like that of SHOW FULL PROCESSLIST.

I think this will be "shell> mysqladmin --verbose processlist

This is another example:
shell> mysqladmin proc stat
----------------------------------------------

Kill mysql threads.
shell> mysqladmin kill id,id,...
----------------------------------------------

If you do mysqladmin shutdown on a socket (in other words, on a the computer where mysqld is running), mysqladmin will wait until the MySQL pid-file is removed to ensure that the mysqld server has stopped properly.


- posted by Chihchiang @ 3:58 AM

 
Q: Can we run the script in mySQL.
A:

Yes, you can run a script from the MySQL command
line by typing "\. script_Name"

For gzipped files:
gunzip -c file.gz | mysql database


To run two sql scripts at a time you can use cat command available in Linux.
cat file1.sql file2.sql | mysql -u USERNAME -p
- posted by Chihchiang @ 2:57 AM