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

MySQL FOR LINUX


MySQL FOR LINUX
Ïȼì²éϵͳÊÇ·ñ×°ÉÏÁËmysql£¬Èç¹ûÓн«ÆäжÔصô
rpm -qa | grep mysql
×¢ÒâmysqlµÄ´óСд£¬´óСд¶¼ÓпÉÄÜ
rpm -e --nodeps mysql*
Ò»¶¨ÒªÓÃ--nodepsжÔØ£¬²»¼ì²éÒÀÀµÐÔ¹Øϵ¡£
´´½¨Óû§mysql
groupadd mysql
useradd -g mysql mysql
passwd mysql
ÔÚ/usr/localϽ¨Á¢ mysql Îļþ¼Ð
È»ºó½«°²×°ÎļþÉÏ´«µ½·þÎñÆ÷ÉÏ£¬ÕâÀïÓõÄÊÇtar.gzµÄÎļþ£¬Ò²ÓÐrpm°ü¿ÉÒÔÓ㬵«ÊÇrpm°ü²»ÄÜÖ¸¶¨°²×°Ä¿Â¼£¬¹Ê²»²ÉÓÃ
tar zxvf mysql-5.0.45.tar.gz 
cd mysql-5.0.45
./configure --prefix=/usr/local/mysql --with-charset=gb2312
Ö¸¶¨°²×°Ä¿Â¼Îª/usr/local/mysql£¬×Ö·û¼¯Îªgb2312
make 
make install
°²×°Íê³É
ÖØÆô
cp /usr/local/mysql/share/mysql/mysql.server
/etc/init.d/mysqld
copyÆô¶¯µÄmysqldÎļþ
ÏÂÃæÈ·±£mysqlÓû§ÓÐÏàÓ¦µÄȨÏÞ
chmod 700 /etc/init.d/mysqld
cd /usr/local
chmod 750 mysql -R
chgrp mysql mysql -R 
chown mysql mysql/var -R
cd /usr/local/mysql/libexec
cp mysqld mysqld.old
strip mysqld 
chkconfig --add mysqld 
chkconfig --level 345 mysqld on
service mysqld start 
Æô¶¯·þÎñ
/usr/local/mysql/bin/mysqld_safe
¿´¿´mysqlÄÜ·ñÕý³£¹¤×÷
mysql -uroot mysql
»òÕß netstat -atln 
¿´¿´ÓÐûÓÐ3306µÄ¶Ë¿Ú´ò¿ª,£¨Èç¹ûmysqld²»ÄÜÆô¶¯,¿´¿´/web/mysql/varϵijö´íÈÕÖ¾,Ò»°ã¶¼ÊÇĿ¼ȨÏÞûÓÐÉèÖúõÄÎÊÌâ £©
¹þ¹þ£¬Ã»ÓÐÎÊÌâ¡£Æô¶¯Õý³£¡£
/usr/local/mysql/bin/mysql_install_db --user=mysql
´´½¨Êý¾Ý¿âmysql£¬Óû§Îªmysql
½ÓÏÂÀ´×ö¸öÁ´½Ó£¬¾õµÃ·½±ãһЩ¡££¨×öÁ´½ÓÇ°È·±£Óû§PATH·¾¶ÀïÓÐsbin£©
ln -s /usr/local/mysql/bin/mysql /sbin/mysql
ln -s /usr/local/mysql/bin/mysqladmin /sbin/mysqladmin
ºÃÁË£¬Ã»ÓÐʲôÎÊÌâ¾ÍÖØÐÂÆô¶¯Ò»Ï¡£
½ÓÏÂÀ´×öһЩ¸üºÃµÄÉèÖðɡ£ÈÃmysql¸üºÃµÄÔËÐаɡ£
cp /usr/local/mysql/share/mysql/my-medium.cnf /etc/my.cnf
copyÅäÖÃÎļþ,ÓÐlarge,medium,smallÈý¸ö»·¾³ÏµÄ,¸ù¾Ý»úÆ÷ÐÔÄÜÑ¡Ôñ,Èç¹û¸ººÉ±È½Ï´ó,¿ÉÐÞ¸ÄÀïÃæµÄһЩ±äÁ¿µÄÄÚ´æʹÓÃÖµ
ÉèÖÃ×Ô¶¯Æô¶¯mysql
É趨¿ª»ú×ÔÆô¶¯mysql
#cd /usr/local/mysql/share/mysql
#cp mysql.server /etc/init.d/mysql
#cd /etc/rc3.d
#ln -s ../init.d/mysql S100mysql
#ln -s ../init.d/mysql K100mysql
#cd /etc/rc5.d
#ln -s ../init.d/mysql S10


Ïà¹ØÎĵµ£º

java µ÷ÓÃÃüÁî ±¸·ÝmysqlÊý¾Ý¿â

 ´úÂëÈçÏ£º
  1  String command  =   " cmd /c C:/Program Files/MySQL/MySQL Server 5.0/bin>mysqldump -h localhost -u root -p aijia > E:/aijia.dmp " ;
  2      try    {
  3     Process process& ......

MySQL¿É¿¿ÐÔ·½°¸·ÖÎöÓë±È½Ï

ÒýÓÃhttp://bbs.yahunet.com/thread-9946-1-1.html
´Ó»ù±¾Çé¿ö¡¢³É±¾¡¢ÓÅȱµãºÍÓ¦Óó¡ºÏµÈ·½Ãæ¶Ô5ÖÖMySQLµÄ¿É¿¿ÐÔ·½°¸
½øÐÐÁË·ÖÎö
ºÍ±È½Ï£¬¶ÔMySQLµÄ¿ª·¢ºÍ¹ÜÀí
ÓÐÒ»¶¨µÄ½è¼ø×÷Óá£
1£®MySQL Clustering(ndb-cluster stogare)
¼ò½é£º
MySQL¹«Ë¾ÒÔ´æ´¢ÒýÇ淽ʽÌṩµÄ¸ß¿É¿¿ÐÔ·½°¸£¬ÊÇÊÂÎñ°²È«µÄ£¬ÊµÊ±¸´ÖÆÊý¾Ý
£¬¿ÉÓ ......

MYSQL£ºCannot convert value '0000

½ñÌì´ÓMYSQLÊý¾Ý¿âץȡʱ£¬·¢ÉúÁËCannot convert value '0000-00-00 00:00:00' from column 10 to TIMESTAMPÒì³£
googleÁËһϣ¬´ó¸ÅÒâ˼ÊÇMySQLÖеÄDatetimeÖµÎÞ·¨ÔÙJAVAÖпɿ¿µÄ±»±íʾ£¬°´ÕÕJDBCºÍSQLµÄ±ê׼ĬÈÏÇé¿öϲúÉúÒì³£¡£
JDBCÔÊÐíÓÃÏÂÁеÄÖµ¶ÔzeroDateTimeBehavior ÊôÐÔÀ´ÉèÖÃÕâЩ´¦Àí·½Ê½£¬
exception (the d ......

MySql ÖеÄÊý¾Ý¿âµÄ²Ù×÷»¹ÓÐһЩ±àÂëÎÊÌâ

±¸·ÝMySQLÊý¾Ý¿âµÄÃüÁî
mysqldump -hhostname -uusername -ppassword databasename > backupfile.sql
±¸·ÝMySQLÊý¾Ý¿âΪ´øɾ³ý±íµÄ¸ñʽ
±¸·ÝMySQLÊý¾Ý¿âΪ´øɾ³ý±íµÄ¸ñʽ£¬Äܹ»Èøñ¸·Ý¸²¸ÇÒÑÓÐÊý¾Ý¿â¶ø²»ÐèÒªÊÖ¶¯É¾³ýÔ­ÓÐÊý¾Ý¿â¡£
mysqldump -–add-drop-table -uusername -ppassword databasename > backu ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ