Mysqlµ¼³öÃüÁîÎļþºÍÃüÁîÎļþµ¼Èë
1)ÃüÁîµ¼³ö
ÔÚÃüÁîÌáʾ·ûģʽÏ£º
mysqldump -u Óû§ -p Êý¾Ý¿â ±íÃû>ÎļþÃû.sql
eg:
mysqldump -u root -p mysql tbcustomerid>a.sql
µ¼³öµÄÃüÁîÎļþÔÚµ±Ç°ÃüÁîÌáʾ·û·¾¶Ï¡£
Èç¹ûÒªµ¼³öÕû¸öÊý¾Ý¿âÃüÁîΪ£º
mysqldump -u Óû§ -p Êý¾Ý¿â ±íÃû>ÎļþÃû.sql
2£©ÃüÁîÎļþµ¼Èë
¢ÙµÇ¼mysql
¢ÚÑ¡ÔñÊý¾Ý¿â
¢ÛÖ´ÐÐÃüÁî
source Îļþ·¾¶Ãû³Æ
eg£º
source c:\a.sql
Ïà¹ØÎĵµ£º
grant replication slave on *.* to backup@192.168.188.128 identified by "123456";
grant replication slave on *.* to backup@192.168.188.8 identified by "123456";
service mysql stop
server_id = 1
log-bin = mysql-bin
log-error=mysql-error
master-host = 192.168.188.8
master-user = ba ......
Êý¾Ý¿âµÄÓÅ»¯ÊÇϵͳÓÅ»¯µÄÖØÒª·½Ã棬¶øÊý¾Ý¿âÓÅ»¯µÄ»ù´¡ÊÇ»ùÓÚͳ¼ÆÊý¾Ý£¬ÏÂÃæµÄÕâЩÃüÁî¿ÉÒÔ°ïÖúÎÒÃÇÁ˽âÊý¾Ý¿âµÄ״̬¡£±ÈÈçÓÃshow table status from ecl where rows>10000;¿ÉÒÔ¿´ÄÄЩÊý¾Ý¿â±í±È½Ï´ó£¬È»ºó¿´¿´ÕâЩ±íµÄÉèÖá¢Ë÷ÒýµÈÊÇ·ñÓÐÎÊÌâ¡£
1. show tables»òshow tables from dat ......
Ò»¡¢Á¬½ÓMYSQL
¡¡¡¡¸ñʽ£º mysql -hÖ÷»úµØÖ· -uÓû§Ãû £pÓû§ÃÜÂë
¡¡¡¡1¡¢Àý1£ºÁ¬½Óµ½±¾»úÉϵÄMYSQL¡£
¡¡¡¡Ê×ÏÈÔÚ´ò¿ªDOS´°¿Ú£¬È»ºó½øÈëĿ¼ mysqlbin£¬ÔÙ¼üÈëÃüÁîmysql -uroot -p£¬»Ø³µºóÌáʾÄãÊäÃÜÂ룬Èç¹û¸Õ°²×°ºÃMYSQL£¬³¬¼¶Óû§rootÊÇûÓÐÃÜÂëµÄ£¬¹ÊÖ±½Ó»Ø³µ¼´¿É½øÈëµ½MYSQL ......
Ô¶³ÌÁ¬½ÓmysqlËÙ¶ÈÂýµÄ½â¾ö·½·¨
http://www.xishuiw.com
¡¡¡¡PHP Ô¶³ÌÁ¬½ÓMYSQLËÙ¶ÈÂý,ÓÐʱԶ³ÌÁ¬½Óµ½MYSQLÓÃʱ4-20Ãë²»µÈ,±¾µØÁ¬½ÓMYSQLÕý³£,³öÏÖÕâÖÖÎÊÌâµÄÖ÷ÒªÔÒòÊÇ,ĬÈÏ°²×°µÄMYSQL¿ªÆôÁËDNSµÄ·´Ïò½âÎö,ÔÚMY.INI(WINDOWSϵͳÏÂ)»òMY.CNF(UNIX»òLINUXϵͳÏÂ)ÎļþµÄ[mysqld]ϼÓÈëskip- name-resolveÕâÒ»¾ä¡£Á¬½Ómysq ......
SQL Server´´½¨ÁÙʱ±í£º
´´½¨ÁÙʱ±í
·½·¨Ò»£º
create table #ÁÙʱ±íÃû(×Ö¶Î1 Ô¼ÊøÌõ¼þ,
×Ö¶Î2 Ô¼ÊøÌõ¼þ,
.....)
create table ##ÁÙʱ±íÃû(×Ö¶Î1 Ô¼ÊøÌõ¼þ,
×Ö¶Î2 Ô¼ÊøÌõ¼þ,
.....)
·½·¨¶þ£º
select * into #ÁÙʱ±íÃû from ÄãµÄ±í;
select * into ##ÁÙʱ±íÃû from ÄãµÄ±í;
×¢£ºÒÔÉϵÄ#´ú±í¾Ö²¿ÁÙʱ±í£¬##´ú±íÈ«¾ ......