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

MYSQLÈçºÎʵÏÖ×Ô¶¯±¸·Ý

ÔÚXP»òÕßLinuxϵͳÏÂÈçºÎʵÏÖMYSQL ÔÚÿÌìijһʱ¶ÎµÄʱºò×Ô¶¯±¸·Ý¡£¡£!

¿ÉÒԲο¼Ò»ÏÂÊÖ²áÖÐÒÔÏÂÄÚÈÝ¡£

MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc/refman/5.1/zh/index.html


5.9. ±¸·ÝÓë»Ö¸´
5.9.1. Êý¾Ý¿â±¸·Ý
5.9.2. ʾÀýÓñ¸·ÝÓë»Ö¸´²ßÂÔ

ÒýÓÃ8.8. mysqldump£ºÊý¾Ý¿â±¸·Ý³ÌÐò
mysqldump¿Í»§¶Ë¿ÉÓÃÀ´×ª´¢Êý¾Ý¿â»òËѼ¯Êý¾Ý¿â½øÐб¸·Ý»ò½«Êý¾Ý×ªÒÆµ½ÁíÒ»¸öSQL·þÎñÆ÷(²»Ò»¶¨ÊÇÒ»¸öMySQL·þÎñÆ÷)¡£×ª´¢°üº¬´´½¨±íºÍ/»ò×°ÔØ±íµÄSQLÓï¾ä¡£

Èç¹ûÄãÔÚ·þÎñÆ÷ÉϽøÐб¸·Ý£¬²¢ÇÒ±í¾ùΪMyISAM±í£¬Ó¦¿¼ÂÇʹÓÃmysqlhotcopy£¬ÒòΪ¿ÉÒÔ¸ü¿ìµØ½øÐб¸·ÝºÍ»Ö¸´¡£²Î¼û8.9½Ú£¬¡°mysqlhotcopy£ºÊý¾Ý¿â±¸·Ý³ÌÐò¡±¡£

ÓÐ3ÖÖ·½Ê½À´µ÷ÓÃmysqldump£º

shell> mysqldump [options] db_name [tables]
shell> mysqldump [options] ---database DB1 [DB2 DB3...]
shell> mysqldump [options] --all--database
Èç¹ûûÓÐÖ¸¶¨Èκαí»òʹÓÃÁË---database»ò--all--databaseÑ¡ÏÔòת´¢Õû¸öÊý¾Ý¿â¡£

ÒªÏë»ñµÃÄãµÄ°æ±¾µÄmysqldumpÖ§³ÖµÄÑ¡ÏִÐÐmysqldump ---help¡£

Èç¹ûÔËÐÐmysqldumpûÓÐ--quick»ò--optÑ¡ÏmysqldumpÔÚת´¢½á¹ûǰ½«Õû¸ö½á¹û¼¯×°ÈëÄÚ´æ¡£Èç¹ûת´¢´óÊý¾Ý¿â¿ÉÄÜ»á³öÏÖÎÊÌâ¡£¸ÃÑ¡ÏîĬÈÏÆôÓ㬵«¿ÉÒÔÓÃ--skip-opt½ûÓá£

Èç¹ûʹÓÃ×îа汾µÄmysqldump³ÌÐòÉú³ÉÒ»¸öת´¢ÖØ×°µ½ºÜ¾É°æ±¾µÄMySQL·þÎñÆ÷ÖУ¬²»Ó¦Ê¹ÓÃ--opt»ò-eÑ¡Ïî¡£

mysqldumpÖ§³ÖÏÂÃæµÄÑ¡Ï

· ---help£¬-£¿

ÏÔʾ°ïÖúÏûÏ¢²¢Í˳ö¡£



ÒýÓÃ
¿ÉÒԲο¼Ò»ÏÂÊÖ²áÖÐÒÔÏÂÄÚÈÝ¡£

MySQL¹Ù·½Îĵµhttp://dev.mysql.com/doc/refman/5.1/zh/index.html


5.9. ±¸·ÝÓë


Ïà¹ØÎÊ´ð£º

eclipseÓëmySQLµÄÎÊÌâ - Java / Eclipse

ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂð£¿
Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡
²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË ......

MYSQLÈçºÎÓëC++Á¬½Ó£¿ - VC/MFC / Êý¾Ý¿â

ÎÒÊÇÐÂÊÖ£¬³õѧMYSQL£¬Óкܶ಻¶®£¬Íû´Í½Ì£¡£¡
±ÈÈç˵ÎÒн¨Ò»¸öMYSQLÊý¾Ý¿âUSER Êý¾Ý¿âÖÐÓбíLIST 
È»ºóÎÒÔÚVCÖÐн¨Ò»¸öMFC¶Ô»°¿ò¹¤³Ì£¬È»ºóÎÒÔõôÑù²ÅÄÜÓÃVC»ñµÃÊý¾Ý¿âÖбíµÄÊý¾Ý£¿
Ï£Íû¸ø³ö¾ßÌåµÄ²Ù×÷² ......

mysql Îļþ¶ÁÈ¡ - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

ÎÒ¼¸ÕÅmysql±í ·ÖÇø
È»ºó°Ñ·ÖÇø±íµ¥¶À¿½³öÀ´ 
ÀýÈ磺test.MYD test.MYI data.MYD data.MYI user.MYD user.MYI dem.MYD dem.MYI
ÎÒÏë¶ÁÈ¡ÕâËÄÕűíµÄÄÚÈÝ
¹ØÁªÊý¾ÝÕûºÏµ½Ò»ÕűíÖС£Õâ¸öÒªÔõô×öÄØ
ÓóÌÐòÔ ......

vc++ ÓÃmysql¹Ù·½ connector ³ö´í - VC/MFC / Êý¾Ý¿â

try
{
sql::Driver *driver;
sql::Connection *con;
//´´½¨Á¬½Ó
driver = get_driver_instance();
con = driver->connect("tcp://192.168.18.52:3306", "root", "1234 ......

mysqlµÄÊý¾Ýµ¼Èëµ½sql2000ÖУ¬Çë½Ì¸÷λ¡£

ÏÖÔÚÎÒÏë°ÑmysqlÊý¾ÝÀïµÄÊý¾Ý¿âÃû£ºmysqlDB,±íÃû£ºcdb_members£¬×ֶΰüº¬name password headpic addtime jifen 
SQLÊý¾Ý¿âÀï Êý¾Ý¿âÃû£ºsq_ha315a ±íÃû£ºfs_ms_user ×Ö¶ÎÒ²°üº¬name password headpic addti ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ