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

mysqlµÄ±¸·ÝºÍ»¹Ô­µÄ±àÂëÎÊÌâ½â¾ö


½ñÌìÐèÒª´ÓÔ¶³Ì·þÎñÆ÷downÒ»¸öuchomeµÄÊý¾Ý¿âÏÂÀ´£¬ÔÚ±¾µØ»¹Ô­¡£
·¢ÏÖÒ»¸öºÜ²»Ë¬µÄÊÂÇ飺Զ³Ì8G£¬NºËµÄlinux»úÆ÷£¬±¸·Ý»¹Ô­²Ù×÷˳ÁïÁïµÄ£¬¿ÉÊÇÔÚ±¾µØµÄwindows£¬2GÆÕͨPCÉÏ£¬²Å100MµÄÎļþ£¬ÓÃuchome×Ô´øµÄ·Ö¾í±¸·Ý»¹Ô­£¬»ù±¾ÉÏÖм䶼»á¶Ïµô£¬ÒªÃ´Ìáʾ“Ö´ÐÐʱ¼ä¹ý³¤”£¨¸Ä³É200Ã룬·Ö¾íΪ20M¶¼²»ÐУ©£¬ÒªÃ´¾ÍÊÇÖÐ;°×ÆÁ¡£
µÃÁË£¬ÓÃmysqldump±¸·ÝµÄÒ»¸ö¶ÀÁ¢ÎļþÀ´ÔËÐÐÃüÁîÐл¹Ô­°É¡£
Ê×ÏÈÔËÐл¹Ô­Óï¾ä£º
mysql -uroot -p123456 mydatabase < d:\backupdatabase.sql
ʱ¼ä»ºÂýµØÊÅÈ¥£¬Ò»¿ÚË®ºÈÍ꣬Éϸö²ÞËù£¬ÔÙÁï´ïһϣ¬ÖÕÓÚÍê³ÉÁË£¨ÔÚÔ¶³Ìlinux·þÎñÆ÷ÉÏÒ²¾Í20ÃëµÄ¹¦·ò£¡£©
È»ºó¸üлº´æ£¬·¢ÏÖÊý¾ÝÂÒÂëÁË£¬ß×£¬ÎÒ±¸·ÝµÄʱºòÊÇÇ¿ÖÆµÄgbk±àÂë°¡£¡¿´¿´±¸·ÝµÄÓï¾ä£º
mysqldump -uroot -p123456 –default-character-set=gbk mydatabase > /usr/local/mysql/backup/backup20091026.sql
û´í°¡£¡ÒѾ­ÉèÖÃÁËĬÈÏ×Ö·û¼¯ÎªgbkÁË£¬¿´À´¿ÉÄÜÊÇÔÚ»¹Ô­µÄʱºòÒ²ÒªÉèÖðɣ¬ÓÚÊÇÐ޸Ļ¹Ô­Óï¾ä£¬ÊÖ¹¤Ö¸¶¨×Ö·û±àÂë
mysql -uroot -p123456 font –default-character-set=gbk mydatabase < d:\backupdatabase.sql
ÓÖÊÇÂþ³¤µÄµÈ´ý…Ë¢ÐÂÒ³ÃæÒ»¿´£¬ÏÖÔÚÂÒÂë½â¾öÁË¡£
×ܽ᣺ÔÚ²»Í¬µÄ²Ù×÷ϵͳºÍÊý¾Ý¿â»·¾³Ö®¼ä±¸·ÝÓ뻹ԭʱ£¬»¹ÊÇÁ½±ß¶¼Ç¿ÖÆÖƶ¨Ò»¸ö×Ö·û¼¯×î±£ÏÕ¡£


Ïà¹ØÎĵµ£º

MYSQL ¶à¹Ø¼ü×ÖÏà¹ØÎÄÕ²éѯ·½·¨

È¡µÃÎÄÕ¹ؼü×ÖΪkeywords
±ínewsµÄ¹Ø¼ü×Ö×Ö¶ÎΪkeyword
keywords=keywords.replace(',','|');
  String sql="SELECT * from news WHERE keyword REGEXP '"+keywords+"' ORDER BY id ";
ÓÉÓÚijЩԭÒò£¬ÓÐʱºòÎÒÃÇûÓа´ÕÕ·¶Ê½µÄÉè¼Æ×¼Ôò¶ø°ÑһЩÊôÐԷŵ½Í¬Ò»¸ö×Ö·û´®×Ö¶ÎÖС£±ÈÈç¸öÈËÐËȤ£¬ÓÐʱºòÎÒÃÇÉè¼Æ±íΪ
cr ......

MySQL°²×°ºÍÅäÖÃ

    ×î½üµÄÏîÄ¿ÖÐʹÓÃÁËMySQLÊý¾Ý¿â£¬Ò»Ð©MySQLµÄÐÂÓû§ÔÚÅäÖÃʹÓÃʱ»¹ÓÐЩ²»¹»ÊìÁ·£¬ÌØÔڴ˼Ǽ£¬·½±ã¿ª·¢ÍŶÓʹÓ㬸ÃÎÄÕÂËùÉæ¼°ÄÚÈݾù¿ÉÒÔÔÚMySQL²Î¿¼ÊÖ²áµÚ¶þÕ“°²×°MySQL”ÖÐÕÒµ½¡£MySQL°²×°ºó×Ô´øÁËÓ¢ÎIJο¼ÊֲᣬҲ¿ÉÒÔÔÚhttp://dev.mysql.com/doc/refman/5.1/zh/index.html²é¿´ÖÐÎİ汾£ ......

³£¼ûµÄMySQLÃüÁî´óÈ«

³£¼ûµÄMySQLÃüÁî´óÈ«
Ò»¡¢Á¬½ÓMySQL
        ¸ñʽ£º mysql -hÖ÷»úµØÖ· -uÓû§Ãû £­pÓû§ÃÜÂë
        1¡¢Àý1£ºÁ¬½Óµ½±¾»úÉϵÄMYSQL¡£
        Ê×ÏÈÔÚ´ò¿ªDOS´°¿Ú£¬È»ºó½øÈëĿ¼ mysqlbin£¬ÔÙ¼üÈëÃüÁîmysql ......

C#²Ù×÷MySQLÊý¾Ý¿âµÄ¼òµ¥Àý×Ó


×÷Õß: ÍõÕßÖ®½£(http://www.albertsong.com/)  ÈÕÆÚ: 2008-01-05 22:10
×ÖÌå´óС: Ð¡ ÖР´ó
ʾÀýÑÝʾÁËÓÃC#²Ù×÷MySQLµÄ·½·¨£¬ÌṩÁËÈý¸ö¿ÉÖØÓõÄÀàMySqlDBUtil,MySqlPageUtil,Page¡£
±¾Ê¾ÀýÓÉ C#²Ù×÷AccessÊý¾Ý¿âµÄ¼òµ¥Àý×Ó£¨http://www.albertsong.com/read-56.html£©Ð޸ĶøÀ´¡£
1.Ê×ÏÈÏÂÔ ......

MySQL ¹ØÓÚ½¨Á¢Íâ¼üʧ°ÜµÄÎÊÌâ

½ñÌ죬ÓÃNavicatΪÁ½ÕÅ±í½¨Á¢Í⽡¹ØÏµ£¬×ÜÊÇÌáʾ´´½¨Ê§°ÜÐÅÏ¢£¬·¢ÏÖÊÇÁ½ÕÅ±í¹ØÁªµÄ×Ö¶ÎÀàÐÍÎÊÌ⣬µ«Á½¸ö×ֶζ¼ÊÇintÐÍÁ¨£¬Ôõô»á»¹»áÀàÐͲ»Ò»ÖÂÄØ£¬×îºó·¢ÏÖµ½Ò»¸öµØ·½Óе㲻һÑù£¬¾ÍÊÇÔÚ“Éè¼Æ±í”½çÃæÏ·½Óиö“ÎÞ·ûºÅ”µÄ¸´Ñ¡¿ò£¬Á½ÕűíµÄÖ÷¼ü×Ö¶ÎÆäÖÐÒ»¸öû¹´Ñ¡ÉÏÕâ¸ö¸´Ñ¡¿ò¶øµ¼ÖÂËäÈ»¶¼ÊÇintÀàÐÍ£ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ