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

mysqlµÄµ¼ÈëºÍµ¼³ö

1¡¢µ¼³ö
´ÓmysqlÊý¾Ý¿âÖе¼³ö´óÁ¿Êý¾Ý£¬ÍƼömysqldump ÃüÁÓÃÃüÁîµÄÓеãÔÚÓڱȹ¤¾ßÁé»î£¬¿ÉÒÔͨ¹ýÉèÖÃÃüÁîµÄ²ÎÊýÀ´¸ù¾ÝÌõ¼þµ¼³öÒ»¸ö±íÖеIJ¿·ÖÊý¾Ý
ÀýÈ磺½«Ò»¸ö±íµÄÊý¾Ý°´ÕÕÒ»¶¨µÄÌõ¼þµ¼³öµ½d:\sql1.sqlÎļþÖÐ
D:\MySQL5\bin>mysqldump -uÓû§Ãû -pÃÜÂë --no-create-db=TRUE --no-create-inf
o=TRUE --add-drop-table=FALSE --default-character-set="gbk" --where="id<428
7152 and id>0" Êý¾Ý¿âÃû ±íÃû>d:\sql1.sql
--no-create-db=TRUE  ±íʾ²»Éú³É´´½¨Êý¾Ý¿âµÄÓï¾ä
--add-drop-table=FALSE  ±íʾ²»Éú³Édrop±íµÄÓï¾ä
--default-character-set="gbk"  µ¼³öÊý¾ÝµÄ±àÂëΪ"GBK",ºÜÖØÒª£¬Èç¹ûÊÇÖÐÎÄÊý¾Ý£¬ÓÈÆäÖØÒª
--where="id<4287152 and id>0"  Ö¸¶¨µ¼³öÊý¾ÝµÄÌõ¼þ
2¡¢µ¼Èë
use Êý¾Ý¿âÃû
source d:\sql1.sql
3¡¢µ¼³öÒ»¸öÊý¾Ý¿â
msyqldump -uroot -p123456 db_name > 1
4¡¢µ¼³öÒ»¸ö±í½á¹¹£¬²¢´ø±íÖÐÊý¾Ý
mysqldump -uroot -p123456 db_name table_name > 1


Ïà¹ØÎĵµ£º

mysql²é¿´Êý¾Ý¿â´óС£¬Ë÷Òý´óС

mysql> use information_schema
Database changed
mysql> select concat(round(sum(index_LENGTH)/(1024*1024),2),'MB') as 'Data Size' from tables where table_schema='bbs';
+-----------+
| Data Size |
+-----------+
| 0.00MB    |
+-----------+
1 row in set (0.01 sec)
½âÊÍ£º
......

mysqlµÄ±¸·ÝºÍ»¹Ô­µÄ±àÂëÎÊÌâ½â¾ö


½ñÌìÐèÒª´ÓÔ¶³Ì·þÎñÆ÷downÒ»¸öuchomeµÄÊý¾Ý¿âÏÂÀ´£¬ÔÚ±¾µØ»¹Ô­¡£
·¢ÏÖÒ»¸öºÜ²»Ë¬µÄÊÂÇ飺Զ³Ì8G£¬NºËµÄlinux»úÆ÷£¬±¸·Ý»¹Ô­²Ù×÷˳ÁïÁïµÄ£¬¿ÉÊÇÔÚ±¾µØµÄwindows£¬2GÆÕͨPCÉÏ£¬²Å100MµÄÎļþ£¬ÓÃuchome×Ô´øµÄ·Ö¾í±¸·Ý»¹Ô­£¬»ù±¾ÉÏÖм䶼»á¶Ïµô£¬ÒªÃ´Ìáʾ“Ö´ÐÐʱ¼ä¹ý³¤”£¨¸Ä³É200Ã룬·Ö¾íΪ20M¶¼²»ÐУ©£¬ÒªÃ´¾ÍÊ ......

MYSQL ×Ö·û¼¯¼°±àÂëÎÊÌâ

MySQLµÄ×Ö·û¼¯Ö§³Ö(Character Set Support)ÓÐÁ½¸ö·½Ã棺
     ×Ö·û¼¯(Character set)ºÍÁ¬½ÓУ¶Ô(Collation)¡£
¶ÔÓÚ×Ö·û¼¯µÄÖ§³Öϸ»¯µ½Ëĸö²ã´Î:
     ·þÎñÆ÷(server)£¬Êý¾Ý¿â(database)£¬Êý¾Ý±í(table)ºÍÁ¬½Ó(connection)¡£
1.MySQLĬÈÏ×Ö·û¼¯
  MySQL¶ÔÓÚ×Ö·û¼¯µÄ ......

jbpm4°²×°ÔÚÒÑÓеÄtomcatÓëmysqlÏÂ

1.JBPM4.3ÏÂÔØ(http://sourceforge.net/projects/jbpm)
2.ant°²×°:jBPMÏÂÔØ°üinstallĿ¼ÖÐÓÐÒ»¸öantµÄbuild.xmlÎļþ,ʹÓÃant -pÄã¿ÉÒÔ¿´µ½ËùÓеݲװ
    demo.setup.jboss£º°²×°jboss£¬°Ñjbpm°²×°µ½jbossÖУ¬ Æô¶¯jboss£¬´´½¨jbpmÊý¾Ý¿â±í½á¹¹£¬²¿ÊðʵÀý£¬¼ÓÔØʵÀýÉí·ÝÈÏÖ¤ÐÅÏ¢£¬ °²×°²¢Æô¶¯eclipse
&n ......

jbpm4°²×°ÔÚÒÑÓеÄtomcatÓëmysqlÏÂ

1.JBPM4.3ÏÂÔØ(http://sourceforge.net/projects/jbpm)
2.ant°²×°:jBPMÏÂÔØ°üinstallĿ¼ÖÐÓÐÒ»¸öantµÄbuild.xmlÎļþ,ʹÓÃant -pÄã¿ÉÒÔ¿´µ½ËùÓеݲװ
    demo.setup.jboss£º°²×°jboss£¬°Ñjbpm°²×°µ½jbossÖУ¬ Æô¶¯jboss£¬´´½¨jbpmÊý¾Ý¿â±í½á¹¹£¬²¿ÊðʵÀý£¬¼ÓÔØʵÀýÉí·ÝÈÏÖ¤ÐÅÏ¢£¬ °²×°²¢Æô¶¯eclipse
&n ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ