Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 3.23 ÖÐÎIJο¼ÊÖ²á

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

mysqlÇý¶¯Ñо¿Ö®Í¨ÓÃÊý¾Ýת·¢Æ÷

   Õâ¶Îʱ¼äÔÚѧϰC#,ÒªÁ¬½ÓmysqlÊý¾Ý¿â,²»ÖªµÀÔõôÁ¬½Ó ,ºóÀ´gooleÁËÏÂ,·¢ÏÖÒªÏÂÔØÇý¶¯,˳±ã¿´ÁËÏÂÁ¬½ÓµÄexample code
  ´úÂëºÍjavaÀïÃæµÄ²îºÜ¶à,֮ǰһֱÔÚѧC++ Ҳѧ¹ýÒ»¶Îʱ¼äµÄÇý¶¯¿ª·¢,Ò»ÌýmysqlÇý¶¯,ҲûÔÚÒâ, Çý¶¯ÔÚÐÄÀïÒ»Ö±¶¼ÊǺÜÄÑ
²¢ÇÒÈÝÒ×Ôì³ÉÀ¶ÆÁ,Êý¾Ý½á¹¹¸´ÔӵĴúÃû´Ê,Ò²¾ÍûÔÚÒâ,µ«ÊǺóÀ´Ô ......

mysqlÃüÁî

²âÊÔ»·¾³£ºmysql 5.0.45
¡¾×¢£º¿ÉÒÔÔÚmysqlÖÐͨ¹ýmysql> SELECT VERSION();À´²é¿´Êý¾Ý¿â°æ±¾¡¿
ÕûÀí£ºleo
Ò»¡¢Á¬½ÓMYSQL¡£
¸ñʽ£º mysql -hÖ÷»úµØÖ· -uÓû§Ãû £­pÓû§ÃÜÂë
1¡¢Á¬½Óµ½±¾»úÉϵÄMYSQL¡£
Ê×ÏÈ´ò¿ªDOS´°¿Ú£¬È»ºó½øÈëĿ¼mysql\bin£¬ÔÙ¼üÈëÃüÁîmysql -u root -p£¬»Ø³µºóÌáʾÄãÊäÃÜÂë.×¢ÒâÓû§ÃûÇ°¿ÉÒÔÓп ......

ÈçºÎ²é¿´mysqlÔËÐС¢·ÃÎʼǼµÈÈÕÖ¾


1.Ê×ÏÈÈ·ÈÏÄãÈÕÖ¾ÊÇ·ñÆôÓÃÁË
mysql>show variables like 'log_bin';
mysql>show variables like 'log';
2.Èç¹ûÆôÓÃÁË£¬¼´ON
Èç¹ûûÓÐÆôÓ㬼´OFF£¬
ÒªÐÞ¸Ämy.cnf
  
  #   The   MySQL   server   
  [mysqld]   
    
  # ......

MysqlË÷Òý

MySQLË÷Òý¼ò½é... 1
Ò»¡¢Ë÷Òý·Öµ¥ÁÐË÷ÒýºÍ×éºÏË÷Òý…………………………………………………………………………………&hel ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ