一般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
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/