¹ØÓÚ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
Ó÷þÎñ·
Ïà¹ØÎĵµ£º
LAST_INSERT_ID
×Ô¶¯·µ»Ø×îºóÒ»¸ö INSERT »ò UPDATE ²Ù×÷Ϊ AUTO_INCREMENT ÁÐÉèÖõĵÚÒ»¸ö·¢ÉúµÄÖµ. ²Î¿¼ÕâÀï
The ID that was generated is maintained in the server on a per-connection basis.
LAST_INSERT_IDÊÇ»ùÓÚµ¥¸öconnectionµÄ, ²»¿ÉÄܱ»ÆäËüµÄ¿Í»§¶ËÁ¬½Ó¸Ä±ä¡£
¿ÉÒÔÓà SELECT LAST_INSERT_ID(); ²éѯLAST ......
×¢£º±¾ÎÄÌÖÂ۵ķ¶Î§ÎªÎ´ÆôÓÃMAXDBģʽµÄ±í£¡
½ñÌ콨ÁËÒ»¸ö±í£¬ÀïÃæÓÐÒ»¸öÁÐÊÇtimestampÀàÐÍ£¬ÎÒ±¾ÒâÊÇÔÚÊý¾Ý¸üÐÂʱ£¬Õâ¸ö×ֶεÄʱ¼äÄÜ×Ô¶¯¸üС£ÆñÖª¶ÔÕâ¸öÀàÐ͵ÄÖµ»¹²»ÉõÁ˽⣬µ¼Ö³ö´í¡£·¢ÏÖÕâ¸ö×Ö¶ÎÖ»ÊÇÔÚÕâÐÐÊý¾Ý½¨Á¢µÄʱºòÓÐÖµ£¬ÔÚ¸üеÄÈ´Îޱ仯¡£
²éÕÒ×ÊÁÏ£¬·¢ÏÖÊÇÎÒ ......
Ò»´ÎNginx+PHP+MysqlµÄ²¢·¢²âÊÔ¾Àú
Ò»¡¢Ó²¼þ»·¾³
CPU:4ºËIntel(R) Xeon(R) CPU E5504 @ 2.00GHz
6GÄڴ棬120GÓ²ÅÌ
¶þ¡¢Èí¼þ»·¾³
L ......
±¸·ÝMySQLÊý¾Ý¿âµÄÃüÁî
mysqldump -hhostname -uusername -ppassword databasename > backupfile.sql
±¸·ÝMySQLÊý¾Ý¿âΪ´øÉ¾³ý±íµÄ¸ñʽ
±¸·ÝMySQLÊý¾Ý¿âΪ´øÉ¾³ý±íµÄ¸ñʽ£¬Äܹ»Èøñ¸·Ý¸²¸ÇÒÑÓÐÊý¾Ý¿â¶ø²»ÐèÒªÊÖ¶¯É¾³ýÔÓÐÊý¾Ý¿â¡£
mysqldump -–add-drop-table -uusername -ppassword databasename > backu ......
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 ......