MySQL 升级方法指南大全第1/5页
{"4":"
\u4e0d\u517c\u5bb9\u7684\u53d8\u5316\uff1a\u7531\u4e8e5.0\u4e2d\u00a0DECIMAL\u00a0\u6570\u636e\u7c7b\u578b\u7684\u5b9e\u73b0\u65b9\u5f0f\u53d1\u751f\u4e86\u53d8\u5316\uff0c\u56e0\u6b64\u5982\u679c\u4f7f\u7528\u5c31\u7248\u672c\u7684\u5e93\u6587\u4ef6\u9700\u8981\u6ce8\u610f\u8fd9\u4e2a\u95ee\u9898\u00a0
\u4e0d\u517c\u5bb9\u7684\u53d8\u5316\uff1a\u57285.0.3\u4e2d\uff0cER_WARN_DATA_TRUNCATED\u00a0\u8b66\u544a\u7b26\u53f7\u6539\u540d\u4e3a\u00a0WARN_DATA_TRUNCATED\u00a0\u4e86\u00a0
MYSQL\u00a0\u7ed3\u6784\u4f53\u4e2d\u7684\u00a0reconnect\u00a0\u6807\u5fd7\u88ab\u00a0mysql_real_connect()\u00a0\u8bbe\u4e3a\u00a00\u3002\u00a0
4\u3001\u4ece\u00a0MySQL\u00a04.0\u00a0\u5347\u7ea7\u5230\u00a0MySQL\u00a04.1
\u670d\u52a1\u5668\u90e8\u5206\uff1a
\u4e0d\u517c\u5bb9\u7684\u53d8\u5316\uff1a\u4ee5\u4e0b\u597d\u51e0\u4e2a\u90fd\u662f\u9700\u8981\u91cd\u5efa\u6570\u636e\u8868\u7684\uff0c\u53ef\u4ee5\u4f7f\u7528\u00a0mysqldump\u00a0\u5bfc\u51fa\u8868\u540e\u91cd\u65b0\u5bfc\u56de\u53bb
\u5982\u679c\u57284.1.0\u52304.1.3\u7248\u672c\u7684MySQL\u4e2d\u521b\u5efa\u4e86\u5305\u542b\u00a0TIMESTAMP\u00a0\u5b57\u6bb5\u7684\u00a0InnoDB\u00a0\u8868\u3002\u5219\u5728\u5347\u7ea7\u52304.1.4\u53ca\u66f4\u9ad8\u65f6\u9700\u8981\u91cd\u5efa\u8868\uff0c\u56e0\u4e3a\u5b58\u50a8\u683c\u5f0f\u53d1\u751f\u53d8\u5316\u4e86\u00a0
\u4ece4.1.3\u5f00\u59cb\uff0cInnoDB\u00a0\u8868\u91c7\u7528\u540c\u4e00\u79cd\u5b57\u7b26\u96c6\u6bd4\u8f83\u51fd\u6570\u6765\u6bd4\u8f83\u90a3\u4e9b\u00a0\u975elatin1_swedish_ci\u00a0\u5b57\u7b26\u96c6\u4e14\u4e0d\u662f\u00a0BINARY\u00a0\u7684\u5b57\u7b26\u4e32\u00a0
\u5982\u679c\u57284.1.0\u52304.1.5\u7248\u672c\u7684MySQl\u4e2d\u5bf9\u00a0UTF8\u00a0\u5b57\u6bb5\u6216\u8005\u5176\u4ed6\u591a\u5b57\u8282\u5b57\u6bb5\u4f5c\u4e86\u524d\u7f00\u7d22\u5f15\uff0c\u5219\u5728\u5347\u7ea7\u52304.1.6\u53ca\u66f4\u9ad8\u65f6\u5fc5\u987b\u91cd\u5efa\u8868\u00a0
\u5982\u679c\u57284.1\u4e4b\u524d\uff0c\u6570\u636e\u5e93\u3001\u8868\u3001\u5b57\u6bb5\u3001\u7ea6\u675f\u540d\u4e2d\u4f7f\u7528\u4e86\u91cd\u97f3\u5b57\u7b26(\u5b57\u8282\u503c\u662f128\u5230255\u7684\u5b57\u7b26)\uff0c\u90a3\u4e48\u4e0d\u80fd\u76f4\u63a5\u5347\u7ea7\u52304.1\u3002\u56e0\u4e3a4.1\u4f7f\u7528\u00a0UTF8\u00a0\u6765\u5b58\u50a8\u5143\u6570\u636e\u540d\u3002\u00a0
\u5b57\u7b26\u4e32\u6839\u636e\u6807\u51c6SQL\u6765\u6bd4\u8f83\uff1a\u6bd4\u8f83\u4e4b\u524d\u4e0d\u5220\u9664\u672b\u5c3e\u7684\u7a7a\u683c\uff0c\u4ee5\u524d\u7528\u672b\u5c3e\u7a7a\u683c\u6269\u5c55\u4e86\u6bd4\u8f83\u77ed\u7684\u5b57\u7b26\u4e32\u3002\u73b0\u5728\u7684\u7ed3\u679c\u662f\u00a0'a'\u00a0>\u00a0'a\\t'\uff0c\u4ee5\u524d\u5219\u4e0d\u8fd9\u6837\u3002\u53ef\u4ee5\u7528\u00a0mysqlcheck\u00a0\u6765\u68c0\u67e5\u4e00\u4e0b\u6570\u636e\u8868\u00a0
MyISAM\u00a0\u73b0\u5728\u4f7f\u7528\u66f4\u597d\u7684\u6821\u9a8c\u548c\u7b97\u6cd5\u4e86\u00a0
\u4e0d\u517c\u5bb9\u7684\u53d8\u5316\uff1aMySQL\u628a\u5b57\u7b26\u4e32\u7c7b\u578b\u5b57\u6bb5\u7684\u957f\u5ea6\u5b9a\u4e49\u7406\u89e3\u4e3a\u5b57\u7b26\u957f\u5ea6\u800c\u4e0d\u662f\u5b57\u8282\u957f\u5ea6\u3002\u00a0
\u91cd\u8981\u63d0\u793a\uff1aMySQL\u00a04.1\u7528\u00a0UTF8\u00a0\u5b57\u7b26\u96c6\u5b58\u50a8\u6570\u636e\u8868\u540d\u548c\u5b57\u6bb5\u540d\u3002\u5982\u679c\u6709\u7528\u6807\u51c6\u00a07\u5b57\u8282\u00a0US-ASCII\u00a0\u8303\u56f4\u4e4b\u5916\u7684\u5b57\u7b26\u4f5c\u4e3a\u8868\u540d\/\u5b57\u6bb5\u540d\u7684\u8bdd\uff0c\u9700\u8981\u91cd\u5efa\u8868\u00a0
\u91cd\u8981\u63d0\u793a\uff1a\u5347\u7ea7\u52304.1.1\u6216\u66f4\u9ad8\u540e\uff0c\u5c31\u5f88\u96be\u964d\u7ea7\u56de\u52304.0\u62164.1\u4e86\uff0c\u56e0\u4e3a\u00a0InnoDB\u00a0\u4f7f\u7528\u4e86\u591a\u4e2a\u8868\u7a7a\u95f4\u7684\u7f18\u6545\u00a0
\u4e0d\u517c\u5bb9\u7684\u53d8\u5316\uff1aMySQL\u00a04.1.13\u652f\u6301\u8ba9\u6bcf\u4e2a\u8fde\u63a5\u8bbe\u5b9a\u65f6\u533a\uff0c\u56e0\u6b64\u7cfb\u7edf\u53d8\u91cf\u00a0timezone\u00a0\u6539\u6210\u00a0system_time_zone\u00a0
\u6240\u6709\u7684\u6570\u636e\u8868\u548c\u975e\u4e8c\u8fdb\u5236\u5b57\u7b26\u4e32(CHAR,\u00a0VARCHAR,\u00a0\u548c\u00a0TEXT)\u7684\u5b57\u6bb5\u90fd\u6709\u5b57\u7b26\u96c6\uff0c\u4e8c\u8fdb\u5236\u5b57\u7b26\u4e32\u5b57\u6bb5\u5305\u62ec\u00a0BINARY,\u00a0VARBINARY,\u00a0\u548c\u00a0BLOB\u00a0
MySQL4.0\u4e2d\uff0c\u5982\u679c\u6709\u5b57\u6bb5\u7c7b\u578b\u4e3a\u00a0CHAR\u00a0BINARY\u00a0\u6216\u00a0VARCHAR\u00a0BINARY\uff0c\u5219\u5b83\u4eec\u4f1a\u88ab\u5f53\u4f5c\u4e8c\u8fdb\u5236\u5b57\u7b26\u4e32\u7c7b\u578b\u00a0
\u5982\u679c\u6570\u636e\u8868\u7684\u5b57\u6bb5\u4e2d\u5b58\u50a8\u7740MySQL\u00a04.1\u76f4\u63a5\u5c31\u80fd\u652f\u6301\u7684\u5b57\u7b26\u96c6\u5b57\u7b26\u6570\u636e\u65f6\uff0c\u5219\u53ef\u4ee5\u5c06\u8fd9\u4e2a\u5b57\u6bb5\u7684\u503c\u8f6c\u6362\u6210\u7531\u5408\u9002\u7684\u5b57\u7b26\u96c6\u5b58\u50a8\u00a0
MySQL\u00a04.1\u4e2d\u5bf9\u6570\u636e\u7ed3\u6784\u63cf\u8ff0\u6587\u4ef6\u00a0.frm\u00a0\u7684\u683c\u5f0f\u7a0d\u4f5c\u6539\u8fdb\uff0c\u65b0\u7248\u672c\u80fd\u517c\u5bb9\u8fd9\u4e2a\u65b0\u683c\u5f0f\uff0c\u4f46\u662f\u65e7\u7248\u672c\u5219\u4e0d\u80fd\u00a0
windows\u4e0b\u7684\u670d\u52a1\u5668\u542f\u52a8\u65f6\u589e\u52a0\u00a0--shared-memory\u00a0\u9009\u9879\u5373\u53ef\u652f\u6301\u4ece\u672c\u5730\u5ba2\u6237\u7aef\u8fde\u63a5\u65f6\u4f7f\u7528\u5171\u4eab\u5185\u5b58\u00a0
\u4e0d\u517c\u5bb9\u7684\u53d8\u5316\uff1a\u4eceMySQL\u00a04.1.1\u5f00\u59cb\uff0c\u5bf9\u7528\u6237\u81ea\u5b9a\u4e49\u51fd\u6570\u96c6\u5408\u63a5\u53e3\u53d1\u751f\u4e86\u5f88\u5927\u6539\u8fdb\u00a0
\u4e0d\u517c\u5bb9\u7684\u53d8\u5316\uff1a\u4ece4.1.10a\u5f00\u59cb\uff0c\u9664\u975e\u548c\u4e3b\u51fd\u6570\u4e4b\u95f4\u6709\u8f85\u52a9\u7684\u94fe\u63a5\uff0c\u5426\u5219\u670d\u52a1\u5668\u5c06\u4e0d\u518d\u9ed8\u8ba4\u5730\u52a0\u8f7d\u7528\u6237\u81ea\u5b9a\u4e49\u51fd\u6570(UDFs)\uff0c\u4e5f\u53ef\u4ee5\u901a\u8fc7\u00a0--allow-suspicious-udfs\u00a0\u9009\u9879\u6765\u542f\u7528\u00a0
\u5ba2\u6237\u7aef\u90e8\u5206\uff1a
mysqldump\u00a0\u9ed8\u8ba4\u542f\u7528\u00a0--opt\u00a0\u548c\u00a0--quote-names\u00a0\u9009\u9879\u00a0
SQL\u90e8\u5206\uff1a
\u4e0d\u517c\u5bb9\u7684\u53d8\u5316\uff1a\u5b57\u7b26\u4e32\u6839\u636e\u6807\u51c6SQL\u6765\u6bd4\u8f83\uff0c\u5982\u4e0a\u9762\u7684\"\u670d\u52a1\u5668\u53d8\u5316\"\u90e8\u5206\u4e2d\u63d0\u5230\u7684\u00a0
\u4e0d\u517c\u5bb9\u7684\u53d8\u5316\uff1aTIMESTAMP\u00a0\u8fd4\u56de\u00a0'YYYY-MM-DD\u00a0HH:MM:SS'\u00a0\u683c\u5f0f\u7684\u5b57\u7b26\u4e32\u3002\u5728MySQL\u00a04.0\u4e2d\uff0c\u53ef\u4ee5\u589e\u52a0\u9009\u9879\u00a0--new\u00a0\u6765\u83b7\u5f97MySQL\u00a04.1\u4e2d\u8fd9\u65b9\u9762\u7684\u7279\u6027\u00a0
\u4e0d\u517c\u5bb9\u7684\u53d8\u5316\uff1a\u4e8c\u8fdb\u5236\u6570\u636e\u4f8b\u5982\u00a00xFFDF\u00a0\u88ab\u5f53\u6210\u5b57\u7b26\u4e32\u800c\u975e\u6570\u5b57\u00a0
\u4e0d\u517c\u5bb9\u7684\u53d8\u5316\uff1a\u5728MySQL\u00a04.1.1\u524d\uff0c\u8bed\u53e5\u89e3\u6790\u5668\u4e0d\u662f\u90a3\u4e48\u4e25\u683c\uff0c\u5b83\u5728\u5904\u7406\u5b57\u7b26\u4e32\u8f6c\u65f6\u95f4\u8f6c\u6362\u65f6\u4f1a\u5ffd\u7565\u7b2c\u4e00\u4e2a\u6570\u5b57\u524d\u7684\u5176\u4ed6\u5b57\u7b26\u3002\u57284.1.1\u4e4b\u540e\uff0c\u5c31\u6bd4\u8f83\u4e25\u683c\u4e86\u00a0
\u4e0d\u517c\u5bb9\u7684\u53d8\u5316\uff1a\u5728MySQL\u00a04.1.2\uff0cSHOW\u00a0TABLE\u00a0STATUS\u00a0\u7ed3\u679c\u7684\u00a0Type\u00a0\u5b57\u6bb5\u6539\u540d\u4e3a\u00a0Engine\u00a0\u4e86\u00a0
\u5f53\u6267\u884c\u591a\u8868\u5220\u9664\u8bed\u53e5\u65f6\uff0c\u8981\u5220\u9664\u7684\u8868\u53ea\u80fd\u4f7f\u7528\u5b83\u7684\u522b\u540d\uff0c\u800c\u4e0d\u80fd\u7528\u771f\u5b9e\u8868\u540d\u00a0
\u8fd4\u56de\u7ed3\u679c\u662f\u00a0DATE,\u00a0DATETIME,\u00a0\u6216\u00a0TIME\u00a0\u7c7b\u578b\u7684\u51fd\u6570\u7684\u7ed3\u679c\u4f1a\u88ab\u8f6c\u6362\u6210\u65f6\u95f4\u578b\u00a0
AUTO_INCREMENT\u00a0\u5b57\u6bb5\u4e0d\u80fd\u8bbe\u5b9a\u00a0\u9ed8\u8ba4(DEFAULT)\u00a0\u503c\u4e86\u00a0
LIMIT\u00a0\u4e0d\u518d\u63a5\u53d7\u8d1f\u6570\u53c2\u6570\u4e86\u00a0
SERIALIZE\u00a0\u4e0d\u518d\u662f\u00a0sql_mode\u00a0\u53d8\u91cf\u7684\u6709\u6548\u503c\u4e86\uff0c\u5b83\u7684\u53d6\u4ee3\u503c\u662f\u00a0SET\u00a0TRANSACTION\u00a0ISOLATION\u00a0LEVEL\u00a0SERIALIZABLE\u00a0
C\u00a0API\u90e8\u5206\uff1a
MySQL\u00a04.1\u4e2d\u7684\u5bc6\u7801\u54c8\u5e0c\u7b97\u6cd5\u505a\u4e86\u6539\u8fdb\u4ee5\u63d0\u5347\u5b89\u5168\u6027\uff0c\u4e0d\u8fc7\u4f1a\u5bfc\u81f4\u517c\u5bb9\u6027\u95ee\u9898\u3002\u4f7f\u7528MySQL\u00a04.0\u53ca\u66f4\u65e9\u7248\u672c\u7684\u5ba2\u6237\u7aef\u5e93\u6587\u4ef6\u4f1a\u53d1\u751f\u95ee\u9898\u3002\u00a0
\u4e0d\u517c\u5bb9\u7684\u53d8\u5316\uff1amysql_shutdown()\u00a0\u51fd\u6570\u589e\u52a0\u4e00\u4e2a\u53c2\u6570\uff1aSHUTDOWN-level\u00a0
\u67d0\u4e9b\u51fd\u6570\u4f8b\u5982\u00a0mysql_real_query()\u00a0\u53d1\u751f\u9519\u8bef\u65f6\u8fd4\u56de\u00a01\u00a0\u800c\u975e\u00a0-1\u00a0
\u5bc6\u7801\u5904\u7406\u90e8\u5206\uff1a
MySQL\u00a04.1\u4e2d\u7684\u5bc6\u7801\u54c8\u5e0c\u7b97\u6cd5\u505a\u4e86\u6539\u8fdb\u4ee5\u63d0\u5347\u5b89\u5168\u6027\uff0c\u4e0d\u8fc7\u4f1a\u5bfc\u81f4\u517c\u5bb9\u6027\u95ee\u9898\u3002\u4f7f\u7528MySQL\u00a04.0\u53ca\u66f4\u65e9\u7248\u672c\u7684\u5ba2\u6237\u7aef\u5e93\u6587\u4ef6\u4f1a\u53d1\u751f\u95ee\u9898\u3002\u89e3\u51b3\u529e\u6cd5\u6709\uff1a
\u5347\u7ea7\u5ba2\u6237\u7aef\u5e93\u6587\u4ef6\u52304.1(\u4e0d\u7528\u5347\u7ea7\u670d\u52a1\u5668\u7aef\u5e93\u6587\u4ef6)\u00a0
\u8fd0\u884c\u00a0mysql_fix_privilege_tables\u00a0\u811a\u672c\u6765\u52a0\u5bbd\u00a0user\u00a0\u8868\u4e2d\u7684\u00a0Password\u00a0\u5b57\u6bb5\u503c\uff0c\u4ee5\u9002\u5e94\u65b0\u7684\u54c8\u5e0c\u7b97\u6cd5\u3002\u5982\u679c\u60f3\u8981\u5141\u8bb84.1\u4ee5\u4e0b\u7684\u5ba2\u6237\u7aef\u8fd8\u80fd\u8fde\u63a5\u5230\u670d\u52a1\u5668\uff0c\u90a3\u4e48\u670d\u52a1\u5668\u8fd0\u884c\u65f6\u8981\u589e\u52a0\u53c2\u6570\u00a0--old-passwords\u00a0
5\u3001\u9644\u5f55
1\u3001)\u00a0\u5728Windows\u5e73\u53f0\u4e0a\u5347\u7ea7MySQL\u6b65\u9aa4\uff1a
\u5907\u4efd\u65e7\u6570\u636e\u00a0
\u505c\u6b62\u65e7\u670d\u52a1\u5668\u00a0
\u4ecewindows\u7684\u7cfb\u7edf\u670d\u52a1\u4e2d\u5220\u6389mysql\u670d\u52a1\uff0c\u7528\u5982\u4e0b\u547d\u4ee4\uff1a
C:\\>\u00a0C:\\mysql\\bin\\mysqld\u00a0--remove\u7528\u53ef\u6267\u884c\u5b89\u88c5\u6587\u4ef6\u65b9\u5f0f\u5b89\u88c5mysql\uff0c\u6216\u8005\u89e3\u538b\u53ef\u76f4\u63a5\u6267\u884c\u7684\u4e8c\u8fdb\u5236\u538b\u7f29\u5305\u6765\u5b89\u88c5\u00a0
\u91cd\u65b0\u6ce8\u518cmysql\u670d\u52a1\uff0c\u7528\u5982\u4e0b\u547d\u4ee4\uff1a
C:\\>\u00a0C:\\mysql\\bin\\mysqld\u00a0--install\u00a0\u00a0\u91cd\u542f\u670d\u52a1\u5668\u00a0
\u5176\u4ed6\u7684\u95ee\u9898\u8be6\u89c1\u4e0a\u9762\u63d0\u5230\u7684\u5404\u79cd\u5347\u7ea7\u4e2d\u4f1a\u78b0\u5230\u7684\u60c5\u51b5\u00a0
2\u3001)\u00a0\u5347\u7ea7\u6388\u6743\u8868
\u4e0d\u517c\u5bb9\u7684\u53d8\u5316\uff1a\u7531\u4e8e5.0\u4e2d\u00a0DECIMAL\u00a0\u6570\u636e\u7c7b\u578b\u7684\u5b9e\u73b0\u65b9\u5f0f\u53d1\u751f\u4e86\u53d8\u5316\uff0c\u56e0\u6b64\u5982\u679c\u4f7f\u7528\u5c31\u7248\u672c\u7684\u5e93\u6587\u4ef6\u9700\u8981\u6ce8\u610f\u8fd9\u4e2a\u95ee\u9898\u00a0
\u4e0d\u517c\u5bb9\u7684\u53d8\u5316\uff1a\u57285.0.3\u4e2d\uff0cER_WARN_DATA_TRUNCATED\u00a0\u8b66\u544a\u7b26\u53f7\u6539\u540d\u4e3a\u00a0WARN_DATA_TRUNCATED\u00a0\u4e86\u00a0
MYSQL\u00a0\u7ed3\u6784\u4f53\u4e2d\u7684\u00a0reconnect\u00a0\u6807\u5fd7\u88ab\u00a0mysql_real_connect()\u00a0\u8bbe\u4e3a\u00a00\u3002\u00a0
4\u3001\u4ece\u00a0MySQL\u00a04.0\u00a0\u5347\u7ea7\u5230\u00a0MySQL\u00a04.1
\u670d\u52a1\u5668\u90e8\u5206\uff1a
\u4e0d\u517c\u5bb9\u7684\u53d8\u5316\uff1a\u4ee5\u4e0b\u597d\u51e0\u4e2a\u90fd\u662f\u9700\u8981\u91cd\u5efa\u6570\u636e\u8868\u7684\uff0c\u53ef\u4ee5\u4f7f\u7528\u00a0mysqldump\u00a0\u5bfc\u51fa\u8868\u540e\u91cd\u65b0\u5bfc\u56de\u53bb
\u5982\u679c\u57284.1.0\u52304.1.3\u7248\u672c\u7684MySQL\u4e2d\u521b\u5efa\u4e86\u5305\u542b\u00a0TIMESTAMP\u00a0\u5b57\u6bb5\u7684\u00a0InnoDB\u00a0\u8868\u3002\u5219\u5728\u5347\u7ea7\u52304.1.4\u53ca\u66f4\u9ad8\u65f6\u9700\u8981\u91cd\u5efa\u8868\uff0c\u56e0\u4e3a\u5b58\u50a8\u683c\u5f0f\u53d1\u751f\u53d8\u5316\u4e86\u00a0
\u4ece4.1.3\u5f00\u59cb\uff0cInnoDB\u00a0\u8868\u91c7\u7528\u540c\u4e00\u79cd\u5b57\u7b26\u96c6\u6bd4\u8f83\u51fd\u6570\u6765\u6bd4\u8f83\u90a3\u4e9b\u00a0\u975elatin1_swedish_ci\u00a0\u5b57\u7b26\u96c6\u4e14\u4e0d\u662f\u00a0BINARY\u00a0\u7684\u5b57\u7b26\u4e32\u00a0
\u5982\u679c\u57284.1.0\u52304.1.5\u7248\u672c\u7684MySQl\u4e2d\u5bf9\u00a0UTF8\u00a0\u5b57\u6bb5\u6216\u8005\u5176\u4ed6\u591a\u5b57\u8282\u5b57\u6bb5\u4f5c\u4e86\u524d\u7f00\u7d22\u5f15\uff0c\u5219\u5728\u5347\u7ea7\u52304.1.6\u53ca\u66f4\u9ad8\u65f6\u5fc5\u987b\u91cd\u5efa\u8868\u00a0
\u5982\u679c\u57284.1\u4e4b\u524d\uff0c\u6570\u636e\u5e93\u3001\u8868\u3001\u5b57\u6bb5\u3001\u7ea6\u675f\u540d\u4e2d\u4f7f\u7528\u4e86\u91cd\u97f3\u5b57\u7b26(\u5b57\u8282\u503c\u662f128\u5230255\u7684\u5b57\u7b26)\uff0c\u90a3\u4e48\u4e0d\u80fd\u76f4\u63a5\u5347\u7ea7\u52304.1\u3002\u56e0\u4e3a4.1\u4f7f\u7528\u00a0UTF8\u00a0\u6765\u5b58\u50a8\u5143\u6570\u636e\u540d\u3002\u00a0
\u5b57\u7b26\u4e32\u6839\u636e\u6807\u51c6SQL\u6765\u6bd4\u8f83\uff1a\u6bd4\u8f83\u4e4b\u524d\u4e0d\u5220\u9664\u672b\u5c3e\u7684\u7a7a\u683c\uff0c\u4ee5\u524d\u7528\u672b\u5c3e\u7a7a\u683c\u6269\u5c55\u4e86\u6bd4\u8f83\u77ed\u7684\u5b57\u7b26\u4e32\u3002\u73b0\u5728\u7684\u7ed3\u679c\u662f\u00a0'a'\u00a0>\u00a0'a\\t'\uff0c\u4ee5\u524d\u5219\u4e0d\u8fd9\u6837\u3002\u53ef\u4ee5\u7528\u00a0mysqlcheck\u00a0\u6765\u68c0\u67e5\u4e00\u4e0b\u6570\u636e\u8868\u00a0
MyISAM\u00a0\u73b0\u5728\u4f7f\u7528\u66f4\u597d\u7684\u6821\u9a8c\u548c\u7b97\u6cd5\u4e86\u00a0
\u4e0d\u517c\u5bb9\u7684\u53d8\u5316\uff1aMySQL\u628a\u5b57\u7b26\u4e32\u7c7b\u578b\u5b57\u6bb5\u7684\u957f\u5ea6\u5b9a\u4e49\u7406\u89e3\u4e3a\u5b57\u7b26\u957f\u5ea6\u800c\u4e0d\u662f\u5b57\u8282\u957f\u5ea6\u3002\u00a0
\u91cd\u8981\u63d0\u793a\uff1aMySQL\u00a04.1\u7528\u00a0UTF8\u00a0\u5b57\u7b26\u96c6\u5b58\u50a8\u6570\u636e\u8868\u540d\u548c\u5b57\u6bb5\u540d\u3002\u5982\u679c\u6709\u7528\u6807\u51c6\u00a07\u5b57\u8282\u00a0US-ASCII\u00a0\u8303\u56f4\u4e4b\u5916\u7684\u5b57\u7b26\u4f5c\u4e3a\u8868\u540d\/\u5b57\u6bb5\u540d\u7684\u8bdd\uff0c\u9700\u8981\u91cd\u5efa\u8868\u00a0
\u91cd\u8981\u63d0\u793a\uff1a\u5347\u7ea7\u52304.1.1\u6216\u66f4\u9ad8\u540e\uff0c\u5c31\u5f88\u96be\u964d\u7ea7\u56de\u52304.0\u62164.1\u4e86\uff0c\u56e0\u4e3a\u00a0InnoDB\u00a0\u4f7f\u7528\u4e86\u591a\u4e2a\u8868\u7a7a\u95f4\u7684\u7f18\u6545\u00a0
\u4e0d\u517c\u5bb9\u7684\u53d8\u5316\uff1aMySQL\u00a04.1.13\u652f\u6301\u8ba9\u6bcf\u4e2a\u8fde\u63a5\u8bbe\u5b9a\u65f6\u533a\uff0c\u56e0\u6b64\u7cfb\u7edf\u53d8\u91cf\u00a0timezone\u00a0\u6539\u6210\u00a0system_time_zone\u00a0
\u6240\u6709\u7684\u6570\u636e\u8868\u548c\u975e\u4e8c\u8fdb\u5236\u5b57\u7b26\u4e32(CHAR,\u00a0VARCHAR,\u00a0\u548c\u00a0TEXT)\u7684\u5b57\u6bb5\u90fd\u6709\u5b57\u7b26\u96c6\uff0c\u4e8c\u8fdb\u5236\u5b57\u7b26\u4e32\u5b57\u6bb5\u5305\u62ec\u00a0BINARY,\u00a0VARBINARY,\u00a0\u548c\u00a0BLOB\u00a0
MySQL4.0\u4e2d\uff0c\u5982\u679c\u6709\u5b57\u6bb5\u7c7b\u578b\u4e3a\u00a0CHAR\u00a0BINARY\u00a0\u6216\u00a0VARCHAR\u00a0BINARY\uff0c\u5219\u5b83\u4eec\u4f1a\u88ab\u5f53\u4f5c\u4e8c\u8fdb\u5236\u5b57\u7b26\u4e32\u7c7b\u578b\u00a0
\u5982\u679c\u6570\u636e\u8868\u7684\u5b57\u6bb5\u4e2d\u5b58\u50a8\u7740MySQL\u00a04.1\u76f4\u63a5\u5c31\u80fd\u652f\u6301\u7684\u5b57\u7b26\u96c6\u5b57\u7b26\u6570\u636e\u65f6\uff0c\u5219\u53ef\u4ee5\u5c06\u8fd9\u4e2a\u5b57\u6bb5\u7684\u503c\u8f6c\u6362\u6210\u7531\u5408\u9002\u7684\u5b57\u7b26\u96c6\u5b58\u50a8\u00a0
MySQL\u00a04.1\u4e2d\u5bf9\u6570\u636e\u7ed3\u6784\u63cf\u8ff0\u6587\u4ef6\u00a0.frm\u00a0\u7684\u683c\u5f0f\u7a0d\u4f5c\u6539\u8fdb\uff0c\u65b0\u7248\u672c\u80fd\u517c\u5bb9\u8fd9\u4e2a\u65b0\u683c\u5f0f\uff0c\u4f46\u662f\u65e7\u7248\u672c\u5219\u4e0d\u80fd\u00a0
windows\u4e0b\u7684\u670d\u52a1\u5668\u542f\u52a8\u65f6\u589e\u52a0\u00a0--shared-memory\u00a0\u9009\u9879\u5373\u53ef\u652f\u6301\u4ece\u672c\u5730\u5ba2\u6237\u7aef\u8fde\u63a5\u65f6\u4f7f\u7528\u5171\u4eab\u5185\u5b58\u00a0
\u4e0d\u517c\u5bb9\u7684\u53d8\u5316\uff1a\u4eceMySQL\u00a04.1.1\u5f00\u59cb\uff0c\u5bf9\u7528\u6237\u81ea\u5b9a\u4e49\u51fd\u6570\u96c6\u5408\u63a5\u53e3\u53d1\u751f\u4e86\u5f88\u5927\u6539\u8fdb\u00a0
\u4e0d\u517c\u5bb9\u7684\u53d8\u5316\uff1a\u4ece4.1.10a\u5f00\u59cb\uff0c\u9664\u975e\u548c\u4e3b\u51fd\u6570\u4e4b\u95f4\u6709\u8f85\u52a9\u7684\u94fe\u63a5\uff0c\u5426\u5219\u670d\u52a1\u5668\u5c06\u4e0d\u518d\u9ed8\u8ba4\u5730\u52a0\u8f7d\u7528\u6237\u81ea\u5b9a\u4e49\u51fd\u6570(UDFs)\uff0c\u4e5f\u53ef\u4ee5\u901a\u8fc7\u00a0--allow-suspicious-udfs\u00a0\u9009\u9879\u6765\u542f\u7528\u00a0
\u5ba2\u6237\u7aef\u90e8\u5206\uff1a
mysqldump\u00a0\u9ed8\u8ba4\u542f\u7528\u00a0--opt\u00a0\u548c\u00a0--quote-names\u00a0\u9009\u9879\u00a0
SQL\u90e8\u5206\uff1a
\u4e0d\u517c\u5bb9\u7684\u53d8\u5316\uff1a\u5b57\u7b26\u4e32\u6839\u636e\u6807\u51c6SQL\u6765\u6bd4\u8f83\uff0c\u5982\u4e0a\u9762\u7684\"\u670d\u52a1\u5668\u53d8\u5316\"\u90e8\u5206\u4e2d\u63d0\u5230\u7684\u00a0
\u4e0d\u517c\u5bb9\u7684\u53d8\u5316\uff1aTIMESTAMP\u00a0\u8fd4\u56de\u00a0'YYYY-MM-DD\u00a0HH:MM:SS'\u00a0\u683c\u5f0f\u7684\u5b57\u7b26\u4e32\u3002\u5728MySQL\u00a04.0\u4e2d\uff0c\u53ef\u4ee5\u589e\u52a0\u9009\u9879\u00a0--new\u00a0\u6765\u83b7\u5f97MySQL\u00a04.1\u4e2d\u8fd9\u65b9\u9762\u7684\u7279\u6027\u00a0
\u4e0d\u517c\u5bb9\u7684\u53d8\u5316\uff1a\u4e8c\u8fdb\u5236\u6570\u636e\u4f8b\u5982\u00a00xFFDF\u00a0\u88ab\u5f53\u6210\u5b57\u7b26\u4e32\u800c\u975e\u6570\u5b57\u00a0
\u4e0d\u517c\u5bb9\u7684\u53d8\u5316\uff1a\u5728MySQL\u00a04.1.1\u524d\uff0c\u8bed\u53e5\u89e3\u6790\u5668\u4e0d\u662f\u90a3\u4e48\u4e25\u683c\uff0c\u5b83\u5728\u5904\u7406\u5b57\u7b26\u4e32\u8f6c\u65f6\u95f4\u8f6c\u6362\u65f6\u4f1a\u5ffd\u7565\u7b2c\u4e00\u4e2a\u6570\u5b57\u524d\u7684\u5176\u4ed6\u5b57\u7b26\u3002\u57284.1.1\u4e4b\u540e\uff0c\u5c31\u6bd4\u8f83\u4e25\u683c\u4e86\u00a0
\u4e0d\u517c\u5bb9\u7684\u53d8\u5316\uff1a\u5728MySQL\u00a04.1.2\uff0cSHOW\u00a0TABLE\u00a0STATUS\u00a0\u7ed3\u679c\u7684\u00a0Type\u00a0\u5b57\u6bb5\u6539\u540d\u4e3a\u00a0Engine\u00a0\u4e86\u00a0
\u5f53\u6267\u884c\u591a\u8868\u5220\u9664\u8bed\u53e5\u65f6\uff0c\u8981\u5220\u9664\u7684\u8868\u53ea\u80fd\u4f7f\u7528\u5b83\u7684\u522b\u540d\uff0c\u800c\u4e0d\u80fd\u7528\u771f\u5b9e\u8868\u540d\u00a0
\u8fd4\u56de\u7ed3\u679c\u662f\u00a0DATE,\u00a0DATETIME,\u00a0\u6216\u00a0TIME\u00a0\u7c7b\u578b\u7684\u51fd\u6570\u7684\u7ed3\u679c\u4f1a\u88ab\u8f6c\u6362\u6210\u65f6\u95f4\u578b\u00a0
AUTO_INCREMENT\u00a0\u5b57\u6bb5\u4e0d\u80fd\u8bbe\u5b9a\u00a0\u9ed8\u8ba4(DEFAULT)\u00a0\u503c\u4e86\u00a0
LIMIT\u00a0\u4e0d\u518d\u63a5\u53d7\u8d1f\u6570\u53c2\u6570\u4e86\u00a0
SERIALIZE\u00a0\u4e0d\u518d\u662f\u00a0sql_mode\u00a0\u53d8\u91cf\u7684\u6709\u6548\u503c\u4e86\uff0c\u5b83\u7684\u53d6\u4ee3\u503c\u662f\u00a0SET\u00a0TRANSACTION\u00a0ISOLATION\u00a0LEVEL\u00a0SERIALIZABLE\u00a0
C\u00a0API\u90e8\u5206\uff1a
MySQL\u00a04.1\u4e2d\u7684\u5bc6\u7801\u54c8\u5e0c\u7b97\u6cd5\u505a\u4e86\u6539\u8fdb\u4ee5\u63d0\u5347\u5b89\u5168\u6027\uff0c\u4e0d\u8fc7\u4f1a\u5bfc\u81f4\u517c\u5bb9\u6027\u95ee\u9898\u3002\u4f7f\u7528MySQL\u00a04.0\u53ca\u66f4\u65e9\u7248\u672c\u7684\u5ba2\u6237\u7aef\u5e93\u6587\u4ef6\u4f1a\u53d1\u751f\u95ee\u9898\u3002\u00a0
\u4e0d\u517c\u5bb9\u7684\u53d8\u5316\uff1amysql_shutdown()\u00a0\u51fd\u6570\u589e\u52a0\u4e00\u4e2a\u53c2\u6570\uff1aSHUTDOWN-level\u00a0
\u67d0\u4e9b\u51fd\u6570\u4f8b\u5982\u00a0mysql_real_query()\u00a0\u53d1\u751f\u9519\u8bef\u65f6\u8fd4\u56de\u00a01\u00a0\u800c\u975e\u00a0-1\u00a0
\u5bc6\u7801\u5904\u7406\u90e8\u5206\uff1a
MySQL\u00a04.1\u4e2d\u7684\u5bc6\u7801\u54c8\u5e0c\u7b97\u6cd5\u505a\u4e86\u6539\u8fdb\u4ee5\u63d0\u5347\u5b89\u5168\u6027\uff0c\u4e0d\u8fc7\u4f1a\u5bfc\u81f4\u517c\u5bb9\u6027\u95ee\u9898\u3002\u4f7f\u7528MySQL\u00a04.0\u53ca\u66f4\u65e9\u7248\u672c\u7684\u5ba2\u6237\u7aef\u5e93\u6587\u4ef6\u4f1a\u53d1\u751f\u95ee\u9898\u3002\u89e3\u51b3\u529e\u6cd5\u6709\uff1a
\u5347\u7ea7\u5ba2\u6237\u7aef\u5e93\u6587\u4ef6\u52304.1(\u4e0d\u7528\u5347\u7ea7\u670d\u52a1\u5668\u7aef\u5e93\u6587\u4ef6)\u00a0
\u8fd0\u884c\u00a0mysql_fix_privilege_tables\u00a0\u811a\u672c\u6765\u52a0\u5bbd\u00a0user\u00a0\u8868\u4e2d\u7684\u00a0Password\u00a0\u5b57\u6bb5\u503c\uff0c\u4ee5\u9002\u5e94\u65b0\u7684\u54c8\u5e0c\u7b97\u6cd5\u3002\u5982\u679c\u60f3\u8981\u5141\u8bb84.1\u4ee5\u4e0b\u7684\u5ba2\u6237\u7aef\u8fd8\u80fd\u8fde\u63a5\u5230\u670d\u52a1\u5668\uff0c\u90a3\u4e48\u670d\u52a1\u5668\u8fd0\u884c\u65f6\u8981\u589e\u52a0\u53c2\u6570\u00a0--old-passwords\u00a0
5\u3001\u9644\u5f55
1\u3001)\u00a0\u5728Windows\u5e73\u53f0\u4e0a\u5347\u7ea7MySQL\u6b65\u9aa4\uff1a
\u5907\u4efd\u65e7\u6570\u636e\u00a0
\u505c\u6b62\u65e7\u670d\u52a1\u5668\u00a0
\u4ecewindows\u7684\u7cfb\u7edf\u670d\u52a1\u4e2d\u5220\u6389mysql\u670d\u52a1\uff0c\u7528\u5982\u4e0b\u547d\u4ee4\uff1a
C:\\>\u00a0C:\\mysql\\bin\\mysqld\u00a0--remove\u7528\u53ef\u6267\u884c\u5b89\u88c5\u6587\u4ef6\u65b9\u5f0f\u5b89\u88c5mysql\uff0c\u6216\u8005\u89e3\u538b\u53ef\u76f4\u63a5\u6267\u884c\u7684\u4e8c\u8fdb\u5236\u538b\u7f29\u5305\u6765\u5b89\u88c5\u00a0
\u91cd\u65b0\u6ce8\u518cmysql\u670d\u52a1\uff0c\u7528\u5982\u4e0b\u547d\u4ee4\uff1a
C:\\>\u00a0C:\\mysql\\bin\\mysqld\u00a0--install\u00a0\u00a0\u91cd\u542f\u670d\u52a1\u5668\u00a0
\u5176\u4ed6\u7684\u95ee\u9898\u8be6\u89c1\u4e0a\u9762\u63d0\u5230\u7684\u5404\u79cd\u5347\u7ea7\u4e2d\u4f1a\u78b0\u5230\u7684\u60c5\u51b5\u00a0
2\u3001)\u00a0\u5347\u7ea7\u6388\u6743\u8868