Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 server°²×°

Èý. mysql server°²×°
    ------------------ÒÔÏÂΪÀ©Õ¹£ºÉ¾³ýmysql----------------
    ɾ³ý mysql
    sudo apt-get autoremove --purge mysql-server-5.0
    sudo apt-get remove mysql-server
    sudo apt-get autoremove mysql- ......

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µÄÇ©Ãû£¬ÎÒÃÇÉî±í¸Ðл¡£Èç¹û¿ÉÒԵϰ£¬ÎÒÃÇÐèÒªÄúµ ......

PHPеÄÁ¬½ÓMySQL·½·¨mysqli

PHPеÄÁ¬½ÓMySQL·½·¨mysqli
1. ¿ªÆôPHPµÄAPIÖ§³Ö
£¨1£©Ê×ÏÈÐÞ¸ÄÄúµÄphp.iniµÄÅäÖÃÎļþ¡£
      ²éÕÒÏÂÃæµÄÓï¾ä£º
      ;extension=php_mysqli.dll
      ½«ÆäÐÞ¸ÄΪ£º
      extension=php_mysqli.dll
......

Can't connect to MySQL server on '' (10060)

Ô¶³ÌÁ¬½Ó·þÎñÆ÷³öÏÖÒÔÉÏ´íÎó
Ö÷ÒªÓÐÈý¸öÔ­Òò£º
1¡¢mysqlÊÚȨ±íÀïûÓÐÔ¶³Ì»úÆ÷µÄȨÏÞ£¬¼°ÐèÒªÔÚÊÚȨ±ímysql.userÌí¼Ó
grant all privileges on *.* to 'root'@'Ô¶³ÌµÇ½IP' identified by 'Ô¶³ÌµÇ½ÃÜÂë'
flush privileges;
2¡¢ÍøÂ粻ͨ£¬Õâ¸ö¾Í²»ËµÁË¡£
3¡¢·À»ðǽ½ûÖ¹3306¶Ë¿Ú£¬ÒÔiptableΪÀý
vi /etc/sysconfig/ipt ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ