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

MySQL°²×°ÓëÓ¦Óá¾LinuxϵݲװÓëÅäÖá¿

LinuxϵݲװÓëÅäÖÃ
Èç¹ûËù°²×°µÄLinuxϵͳûÓÐÄÚÖõÄMySQL£¬±ÊÕß½¨ÒéÔÚLinuxÖÐʹÓÃRPM°üÀ´°²×°MySQL£¬Í¬ÑùÕâÒ²ÊÇMySQL¹Ù·½ÌṩµÄ½¨Òé¡£±ÊÕß½Ó´¥×î¶àµÄLinuxϵͳÊÇRadhatµÄ“½üÇ×”£ºCentOS£¬ÓÉÓÚCentOS½Ïеİ汾¶¼ÄÚÖÃÁËMySQL£¬Òò´ËÔÚ°²×°ÏµÍ³Ê±¾Í½«MySQL°²×°²¢×¢²áΪϵͳ·þÎñ£¬Ê¡È¥Á˲»ÉÙ¹¤×÷Á¿£¬´Ë´¦Ò²¾Í²»¶ÔLinuxϵݲװ×öÌ«¶à³ÂÊö£¬½öÌṩ²¿·Ö×ÊÁϹ©²Î¿¼¡£
×¢Ò⣺
MySQLÖÁÉÙÐèÒªLinux 2.0°æ±¾¡£
ÒÔÏÂÊÇÍøÓÑÌṩµÄCentOS 5ϰ²×°MySQLµÄ²½Ö裨³ö´¦£ºhttp://wenda.tianya.cn/wenda/thread?tid=0c194eed74f2577b£©£¬½ö¹©²Î¿¼¡£
CentOS5ÏÂMySQLµÄ°²×°²½Öè
´´½¨mysqlÓû§×éºÍÓû§
[root@centos ]# groupadd mysql
[root@centos ]# useradd -g mysql mysql
[root@centos ]# cd homexule
[root@centos ]# chmod 755 mysql-5.0.22.tar.gz
±àÒë²¢°²×°MySQL
[root@centos ]# tar zxvf mysql-5.0.22.tar.gz
[root@centos ]#cd mysql-5.0.22
[root@centos mysql-5.0.22] .configure --prefix=usrlocalmysql
[root@centos mysql-5.0.22] make
[root@centos mysql-5.0.22] make install
ÅäÖò¢Æô¶¯MySQL
[root@centos mysql-5.0.22]# cp support-filesmy-medium.cnf etcmy.cnf
[root@centos mysql-5.0.22]# cd usrlocalmysql
[root@centos mysql]# binmysql_install_db --user=mysql
Installing all prepared tables
Fill help tables
To start mysqld at boot time you have to copy support-filesmysql.server
to the right place for your system
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands
usrlocalmysqlbinmysqladmin -u root password 'new-password'
usrlocalmysqlbinmysqladmin -u root -h centos.job100.com password 'new-password'
See the manual for more instructions.
You can start the MySQL daemon with
cd usrlocalmysql ; usrlocalmysqlbinmysqld_safe &
You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory
cd sql-bench ; perl run-all-tests
Please report any problems with the usrlocalmysqlbinmysqlbug script!
The latest information about MySQL is available on the web at
httpwww.mysql.com
Support MySQL by buying supportlicenses at httpshop.my


Ïà¹ØÎĵµ£º

Linux ÏÂphpÀ©Õ¹ tidy µÄ°²×° _ ²Î¿¼

tidy ÊÇÒ»¸ö·Ç³£°ïæµÄÍøÒ³´úÂë·ÖÎöºÍ¾À´íµÄ¹¤¾ß£¬Äܹ»Ö§³Ö¶àÖÖÒ³Ãæ±àÂ룬²¢ÇÒÖ§³ÖxhtmlÊä³ö¡£Èç¹ûÎÒÃÇ͵ÀÁ£¬ÉõÖÁ¿ÉÒÔ½«Õû¸öÒ³Ãæ»º´æ£¬×îºó²ÉÓÃtidy´¦Àí£¬×îºóÊä³öÍêÃÀµÄxhtml´úÂë¡£
linuxϰ²×°¹ý³ÌÈçÏ£º
Ê×ÏȰ²×°tidy £¬ÏÂÔØtidyÔ´´úÂ룺
cvs -d:pserver: anonymous@tidy.cvs.sourceforge.net Ϊ·À±¸µç×ÓÓʼþµØÖ·ÊÕ¼¯ ......

java¶ÔmysqlÊý¾Ý¿âµÄµ¼Èëµ¼³ö

//µ¼³ö
String mysql="mysqldump -uroot -proot  --opt databasename > d:/test.sql";    
java.lang.Runtime.getRuntime().exec("cmd /c "+mysql);   
//µ¼Èë
String mysql="mysqladmin -uroot -proot create databasename";    
java.lang.Runt ......

MySQL 3.23 ÖÐÎIJο¼ÊÖ²á

mysql_affected_rows() ·µ»Ø±»×îеÄUPDATE, DELETE»òINSERT²éѯӰÏìµÄÐÐÊý¡£ 
mysql_close() ¹Ø±ÕÒ»¸ö·þÎñÆ÷Á¬½Ó¡£ 
mysql_connect() Á¬½ÓÒ»¸öMySQL·þÎñÆ÷¡£¸Ãº¯Êý²»ÍƼö£»Ê¹ÓÃmysql_real_connect()´úÌæ¡£ 
mysql_change_user() ¸Ä±äÔÚÒ»¸ö´ò¿ªµÄÁ¬½ÓÉϵÄÓû§ºÍÊý¾Ý¿â¡£ 
mysql_create_db() ´´½¨Ò ......

MySQL .Íâ¼üÔ¼Êø

InnoDBÒ²Ö§³ÖÍâ¼üÔ¼Êø¡£InnoDBÖжÔÍâ¼üÔ¼Êø¶¨ÒåµÄÓï·¨¿´ÆðÀ´ÈçÏ£º
[CONSTRAINT symbol] FOREIGN KEY [id] (index_col_name, ...)
    REFERENCES tbl_name (index_col_name, ...)
    [ON DELETE {RESTRICT | CASCADE | SET NULL | NO ACTION}]
    [ON UPDATE ......

mysql×Ö·û±àÂëµÄËѼ¯

mysql×Ö·û¼¯±àÂëÏòÀ´ÊÇÒ»¸öÄÑÌ⣬ÒòΪÓÐʱºòΪ´ó¶àÊýÈËÏëµÄUTF8¿ÉÒÔ½â¾öһЩÄÑÌ⣬²»¹ý²»ÒªÌ«ÀíÏ뻯ÁË£¬ÓÐʱºòÔÚwindow¿Í»§¶ËÏ Ð޸ijÉutf8£¬mysqlÊDz»Ö§³ÖµÄ£¬ËùÒÔ»¹µÃ¾ßÌåÎÊÌâ¾ßÌå·ÖÎö£¬¿ÉÊÇÕâ¸ö»¹ÕæµÃÐèÒªÄ㻨µãʱ¼äÀ´Ñо¿
ÏÂÃæÊÇһЩ±ðÈ˵ÄÎÄÕ£¬ÔÚ´ËÏÈлÁË
         & ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ