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

Ò»¶Î×Ô¶¯±¸·ÝµÄMYSQL±¸·ÝµÄ½Å±¾

     ×î½ü¹«Ë¾×¼±¸Ê¹ÓÃÏîÄ¿¹ÜÀíµÄÍøÕ¾DotProject£¬¹«Ë¾ËäÈ»²»´ó£¬µ«ÊÇÇ£Éæµ½µÄÒµÎñÒ²ÊǺܸ´Ôӵģ¬ËùÒÔÐèÒª¶¨Ê±È¥±£´æÊý¾Ý¿âµÄÐÅÏ¢ÒÔ·ÀÖ¹Êý¾Ý¿â±ÀÀ£»òÕ߯äËûµÄÔ­ÒòÔì³ÉµÄÊý¾ÝËðʧ£¬ÕâÑù¾ÍÐèÒª½øÐÐÊý¾Ý¿âµÄ±¸·Ý¡£
     DotProjectʹÓõÄÊÇMysqlÊý¾Ý¿â£¬±¸·ÝMysqlÊý¾Ý¿âµÄÒ»¸ö±È½ÏºÃµÄ·½·¨¾ÍÊÇÀ䱸·Ý£¨½«´æ´¢ÎļþÖ±½Ó¿½±´³öÀ´£©¡£ËùÒÔÎÒдÁËÒ»¸öС½Å±¾£¬È»ºóʹÓÃWindowsµÄÈÎÎñ¼Æ»®¹¦ÄÜʵÏÖÕâ¼þÊÂÇé¡£
     ½Å±¾µÄÄÚÈÝÈçÏ£º
@echo off
if exist E:\DotprojectBackup\%date:~8,2%\DotprojectDatabase\ ( del /f /s /Q E:\DotprojectBackup\%date:~8,2%\DotprojectDatabase\)
if exist E:\DotprojectBackup\%date:~8,2%\DotprojectSite\ ( del /f /s /Q E:\DotprojectBackup\%date:~8,2%\DotprojectSite\)
mkdir E:\DotprojectBackup\%date:~8,2%\DotprojectDatabase\
mkdir E:\DotprojectBackup\%date:~8,2%\DotprojectSite\
net stop mysql
xcopy D:\AppServ\MySQL\data\dotproject\*.* E:\DotprojectBackup\%date:~8,2%\DotprojectDatabase\ /y
net start mysql
xcopy D:\AppServ\www\dotProject /e /h /k /y E:\DotprojectBackup\%date:~8,2%\DotprojectSite\
ʵÏֵŦÄܼܺòµ¥£¬´ó¼ÒÓ¦¸Ã»áÒ»¿´¾Í¶®µÄ¹þ


Ïà¹ØÎĵµ£º

½â¾ö ubuntu ÉϵÄmysqlÎÞ·¨Ô¶³Ì·ÃÎÊ

ÔÚUbuntu9.10ÉÏʹÓÃsudo apt-get install mysql-server-5.0 °²×°ÁËmysql£¬ÔÚÍâÃæ·ÃÎʲ»ÁËmysql,µ«ÊÇÔÚUbuntuÉÏ·ÃÎÊÊÇûÓÐÎÊÌâµÄ¡£
ÓÚÊÇ¿ªÊ¼²éÕÒÔ­Òò£º
3306¶Ë¿ÚÊDz»ÊÇûÓдò¿ª£¿
ʹÓÃnestatÃüÁî²é¿´3306¶Ë¿Ú״̬£º
~# netstat -an | grep 3306
tcp        0    ......

mysql°²×°µÄ¹ý³Ì

   ½ñÌìÖØÐÂ×°ÁËÒ»ÏÂmysqlÊý¾Ý¿â£¬½ØÖ¹µ½ÏÖÔÚÒѺÄʱ2£º30£¬ÓôÃÆ£¡£¡£¡£¡£¨ÎÒÔ­À´²»ÖªµÀ×°¹ý¶àÉÙ´Îmysql£©
   ËùÒÔÎÒ¾ö¶¨£¬°Ñ¹ØÓÚmysqlÊý¾Ý¿âµÄ³õʼ»¯²Ù×÷½éÉÜÒ»ÏÂ
£º
    1.°²×°mysqlÊý¾Ý¿â
       http://www.duote.com/tech/1/2430_1.html
  ......

MySQL Ë÷Òý¸ÅÊö hust ei

±¾ÎĽéÉÜÁËÊý¾Ý¿âË÷Òý£¬¼°ÆäÓÅ¡¢È±µã¡£Õë¶ÔMySQLË÷ÒýµÄÌØµã¡¢Ó¦ÓýøÐÐÁËÏêϸµÄÃèÊö¡£·ÖÎöÁËÈçºÎ±ÜÃâMySQLÎÞ·¨Ê¹Óã¬ÈçºÎʹÓÃEXPLAIN·ÖÎö²éѯÓï¾ä£¬ÈçºÎÓÅ»¯MySQLË÷ÒýµÄÓ¦Óᣱ¾ÎÄÕª×Ô¡¶MySQL 5ȨÍþÖ¸ÄÏ¡·(3rd)µÄ8.9½Ú¡£(2007.07.05×îºó¸üÐÂ)
    Ë÷ÒýÊÇÒ»ÖÖÌØÊâµÄÎļþ(InnoDBÊý¾Ý±íÉϵÄË÷ÒýÊDZí¿Õ¼äµÄÒ»¸ö× ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ