Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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Ŀ¼ÏÂ


Ïà¹ØÎĵµ£º

phpÁ¬½Ómysql²âÊÔºÍÅäÖÃ


phpÁ¬½Ómysql²âÊÔ´úÂ룺
$link=mysql_connect('localhost','root','123456');
if(!$link) echo "ʧ°Ü!";
else echo "³É¹¦!";
mysql_close();
?>
ÔËÐдúÂë³öÏÖ£ºCall   to   undefined   function   'mysql_connect()'… ʧ°Ü
°Ù¶ÈÕÒµ½½á¹ûÊÇPHP+MYSQL »·¾³Ã ......

Õýȷɾ³ýMYSQlÈÕÖ¾·½·¨

1.²éÕÒµ±
mysql> show binary logs;
+—————-+———–+
| Log_name | File_size |
+—————-+———–+
| mysql-bin.000001 | 150462942 |
| mysql-bin.000002 | 125 |
| mysql-bin.000003 | 106 |
+&mdash ......

mysql´íÎóÌáʾ¼°×ÊÁÏ×ܽá

mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!
[root@localhost]# mysql -u root -p
Enter password:
ERROR 2002 (H ......

MySQL±Ê¼Ç

mysqldump -uÓû§Ãû -pÃÜÂë Êý¾Ý¿âÃû >dumpÎļþµÄ·¾¶ºÍÃû³Æ
mysql> source dump.sql
There are three general ways to invoke mysqldump:
shell> mysqldump [options] db_name [tbl_name ...]
shell> mysqldump [options] --databases db_name ...
shell> mysqldump [options] --all-databases
......

MySQLÖÐÊý¾Ý½á¹û¼¯·ÖÒ³¹¦ÄܵÄʵÏÖ·½·¨

---------------------------------------------------------------------------
---- ±¾ÎÄΪandkylee¸öÈËÔ­´´£¬ÇëÔÚ×ðÖØ×÷ÕßÀͶ¯³É¹ûµÄÇ°ÌáϽøÐÐתÔØ£»
---- תÔØÎñ±Ø×¢Ã÷ԭʼ³ö´¦
:
http://blog.csdn.net/andkylee
--- 2010-05-31 18:46:12
---- ¹Ø¼ü×Ö£º  MySQL ·ÖÒ³  limit
----------------------- ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ