¹ØÓÚMYSQLµÄinnodb±í±¸·ÝµÄÎÊÌâ
ÇëÎÊÏÂÄÄλÈÊÐÖÓбȽϺõı¸·Ý·½°¸£¬ÓÃʲô¹¤¾ß»òÕßÓÃʲô·½Ê½£¬Ð¡µÜ½è¼øÏÂ
Ö±½ÓÓÃMYSQLDUMP±¸·Ý OR ÓÃSQLYOGÖ®ÀàµÄͼÐλ¯¹ÜÀí¹¤¾ß±¸·Ý Ö±½ÓÓÃmysql×Ô´øµÄ mysqldump ¾Í¿ÉÒÔÁË¡£ http://dev.mysql.com/doc/refman/5.1/zh/database-administration.html#disaster-prevention 5.9. ±¸·ÝÓë»Ö¸´ 5.9.1. Êý¾Ý¿â±¸·Ý 5.9.2. ʾÀýÓñ¸·ÝÓë»Ö¸´²ßÂÔ 5.9.3. ×Ô¶¯»Ö¸´ 5.9.4. ±íά»¤ºÍ±ÀÀ£»Ö¸´ 5.9.5. myisamchk£ºMyISAM±íά»¤ÊµÓù¤¾ß 5.9.6. ½¨Á¢±íά»¤¼Æ»® 5.9.7. »ñÈ¡¹ØÓÚ±íµÄÐÅÏ¢ ÒòΪijЩÔÒò£¬²»×¼±¸²ÉÓÃÖ±½ÓÓÃmysql×Ô´øµÄ mysqldump£¬ËùÒÔµÃÁíÏë°ì·¨ ÓÐûÓбȽϺõĵÚÈý·½Ëã·¨Á÷³ÌÒýÓà ÒòΪijЩÔÒò£¬²»×¼±¸²ÉÓÃÖ±½ÓÓÃmysql×Ô´øµÄ mysqldump£¬ËùÒÔµÃÁíÏë°ì·¨ ÄÇÄãµÄÐèÇóÊÇÊ²Ã´ÄØ£¿ ÓóÌÐòÖð±í±éÀú£¬È»ºó°ÑÊý¾Ýдµ½Îı¾ÎļþÖУ¿ÒýÓà ÓÐûÓбȽϺõĵÚÈý·½Ëã·¨Á÷³Ì ÄǾÍÖ»ÓÐÓÃSELECT INTO OUTFILE ºÇºÇ£¬ÊµÔÚ²»ÐÐÖ»ÄÜÓÃÕâÕÐÁË£¬ºÃÏñÌý˵ÓеÚÈý·½¿ªÔ´µÄ¹¤¾ßÔÚ×öÕâ¸ö£¬ÎÒÔÙÕÒÕÒ°É£¬Èç¹ûÕÒµ½£¬Ôٺʹó¼Ò¹²Ïí ²Î¿¼£ºhttp://blog.csdn.net/chuan122345/archive/2009/12/07/4956006.aspx ¿ÉÒÔÓÃSELECT * INTO OUTFILE 'file_name' from tbl_name Õâ¸öSQL Óï¾ä£¬Õâ¸öÎļþ½«ÔÚMYSQL ·þÎñÆ÷µÄÖ÷»úÉϱ»´´½¨£¬¶ø²»ÊÇÔÚ¿Í»§¶ËÖ÷»úÉÏ¡£Í¨¹ýÕâ¸öÓï¾äÉú³ÉÎļþʱ£¬Êä³öÎļþ²»ÄÜÒѾ´æÔÚ£¬ÒòΪ¸²¸ÇÎļþÓÐÊý¾Ý°²È«·½ÃæµÄ·çÏÕ¡£Õâ¸ö·½·¨¿ÉÒÔ±¸·ÝÈκÎÀàÐ͵ÄÊý¾ÝÎļþ£¬µ«Ö»Äܱ£´æ±íÊý¾Ý£¬²»Äܱ£´æ±í½á¹¹ À䱸»¹ÊÇÈȱ¸£¬ À䱸£¬¿ÉÒÔÖ±½Ó±¸·ÝdataĿ¼»ò
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4 mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓᣠ×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£ Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£ºError 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it. ¿ÉÊÇÎÒÕÒ ......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡ лл¸÷λÁË ¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î ±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡ ллÁË ¼Æ»®ÈÎÎñ...php....sql...truncate....OK Äã¾ÍÕâ½ÓÔÚҳà ......
ÎÒ¿ª·¢ASP.netʱ ²åÈëÍâÎÄÂÒÂë SHOW VARIABLES LIKE 'character%'; Õâ¸öʱºò character_set_client utf8 character_set_connection utf8 character_set_database utf8 ch ......