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

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


Ïà¹ØÎĵµ£º

(ת)MySQL¸ü¸Ä/ÐÞ¸ÄrootÃÜÂëµÄÈýÖÖ·½·¨

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¼ÓÃÜ/ѹËõº¯Êý

ÔÚMySQLÖУ¬¼ÓÃܺÍѹËõº¯Êý·µ»Ø¶þ½øÖÆ´®¡£¶ÔÆäÖеÄÐí¶àº¯Êý¶øÑÔ£¬½á¹û¿ÉÄÜ°üº¬ÈÎÒâµÄ×Ö½ÚÖµ£¬Èç¹ûÏë´æ´¢ÕâЩ½á¹û£¬ÄãÓ¦¸ÃʹÓÃÒ»
¸ö¾ßÓÐvarbinary»òÕßblob¶þ½øÖÆ´®Êý¾ÝÀàÐ͵ÄÁУ¬Õâ¿É±ÜÃâDZÔÚµÄɾ³ýβ²¿¿Õ°×ÎÊÌâ»òÕß×Ö·û¼¯×ª»»ÎÊÌâ¡£ÕâЩÎÊÌâ¿ÉÄܵ¼ÖÂÊý¾ÝÖµµÄ¸Ä±ä¡£Ò»°ã¶øÑÔ£¬ÉÏÊöÎÊÌâ¿ÉÄÜÔÚÄãʹÓ÷Ƕþ½øÖÆ´®Êý¾ÝÀàÐÍ£¨Èçch ......

mysql ÐÔÄܲâÊÔ


mysql ÐÔÄܲâÊÔ
»úÆ÷ÅäÖÃ
drivers  : mysql odbc 3.51
program  : vb 6.0
database : mysql 4.01. nt
member   : 256 ddr
cpu      : 1.2g
²âÊÔÊý¾ÝÁ¿Îª14w ,200w
select ²âÊÔ!
µÚÒ»¸ö²âÊÔ
select count(*) from tbl_outgoing_log ;
ºÜ¶ÌµÄʱ¼ä ²»ÓÃÍøÂçµÄÇé¿öÏ ......

MysqlË÷Òý

MySQLË÷Òý¼ò½é... 1
Ò»¡¢Ë÷Òý·Öµ¥ÁÐË÷ÒýºÍ×éºÏË÷Òý…………………………………………………………………………………&hel ......

Ubuntu9.10Ï°²×°Mysql 5.5.0 M2

×÷Õߣº°½Ê¿Î°
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/
…………
& ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ