Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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\
ʵÏֵŦÄܼܺòµ¥£¬´ó¼ÒÓ¦¸Ã»áÒ»¿´¾Í¶®µÄ¹þ


Ïà¹ØÎĵµ£º

mysqlµÄ±È½ÏÔËËã

ÔÚmenzhi007µÄblogÀï¿´µ½·Ç³£ÓÐÒâ˼µÄ¶«Î÷£ºhttp://hi.baidu.com/menzhi007/blog/item/c2e98551a18754848c54301c.html
ÔÚmysqlÊÖ²áÀ
http://www.phpchina.com/manual/mysql/functions.html#comparison-operators
MySQL°´ÕÕÒÔϹæÔò½øÐÐÊýÖµ±È½Ï£º
ÈôÓÐÒ»¸ö»òÁ½¸ö²ÎÊýΪ NULL£¬³ý·ÇNULL-safe <=> µÈËã·û£¬Ôò±È ......

MySQL server has gone away µÄ½â¾ö°ì·¨

ÓÐʱºòʹÓÃMySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)ÃüÁîÐе¼È뱸·Ýʱ»á³öÏÖ“MySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ) server has gone away”´íÎó£¬Õâ¿ÉÄÜÊÇÒòΪÆäÖÐһЩinsertÓï¾äµÄ´óС³¬³öÁËMySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)ĿǰÉèÖõĻº³åÇø´óС¡£
½â¾ö°ì·¨
1.ʹÓÃphpmyadmin ±¸·ÝMySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)µÄʱºò£¬Ö»Ñ¡Ôñ
Êý¾Ý: ......

MySQL Ë÷Òý¸ÅÊö hust ei

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

MySQL µÄ´¥·¢Æ÷¡¢´æ´¢¹ý³Ì¡¢º¯Êý¡¢ÊÓͼʵÑé

    ±¾ÊµÑéÍê³ÉÈçϽá¹û£º
    0. testÊý¾Ý¿â,userinfo Óû§ÐÅÏ¢±í ºÍ userinfolog Óû§ÐÅÏ¢ÈÕÖ¾±í
    1. ½¨Á¢Ò»¸öuserinfo±íÐÂÔö¼Ç¼ʱµÄ´¥·¢Æ÷,½«ÐÂÔöÈÕÖ¾¼ÓÈëµ½userinfolog
    2. ½¨Á¢Ò»¸öÏòuserinfo±íÐÂÔö¼Ç¼µÄ´æ´¢¹ý³Ì
    3. ¸ù¾ ......

mysql root ÃÜÂëÍü¼Ç£¿£¿£¿£¿

½ñÌì¸øÐÂÀ´µÄÔ±¹¤Á¬½ÓÊý¾Ý¿â£¬ÐÞ¸ÄÁËÒ»ÏÂmysql rootÓû§µÄÃÜÂ룬ÎÒÏÂÔØµÄÊÇ´ò°üµÄredMine£¬Ä¬ÈÏÃÜÂëÊǿգ¬ÐÞ¸ÄÃÜÂëÖ®ºóÖØÆôredmine£¬phpAdmin Á´½Ó²»ÉÏmysqlÊý¾Ý¿âÁË£¬ÎÒÒ²ÐÞ¸ÄÁËphpadminÎļþ¼ÐϵÄconfig.inc.phpµÄÃÜÂ룬»¹ÊDz»ÐУ¬Ìáʾ#1130 - Host 'localhost' is not allowed to connect to this MySQL server´íÎó£¬Ã÷ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ