RedhatÏ Apache, php, mysqlµÄĬÈϰ²×°Â·¾¶
apache:
Èç¹û²ÉÓÃRPM°ü°²×°£¬°²×°Â·¾¶Ó¦ÔÚ /etc/httpdĿ¼ÏÂ
apacheÅäÖÃÎļþ:/etc/httpd/conf/httpd.conf
ApacheÄ£¿é·¾¶£º/usr/sbin/apachectl
webĿ¼:/var/www/html
Èç¹û²ÉÓÃÔ´´úÂë°²×°£¬Ò»°ãĬÈϰ²×°ÔÚ/usr/local/apache2Ŀ¼ÏÂ
php:
Èç¹û²ÉÓÃRPM°ü°²×°£¬°²×°Â·¾¶Ó¦ÔÚ /etc/Ŀ¼ÏÂ
phpµÄÅäÖÃÎļþ:/etc/php.ini
Èç¹û²ÉÓÃÔ´´úÂë°²×°£¬Ò»°ãĬÈϰ²×°ÔÚ/usr/local/libĿ¼ÏÂ
phpÅäÖÃÎļþ: /usr/local/lib/php.ini
»ò/usr/local/php/etc/php.ini
mysql:
Èç¹û²ÉÓÃRPM°ü°²×°£¬°²×°Â·¾¶Ó¦ÔÚ/usr/share/mysqlĿ¼ÏÂ
mysqldumpÎļþλÖãº/usr/bin/mysqldump
mysqliÅäÖÃÎļþ:
/etc/my.cnf»ò/usr/share/mysql/my.cnf
mysqlÊý¾ÝĿ¼ÔÚ/var/lib/mysqlĿ¼ÏÂ
Èç¹û²ÉÓÃÔ´´úÂë°²×°£¬Ò»°ãĬÈϰ²×°ÔÚ/usr/local/mysqlĿ¼ÏÂ
Ïà¹ØÎĵµ£º
ÕýÔò±í´ïʽ×Ô¼ºÒ»Ö±²»ÊìϤ£¬Õâ2ÌìÔÚÍøÉÏÒ»Ö±¿´¹ØÓÚËüµÄÎÄÕ£¬×Ô¼º×ܽáÁ˼¸¸öº¯Êý¡£
1£®preg_match()
º¯ÊýÔÐÍ£ºint preg_match (string $pattern, string $content [, array
$matches])
preg_match
()º¯ÊýÔÚ$content×Ö·û´®ÖÐËÑË÷Óë$pattern¸ø³öµÄÕýÔò±í´ïʽÏàÆ¥ÅäµÄÄÚÈÝ¡£Èç¹ûÌṩÁË$matches£¬Ôò½«Æ¥Åä½á¹û·ÅÈëÆäÖС ......
1.²éÕÒµ±
mysql> show binary logs;
+—————-+———–+
| Log_name | File_size |
+—————-+———–+
| mysql-bin.000001 | 150462942 |
| mysql-bin.000002 | 125 |
| mysql-bin.000003 | 106 |
+&mdash ......
ÏÈ˵Ã÷Ò»ÏÂBlobµÄÀàÐÍ£¬Ö±½Ó´ÓÍøÉÏÕª³ÁË£¡£¡£¡
1¡¢MySQLÓÐËÄÖÖBLOBÀàÐÍ:
¡¡¡¡·tinyblob:½ö255¸ö×Ö·û
¡¡¡¡·blob:×î´óÏÞÖÆµ½65K×Ö½Ú
¡¡¡¡·mediumblob:ÏÞÖÆµ½16M×Ö½Ú
¡¡¡¡·longblob:¿É´ï4GB
2¡¢³ýÁËÀàÐͶԺóÃæ´æÈ¡Îļþ´óСÓÐÏÞÖÆ£¬»¹ÒªÐÞ¸ÄmysqlµÄÅäÖÃÎļþ¡£
¡¡¡¡Windows¡¢linux»ù±¾Ò»Ñù ......
MySQL×Ö·û´®º¯ÊýµÄÓ¦ÓÃÓë×¢ÒâÊÂÏî
ÒÔϵÄÎÄÕÂÖ÷ÒªÏò´ó¼ÒÃèÊöµÄÊÇMySQL×Ö·û´®º¯ÊýµÄʵ¼ÊÓ¦ÓÃÓëÆäʵ¼Ê²Ù×÷´úÂëµÄÃèÊö£¬Í¬Ê±±¾ÎÄ»¹¶ÔÆäÔÚʵ¼ÊÓ¦ÓÃÖУ¬Ò»Ð©ÖµµÃÎÒÃÇ´ó¼Ò×¢ÒâµÄÏà¹ØÊÂÏîµÄÃèÊö£¬ÒÔϾÍÊÇÎÄÕµÄÖ÷ÒªÄÚÈÝÃèÊö£¬ÍûÄã»áÓÐËùÊÕ»ñ¡£
CHARSET(str) ·µ»Ø×Ö´®×Ö·û¼¯
CONCAT (string2 [,& ......
ÉèÖÃÊý¾Ý¿âÁ¬½Ó
<?php
/**
* @author [˹ÈË]
* @date 2010/6/1/10:16
* @
*
*/
define("RDFAPI_INCLUDE_DIR", "E:/siren/rdfapi-php/api/");
include(RDFAPI_INCLUDE_DIR . "RDFAPI.php");
//Á¬½Óµ½MSAccessÊý¾Ý¿â£¨rdf_db DSN£©µÄʹÓÃÁ¬½ÓÉèÖÃ
......