sqlwatch <test.sql 2>&1|grep ERROR

sqlwatch <test.sql 2>&1|grep dbtablename

yum install cmake

yum install perl

yum install perl-DBD*

yum install libaio.so.1

yum install *CPAN*

yum install *libaio*

yum install *Curses*

yum install ncurses-devel

yum install ksh

useradd -m -d /home/mysql -u 202 -g dba mysql

mkdir -p /data0/mysql2/dbdata

cmake -DCMAKE_INSTALL_PREFIX=/data0/mysql/ -DMYSQL_DATADIR=/data0/mysql2/dbdata -DMYSQL_UNIX_ADDR=/data0/mysql2/dbdata/mysql.sock -DSYSCONFDIR=/data0/mysql2/dbdata/config -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DEXTRA_CHARSETS=all -DWITH_DEBUG=0 -DENABLED_LOCAL_INFILE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_PARTITION_STORAGE_ENGINE=1

   mv mysqld sqlwatch