mysql ÂÒÂë´¦Àí
1. mysqldump -u username -h somehost -p --compatible=mysql40 db_name > temp.sql
2. ÓÃphpmyadminÇå¿ÕÊý¾Ý¿â²¢ÉèÖÃÊý¾Ý¿âÕûÀíΪutf8_general_ci
3. mysql -u username -h somehost -p --default-character-set=utf8 db_name < temp.sql
Ïà¹ØÎĵµ£º
1¡¢±à¼MySQLÅäÖÃÎļþ£º
windows»·¾³ÖУº%MySQL_installdir%\my.ini¡¡//Ò»°ãÔÚMySQL°²×°Ä¿Â¼ÏÂÓÐmy.ini¼´MySQLµÄÅäÖÃÎļþ¡£
linux»·¾³ÖУº/etc/my.cnf
ÔÚ[MySQLd]ÅäÖöÎÌí¼ÓÈçÏÂÒ»ÐУº
skip-grant-tables
±£´æÍ˳ö±à¼¡£
2¡¢È»ºóÖØÆôMySQL·þÎñ
windows»·¾³ÖУº
net stop MySQL
net start MySQL
linux»·¾³ÖУº
/e ......
mysql_affected_rows() ·µ»Ø±»×îеÄUPDATE, DELETE»òINSERT²éѯӰÏìµÄÐÐÊý¡£
mysql_close() ¹Ø±ÕÒ»¸ö·þÎñÆ÷Á¬½Ó¡£
mysql_connect() Á¬½ÓÒ»¸öMySQL·þÎñÆ÷¡£¸Ãº¯Êý²»ÍƼö£»Ê¹ÓÃmysql_real_connect()´úÌæ¡£
mysql_change_user() ¸Ä±äÔÚÒ»¸ö´ò¿ªµÄÁ¬½ÓÉϵÄÓû§ºÍÊý¾Ý¿â¡£
mysql_create_db() ´´½¨Ò ......
×÷Õߣº°½Ê¿Î°
Mysql ÓõÄÊÇLinux (non RPM packages)
Ò»¡¢½«mysql-5.5.0-m2-linux-i686-glibc23.tar.gzÏÂÔص½/home/ikmb ²¢ÔÚµ±Ç°Ä¿Â¼½âѹ£»
……..
mysql-5.5.0-m2-linux-i686-glibc23/data/mysql/
mysql-5.5.0-m2-linux-i686-glibc23/data/test/
…………
¶þ¡¢´´½¨MySQL×飬 ......
http://hi.baidu.com/ubuntu2me/blog/item/e1bd54de9a428f1862279828.html
¡¾IT168¼¼ÊõÎĵµ
¡¿ÈκÎÒ»ÖÖÊý¾Ý¿âÖУ¬¶¼Óи÷ÖÖ¸÷ÑùµÄÈÕÖ¾¡£MysqlÒ²²»ÀýÍ⣬ÔÚMysqlÖÐÓÐ4ÖÖ²»Í¬µÄÈÕÖ¾¡¢·Ö±ð´íÎóÈÕÖ¾¡¢¶þ½øÖÆÈÕÖ¾¡¢²éѯÈÕÖ¾ºÍÂý²éѯÈÕÖ¾¡£ÕâЩÈÕÖ¾¼Ç¼×ÅMysqlÊý¾Ý¿â²»Í¬·½ÃæµÄ×Ù¼£¡£ÏÂÎĽ«½éÉÜÕâ4ÖÖ²»Í¬µÄÈÕÖ¾×÷ÓúÍÓÃ;¡£
¡¡¡ ......
1. Mysql ×Ô¶¯Æô¶¯µÄÅäÖÃ
ÔÚMySQL°²×°³ÌÐòµÄ½âѹ°ü
/usr/local/mysql/support-files
myslq.serverµÄÆô¶¯½Å±¾³ÌÐò=¡· ¸´ÖÆ/etc/rc.d/init.dĿ¼
[root@localhost ~]# cd /etc/rc.d/init.d
¸´ÖƲ¢ÖØÃüÃûΪmysql
[root@localhost init.d]# cp /usr/local/mysql/support-files/mysql.server mysql
¸ü¸ÄÊôÐÔ¸ÄΪ“x& ......