´´½¨mysqlʵÀý
1. ÔÚ/etc/my.cnfÖмÓÈëÒ»ÏÂÄÚÈÝ
[mysqld_dev]
socket=/tmp/mysql.sock
port=3307
pid-file=/var/run/mysqld/mysqld_dev.pid
datadir=/var/lib/mysql_dev
log=/var/log/mysqld_dev.log
log-error=/var/log/mysqld_dev.err.log
user=mysql
2. ¸ù¾ÝÒÔÉÏÄÚÈÝ´´½¨Ä¿Â¼ºÍÎļþ
mkdir /var/lib/mysqld_dev
chown mysql:mysql /var/lib/mysqld_dev
...
3. ±àд/etc/rc.d/init.d/mysqld_dev, »òÕß´Ó/etc/rc.d/init.d/mysqld copy Ò»·Ý£¬È»ºóÐÞ¸ÄÆäÖлñÈ¡²ÎÊýµÄ´úÂë¡£
get_mysql_option mysqld_dev datadir "/var/lib/mysql"
datadir="$result"
get_mysql_option mysqld_dev socket "$datadir/mysql.sock"
socketfile="$result"
get_mysql_option mysqld_dev log-error "/var/log/mysqld.log"
errlogfile="$result"
get_mysql_option mysqld_dev pid-file "/var/run/mysqld/mysqld.pid"
mypidfile="$result"
4. Æô¶¯server
servie mysqld_dev start
·¢ÏÖ´íÎó
mysqld_safe [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
ÐèÒªÓÃmysql_install_dbÀ´´´½¨ÏµÍ³±í¡£
mysql_install_db --user=mysql --datadir=/var/lib/mysql_dev/
ÔÙ´ÎÖØÆô£¬³É¹¦
5. ÓÃmysql -u root -S /tmp/mysql.sock ¾Í¿ÉÒÔÁ¬½ÓÉÏÕâ¸öinstanceÁË¡£
6. Èç¹û²»Ïëд-S /tmp/mysql_dev.sock£¬ ¿ÉÒÔÔÚmy.cnf µÄ[client]ÖмÓÈë´úÂëÉèΪĬÈÏsock
[client]
socket= /tmp/mysql_dev.sock
This article is created by ¿ªÐÄд×÷Íø
Ïà¹ØÎĵµ£º
MySQLµÄ±¸·Ý·½Ê½£¬Ä¿Ç°ÎÒÏëµ½µÄÓÐÎåÖÖ£¬ÓпÉÄÜ»¹ÓÐ
1£¬mysqldump·½Ê½£¬¼ÓÉϾßÌå²ÎÊýÃû£¨µ¥¿â£¬¶à¿â£¬´¥·¢Æ÷£¬´æ´¢¹ý³Ì£¬±í½á¹¹£¬×Ö·û¼¯£¬–single-transaction£¬µÈµÈ£©
2£¬mysqlhotcopy Ö»Äܱ¸·ÝmyisamÊý¾Ý±í±¸·Ý£¬ËÙ¶ÈÏ൱¿ì£¬ÒòΪÊÇÎļþ¿½±´£¬¿ÉÄÜ˲¼ä±»Ëø±í£¬ÈκεÄÊý¾Ý²Ù×÷£¬±ÈÈç²åÈëºÍ¸üж¼»á¹ÒÆð¡£
3£¬LVMµ ......
°²×°mysql
sudo apt-get install mysql-servel-5.0 mysql-client-5.0
ÏÂÔØ°²×°¹ý³ÌÖУ¬»áÌáʾÊäÈërootÃÜÂë
°²×°CÓïÑÔ±à³Ì½Ó¿Ú£º
sudo apt-get install libmysqlclient15-dev
¸ü¶àapi ²é¿´£ºhttp://dev.mysql.com/doc/refman/5.0/en/c.html
Ïà¹ØmysqlÍ·ÎļþºÍ¿âÎļþ°²×°ÔÚ/usr/include/mysql/ºÍ/usr/lib/mysqlÄ¿ ......
½â¾öMySQL²»ÔÊÐí´ÓÔ¶³Ì·ÃÎʵķ½·¨
2009-06-04 13:11
1¡£ ¸Ä±í·¨¡£¿ÉÄÜÊÇÄãµÄÕʺŲ»ÔÊÐí´ÓÔ¶³ÌµÇ½£¬Ö»ÄÜÔÚlocalhost¡£Õâ¸öʱºòÖ»ÒªÔÚlocalhostµÄÄÇ̨µçÄÔ£¬µÇÈëmysqlºó£¬¸ü¸Ä "mysql" Êý¾Ý¿âÀïµÄ "user" ±íÀïµÄ "host" Ï´Ó"localhost"¸Ä³Æ"%"
Sql´úÂë ¸´ÖÆ´úÂë
1. mysql -u root -pvmwaremysql>us ......
¸ñʽΪ2008-06-16
²éѯ³öµ±ÌìÊý¾Ý£º
SELECT * from `table` WHERE date(ʱ¼ä×Ö¶Î) = curdate();
²éѯ³öµ±ÔÂ×ֶΣº
SELECT *
from `table`
WHERE month( ʱ¼ä×Ö¶Î) = month( now( ) ) ;
ʱ¼ä¸ñʽΪ1219876…… UNIXʱ¼ä£¬Ö»ÒªÓ¦ÓÓfrom_UNIXTIME( )”º¯Êý
ÀýÈç²éѯµ±Ô£º
SELECT ......
±¾ÎÄÌÖÂÛ MySQL µÄ±¸·ÝºÍ»Ö¸´»úÖÆ£¬ÒÔ¼°ÈçºÎά»¤Êý¾Ý±í£¬°üÀ¨×îÖ÷ÒªµÄÁ½ÖÖ±íÀàÐÍ£ºMyISAM ºÍ Innodb£¬ÎÄÖÐÉè¼ÆµÄ MySQL °æ±¾Îª 5.0.22¡£
Ŀǰ MySQL Ö§³ÖµÄÃâ·Ñ±¸·Ý¹¤¾ßÓУºmysqldump¡¢mysqlhotcopy£¬»¹¿ÉÒÔÓà SQL Óï·¨½øÐб¸·Ý£ºBACKUP TABLE »òÕß SELECT INTO OUTFILE£¬ÓÖ»òÕß±¸·Ý¶þ½øÖÆÈÕÖ¾£¨binlog£©£¬»¹¿ÉÒÔÊÇÖ±½Ó¿½± ......