¿ªÆôMYSQLÈÕÖ¾ÅäÖÃ
ÔÚ[mysqld] ÏÂÌí¼Ó²ÎÊýÈçÏÂ
#´íÎóÈÕÖ¾Êä³ö·¾¶(ʹÓÃ/×÷Ϊ·Ö¸î¶ø²»ÊÇ\)
log-error="your error-log path"
log="Your mysql log path"
log-show-queries="Your slowquery path"
#É趨³¬Ê±Ê±¼ä ´Ë´¦ÉèÖÃΪÁ½Ãë
long_query_time=2
Ok save my.ini
next
#Í£Ö¹mysql ·þÎñ
net stop mysql
#ÖØÐ¿ªÊ¼·þÎñ
net start mysql
Ïà¹ØÎĵµ£º
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| test &n ......
1.MemoryÒýÇæ,ÌṩÄÚ´æ±í
MySql Memory´æ´¢ÒýÇæ£¨Àϰ汾Ҳ½Ð×öheap´æ´¢ÒýÇæ£©£¬¹ËÃû˼ÒåÊÇÔÚÄÚ´æÖд洢ËùÓеÄÊý¾Ý£¬Ëü¾ßÓÐÒÔÏÂÁ½¸öÃ÷ÏÔÌØÕ÷£º
¢ÙÄÚ´æÖд洢Êý¾Ý£¬·Ç³£¸ßËÙ;
¢Úmysql¹Ø±ÕºóËùÓÐÊý¾ÝÏûʧ£¬mysqlÆô¶¯Ê±»á´´ ......
±¸·ÝÊý¾Ý¿âÃüÁî:
mysqldump -u root --password=root --database helloworld
>helloworld_backup.sql
ÆäËûÓ÷¨:
1.µ¼³öÕû¸öÊý¾Ý¿â
mysqldump -u Óû§Ãû -p Êý¾Ý¿âÃû > µ¼³öµÄÎļþÃû
mysqldump -u wcnc -p smgp_apps_wcnc > wcnc.sql
2.µ¼³öÒ»¸ö±í
mysqldump -u Óû§Ãû -p Êý¾Ý¿âà ......
1¡¢µ¼³ö
´ÓmysqlÊý¾Ý¿âÖе¼³ö´óÁ¿Êý¾Ý£¬ÍƼömysqldump ÃüÁÓÃÃüÁîµÄÓеãÔÚÓڱȹ¤¾ßÁé»î£¬¿ÉÒÔͨ¹ýÉèÖÃÃüÁîµÄ²ÎÊýÀ´¸ù¾ÝÌõ¼þµ¼³öÒ»¸ö±íÖеIJ¿·ÖÊý¾Ý
ÀýÈ磺½«Ò»¸ö±íµÄÊý¾Ý°´ÕÕÒ»¶¨µÄÌõ¼þµ¼³öµ½d:\sql1.sqlÎļþÖÐ
D:\MySQL5\bin>mysqldump -uÓû§Ãû -pÃÜÂë --no-create-db=TRUE --no-create-inf
o=TRUE --add-drop-t ......
ǰ¼¸Ì칫˾ÈÃÎÒ×öCÓïÑÔºÍMySQLÊý¾Ý¿âµÄ½»»¥²Ù×÷£¬·ÑÁ˾ÅÅ£¶þ»¢Ö®Á¦Ö®ºó×ÜËã×ö³öÀ´ÁË£¬½ñÌìÌØµØ°ÑÔ´´úÂëÌù³öÀ´¹©´ó¼Òѧϰ£»ÈçÓÐÈËÏëÒª´ò°üÏîÄ¿¿ÉÒÔ¼ÓÎÒQQ260990509,×¢Ã÷¼¼Êõ½»Á÷£¬¼´¿É»ñµÃ´ò°üÖ®ºóµÄÏîÄ¿£¡
#if defined(_WIN32) || defined(_WIN64) //ΪÁËÖ§³Öwindowsƽ̨ÉϵıàÒë
#include <windows.h>
#end ......