windows°²×°apache+php+mysqlµÄһЩ¼Ç¼
apache°²×°£¬mysql°²×°£¬php5Ö±½Ó½âѹ£¬¾ù·ÅÔÚD:\wwwÏ¡£
Ŀ¼½á¹¹Îª£º
D:\www\apache2
D:\www\mysql
D:\www\php5
½«php5\php.ini-dist¸´ÖÆÎªphp.ini£¬°ÑÐèÒªÓõ½µÄ×é¼þ½«Ç°ÃæµÄ;È¥µô¡£
Èç
extension=php_mysql.dll
extension=php_gd2.dll
ÔÚapache2µÄconf/httpd.confÎļþÖмÓ
LoadFile D:/www/php5/php5ts.dll
LoadFile D:/www/php5/libmysql.dll
LoadModule php5_module D:/www/php5/php5apache2_2.dll
AddType application/x-httpd-php .php
PHPIniDir "D:/www/php5"
Íê³ÉÁË! ÎÞÐè¸´ÖÆÈκÎÎļþµ½C:\windowsÏ£¬ºÇºÇ!
¼´Ê¹ÏµÍ³ÖØ×°£¬ÅäÖÃÒ²¶¼»áÔÚŶ£º)
Èç¹û·þÎñÆ÷֨װ£¬¾ÍÖ»ÐèÒªÖØ×°ÏÂapache2ºÍmysqlµ½ÔĿ¼£¬µ±È»ÔĿ¼ҲҪÏȱ¸·ÝÒ»ÏÂÒÔÈ·±£°²È«¡£
ÒÔÏÂÊÇÎÒ¶Ôapache2µÄһЩÉèÖ㬼ǼһÏ¡£
<IfModule mpm_winnt.c>
ThreadsPerChild 150
MaxRequestsPerChild 10000
Win32DisableAcceptEx
</IfModule>
# Virtual hosts
Include conf/extra/httpd-vhosts.conf
ÎÒ°ÑÐéÄâÖ÷»úµÈÅäÖÃÄÚÈݶ¼·ÅÔÚextra/httpd-vhosts.confϵģ¬ËùÒÔÕâÑùÉèÖá£
apache2µÄÏêϸÅäÖÃÇë²Î¼ûÎĵµ£ºhttp://www.itlearner.com/code/apache2.2/
php.ini(php5.2)µÄÏêϸÅäÖãºhttp://www.itlearner.com/article/2009/4316.shtml
Ïà¹ØÎĵµ£º
PBÁ¬½ÓMySQLÊý¾Ý¿â
È¥mysqlµÄ¹Ù·½ÍøÕ¾ÏÂÔØodbc connector(http://dev.mysql.com/downloads/connector/odbc/)
ÏÂÔØµÄÊÇmysql-connector-odbc-noinstall-5.1.6-win32.zip
½âѹºóÖ±½ÓÔËÐÐÎļþ¼ÐÖÐµÄ Install.bat Åú´¦ÀíÎļþ
mysql-connectorÓкü¸ÖÖ£¬Ñ¡ÔñÒ»¸ö×Ô¼ºÏ²»¶µÄ¼´¿É¡£
ÔÚxpÖдò¿ªODBCÊý¾ÝÔ´¹ÜÀíÆ÷£¨¿ØÖ ......
¸Õ¿ªÊ¼²Ù×÷Êý¾Ý¿âʱÎÒÒ»°ãÊDz»Ê¹ÓÃʲôgui¹¤¾ßµÄ£¬ÎÒÊÇÖ±½ÓʹÓÃcmdϲÙ×÷µÄ£¬¸Ð¾õÓÃÆðÀ´Ò²Í¦²»´íµÄ¡£
×î½ü¿´µ½ÓÐgui¹¤¾ßÄÇÒ²²»´í°¡£¬¾ÍÏÂÀ´Ê¹ÓÃһϣ¬ÎÒϲ»¶ÏµÄÊÇѹËõ°üÃâ°²×°µÄ£¬ÕâÑù¸Ð¾õ±È½ÏÊæ·þ°¡
´ò¿ª²éѯ¹¤¾ßÊǾ¹È»³ö´íÁË£¬²»¹ýÄÜÕý³£Ê¹Óõ쬵±Ê±Ò²Ã»ÓÐ×¢Ò⣬½ñÌìÌØÒâµÄ¿´ÁËÒ»ÏÂ
Ó¦¸ÃÊÇmysqlqb_functions.xml¼ÓÔØ ......
×î½üÐèҪʹÓÃMySQL£¬Ö»ºÃ¸Ï½ôѧϰһÏ¡£ÄÄÀïÖªµÀµÚÒ»²½¾Í¿¨×¡ÁË¡£×°ÁËÒ»¸ö¿Í»§¶Ë£¬Á¬²»ÉÏ£¬±¨1045µÄ´íÎó¡£
´ÓÍøÉÏÕÒÁËһϣ¬Èý²½¾ÍºÃ¡£
INSERT INTO `user` VALUES ('%','root','*196BDEDE2AE4F84CA44C47D54D78478C7E2BD7B7','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y',' ......
[Ô´´] MySQLÊý¾Ý¿â´æ´¢ÒýÇæºÍ·ÖÖ§ÏÖ×´
ÔÚMySQL¾ÀúÁË2008ÄêSunµÄÊÕ¹ººÍ2009ÄêOracleÊÕ¹ºSunµÄ¹ý³ÌÖУ¬»ù±¾´¦ÓÚÍ£ÖÍ·¢Õ¹µÄÇé¿ö£¬ÔÚ¿ÉÒÔÔ¤¼ûµÄδÀ´£¬MySQLÊǿ϶¨»á±»Oracle¸éÖò¢ÇÒÖð²½Ñ©²ØÏûÃðµôµÄ¡£MySQLËæ×ÅÏàÓ¦µÄ¸÷Ö÷´´ºÍÄÚ²¿¿ª·¢ÈËÔ±µÄÀëÈ¥£¬µÞÔìÁ˸÷¸ö²»Í¬µÄÒýÇæºÍ·ÖÖ§£¬ÈÃMySQLÓÐÏ£Íû¼ÌÐø·¢Ñï¹â´óÆðÀ´¡£
±¾ ......
Ó¦¸Ã˵һ°ãµÄÊý¾Ý¿â¶¼ÓÐBackUpµÄÐèÇó, MySql±¸·ÝÊý¾Ý¿âµÄ·½Ê½ºÜ¼òµ¥, µ«ÊÇÔÚÍøÉÏ˵µÃÔÆÀïÎíÀï, Ò²Ó¦¸ÃÊÇÎÒ¶ÔMySqlÊý¾Ý¿â²»ÊìϤ.
Ä¿±ê(Target) : ½«±¾»úÖеÄmysqlÊý¾Ý¿â±¸·Ýµ½±¾»úÖеÄmydatabaseÊý¾Ý¿âÖÐ - Ò²¾ÍÊÇÍêÈ«µÄCopyÒ»¸öÊý¾Ý¿â.
#1. C:\Program Files\MySQL\MySQL Server 5.0\bin>mysqldump -u ......