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

MysqlÊý¾Ý±¸·ÝÒÔ¼°ÒìµØ´æ´¢

ÕûÀítuscany.org.cnµÄ·þÎñÆ÷£¬·¢ÏÖ3ÄêǰдµÄ½Å±¾»¹ÔÚÅÜ×Å :)
½Å±¾ÈçÏ£º
#==========================================================
#!/bin/bash
current_date=`date +%Y-%m-%d:%H:%M:%S`
/usr/local/mysql/bin/mysqldump -prootpass  dbname1 > ./DB_DIR/dbname1_"$current_date"_dump_file.sql 
/usr/local/mysql/bin/mysqldump -prootpass  dbname2 > ./DB_DIR/dbname2_"$current_date"_dump_file.sql
scp /root/DB_DIR/dbname1_"$current_date"_dump_file.sql sca@172.90.91.92:/root/DBBakDir
scp /root/DB_DIR/dbname2_"$current_date"_dump_file.sql sca@172.91.92.93:/root/DBBakDir
if [ $? -ne 0 ]
then
mail -s "Warning mesage from the automating backup program of tuscany.org.cn" wanghongwei@myce.net.cn < mailcontext.txt
fi
#==========================================================
mailcontext.txtµÄÄÚÈÝ
==================================
TuscanyÊý¾Ý±¸·Ý³ö´í£¬Ç뾡¿ì²é¿´Ô­Òò²¢½â¾ö£¡


Ïà¹ØÎĵµ£º

gwt ext Á¬½ÓMySqlÊý¾Ý¿â

¸ÃÁ¬½Ó·½Ê½²ÉÓÃRPCÀ´·µ»ØÊý¾Ý¿â²éѯ½á¹û¡£
1.Ê×ÏÈÊÇ´´½¨ÆÕͨµÄGWT-EXT¹¤³Ì¡£¿ÉÒԲο¼1http://www.ibm.com/developerworks/cn/java/j-lo-gwtext1/#resources
    ϵÁРÈë ÃÅ  ½Ì³Ì¡£¾ßÌåͨѶ¹ý³Ì·þÎñÒ²¿É²Î¿¼ÉÏÊöµÄ×îºó²¿·Ö˵Ã÷¡£
2. ½ÓÏÂÀ´¾ÍÊÇÒª´´½¨GWT Remote ServiceÁË£¬ÔÚÔ­Óй¤³ÌÉÏnew-&g ......

UbuntuϳöÏÖMysql error(2002)µÄ½â¾ö·½·¨

      ¹ýÁËÒ»Õó×Óºó£¬ÎªÁËд·Ö²¼Ê½×÷Òµ£¬ÖØÐÂʹÓÃMysqlʱ£¬·¢ÏÖËäÈ»Æô¶¯³É¹¦ÁË£¬µ«ÊÇÁ¬½ÓµÄʱºòÈ¥³öÏÖÈçÏ´íÎó
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
¸ù¾ÝÌáʾÊÇ/var/run/mysqld/mysqld.sockÎļþ²»´æÔÚ¡£
Ϊʲô»áÕâÑùÄØ£¿
  ......

MySQLÊý¾Ý¿âÎļþ½éÉÜ

±¾ÎÄÁ´½Óhttp://www.chysoft.net/files/article_234.htm ¸ü¶à×ÊѶÇë½øÈëwww.chysoft.net 
mysqlµÄÊý¾Ý´¢´æÄ¿Â¼ÔÚmysqlµÄÅäÖÃÎļþmy.iniÎļþÉèÖ㬸ñʽÈçÏ£º
# Uncomment the following rows if you move the MySQL distribution to another
# location
basedir = d:/cyoa/mysql_cy/
datadir = d:/cyoa/mysq ......

¹ØÓÚmysqlµÄ¾Û¼¯Ë÷Òý

·­Ò룺
InnoDB±í»á°üº¬Ò»¸ö¾Û¼¯Ë÷Òý£¨Êý¾Ý±íµÄÎïÀí´æ´¢Ë³ÐòºÍ±íµÄÂß¼­´æ´¢Ë³ÐòÒ»Ö£©
Ò»°ãÊǰ´ÕÕÏÂÃæµÄ¹æÔòÀ´É趨¾Û¼¯Ë÷ÒýµÄ£º
1£¬¼ÙÈç±í°üº¬PRIMARY KEY£¬InnoDBʹÓÃËü×÷Ϊ¾Û¼¯Ë÷Òý
2£¬¼ÙÈç±íûÓж¨ÒåPRIMARY KEY£¬InnoDB½«µÚÒ»¸öÖ»°üº¬NOT NULLÊôÐÔÁеÄUNIQUE index×÷ΪÖ÷¼ü²¢ÇÒ½«ËüÉèÖÃΪ¾Û¼¯Ë÷Òý
3£¬Ç°Á½Õß¶¼²»Âú× ......

mysql ³£ÓþÙÀý

drop table student;
create table student
(sno   int   not null unique,
 sname varchar(8) not null,
 ssex  char(2)    not null,
 sage int ,
 sdept varchar(20));
 
 select * from student;
 alter table student drop uniq ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ