ÈçºÎÔ¶³ÌÏÂÔØmysqlÊý¾ÝÎļþ--ÐÂÊÖ¾ÈÖú
¾ßÌåÊÇÕâÑùµÄ, ÎÒÅóÓѽÐÈË×öÁËÒ»¸öÍøÕ¾, È»ºóÂòÁËÓòÃû, ×â·þÎñÆ÷µÈµÈ, ¾ÍÊÇÄÜÅÜÆðÀ´ÁË. ºóÀ´, °ïËû×öÕâ¸öÍøÕ¾µÄÕâ¸öÈËÅÜÁË, ÁªÏµ²»ÉÏ, È»ºó, ÎÒÅóÓѽÐÎÒ°ïËûÐÞ¸ÄÏÂÊý¾Ý¿â(mysql)ÀïµÄ¶«Î÷. ¸øÎÒÎÒftpµÄÕ˺ÅÃÜÂë, ·þÎñÆ÷Ãû³Æ(IP), ÎÒÓÃÎÒ±¾»úµÄmysql¾ÍÊÇÁ¬²»ÉÏÈ¥(ÎÒÓõÄÊÇftpµÄÕ˺źÍÃÜÂë, ²»ÖªµÀ¶Ô²»¶Ô, Ò²ÊÔ¹ýĬÈÏroot+¿ÕÃÜÂë), ¶Ë¿Ú¹À¼ÆÓÐûÓб»¸Ä¹ý. ÎÊÌâÒ»: ͨ¹ýftpÄÜÏÂÔØµ½Êý¾ÝÎļþÂð? ¸öÈËÕÒ²»µ½. ÎÊÌâ¶þ:¡¡Èç¹ûÄÜ´Ó±¾»úÁ¬µ½·þÎñÆ÷µÄÊý¾Ý¿â£¬Õ˺ÅÃÜÂëºÍ£æ£ô£ðµÄÒ»ÑùµÄô£¿£¨ÍøÉÏÓÐÈË˵mysqlµÄÊý¾ÝÔ¶³ÌµÇ¼һ°ãÊDz»¿ªµÄ) ÎÒÒѾ×ÁÄ¥ÁËÁ½ÌìÁË, ÉÏÍø²éÁËÏÂÒ²Î廨°ËÃŵÄ, ÍûÓиßÊÖ°ïæÏÂ.
linuxÖÐÖ±½ÓwgetÁ¬½Ó¾Í¿ÉÒÔÁËÒýÓà ¾ßÌåÊÇÕâÑùµÄ, ÎÒÅóÓѽÐÈË×öÁËÒ»¸öÍøÕ¾, È»ºóÂòÁËÓòÃû, ×â·þÎñÆ÷µÈµÈ, ¾ÍÊÇÄÜÅÜÆðÀ´ÁË. ºóÀ´, °ïËû×öÕâ¸öÍøÕ¾µÄÕâ¸öÈËÅÜÁË, ÁªÏµ²»ÉÏ, È»ºó, ÎÒÅóÓѽÐÎÒ°ïËûÐÞ¸ÄÏÂÊý¾Ý¿â(mysql)ÀïµÄ¶«Î÷. ¸øÎÒÎÒftpµÄÕ˺ÅÃÜÂë, ·þÎñÆ÷Ãû³Æ(IP), ÎÒÓÃÎÒ±¾»úµÄmysql¾ÍÊÇÁ¬²»ÉÏÈ¥(ÎÒÓõÄÊÇftpµÄÕ˺źÍÃÜÂë, ²»ÖªµÀ¶Ô²»¶Ô, Ò²ÊÔ¹ýĬÈÏroot+¿ÕÃÜÂë), ¶Ë¿Ú¹À¼ÆÓÐûÓб»¸Ä¹ý. ÎÊÌâÒ»: ͨ¹ýftpÄÜÏÂÔØµ½Êý¾ÝÎļþÂð? ¸öÈËÕÒ²»µ½. ÎÊÌâ¶þ:¡¡Èç¹ûÄÜ´Ó±¾»úÁ¬µ½·þÎñÆ÷µÄÊý¾Ý¿â£¬Õ˺ÅÃÜÂëºÍ£æ£ô£ðµÄÒ»ÑùµÄô£¿£¨ÍøÉÏÓÐÈË˵mysqlµÄÊý¾ÝÔ¶³ÌµÇ¼һ°ãÊDz»¿ªµÄ) ÎÒÒѾ×ÁÄ¥ÁËÁ½ÌìÁË, ÉÏÍø²éÁËÏÂÒ²Î廨°ËÃŵÄ, ÍûÓиßÊÖ°ïæÏÂ. 2¡¢³ý·ÇMYSQLµÇ¼ÓëÃÜÂëÓëFTPµÄÒ»Ö£¬ÕâÊÇÁ½¸ö²»Í¬µÄ¸ÅÄî 1¡¢MYSQLÊý¾Ý¿â·ÅÔÚFTPÉÏ£¿²éÕÒÊý¾Ý¿âĿ¼ÊÔÊÔ ftp·½Ã治̫Á˽⠲»¹ýÄãmys
Ïà¹ØÎÊ´ð£º
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡ лл¸÷λÁË ¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î ±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡ ллÁË ¼Æ»®ÈÎÎñ...php....sql...truncate....OK Äã¾ÍÕâ½ÓÔÚҳà ......
ÎÒ°²×°µÄÕâ¸öÈí¼þVertrigoServ£¬ÔÚwindows7ÖÐÔËÐУ¬Í¼±ê¼ÓºÅΪÀ¶É«£¬±¨MySQLµÄ´íÎó£¬Çë½Ì¸÷λ¸ßÊÖ¸ÃÔõÑù¸ü¸Ä¡£Ð»Ð»¸÷λ£¡ mysql ·þÎñÊÇ·ñÆðÀ´ÁË£¿ ûÓУ¬±¨µÄÊǶ˿ڴíÎó£¬ÔÚÅäÖÃÎļþµ±ÖиÄÁË£¬Ò²²»ÐÐ ¿ÉÒÔÓÃÈ ......
ÎÒÔÚÇåÀímysqlµÄʱºò£¬Ò»²»ÁôÉñ½«mysql(¼´dataÀïµÄmysqlÎļþ¼Ð)Êý¾Ý¿â¸øÉ¾µôÁË£¬¸ôÁ˼¸¸öСʱÎÒÖØÆôÁËmysqlÈí¼þ£¬mysql¾Í×Ô¶¯³õʼ»¯ÁËÊý¾Ý¿â£¬µ¼Ö´Óɾ³ýmysqlÎļþ¼Ð¿ªÊ¼µ½ÖØÆôÕâ¶Îʱ¼äµÄÊý¾Ý¶ªÊ§£¬ÄÇλ¸ßÊÖ°ïÏëÏë°ì ......
CREATE DATABASE ADDRESSLIST; USE ADDRESSLIST; DROP TABLE IF EXISTS FRIEND; CREATE TABLE FRIEND (FRIEND_ID INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY , FRIEND_NAME VARCHAR(20) NOT N ......
mysqlÊý¾Ý¿âµÄ±àÂë¸ñʽÊÇutf8 ÔÚc++³ÌÐòÖÐʹÓÃC APIÖ±½ÓÁ¬½ÓmysqlÊý¾Ý¿â£¬°ÑÖÐÎı£´æµ½mysqlÊý¾Ý¿âÖУ¬ÖÐÎç±ä³ÉÂÒÂë ʹÓÃmysqlµÄloadÃüÁîµ¼ÈëÎı¾Îļþ£¬ÎÞÂÛÎı¾ÎļþÊÇANSI»¹ÊÇutf8±àÂ룬¶¼ÊÇÂÒÂë ÇëÎÊÉÏÃæÁ½¸öÎÊ ......