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

linuxϵ¼Èë¡¢µ¼³ömysqlÊý¾Ý¿âÃüÁî

Ò»¡¢µ¼³öÊý¾Ý¿âÓÃmysqldumpÃüÁעÒâmysqlµÄ°²×°Â·¾¶£¬¼´´ËÃüÁîµÄ·¾¶£©£º
1¡¢µ¼³öÊý¾ÝºÍ±í½á¹¹£º
mysqldump -uÓû§Ãû -p Êý¾Ý¿âÃû > Êý¾Ý¿âÃû.sql
#/usr/local/mysql/bin/mysqldump -uroot -p abc > abc.sql
Çûسµºó»áÌáʾÊäÈëÃÜÂë
2¡¢Ö»µ¼³ö±í½á¹¹
mysqldump -uÓû§Ãû -p -d Êý¾Ý¿âÃû > Êý¾Ý¿âÃû.sql
#/usr/local/mysql/bin/mysqldump -uroot -p -d abc > abc.sql
¶þ¡¢µ¼ÈëÊý¾Ý¿â
1¡¢Ê×ÏȽ¨¿ÕÊý¾Ý¿â
mysql>create database abc;
2¡¢µ¼ÈëÊý¾Ý¿â
·½·¨Ò»£º
£¨1£©Ñ¡ÔñÊý¾Ý¿â
mysql>use abc;
£¨2£©ÉèÖÃÊý¾Ý¿â±àÂë
mysql>set names utf8;
£¨3£©µ¼ÈëÊý¾Ý£¨×¢ÒâsqlÎļþµÄ·¾¶£©
mysql>source /home/abc/abc.sql;
·½·¨¶þ£º
mysql -uÓû§Ãû -p Êý¾Ý¿âÃû < Êý¾Ý¿âÃû.sql
#mysql -uabc_f -p abc < abc.sql
×¢Ò⣺ÓÐÃüÁîÐÐģʽ£¬ÓÐsqlÃüÁî


Ïà¹ØÎĵµ£º

GCCÔÚUbuntu Linuxϵݲװ

GCC±àÒ빤¾ßÔÚRed Hat/Fedora Core·¢ÐаæÖÐĬÈÏÒѾ­°²×°£¬Òò´Ë²»ÐèÒªÔÙ°²×°¡£ÔÚUbuntu·¢ÐаæÖУ¬´ò¿ªshell£¬Ê¹ÓÃÏÂÃæµÄÃüÁî¿ÉÒÔ·½±ãµÄ°²×°GCC±àÒëÆ÷(\$ΪÃüÁîÐÐÌáʾ·û)£º
¡¡¡¡$ sudo apt-get install build-essential
¡¡¡¡¸ÃÃüÁî¿ÉÒÔ°ÑËùÐèÒªgcc¡¢g++±àÒëÆ÷ºÍmake¹¤¾ß¼°ÆäÒÀÀµµÄÆäËüÈí¼þ°ü×Ô¶¯°²×°²¢ÅäÖúá£
  &nb ......

xshellÁ¬½ÓlinuxÖÐÎÄÂÒÂë


ÍøÉϺܶàÌû×ÓÎÊxhellÁ¬½ÓlinuxÖÐÎÄÂÒÂ룬¾ø´ó²¿·ÖÊǽ«LANGÊôÐÔÖµÉèÖÃÓ¢ÎÄ£¬¼´export LANG=en_US.UTF-8;
µ«ÊÇÎÒÃǽ«ÏµÍ³ÉèÖÃΪÖÐÎÄ£¬µ±È»ÊÇÒòΪ×Ô¼ºÓÃÖÐÎÄ¿ÉÒÔÌá¸ßЧÂÊ£¬¼õÉÙ³ö´í¡£
ÕâÖÖ·½Ê½Ö»ÄÜÖα겻ÄÜÖα¾£¬Ï´ÎʹÓÃsshÁ¬linuxʱ»¹ÊÇ»áÂÒÂ룬
ÏÖÔÚ½«ÎÒ×Ô¼ºµÄ½â¾ö·½Ê½¹²Ïí¸ø´ó¼Ò¡£
±à¼­/etc/sysconfig/i18n
½«ÎļþÖ ......

MySQL Cluster Multi Computer Installation

    
Each MySQL Cluster host computer running an SQL node must have
installed on it a MySQL binary. For management nodes and data
nodes, it is not necessary to install the MySQL server binary, but
management nodes require the management server daemon
......

Initial Startup of MySQL Cluster


Starting the cluster is not very difficult after it has been configured. Each cluster node process must be started separately, and on the host where it resides. The management node should be started first, followed by the data nodes, and then finally by any SQL nodes:
On the management host, issu ......

Safe Shutdown and Restart of MySQL Cluster


To shut down the cluster, enter the following command in a shell
on the machine hosting the management node:

shell> ndb_mgm -e shutdown
The -e
option here is used to pass a command to
the ndb_mgm
client from the shell. (See
Section 4.23, “ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ