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

mysql»ù±¾Ó÷¨

http://dev.mysql.com/doc/refman/5.1/zh/index.html
(MySql 5.1 ÖÐÎIJο¼ÊÖ²á)
*------------------------------------------------------------------------------------------
show databases; ÏÔʾÊý¾Ý¿â
drop database Êý¾Ý¿âÃû;ɾ³ýÊý¾Ý¿â
set names 'utf8';ÉèÖÃÊý¾Ý¿â±àÂëΪutf-8
source x:\Êý¾Ý¿âÃû.sql;µ¼ÈëÒ»¸öÊý¾Ý¿â
USE Êý¾Ý¿âÃû;³¢ÊÔ´æÈ¡Êý¾Ý¿â
CREATE DATABASE Êý¾Ý¿âÃû;´´½¨Ò»¸öÊý¾Ý¿â
*---------------------------------------------------------------------------------------------
Ϊ±íÔö¼ÓË÷Òý:alter table ±íÃû add index Ë÷ÒýÃû ('×Ö¶ÎÃû');
Ϊ±íÔö¼ÓÍâ¼ü: (Àý±íAµÄuidÊÇÍâ¼ü,¶ÔÓ¦±íBµÄid) (±íÀàÐÍΪInnoDB²ÅÓÐÍâ¼üÔ¼Êø)
                 alter table A add foreign key (uid) references B (id) on delete restrict on update restrict;
*--------------------------------------------------------------------------------------------
MysqlµÄµ¼ÈëºÍµ¼³ö
mysqldump -u root -pYOURPASSWORD DATA_BASE_NAME >mydatabasebak.sql
::ÊÇ°Ñ Êý¾Ý¿â DATA_BASE_NAME ±¸·Ýµ½Îı¾Îļþ mydatabasebak.sql
scp mydatabasebak.sql username@192.168.0.114:.
ÊäÈëÓû§username µÄÃÜÂë.
ssh 192.168.0.114
mysql -u root -p # ÊäÈëÃÜÂëºó½øÈëMysql ÃüÁîÐÐģʽ
sql>create database DATA_BASE_NAME;
sql> use DATA_BASE_NAME; # Êý¾Ý¿âÃû×Ö£¬Çл»Òªµ¼ÈëµÄÄ¿±êÊý¾Ý¿â¡£
sql> set names 'utf8'; # ÕâÒ»²½Ïàµ±ÖØÒª£¬Èç¹ûԭʼSQLÎļþ±àÂëÊÇutf8µÄ£¬²»¼ÓÉÏÕâ¸öÓï¾ä£¬µ¼ÈëºóÖÐÎÄÊÇÂÒÂë
sql> source mydatabasebak.sql; # ¿ªÊ¼µ¼ÈëÊý¾Ý¡£
*---------------------------------------------------------------------------------------------------------------


Ïà¹ØÎĵµ£º

mysql ±¸·ÝÁ·Ï°

<?php
$db_name="new";
mysql_connect("localhost","root","123456");
mysql_select_db($db_name);
$tb=mysql_list_tables($db_name);
$sql="";
while($query=mysql_fetch_row($tb)){
 $sql="";$table_sql="";
    $sql.= get_table_fn($query[0]);
    get_table_row($que ......

MySQL Cluster Multi Computer How To


This section is a “How-To
” that describes the basics
for how to plan, install, configure, and run a MySQL Cluster.
Whereas the examples in
Chapter 3, MySQL Cluster Configuration
provide more in-depth
information on a variety of clustering options and co ......

MySQL´´Ê¼ÈË·¢ÓʼþѰÇóÖйú°ïÖú


½ñÔçÊÕµ½ÁËMySQLµÄÓʼþ£¬È«ÎÄÈçÏ£º
Ç×°®µÄÕü¾ÈMySQLµÄÖйúÇ©ÃûÖ§³ÖÕߣ¬
Å·ÃË¿ÉÄÜÎÞ·¨Õü¾ÈMySQL,ÖйúºÍ¶íÂÞ˹¿ÉÄÜÊÇÕü¾ÈMySQLµÄÏ£ÍûÖ®ËùÔÚ¡£ÖйúÓµÓÐÇ¿´ó¡¢¶ÀÁ¢ÒÔ¼°×ÔÐŵķ´Â¢¶ÏÖ÷¹Ü»ú¹Ø£¬Òò´Ë£¬ÎÒ±¾ÈËÔÚ´ËÇëÇóÄúµÄ°ïÖú¡£¶ÔÓÚÄúÔÚhttp://www.helpmysql.org/ru/petitionµÄÇ©Ãû£¬ÎÒÃÇÉî±í¸Ðл¡£Èç¹û¿ÉÒԵϰ£¬ÎÒÃÇÐèÒªÄúµ ......

MYSQLÒýÇæ¼òµ¥¶Ô±È

·þÎñÆ÷ÒµÎñÀàÐÍ¶Ô±È ÐÔÄÜÆ¿¾±
DB                   I/O´ÅÅÌ
ת·¢·þÎñÆ÷         Íø¿¨PPS
¶¯Ì¬WEBǰ̨         CPU
¾²Ì¬WEBǰ̨   ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ