Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

MySQL 6 ÂÌÉ«¾«¼òBAT°æ

 
¹Ø¼ü×Ö: mysql6 mysql6ÏÂÔØ
×÷ΪһÃû¿ª·¢ÈËÔ±,ÎÒ¶ÔÂÌɫСÈí¼þÇéÓжÀÖÓ,ÒòΪÓÃÆðÀ´·½±ã¿ì½ÝÂï,±ãÓÚЯ´ø,Ò×ÓÚÔÚÑÝʾϵͳÖÐʹÓÃ,¿ª·¢Ê±¿ÉÁ¢¼´½øÈë״̬. £¨ÔÚ¸½¼þÖУ©
ÒÔÏÂÊÇÏêϸ˵Ã÷:
MySQL 6 ÂÌÉ«¾«¼ò°æ(BAT°æ±¾)
        MySQL 6 Ö§³ÖÍâ¼ü,ÊÓͼ´æ´¢¹ý³Ì,ÊÂÎñµÈ¹¦ÄÜ(ÂÌÉ«¾«¼ò°æ²âÊÔͨ¹ý,Ö§³ÖÕâЩ¹¦ÄÜ),·Ç³£·½±ã½øÐпª·¢(ÓÈÆäÊÇMyEclipseÉú³ÉÒ»¶Ô¶à,¶à¶Ô¶àµÄ Hibernate/JPAÓ³Éä´úÂë,¾Í¸ü·½±ã¿ì½ÝÁË,ÊÂÎñ¹¦ÄÜÔò¿ÉÒÔ¼ìÑéHibernate»òÕßSpringÕûºÏHibernateʱÊÇ·ñÕýÈ·´¦ÀíÁËÊÂÎñ,Èç¹ûʧ°ÜµÄ»°»áÎÞ·¨ÕæÕý²åÈëÊý¾Ý). °æ±¾ÊÇ: 6.0.5alpha. ΪÁË·½±ã¿ª·¢,°ÑÆô¶¯ºóµÄĬÈϱàÂ뷽ʽÉèÖóÉΪÁËGBK.¿ÉÒÔÅäºÏMySQL-Front»òÕß¿ªÔ´Èí¼þHeidiSQLÀ´¹ÜÀíÊý¾Ý¿â. ¶øÅäºÏÃâ·ÑµÄMySQL¹ÜÀí¹¤¾ß µ¼º½Ã¨Ãâ·Ñ°æ(Navicat Lite),¿É»ñµÃ²»µÍÓÚSQL ServerµÄÒ×ÓöÈ, ÀýÈç¿ÉÊÓ»¯½¨±í, Ð޸ıí½á¹¹, ´´½¨Íâ¼ü, ÐÞ¸ÄÊý¾Ý, Ö´ÐвéѯµÈ¹¦ÄÜ,´ËÈí¼þµÄÖÐÎÄ°æ¿ÉÒÔÔÚhttp://www.navicat.com.cn/download.html ÏÂÔØ:*
Navicat for MySQL ¼òÌåÖÐÎÄ
(Windows°æ)
*·ÇÉÌҵʹÓà8.0.27 7.7 MB  
µØÖ·1 http://www.navicat.com/download/navicat8lite_mysql_cs.exe 
MySQL 6 ÂÌÉ«°æʹÓÃÅú´¦Àí(BAT)ÏÂÔصØÖ·
http://dl3.csdn.net/fd.php?i=55495248124426&s=20bda884a80d085e0dc9eb9ba37d2820
MySQL 6 ÂÌÉ«°æʹÓÃÅú´¦Àí(BAT)ÏÂÔصØÖ·ÎļþÖ´ÐÐ,¿ÉÒÔËæÒâÆô¶¯Í£Ö¹,ʹÓ÷dz£·½±ã,Ò²ºÜÈÝÒ××÷Ϊ¿ª·¢ÑÝʾ»òÕß×÷Ϊ×îÖÕ²úÆ·µÄÒ»²¿·Ö·¢²¼.
    ʹÓÃ: ÏÂÔغó½âѹËõµ½´ÅÅÌÉϵÄÈÎÒâĿ¼, ¿ÉÒÔ¿´µ½¶à³öÁËÒ»¸ö mysql6green µÄĿ¼. ´ò¿ªÕâ¸öĿ¼, ÓÐÒÔϵļ¸¸öÎļþ:Îļþ ËµÃ÷
[bin]  MySQL µÄ¶þ½øÖÆÎļþ
[data] MySQL Êý¾Ý¿âÎļþ
[share] MySQL Ó¢ÎÄ×ÊÔ´Îļþ
mysql_start.bat Æô¶¯ MySQL, Ë«»÷ºóÈç¹ûûÓдíÎóµÄ»°¿ÉÒÔÔÚϵͳ½ø³ÌÖп´µ½ mysqld-nt.exe, ²¢ÇÒ¿ÉÒÔͨ¹ý mysql ¹ÜÀí¹¤¾ßÁ¬½ÓÉÏ, ¶Ë¿Ú 3306, Óû§Ãû root, ÃÜÂëΪ¿Õ
mysql_stop.bat Í£Ö¹ MySQL
mysqlÂÌÉ«°æ.htm ½éÉÜÎļþ
     Ô­Àí: Ê×ÏÈÖ»±£ÁôÁË MySQL µÄ×îÉÙÔËÐÐÎļþÀ´¼õÉÙËùÕ¼ÓõĿռä. µ±È»Èç¹ûÄãÔ¸ÒâµÄ»°ÁôÏÂËùÓÐµÄ Mysql 6 ³ÌÐòÎļþҲûÓÐÎÊÌâ. È»ºó¸ù¾Ý mysqladmin.exe ºÍ mysqld-nt.exe µÄÃüÁîÐвÎÊý½øÐй¤×÷. mysqld-nt.exe --verbose --help ¿ÉÒÔ¿´µ½ËùÓÐÄܹ»Ê¹ÓõIJÎÊý.
mysq


Ïà¹ØÎĵµ£º

ubuntu°²×°MySQL£¬Apache

 °²裝MySQL-Server
$ sudo apt-get install mysql-server
°²裝Apache HTTP Server
$ sudo apt-get install apache2
°²裝PHP for Apache HTTP Server
$ sudo apt-get install php5
°²裝MySQL for Apache HTTP Server
$ sudo apt-get install libapache2-mod-auth-mysql
$ sudo apt-get ......

¿ÉÁ¯µÄSun¹«Ë¾£¬ÒòΪÊÕ¹ºÁËMySQL£¬ÏëÂô×Ô¼º¶¼Âô²»ÁËÁË

write by ¾ÅÌìÑãôá(JTianLing) -- blog.csdn.net/vagrxie ÌÖÂÛÐÂÎÅ×é¼°Îļþ ½ñÌì¿´µ½CSDNÉϵÄÒ»ÔòÐÂÎÅ¡¶Å·ÃËÕýʽ·ñ¾ö¼×¹ÇÎÄÊÕ¹ºSun ¼×¹ÇÎľÝÀíÁ¦Õù¡·ºóÕæÊǸÐ̾°¡¡£¡£¡£¡£ SunÒ²ËãÊÇÊ¢¼«Ò»Ê±µÄ´ó¹«Ë¾ÁË£¬ÒòΪJAVAÓïÑÔ¶øÎÅÃûÓÚÊÀ£¬ºóÀ´¹ÉƱ´úÂ붼¸Ä³ÉJAVAÁË£¬ËäÈ»JAVAʵ¼ÊÉÏûÓÐΪÆä´øÀ´Ì«¶àµÄÀûÈ󣬵«ÊÇSunÒ²ËãÊÇÄܹ»×Ô¼ ......

ͨ¹ý·ÖÇø£¨Partition£©ÌáÉýMySQLÐÔÄÜ

°³½ñÌìÕâô¼¤¶¯ÓÖÏëдÎÄÕµÄÔ­ÒòÊÇMySQL5.1µÄ·¢²¼´øÀ´ÁËÉè¼Æ³¬Ç¿¶¯Á¦Êý¾Ý¿âµÄÇ¿ÓÐÁ¦µÄÎäÆ÷£¬ÈκÎMySQLµÄDBA¶¼Ó¦¸Ã¾¡¿ìѧϰ²¢Ê¹ÓÃËü¡£°³¾õµÃÈç¹ûÄܺܺõÎʹÓÃÕâ¸ö5.1°æ´øÀ´µÄÐÂÌØÐÔ£¬DBA¿ÉÒÔʹ×Ô¼º¹ÜÀíµÄVLDB£¨²»ÖªµÀʲôÊÇVLDB£¿¸æËßÄ㣬ÊǺôóºÃ´óµÄÊý¾Ý¿âµÄÒâ˼£¬Very Large DB£©»òÊý¾Ý²Ö¿âÆæ¼£°ãµÄ»ñµÃ¾Þ´óµÄÐÔÄÜÌáÉý¡£ ......

MySQL²éѯµÄÐÔÄÜÓÅ»¯

²éѯÊÇÊý¾Ý¿â¼¼ÊõÖÐ×î³£ÓõIJÙ×÷¡£²éѯ²Ù×÷µÄ¹ý³Ì±È½Ï¼òµ¥£¬Ê×ÏÈ´Ó¿Í»§¶Ë·¢³ö²éѯµÄSQLÓï¾ä£¬Êý¾Ý¿â·þÎñ¶ËÔÚ½ÓÊÕµ½ÓÉ¿Í»§¶Ë·¢À´µÄSQLÓï¾äºó£¬Ö´ÐÐÕâÌõSQLÓï¾ä£¬È»ºó½«²éѯµ½µÄ½á¹û·µ»Ø¸ø¿Í»§¶Ë¡£ËäÈ»¹ý³ÌºÜ¼òµ¥£¬µ«²»Í¬µÄ²éѯ·½Ê½ºÍÊý¾Ý¿âÉèÖ㬶ԲéѯµÄÐÔÄܽ«»áÓкÜÔÚµÄÓ°Ïì¡£
Òò´Ë£¬±¾ÎľÍÔÚMySQLÖг£ÓõIJéѯÓÅ»¯¼¼Êõ½ø ......

ÀûÓÃmysqldumpµ¼³öµ¼ÈëmysqlËùÓÐÊý¾Ý¿â


1 µ¼³ö:
½øÈëÃüÁîÐÐ: Ö´ÐÐ
mysqldump -u username -p password –all-databases > all.sql
Ïêϸ²ÎÊý:
http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html
2 µ¼Èë
½øÈëmysql -u username -p password
Ö´ÐÐsource all.sql;
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ