×Ô¶¯±¸·ÝSQL2000/MysqlµÄÅú´¦ÀíÎļþ
@echo off
C:
CD "C:\Program Files\WinRAR"
net stop MSSQLserver
winrar.exe a -ag"-[YYYY-MM-DD-HH-MM-SS]" -k -r -s
-ibck -inul "E:\SQL2000±¸·ÝÉú³ÉµÄÎļþ.rar" "E:\SQL2000ËùÔÚÊý¾Ý¿âµÄDataĿ¼µÄλÖÃ\*.*"
net
start MSSQLserver
net stop Mysql
winrar.exe a -ag"-[YYYY-MM-DD-HH-MM-SS]" -k -r -s -ibck
-inul "E:\MYSQL±¸·ÝÉú³ÉµÄÎļþ.rar" "E:\MysqlËùÔÚÊý¾Ý¿âµÄDataĿ¼µÄλÖÃ\*.*"
net start
Mysql
½«ÉÏÃæµÄÎļþ±£´æΪ£ºbackupsql.bat
½«ÀïÃæµÄ
"E:\SQL2000ËùÔÚÊý¾Ý¿âµÄDataĿ¼µÄλÖÃ\*.*"
¸Ä³ÉÄú×Ô¼ºµÄSQL2000µÄdataĿ¼,Èç
"E:\Program Files\Microsoft SQL Server\MSSQL\Data\*.*"
ÔÙ½«ÀïÃæµÄ
"E:\MysqlËùÔÚÊý¾Ý¿âµÄDataĿ¼µÄλÖÃ\*.*"
¸Ä³ÉÄú×Ô¼ºµÄMysqlµÄdataĿ¼,Èç:
"E:\Program Files\MySQL\MySQL Server 5.0\data\*.*"
±£´æºó,
Äú¾Í¿ÉÒÔÔÚ·þÎñÆ÷ÉϵĿØÖÆÃæ°å,¼Æ»®ÈÎÎñÖÐ,
Ìí¼ÓÒ»¸ö¼Æ»®ÈÎÎñ,µ÷ÓÃÕâ¸öbackupsql.batÀ´ÔËÐоͿÉÒÔʵÏÖ¶¨Ê±±¸·Ý.±¸·ÝÉú³ÉµÄÎļþĬÈϱ£´æÔÚEÅÌ,Äú¿ÉÒÔͨ¹ýÐÞ¸Äbackupsql.batÀ´ÐÞ¸ÄλÖÃ.
Ïà¹ØÎĵµ£º
ÅäÖû·¾³:UUbuntu 8.04
1.°²×°vsftpd
sudo apt-get install vsftpd
2.´´½¨guestÓû§
vsftpd°²×°µÄʱºò»á×Ô¶¯°²×ªÒ»¸öftpÓû§£¬ÔÚpasswdÖÐɾ³ý
sudo useradd virtual
ÉèÖÃvirtualµÄÃÜÂëΪwebftp
sudo passwd virtual
±à¼virtualÓû§µÄÖ÷Ŀ¼²¢ÉèÖÃshell
sudo vim /etc/passwd
ÎÒÉèÖõÄÊÇvirtual:x:1001: ......
Sql´úÂë
--²ÉÓÃSQLÓï¾äʵÏÖsql2005ºÍExcel Êý¾ÝÖ®¼äµÄÊý¾Ýµ¼Èëµ¼³ö£¬ÔÚÍøÉÏÕÒÀ´Ò»--Ï£¬ÊµÏÖ·½·¨ÊÇÕâÑùµÄ£º
--Excel---->SQL2005 µ¼È룺
select * into useinfo from O ......
import java.sql.*;
/*
* JAVAÁ¬½ÓACCESS£¬SQL Server,MySQL,OracleÊý¾Ý¿â
*
* */
public class JDBC {
public static void main(String[] args)throws Exception {
Connection conn=null;
//====Á¬½ÓACCESSÊý¾Ý¿â ......
²Ù×÷Êý¾Ý¿â
µÇ¼µ½mysqlÖУ¬È»ºóÔÚmysqlµÄÌáʾ·ûÏÂÔËÐÐÏÂÁÐÃüÁÿ¸öÃüÁîÒԷֺŽáÊø¡£
1¡¢ ÏÔʾÊý¾Ý¿âÁÐ±í¡£
show databases;
ȱʡÓÐÁ½¸öÊý¾Ý¿â£ºmysqlºÍtest¡£ mysql¿â´æ·Å×ÅmysqlµÄϵͳºÍÓû§È¨ÏÞÐÅÏ¢£¬ÎÒÃǸÄÃÜÂëºÍÐÂÔöÓû§£¬Êµ¼ÊÉϾÍÊǶÔÕâ¸ö¿â½øÐвÙ×÷¡£
2¡¢ ÏÔʾ¿âÖе ......
ÒÔǰû½Ó´¥¹ýÕâ¸ö¶«¶«£¬Ç°ÌìÒ»¸öͬÊÂÈÃÎÒ°²×°ÏÂjira+confluence£¬µ«ÊÇconfluenceŪÁ˺ó¤Ê±¼äҲû¼¯³É³É¹¦£¡ÏÖÔÚ°ÑÉÏÊöÈýÕߵļ¯³É¹ý³Ì×ܽáÏ£¡
°²×°»·¾³£º
ϵͳ£ºxp sp2
jdk: 1.6
tomcat: 5.5 °²×°°æ (¿ÉÒÔÓýâѹ°æµÄ)
MySql: 5.0.x
ËùÐèÈí¼þ£º
jiar£º atlassian-jira-enterprise-3.9.3.zi ......