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----------------
ɾ³ý mysql
sudo apt-get autoremove --purge mysql-server-5.0
sudo apt-get remove mysql-server
sudo apt-get autoremove mysql- ......
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µÄÏ£ÍûÖ®ËùÔÚ¡£ÖйúÓµÓÐÇ¿´ó¡¢¶ÀÁ¢ÒÔ¼°×ÔÐŵķ´Â¢¶ÏÖ÷¹Ü»ú¹Ø£¬Òò´Ë£¬ÎÒ±¾ÈËÔÚ´ËÇëÇóÄúµÄ°ïÖú¡£¶ÔÓÚÄúÔÚhttp://www.helpmysql.org/ru/petitionµÄÇ©Ãû£¬ÎÒÃÇÉî±í¸Ðл¡£Èç¹û¿ÉÒԵϰ£¬ÎÒÃÇÐèÒªÄúµ ......
PHPеÄÁ¬½ÓMySQL·½·¨mysqli
1. ¿ªÆôPHPµÄAPIÖ§³Ö
£¨1£©Ê×ÏÈÐÞ¸ÄÄúµÄphp.iniµÄÅäÖÃÎļþ¡£
²éÕÒÏÂÃæµÄÓï¾ä£º
;extension=php_mysqli.dll
½«ÆäÐÞ¸ÄΪ£º
extension=php_mysqli.dll
......
Ô¶³ÌÁ¬½Ó·þÎñÆ÷³öÏÖÒÔÉÏ´íÎó
Ö÷ÒªÓÐÈý¸öÔÒò£º
1¡¢mysqlÊÚȨ±íÀïûÓÐÔ¶³Ì»úÆ÷µÄȨÏÞ£¬¼°ÐèÒªÔÚÊÚȨ±ímysql.userÌí¼Ó
grant all privileges on *.* to 'root'@'Ô¶³ÌµÇ½IP' identified by 'Ô¶³ÌµÇ½ÃÜÂë'
flush privileges;
2¡¢ÍøÂ粻ͨ£¬Õâ¸ö¾Í²»ËµÁË¡£
3¡¢·À»ðǽ½ûÖ¹3306¶Ë¿Ú£¬ÒÔiptableΪÀý
vi /etc/sysconfig/ipt ......