mysqlreport 安装

一般linux安装的时候默认安装了perl。

perl -v 验证下

1.安装mysql

3.DBI安装

到http://search.cpan.org/查找相应的包

#tar zxf DBI-1.58.tar.gz
#cd DBI-1.58
#perl Makefile.pl 
#make 
#make test 
#make 
#make install

4.data-showtable包

到http://search.cpan.org/查找相应的包

tar xvf  Data-ShowTable.tar.gz 

cd Data-ShowTable-?.?? 
perl Makefile.PL 
make 



make test


make install

5.msql-mysql-modules

上http://search.cpan.org/找

tar zxvf Msql-Mysql-modules-.tar.gz 

cd Msql-Mysql-modules-?.?? 
perl Makefile.PL 

make 
make test 
make install 

6.DBD-mysql
安装DBD: DBD-mysql-4.005

#perl Makefile.PL --mysql_config=/usr/local/mysql/bin/mysql_config --with-mysql=/usr/local/mysql --testuser=root
#make 
#make test 
#make 
#make install

7.mysqlreport 安装

tar zxvf mysqlreport.tar.gz

执行 ./mysqlreport

如果报错

install_driver(mysql) failed: Can't load '/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBD/mysql/mysql.so' for

module DBD::mysql: libmysqlclient.so.12: cannot open shared object file: No such file or directory at

/usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm line 230.
at (eval 6) line 3
Compilation failed in require at (eval 6) line 3.
Perhaps a required shared library or dll isn't installed where expected
at /root/mysqlreport line 162

则将mysql

cp /usr/local/mysql/lib/mysql/libmysqlclient.so.15 /usr/lib/