2009年11月
MySQL - Monitor & kill sleep processes
摘要： 1. Monitor:mysql -uroot -ppassword databaseName -e "show full processlist" | grep -v Sleepmysql -uroot -ppassword databaseName -e "show full processlist" | grep -v Sleep | sort -k6rn >sort.tmp //... 阅读全文
posted @ 2009-11-23 17:24 xxd 阅读(873) 评论(0) 推荐(0)
Oracle与SQL Server的数据库连接
摘要： Software:SQL Server 2005 (win 2003)Oracle 10gR2 (Redhat AS 4 update 2)1. isntall 10201_client_win32.zip under D:\oracleif the D: drive is NTFS you have to give ALL rights to the user2. listener.ora an... 阅读全文
posted @ 2009-11-23 16:38 xxd 阅读(812) 评论(0) 推荐(0)
Oracle数据导出到MySql
摘要： Oracle数据导出到MySql1. 使用默认的结束符号导入到MySql数据库中:LOAD DATA LOCAL INFILE 'd:\oracle.txt' IGNORE INTO TABLE alarmLog 此时Fields的结束符默认的就是'\t'制表符，而不是"\t"字符串.2. 当设定Fields结束符导入到MySql数据库中:LOAD DATA LOCAL INFILE 'd:\or... 阅读全文
posted @ 2009-11-23 16:37 xxd 阅读(4736) 评论(0) 推荐(0)