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ÃüÁî
Ïà¹ØÎĵµ£º
Ò»£ºÇ°ÑÔ
×î½üÔÚÑо¿androidµÄsensor driver£¬Ö÷ÒªÊÇE-compass£¬ÆäÖÐÓõ½ÁËLinux input×Óϵͳ.ÔÚÍøÉÏÒ²¿´Á˺ܶàÕâ·½ÃæµÄ×ÊÁÏ£¬¸Ð¾õ»¹ÊÇÕâÆª·ÖÎöµÄ±È½ÏϸÖÂ͸³¹£¬Òò´Ë×ªÔØÒ»ÏÂÒÔ±ã×Ô¼ºÑ§Ï°£¬Í¬Ê±ºÍ´ó¼Ò·ÖÏí£¡
£¨ÕâÆª²©¿ÍÖ÷ÒªÊÇÒÔ¼üÅÌÇý¶¯ÎªÀýµÄ£¬²»¹ý½²½âµÄÊÇLinux Input Subsystem£¬¿ÉÒÔ×ÐϸµÄÑо¿Ò»Ï£¡£©
¼üÅÌÇý¶¯½«¼ì ......
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
......
GROUP_CONCAT ÊÇÒ»¸öºÏ²¢¶àÐеĺ¯Êý£¬Ò»°ãÓõÄÉÙ£¬ËùÒԺܶàÈ˶¼²»ÖªµÀ£¬ÎÒÒ²ÊÇÒ»¸ö£¬½ñÌìżȻ¿´µ½£¬¹Ê¼ÇÏ·½·¨£»
GROUP_CONCATµÄÓï·¨ÈçÏ£º
GROUP_CONCAT([DISTINCT] expr [,expr ...][ORDER BY {unsigned_integer | col_name | expr}[ASC | DESC] [,col_name ...]][SEPARATOR str_val])
ÏÂÃæÑÝʾһÏÂÕâ¸öº¯Êý£¬ÏȽ¨Á¢Ò ......
1. ÏÈ¿´ÏÂÃæ´úÂë:
#include<stdio.h>
#include <sys/types.h> //pid_tÀàÐͶ¨Òå
#include <unistd.h> //º¯Êýfork() ......
¹«Ë¾ÄÚÍøµÄ·þÎñÆ÷Ó²Å̿ռ䲻×㣬½«ÐÂÂòÀ´µÄ150GÓ²Å̹ÒÔØ²¢ÉèÖóÉsambaµÄ¹²ÏíĿ¼£¬¹ØÓÚsambaÇë²Î¿¼´ËÎÄÕÂhttp://blog.csdn.net/linglongwunv/archive/2010/01/19/5212875.aspx£¬ÏÂÃæ½éÉÜÔõÑù½«Ò»¿éÐÂÓ²ÅÌ·ÖÇø¡¢¸ñʽ»¯¡¢¹ÒÔØµ½ÏµÍ³£¬ÈçÊʺÏÄãÇë¼ÌÐøÔĶÁ¡£·þÎñÆ÷ÉÏÒѾÓÐÁ½¿éÓ²ÅÌ£¬ËùÒÔÓ²ÅÌΪsdc£¬ºóÃæ¾Í² ......