PerlÖÐDBI¡¢DBD::mysqlÄ£¿éµÄ°²×°
PerlÖÐDBI¡¢DBD::mysqlÄ£¿éµÄ°²×°
ʹÓõÄÈí¼þ°æ±¾
DBI-1.604.tar.gz
DBD-mysql-4.006.tar.gz
½¨ÒéʹÓÃÒÔÉϰ汾´îÅ䣬·ñÔò¿ÉÄÜÁ¬½Ómysql´íÎó
Ò»¡¢DBIµÄ°²×°
wget http://www.cpan.org/modules/by-module/DBD/DBI-1.604.tar.gz
tar -zxvf DBI-1.604.tar.gz
cd DBI-1.604
perl Makefile.PL
make
make test
make install
¶þ¡¢DBDµÄ°²×°
×¢ÒâmysqlµÄ»·¾³±äÁ¿£¬ÈôûÓÐÔòÓà Ìí¼Ó/usr/local/mysql/binµ½»·¾³±äÁ¿PATHÖÐ
PATH=/usr/local/mysql/bin:$PATH;
export PATH (mysqlµÄ°²×°Â·¾¶¸ù¾Ýʵ¼ÊÇé¿öÌîд)
wget http://www.cpan.org/modules/by-module/DBD/DBD-mysql-4.006.tar.gz
tar -zxvf DBD-mysql-4.006.tar.gz
cd DBD-mysql-4.006
perl Makefile.PL --mysql_config=/usr/local/mysql/bin/mysql_config
make
make test
make install
Èý¡¢ÆäËü¿ÉÄÜ·¢ÉúµÄ×´¿ö
Èç¹ûÔËÐÐij¸öµ÷ÓÃMYSQLÊý¾Ý¿âµÄ³ÌÐòʱ³öÏÖÈçÏÂϵͳÌáʾ£º
install_driver(mysql) failed: Can't load '/usr/lib/perl5/site_perl/5.6.1/i386-linux/auto/DBD/mysql/mysql.so' for module DBD::mysql: /usr/lib/perl5/site_perl/5.6.1/i386-linux/auto/DBD/mysql/mysql.so: undefined symbol: uncompress at /usr/lib/perl5/5.6.1/i386-linux/DynaLoader.pm line 206. at (eval 2) line 3
ÄÇô˵Ã÷DBD::MYSQLδ°²×°³É¹¦¡£
´Ëʱ½«/usr/local/mysql/include/mysql/*
¸´ÖƵ½/usr/include/
ͬʱ½«/usr/local/mysql/lib/mysql/*
¸´ÖƵ½/usr/lib/(64λϵͳ/usr/lib64/)
È»ºóʹÓÃperl Makefile.PLÉèÖû·¾³£¬ÔÙ½øÐкóÐøµÄÕý³£°²×°£¬¾ÍÄÜÕýÈ·Á¬½Óµ½MYSQLÊý¾Ý¿â¡£
Ïà¹ØÎĵµ£º
Ë÷Òý
¡¡¡¡Ë÷ÒýÓÃÀ´¿ìËÙµØÑ°ÕÒÄÇЩ¾ßÓÐÌØ¶¨ÖµµÄ¼Ç¼£¬ËùÓÐMySQLË÷Òý¶¼ÒÔB-Ê÷µÄÐÎʽ±£´æ¡£Èç¹ûûÓÐË÷Òý£¬Ö´ÐвéѯʱMySQL±ØÐë´ÓµÚÒ»¸ö¼Ç¼¿ªÊ¼É¨ÃèÕû¸ö±íµÄËùÓмǼ£¬Ö±ÖÁÕÒµ½·ûºÏÒªÇóµÄ¼Ç¼¡£±íÀïÃæµÄ¼Ç¼ÊýÁ¿Ô½¶à£¬Õâ¸ö²Ù×÷µÄ´ú¼Û¾ÍÔ½¸ß¡£Èç¹û×÷ΪËÑË÷Ìõ¼þµÄÁÐÉÏÒѾ´´½¨ÁËË÷Òý£¬MySQLÎÞÐèɨÃèÈκμǼ¼´¿ÉѸËٵõ½Ä¿±ê¼Ç ......
µ¼³ö.sqlÎļþ
1.½«Êý¾Ý¿âtransfer_server_dbµ¼³öµ½transfSRV.sqlÎļþÖУº
mysqldump -u root -p transfer_server_db > /home/eric/transfSRV.sql
2.½«Êý¾Ý¿âtransfer_server_dbÖеÄdevice_info_tableµ¼³öµ½table.sqlÎļþÖУº
mysqldump -u root -p transfer_server_db device_info_table > /home/eric/ta ......
JavaÁ¬½ÓmysqlÊý¾Ý¿â£¬´úÂë¾¹ýÔËÐÐ׼ȷÎÞÎó¡£
ÏÂÃæÎªÊµÀý---->
ÓÃÊý¾Ý¿â²Ù×ݹ¤¾ß£¨Àý£ºSQLyogEnt£©²Ù×Ýmysql½¨±í£¬»òdosϽ¨£¬ÈçÏ£º
Êý¾Ý¿âÃû£ºscutcs
±íÃû£ºstudent
±íÄÚÈÝ£º
sno char[7] NO NULL Primary Key;
sname varchar[8] NO NULL;
sex char[2] NO NULL; ......
Accessing Distributed Data with the Federated Storage Engine
http://dev.mysql.com/tech-resources/articles/mysql-federated-storage.html
Federated´æ´¢ÒýÇæ¿ÉÒÔʹ¼¸Ì¨Êý¾Ý¿âÂß¼ÉÏ×é³ÉÒ»¸öÊý¾Ý¿â£¬Æä×÷ÓÃÏ൱ÓÚOracleµÄÊý¾Ý¿âÁ´½Ó£¬Í¨Ë×µØËµ£¬¼´ÔÚ±¾µØ½¨Á¢Ô¶³ÌµÄÊý¾Ý¿â±íµÄÒýÓá£
MysqlÐèÒª5.0ÒÔÉÏ
£¨1£©²é¿´ÊÇ ......
½üÀ´¶Ôphp±È½Ï¸ÐÐËȤ£¬¾Í¶Ï¶ÏÐøÐøµÄ»¨ÁËÁ½¸öÐÇÆÚµÄʱ¼ä°ÑÕû¸öphp¿ª·¢ÐèÒªÓõ½µÄ¶«Î÷¶¼×°ºÃÁË£¬´ó¸ÅµÄ°²×°¹ý³ÌÈçÏ¡£
Ò»¡¢°²×°µÄÈí¼þ:
Apache: 2.2.14
PHP:5.2.12
MySQL:5.1.42¡£
SVN:1.5.6
PHPMyAdmin:3.2.5
Zend Studio: 7.1
Zend Debugger: 5.1.14
¶þ¡¢°²×°¹ý³Ì£º
1. °²×°ºÍÅäÖÃapache
°²×°£ºÊ×ÏÈ´Óhttp://apa ......