MySql¼òÒױʼÇ
MySql¼òÒױʼÇ
1£º°²×°http://download.mysql.cn/src/2006/0710/5543.html£»
2£º´ò¿ªmysqlµÄCMD
3£º´´½¨Ò»¸öÊý¾Ý¿â¼°±í£º
mysql> CREATE DATABASE bbs;
mysql> CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20),
-> species VARCHAR(20), sex CHAR(1), birth DATE, death DATE);
4£º²é¿´£º
show databases;
show tabales;
describe pet;
5:µ¼³ö³É*.sqlÎļþ
ÔÚϵͳcmdÏÂʹÓÃÃüÁmysqljump -u root –p test > c:\test.sql
»ù±¾¹¦ÄܾʹËOK£¡
Ïà¹ØÎĵµ£º
×¢Ò⣺֮ǰÎÒÔÚÍøÉÏÕÒÁ˺öàµÄ×ÊÁÏ NND¶¼²»ÄÜÕý³£ÅäÖóɹ¦ ¸ãµÃÎÒÊǷdz£µØÓôÃÆ£¡
ÕÒµ½ÕâÆªÎÄÕÂÖ®ºóÎÒÖÕÓÚÅäÖóɹ¦ÁË£¡ÍÛºÃˬѽ£¡Ö»Òª°´ÕÕ ÉÏÃæµÄ²½Öè¾ÍÒ»¶¨Äܹ»³É¹¦µÄ£¡
´ËÎÄյݲװ·½·¨ÊÊÓÃÓÚWindows XPϵÄApache+PHP+MySQL°²×°£¬Í¬Ê±Ò²ÊÊÓÃÓÚWindows 2003ϵͳϵݲװºÍÅäÖá£
1. °²×°»·¾³
²Ù×÷ϵͳÊÇ Window ......
ÔÚwindowsÏ£º
´ò¿ªÃüÁîÐд°¿Ú£¬Í£Ö¹mysql·þÎñ£º Net stop mysql
Æô¶¯mysql£¬Ò»°ãµ½mysqlµÄ°²×°Â·¾¶£¬ÕÒµ½ mysqld-nt.exe
Ö´ÐУºmysqld-nt --skip-grant-tables µ±Ç°´°¿Ú½«»áÍ£Ö¹¡£
ÁíÍâ´ò¿ªÒ»¸öÃüÁîÐд°¿Ú£¬Ö´ÐÐmysql Èç¹ûÌáʾûÓÐÕâ¸öÃüÁÏȽøÈëMYSQL ......
ÔÚTOMCAϵÄCatalina\localhostĿ¼µÄ¹¤³Ìxml£¬±àдÈçÏ´úÂ룺
<Context path="/testProject" docBase="E:\project\TestProject\WebContent" reloadable="true" debug="0" privileged="true">
<Resource name="jdbc/mysql" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name=" ......
Ò»ÖÖ±íÇý¶¯,³ýÁËinnodb»¹ÓÐÆäËüµÄ,ÀýÈçisam,myisamµÈ.
innodbµÄÌØÉ«ÔÚÓÚÖ§³Ö²¢·¢Óë±í¼äÒýÓÃ
MySQLÖ§³Ö¶àÖÖ´æ´¢ÒýÇæ£¬Óû§¿ÉÒÔ·½±ãµÄÑ¡Óò»Í¬µÄ´æ´¢ÒýÇæÀ´Ö§³Ö×Ô¼ºµÄÓ¦Óã¬Ã¿ÖÖ²»Í¬µÄ´æ´¢ÒýÇæ¶¼ÓÐÆä×Ô¼ºµÄÌØÐÔ
InnodbÊÇÆäÖеÄÒ»ÖÖ´æ´¢ÒýÇæ£¬ËüµÄÌØÐÔÊÇÖ§³ÖÊÂÎñ£¬²¢ÇÒ²ÉÓÃ¶à°æ±¾²¢·¢¿ØÖƵķ½Ê½À´Ìá¸ß²¢·¢¶È
Ö÷Òª ......
×ÔÖú½¨Õ¾ÔËÓª/ÔËάϵͳ(jboss)°²×°Î¬»¤ÊÖ²á
1.Èí¼þ¸ÅÊö
1.1×ÔÖú½¨Õ¾ÔËÓª/ÔËάϵͳÊÇ»ùÓÚASPÔËӪģʽµÄÆóÒµÔËÓª¹ÜÀíÆ½Ì¨ÏµÍ³£¬ÓɶÀÁ¢µÄÓ¦Ó÷þÎñÆ÷·Ö±ðÌṩͳһÔËÓª¹ÜÀí¹¦ÄÜ¡¢
¸÷²úÆ·ÔËӪϵͳµÄ¹¦ÄÜ¡£
1.2¿ª·¢ÓïÑÔ
±¾ÏµÍ³²ÉÓÃJ2EE¼¼Êõ¼Ü¹¹£¬Ê¹Óõ½java, xml, xsl£¬javascript£¬htmlµÈ¸÷Ïî¼¼Êõ£¬Êý¾Ý¿âÊ¹Ó ......