Reference: http://code.taobao.org/p/orzdba/src/
http://code.taobao.org/p/myrelay/wiki/index/
Http://www.taobaodba.com/html/937_orzdba.html
Download Source code:
[[Email protected] paul]# SVN co http://code.taobao.org/svn/orzdba/trunk
A trunk/orzdba_rt_depend_perl_module.tar.gz
A TRUNK/ORZDBA
A TRUNK/ORZDBA tool instructions for use. pdf
Remove version 4.
[Email protected] paul]#
Tool use:
[Email protected] trunk]#./orzdba-l
.=================================================.
| Welcome to use the ORZDBA tool! |
| Yep ... Chinese english~ |
' =============== date:2013-07-15 =============== '
Host:yz-db ip:127.0.0.1
-–load-avg--
1m 5m 15m |
0.00 0.00 0.00|
0.00 0.00 0.00|
0.00 0.00 0.00|
[Email protected] trunk]#./orzdba-com
.=================================================.
| Welcome to use the ORZDBA tool! |
| Yep ... Chinese english~ |
' =============== date:2013-07-15 =============== '
Host:yz-db ip:127.0.0.1
ERROR 1045 (28000): Access denied for user ' root ' @ ' localhost ' (using Password:no)
Db:
Var:error 1045 (28000): Access denied for user ' root ' @ ' localhost ' (using Password:no)
ERROR 1045 (28000): Access denied for user ' root ' @ ' localhost ' (using Password:no)
Can ' t close! At./ORZDBA Line 516.
[Email protected] trunk]#
Solve:
If MySQL sets a password, it cannot run. 160 Lines plus-ppassword
My $MYSQL = Qq{mysql-s–skip-column-names-uroot-ppassword-p$port};
Reference:
http://www.techsiteanalytics.com/index.php/2014/01/07/7105
Installation and use of ORZDBA