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

¹ØÓÚ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Ŀ¼»ò


Ïà¹ØÎÊ´ð£º

MYSQL°²×°Ê§°Ü

ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£º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. 
¿ ......

MYSQLÓëSmartyµÄÓ¦ÓÃ

ÔÚÈýÊ®½²Óöµ½ÕâÑùÒ»¸öÎÊÌâ¾ÍÊÇÔËÐдúÂëʱ³öÏÖ´íÎó Fatal error: Call to undefined method mysql::fetch_array() in D:\WWW\news\index.php on line 12
£¬ÎÒ°Ñmysql::fetch_array() ¸Ä³Émysql::fetch_row() ÓÖ³öÏÖF ......

½éÉÜOracleºÍmysqlµÄÊé - Oracle / ·Ç¼¼ÊõÇø

ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......

ÐèÒªÊÓÆµ½Ì³ÌµÄÐÂÊÖ½ø php + mysql + apache ÅäÖÃ

Õâ¸öÊÓÆµ½²µÄºÜÏêϸ, ¶ÔÐÂÊַdz£ÓÐÓÃ, »ù±¾ÉÏÒ»¿´¾Í¶®
ÓÉÓÚÌ«´óÁË(50m, ÎÒÖ»ÄÜÉÏ´«20m), ÎÒÉÏ´«²»ÁË, Ö»ºÃÌù³öÏÂÔØµØÖ·
ÏÂÔØµØÖ·: http://ftel1.3800hk.com/0807/080720djxnzj.rar
ºÃ¶«Î÷,ϸö¿´¿´


......

ASP +Mysql proc

ÏëÇë½ÌÒ»¸öÎÊÌ⣬ASP+mysql »á²»»áÓÐÁ¬½ÓĬÈÏʱ¼ä¡£
ÎÒÓöµ½Ò»¸öÎÊÌ⣺ÎÒÔÚÒ³ÃæÉϰ´Ò»¸öSave°´Å¥£¬Õâ¸ö°´Å¥ÊÇÑ­»·ÔËÐÐ100ƪ insertÊý¾ÝµÄ´æ´¢¹ý³Ì¡£ asp´úÂëÓ¦¸ÃûÓдíµÄ£¬Êý¾ÝÎÒÊÇ·ÅÔÚÒ»¸öÊý×éµÄÈç¹ûÎÒÖ»±£´æ50¸öÊÇ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ