Linux ƽ̨Ï MYSQL°²×° Æô¶¯ mysqlÃüÁî
MYSQL°²×°
//½âѹ±àÒë°²×°
# tar xzvf mysql-5.0.27.tar.gz
# cd mysql-5.0.27
# ./configure -prefix=/home/redadmin/mysql
# make
# make install
# cd /home/redadmin/mysql/
# cp share/mysql/my-medium.cnf ./
# mv my-medium.cnf my.cnf
// my.confÎļþÐÞ¸Ä
# vi my.cnf
ÐÞ¸Äǰ£º
port = 3306
socket = /tmp/mysql.sock
Ð޸ĺó£º
port = 3307
socket = /tmp/mysql5.sock
// mysqlÊý¾Ý¿â³õʼ»¯
# ./mysql_install_db --defaults-file=../my.cnf --user=mysql
// mysqlÆô¶¯
# ./mysqld_safe --defaults-file=../my.cnf --user=mysql &
// mysqlÃüÁî
# ./mysql --defaults-file=../my.cnf
# create database pligg
select * from user;
quit;
./mysqladmin --port=3307 --socket=/tmp/mysql5.sock -u root -p shutdown
mySqlֹͣ
/home/redadmin/mysql/bin/mysqladmin --port=3307 --socket=/tmp/mysql5.sock -u root -p shutdown
MYSQL°²×°£¨½âѹ°æ£©
# gunzip mysql-5.0.51a-solaris10-i386.tar.gz
# tar xvf mysql-5.0.51a-solaris10-i386.tar
# cp mysql-5.0.51a-solaris10-i386/* /usr/local/mysql/
# cd /usr/local/mysql/
# chown -R mysql .
# chgrp -R mysql .
// mysqlÊý¾Ý¿â³õʼ»¯
# cp ./support-files/my-medium.cnf ./my.cnf
# scripts/mysql_install_db --user=mysql
// mysqlÆô¶¯
# chown -R root .
# chown -R mysql data
# bin/mysqld_safe --user=mysql &
// mysqlÃüÁî
# ./mysql -u root -p
mysql> create database deva_db
Ïà¹ØÎĵµ£º
MySQL³£ÓòÙ×÷»ù±¾²Ù×÷£¬ÒÔ϶¼ÊÇMySQL5.0ϲâÊÔͨ¹ýÊ×ÏÈ˵Ã÷Ï£¬¼ÇסÔÚÿ¸öÃüÁî½áÊøÊ±¼ÓÉÏ£»£¨·ÖºÅ£©
1.µ¼³öÕû¸öÊý¾Ý¿â
mysqldump -u Óû§Ãû -p --default-character-set=latin1 Êý¾Ý¿âÃû > µ¼³öµÄÎļþÃû(Êý¾Ý¿âĬÈϱàÂëÊÇlatin1)
mysqldump -u wcnc -p smgp_apps_wcnc > wcnc.sql
2.µ¼³öÒ»¸ö±í
mysqldump -u Ó ......
MySQL Reference Manual for version 4.1.0-alpha.
¡¡ÒëÕßÐò
¡¡ÁÐÀàÐÍÓ뺯ÊýË÷Òý
6 MySQL ÓïÑԲο¼
6.1 ÓïÑԽṹ
6.1.1 ÎÄ×Ö£ºÔõôд×Ö·û´®ÓëÊý×Ö
6.1.1.1 ×Ö·û´®
6.1.1.2 Êý×Ö
6.1.1.3 Ê®Áù½øÖÆÖµ
......
¿ÉÒÔ£¬µ«ÊÇÍêÈ«»Ö¸´ËùÓÐµÄ±í²»Ò»¶¨¿ÉÒÔ
¹¤¾ß: innodb-recovery
Official Website: http://code.google.com/p/innodb-tools/
This set of tools could be used to check InnoDB
tablespaces and to recover data from damaged tablespaces or from
dropped/truncated InnoDB tables.
Õâ¸ö¹¤¾ßÓÃÀ´¼ì²éInnoDB¿Õ¼ä±íºÍ» ......
JDBCÁ¬½ÓMySQL
JDBCÁ¬½ÓMySQL
¼ÓÔØ¼°×¢²áJDBCÇý¶¯³ÌÐò
Class.forName("com.mysql.jdbc.Driver");
Class.forName("com.mysql.jdbc.Driver").newInstance();
JDBC URL ¶¨ÒåÇý¶¯³ÌÐòÓëÊý¾ÝÔ´Ö®¼äµÄÁ¬½Ó
±ê×¼Óï·¨£º
<protocol£¨Ö÷ҪͨѶÐÒ飩>:<subprotocol£¨´ÎҪͨѶÐÒ飬¼´Çý¶¯³ÌÐòÃû³Æ£©>:<data so ......
1. ÔÚʹÓÃNavicat 8 for MySQL¿Í»§¶Ë´´½¨Êý¾Ý¿âʱ£¬±àÂëµÄÉèÖÃÈçÏÂͼ£º
2. ½«°²×°Ä¿Â¼F:\MySQL\MySQL Server 5.1Ï£¬my.iniÎļþÉèÖñäÁ¿Öµdefault-character-set=gbk £¨°üº¬Á½´¦£¬¿É²éÕÒdefault-character-set£©£¬È»ºóÖØÆôMYSQL·þÎñ¡£ ......