¹ØÓÚMySQLµÄ1067´íÎó½â¾ö·½·¨
¡ù ¹ØÓÚMySQLµÄ1067´íÎó½â¾ö·½·¨ ¡ù
ÄÚÈÝ£º
*************
1
°²×°MYSQLºó¸ü¸ÄÁËROOTµÄÃÜÂëºóÓÃ
net startmysql
Æô¶¯Ê±ÎÒ¾ÍÓöµ½ÁËÕâÑùµÄÎÊÌ⣮ʹÓÃÒÔÏÂÃüÁîºó
c:\mysql\bin\mysqladmin-u root -p shutdown
ÔÙnet start mysql¾ÍûÓÐÕâ¸ö´íÎóÌáʾÁË!
*************
2
MySQLµÄ1067´íÎó
Q£ºÎÒµÄMysqlÅöµ½ÁË 1067 ´íÎó
´íÎóÐÅϢΪ£º
A system error has occurred.
System error 1067 has occurred.
The process terminated unexpectedly.
A£ºÔÚÎҵĻúÉϵĽâ¾ö°ì·¨ÊÇ£º
ÐÞ¸Ä%windir%\my.ini£¬Ôö¼Ó
[mysqld]
#ÉèÖÃbasedirÖ¸ÏòmysqlµÄ°²×°Â·¾¶
basedir=D:\Program\Tools\mysql
datadir=D:\Program\Tools\mysql\data
*************
3
ÒѾŪºÃÁË!!!
ºÃÏñÊÇÕâÑù……
mysql_install_db½Å±¾Ö»ÊÇÔÚ³õ´Î°²×°Ê±²ÅÐèÒªÔËÐÐÒ»´Î,Ö®ºó¾Í²»ÓÃÔÙÔËÐÐÁË,²»ÖªµÀÊDz»ÊÇÕâô»ØÊÂ.ÎÒ°Ñmysql.server¿½±´ÖÁ/etc/rc.d/init.d/ÖÐ,ÔËÐÐchkconfig mysql.server,ÖÁ´Ëmysql·þÎñÆ÷ÿ´Î¿ª»ú×Ô¶¯Æô¶¯,Ö»ÒªÉèÖúÃPATH,ÔÚÃüÁîÐÐÉÏÊäÈëmysql¾ÍÒ»Çи㶨!
¿´À´ÃþË÷µÄ¹ý³ÌʵÔÚÊÇÍ´¿à°¡,ÕâÒѾÕÛÄ¥ÎҺü¸ÌìÁË……
*************
4
ÎÊ£ºÎÒµÄMysqlÅöµ½ÁË 1067 ´íÎó
´íÎóÐÅϢΪ£º
A system error has occurred.
System error 1067 has occurred.
The process terminated unexpectedly.
´ð£º
½â¾ö°ì·¨£º
1.¼ì²éÄãµÄMysqlĿ¼ÓÐûÓиøϵͳµÄSystemÓû§È¨ÏÞ¡£
2.ɾ³ýµôÄãµÄ %WINDOWS%/my.ini Îļþ¡£
3.¼ì²éÄãµÄ c:/my.cnf ÎļþÅäÖÃÊÇ·ñÕýÈ·¡£
*************
5
¡¾¡î¡î¡î MySql¸ÅҪ˵Ã÷ ¡î¡î¡î¡¿
MySqlµÄĬÈÏ°²×°Ä¿Â¼ÊÇc:mysql£¬°²×°½áÊøºóûÓÐÈκÎÌáʾÐÅϢ˵°²×°½áÊø£¬ÇëµãFinish°´Å¥Ö®ÀàµÄ»°£¬Ö±½Ó¾ÍÍ˳öÁË¡£Èç¹ûÐèÒª°²×°µ½ÆäËûĿ¼£¬½¨ÒéÏÈ°²×°µ½c:mysql£¬È»ºóÔÙÕû¸öĿ¼moveµ½×Ô¼ºÏ£ÍûµÄµØ·½£¬ÀýÈçÒƶ¯µ½d:mysql Ö®ºó£¬ÐèÒª±à¼ d:mysqlmy-example.cnf £¨*.cnfµÄÎļþÔÚWindows 2000Öлᱻע²á³ÉΪ SpeedDialÎļþ£¬ÔÚ×ÊÔ´¹ÜÀíÆ÷ÖÐÎÞ·¨²Ù×÷£¬ÒªÓÃÃüÁîÐÐÀ´Æô¶¯notepad±à¼£¬ÀýÈçÔËÐÐnotepadd:mysqlmy-example.cnf £¬µ«ÊÇÕâ¸öÎļþÊÇUNIXϵͳϵÄÎı¾Îļþ¸ñʽ£¬ÔÚnotepadÖв»ÄÜÕýÈ·»»ÐУ¬¿ÉÒÔÓÃwrite´ò¿ª±à¼£¬
»òÕßÓÃwrite´ò¿ªºó±£´æÒ»´Î£¬ÔÙÓÃnotepad¾Í¿ÉÒÔ±à¼ÁË¡££©ÕÒµ½basedirÒ»ÐУ¬È¥µôÇ°ÃæµÄ“#”ºÅ×¢ÊÍ£¬½«ºóÃæµÄ·¾¶¸ÄΪÒƶ¯ºóµÄĿ¼£¨Ä¿Â¼·Ö¸ô·ûÒªÓÃбÏ߶ø²»ÊÇ·´Ð±Ïߣ©£¬È»ºóÁí´æΪ£ºc:my.cnf
Ó÷þÎñ·
Ïà¹ØÎĵµ£º
1. Í£µ½ÔËÐеÄmysql: /etc/init.d/mysql stop
2. ʹÓÃskip-grant-tablesÕâ¸öÑ¡ÏîÆô¶¯MySQL£º /usr/bin/mysqld_safe --skip-grant-tables &
3. ÏÖÔÚ¿ÉÒÔ²»ÓÃÃÜÂë½øÈëmysql ÁË¡£
# myql
>   ......
1. Mysql Åàѵ
1.1. ÅàѵĿµÄ
±¾ÎĵµÊÇÕë¶ÔMySQL Êý¾Ý¿â·½ÃæµÄ»ù´¡Åàѵ£¬ÎªÁËʹÏîÄ¿×é³ÉÔ±Äܹ»´ïµ½Ê¹ÓÃMySQL Êý¾Ý¿âµÄÄ¿µÄ¡£
1.2. Åàѵ¶ÔÏó
¿ª·¢ÈËÔ±
1.3. ³£Óôʼ°·ûºÅ˵Ã÷
³£Óôʣº
Mysql£ºÒ»ÖÖÃâ·ÑµÄ¿çƽ̨µÄÊý¾Ý¿âϵͳ
E:\mysql£º±íʾÊÇÔÚdos ÃüÁî´°¿ÚÏÂÃæ
mysql> ±íʾÊÇÔÚmysql µÄÃüÁîÐÐÏÂ
1.4 ......
¼Ù¶¨±ítbl_name¾ßÓÐÒ»¸öPRIMARY KEY»òUNIQUEË÷Òý£¬±¸·ÝÒ»¸öÊý¾Ý±íµÄ¹ý³ÌÈçÏ£º
1¡¢Ëø¶¨Êý¾Ý±í£¬±ÜÃâÔÚ±¸·Ý¹ý³ÌÖУ¬±í±»¸üÐÂ
mysql>LOCK
TABLES READ tbl_name;
¹ØÓÚ±íµÄËø¶¨µÄÏêϸÐÅÏ¢£¬½«ÔÚÏÂÒ»Õ½éÉÜ¡£
2¡¢µ¼³öÊý¾Ý
mysql>SELECT
* INTO OUTFILE ‘tbl_name.bak’ from tbl_name;
3¡¢½âË ......
Ê×ÏÈ·ÖÎöÂÒÂëµÄÇé¿ö
1.дÈëÊý¾Ý¿âʱ×÷ΪÂÒÂëдÈë
2.²éѯ½á¹ûÒÔÂÒÂë·µ»Ø
¾¿¾¹ÔÚ·¢ÉúÂÒÂëʱÊÇÄÄÒ»ÖÖÇé¿öÄØ£¿
ÎÒÃÇÏÈÔÚmysql ÃüÁîÐÐÏÂÊäÈë
show variables like '%char%';
²é¿´mysql ×Ö·û¼¯ÉèÖÃÇé¿ö:
mysql> show variables like '%char%';
+--------------------------+---------------------------------------- ......
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using MySql.Data.Types;
using MySql.Data.MySqlCl ......