ÎÒµÄMysqlÖØ×°Ê§°Ü£¬½â¾ö°ì·¨
ÖØÐ°²×°£¬³öÏÖ/etc/init.d/mysql: line 115: /etc/mysql/debian-start: ûÓиÃÎļþ»òĿ¼
invoke-rc.d: initscript mysql, action "start" failed.
ʹÓÃÃüÁsudo aptitude purge mysql-server mysql-server-5.0
È»ºóÔÚÖØÐ°²×°....
apt-get install mysql-server-5.0
Ïà¹ØÎĵµ£º
¡¡MYSQL¶¨ÆÚ±¸·ÝÊÇÒ»ÏîÖØÒªµÄ¹¤×÷£¬µ«È˹¤²Ù×÷Ì«·±Ëö£¬Ò²ÄѱÜÃâÓÐËùÊè©£¬Ê¹ÓÃÏÂ
ÃæµÄ·½·¨¼´¿ÉÈÃϵͳ¶¨ÆÚ±¸·ÝÊý¾Ý¡£
¡¡¡¡1¡¢´´½¨±¸·ÝÎļþ¼Ð
¡¡¡¡#cd /www
¡¡¡¡#makedir backup
¡¡¡¡2¡¢±àдÔËÐнű¾
¡¡¡¡#vi autobackup
¡¡¡¡Ð´ÈëÒÔÏÂÄÚÈÝ£º
¡¡¡¡filename=`date +%Y%m%d`
¡¡¡¡mysql_bin_dir/mysqldump –opt da ......
ʲôÊÇË÷Òý£¿
Ë÷
ÒýÓÃÀ´¿ìËÙµØÑ°ÕÒÄÇЩ¾ßÓÐÌØ¶¨ÖµµÄ¼Ç¼£¬ËùÓÐMySQLË÷Òý¶¼ÒÔB-Ê÷µÄÐÎʽ±£´æ¡£Èç¹ûûÓÐË÷Òý£¬Ö´ÐвéѯʱMySQL±ØÐë´ÓµÚÒ»¸ö¼Ç¼¿ªÊ¼É¨ÃèÕû¸ö±íµÄ
ËùÓмǼ£¬Ö±ÖÁÕÒµ½·ûºÏÒªÇóµÄ¼Ç¼¡£±íÀïÃæµÄ¼Ç¼ÊýÁ¿Ô½¶à£¬Õâ¸ö²Ù×÷µÄ´ú¼Û¾ÍÔ½¸ß¡£Èç¹û×÷ΪËÑË÷Ìõ¼þµÄÁÐÉÏÒѾ´´½¨ÁËË÷Òý£¬MySQLÎÞÐèɨÃèÈκμǼ¼´
¿ ......
mysqldump -u[user] -p[password] [databasename] > [dump_name]
ÔÚ½« dump_name Õâ¸öµµ°¸¸´ÖƵ½Áíһ̨¼ÆËã»úÉÏ
Áíһ̨¼ÆËã»úÉÏÏȽøÈëmysql
½¨Á¢Ò»¸ö database ÔÙÖ´ÐÐÏÂÁÐÖ¸Áî
mysql -u[user] -p[password] [database_name] < [dump_name]
MYSQL¼¸ÖÖ±¸·Ý·½·¨¸ÅÊö
MysqlÊý¾Ý
¿â±¸·ÝÖ÷ÒªÓÐ4Ö ......
Vs2005Á¬½ÓmysqlÊý¾Ý¿â
Ò»¡¢ÏÂÔØÖ§³ÖmysqlµÄ΢ÈíµÄͨÓÃÀàmysql-connector-net-1.0.7-noinstall.zip
¶þ¡¢ÏÂÔØµØÖ·http://www.cnblogs.com/eugenewu0808/archive/2006/10/11/mysqldata.html
Èý¡¢½âѹÎļþ
ËÄ¡¢Ìí¼ÓÒýÓÃÕÒµ½binÎļþ¼ÐÕÒµ½net-2.0 vs2005µÄ£¨ºÍvsÏàÓ¦°æ±¾µÄ£©ÕÒµ½MySql.Data.dll
Îå¡¢ÔÚÀàÖÐÒýÓÃusing MySq ......
1.½ñÌìµÄ³ÌÐò·¢²¼µ½·þÎñÆ÷£¬¹ýÁËÒ»Ííºó·¢ÏÖ³ÌÐò²»ÄÜ·ÃÎÊÁË£¬ºÃÏñÊÇÁ¬½Ó³ØÎÊÌâ¡£´íÎóÈçÏ£º [log4j:] 2009-10-30 17:32:10,353 - com.school.dao.OperaDAO -65984388 [http-8080-12] ERROR com.school.dao.OperaDAO - find all failed
org.hibernate.exception.JDBCConnectionException: could not execute query ......