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

ÔÚMySQLÖе¼Èëµ¼³öÎļþ

Ç°Ì᣺MySQLÖдæÔÚÒ»¸öÓû§×Ô¼º½¨Á¢µÄÊý¾Ý¿â£¬¼ÙÉèΪmydb£¬mydbÖÐÓÐÒ»ÕÅÓû§×Ô¼º½¨Á¢µÄ±í¸ñ£¬¼ÙÉèÃû³ÆΪmytable
ÎÒµÄÇ°Ì᣺MySQLÖдæÔÚÁ½¸öÊý¾Ý¿â£¬yldbºÍyldb2£¬ÆäÖÐyldbÊý¾Ý¿âÖÐÓÐÒ»ÕÅ±í£¬ÃûΪpet
Ò».MYSQLµÄÃüÁîÐÐģʽµÄÉèÖãº
×ÀÃæ->ÎҵĵçÄÔ->ÊôÐÔ->»·¾³±äÁ¿->н¨->
PATH=“£»path\mysql\bin;”ÆäÖÐpathΪMYSQLµÄ°²×°Â·¾¶¡£
ÔÚConfigure the MySQL Server 5.1 server instance¹ý³ÌÖÐÓÐÒ»ÏîÊÇÒªÌáʾÊÇ·ñ"Include Bin Directory in Windows PATH"£¬Ñ¡ÔñÁËÕâ¸öÑ¡ÏÏ൱ÓÚ°ÑMySQLµÄ¿ÉÖ´ÐÐÎļþ·¾¶£¨binµÄ·¾¶£©¼ÓÈëµ½ÁËWINDOWSϵͳµÄ»·¾³±äÁ¿ÖУ¬ÕâÑùMySQL¿ÉÒÔ´ÓwindowsµÄÃüÁîÐÐÆô¶¯ÁË¡£ 
 
¶þ.¼òµ¥µÄ½éÉÜÒ»ÏÂÃüÁîÐнøÈëMYSQLµÄ·½·¨£º
1.C:\>mysql -h hostname -u username -p
°´ENTER¼ü£¬µÈ´ýÈ»ºóÊäÈëÃÜÂë¡£ÕâÀïhostnameΪ·þÎñÆ÷µÄÃû³Æ£¬Èçlocalhost£¬usernameΪMYSQLµÄÓû§Ãû£¬Èçroot¡£
½øÈëÃüÁîÐкó¿ÉÒÔÖ±½Ó²Ù×÷MYSQLÁË¡£
2.¼òµ¥½éÉÜÒ»ÏÂMYSQLÃüÁ
   mysql->CREATE DATABASE dbname;//´´½¨Êý¾Ý¿â
   mysql->CREATE TABLE tablename;//´´½¨±í
   mysql->SHOW DATABASES;//ÏÔʾÊý¾Ý¿âÐÅÏ¢£¬ÓÐÄÇЩ¿ÉÓõÄÊý¾Ý¿â¡£
  mysql->USE dbname;//Ñ¡ÔñÊý¾Ý¿â
   mysql->SHOW TABLES;//ÏÔʾ±íÐÅÏ¢£¬ÓÐÄÇЩ¿ÉÓõıí
   mysql->DESCRIBE tablename;//ÏÔʾ´´½¨µÄ±íµÄÐÅÏ¢
 
Èý.´ÓÊý¾Ý¿âµ¼³öÊý¾Ý¿âÎļþ£º
1.½«Êý¾Ý¿âmydbµ¼³öµ½e:\mysql\mydb.sqlÎļþÖУº
´ò¿ª¿ªÊ¼->ÔËÐÐ->ÊäÈëcmd    ½øÈëÃüÁîÐÐģʽ
c:\>mysqldump -h localhost -u root -p mydb >e:\mysql\mydb.sql
È»ºóÊäÈëÃÜÂ룬µÈ´ýÒ»»áµ¼³ö¾Í³É¹¦ÁË£¬¿ÉÒÔµ½Ä¿±êÎļþÖмì²éÊÇ·ñ³É¹¦¡£
ÎÒÊäÈëµÄÊÇ
C:\Documents and Settings\yangliu>mysqldump -h localhost -u root -p -C -v yldb >
 e:\mysql\yldb.sql
 Enter password: *******
-- Connecting to localhost...
-- Retrieving table structure for table pet...
-- Sending SELECT query...
-- Retrieving rows...
-- Disconnecting from localhost...
¼ÓÈëÁË-C -v ¾Í¶à³öÁËÏÂÃæµÄÎåÐУ¬ÏÔʾÁ˾ßÌåµ¼³öµÄ¹ý³Ì¡£ÕâÑù¾Íµ¼³öÁËyldb.sqlÎļþµ½ÁËE:\mysql\ ÖÐ
2.
½«Êý¾Ý¿âmydbÖеÄmytableµ¼³öµ½e:\mysql\mytable.sqlÎļþÖУº
c:\>mysqldump -h lo


Ïà¹ØÎĵµ£º

jdbc Óë mysqlÁ¬½Ó

JDBCÁ¬½ÓMySQL
JDBCÁ¬½ÓMySQL
¼ÓÔؼ°×¢²áJDBCÇý¶¯³ÌÐò
Class.forName("com.mysql.jdbc.Driver");
Class.forName("com.mysql.jdbc.Driver").newInstance();
JDBC URL ¶¨ÒåÇý¶¯³ÌÐòÓëÊý¾ÝÔ´Ö®¼äµÄÁ¬½Ó
±ê×¼Óï·¨£º
<protocol£¨Ö÷ҪͨѶЭÒ飩>:<subprotocol£¨´ÎҪͨѶЭÒ飬¼´Çý¶¯³ÌÐòÃû³Æ£©>:<data so ......

CentOS ÉÏmysql¶Ë¿Ú3306µÄÎÊÌâ

½ñÌì×°ÁËһ̨Linuxϵͳ£¬ÒÔÇ°¶¼ÊÇRedHat£¬ºóÀ´Ìý˵ÓÐFedoraÁË£¬Ò»Ö±Ã»Óùý¡£ÕýºÃÏîÄ¿Àï»·¾³ÒªÓþÍÏëŪһ¸öÀ´ÍæÍ棬½á¹ûÏÖÔÚÈ˼Ò×îеÄÊÇCentOS£¬¾ÍÒ»ÕÅCD£¬ÆäËûµÄ¸ù¾ÝÐèÒª×Ô¼ºÉÏÍøDown£¬£¨ÎÒ²»Ï²»¶ÕâÑù×Ó¾Í×Ô¼ºÏÂÔØDVD°æ£©¡£°²×°ÍêÖ®ºóûÓÐͼÐνçÃ棬¶øÇÒûÓÐÌáʾÊäÈërootÃÜÂ룬»¹µÃµ½µ¥Óû§Ä£Ê½ÏÂÐ޸ġ£ºóÀ´ÏÂÔØÁËÒ»¸öͼÐÎ ......

myeclipse mysql²»ÈòåÈëÖÐÎÄ

 Ê×ÏÈ¿´¿´ jspÎļþ java³ÌÐòÀïÓÐûÓÐrequest.setCharacterEncoding("UTF-8");
  ×Ö·û±àÂëÎÊÌ⣬Êý¾Ý²åÈë¿âÖÐʱ£¬java±àÂëºÍÊý¾Ý¿â±àÂë²»Ò»Ö£¬µ¼Ö²åÈëÊý¾Ý¿âΪÂÒÂ룬¿´µ½Îª£¿£¿£¿£¿µÄÐÎʽ  
  ½«ÄãµÄjspÒ³Ãæ±àÂë¸ÄΪGBK£¬Êý¾Ý¿â¶ÔÓ¦±íµÄ±àÂëÒ²¸ÄΪGBK
  ±àÂëÒ»Ö£¬¾Í²»»á³öÏÖÂÒÂëÎÊÌâÁ ......

mysqlÃâ°²×°°æÅäÖÃÓëʹÓ÷½·¨

ÒÔmysql-noinstall-5.1.6(win32)ΪÀý
1>°ÑѹËõÎļþmysql-noinstall-5.1.6-alpha-win32.zip½âѹµ½Ò»¸öĿ¼Ï£¬ÔÚ»·¾³±äÁ¿ÖÐÉèÖÃMYSQL_HOME£¬°Ñ%MYSQL_HOME%\bin ¼Ó
Èëµ½ path¡£
2>´´½¨my.iniÅäÖÃÎļþ,ÄÚÈÝÈçÏ£º
[mysqld]
#ÉèÖÃbasedirÖ¸ÏòmysqlµÄ°²×°Â·¾¶
basedir=...\mysql
datadir=...\mysql\data
my.iniÎ ......

ͨ¹ýrpm°ü°²×°¡¢ÅäÖü°Ð¶ÔØmysqlµÄÏêϸ¹ý³Ì


¡¡¡¡ÒÔMySQL-server-4.0.14-0.i386.rpmΪÀý£¬·ÅÔÚ/dataĿ¼Ï 
¡¡¡¡cd /data 
¡¡¡¡rpm -ivh MySQL-server-4.0.14-0.i386.rpm 
¡¡¡¡°²×°Íê³ÉºóÔÚ/usr/share/mysqlĿ¼ÖлáÓÐÒ»¸ömysqlµÄÆô¶¯½Å±¾mysql.server¼°Ê¾ÀýÅäÖÃÎļþµÈ(Èçmy-huge.cnf¡¢my-large.cnf¡¢my-medium.cnf) 
¡¡¡¡¿½±´Ò»¸öʾÀýÅäÖÃÎ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ