×Ô¶¯±¸·Ý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À´ÐÞ¸ÄλÖÃ.
Ïà¹ØÎĵµ£º
ÔÚWindowsXPÖдò¿ªDOS£¬Í¨¹ýÊäÈëÃüÁî“mysql -u root -p”Çл»µ½mysqlÏ£¬Çл»Ê§°Ü£¬ÈçÏÂËùʾ£º
Microsoft Windows XP [°æ±¾ 5.1.2600]
(C) °æÈ¨ËùÓÐ 1985-2001 Microsoft Corp.
C:\>mysql -u root -p
'mysql' ²»ÊÇÄÚ²¿»òÍⲿÃüÁҲ²»ÊÇ¿ÉÔËÐеijÌÐò
»òÅú´¦ÀíÎļþ¡£
......
Éý»ªÌṩÖÕÉíÃâ·ÑASP+access PHP+mysqlÐéÄâÖ÷»ú
Ò»£ºÉý»ªÍøÂç¿Æ¼¼ÓÐÏÞ¹«Ë¾,ÓëÉý»ªÍ¬ÔÚÕ¾³¤ÖÕÉíÃâ·Ñ¿Õ¼ä·ö³Ö¼Æ»®.
1¡¢×ð¾´µÄÓû§ÄúºÃ,Ò²ÐíÄú»¹ÔÚΪÿÄêÒ»½»µÄ¿Õ¼ä·ÑÓ÷¢³î,Ò²ÐíÄúÏë»ñµÃÒ»¸ö¸üÓÅÖʵĿռäÈ´²»ÏëͶÈëÌ«¶à,´ÓÏÖÔÚÆð ÕâЩÎÊÌ⽫ÓÈжø½â→Éý»ªÍøÂç←ÓëÉý»ªÍ¬ÔÚÕ¾³¤·ö³Ö¼Æ»®È«ÃæÆô¶¯¡£
2¡¢Ã»ÓÐ×¢²á¹«Ë¾ ......
1.Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò(Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧ)¡¡¡¡
¡¡¡¡ SQLSERVERµÄ½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àífrom×Ó¾äÖеıíÃû£¬Òò´Ëfrom×Ó¾äÖÐдÔÚ×îºóµÄ±í£¨»ù´¡±ídriving table£©½«±»×îÏÈ´¦Àí£¬ÔÚfrom×Ó¾äÖаüº¬¶à¸ö±íµÄÇé¿öÏ£¬±ØÐëÑ¡Ôñ¼Ç¼ÌõÊý×îÉٵıí×÷Ϊ»ù´¡±í£¬µ±SQLSERVER´¦Àí¶à¸ö±íʱ£¬»áÔËÓÃÅÅÐò¼°ºÏ²¢µÄ·½Ê½Á ......
Èç¹ûÄã¾³£Óöµ½ÏÂÃæµÄÎÊÌ⣬Äã¾ÍÒª¿¼ÂÇʹÓÃSQL ServerµÄÄ£°åÀ´Ð´¹æ·¶µÄSQLÓï¾äÁË£º
SQL³õѧÕß¡£
¾³£Íü¼Ç³£ÓõÄDML»òÊÇDDL SQL Óï¾ä¡£
ÔÚ¶àÈË¿ª·¢Î¬»¤µÄSQLÖУ¬Ã¿¸öÈ˶¼ÓÐ×Ô¼ºµÄSQLϰ¹ß£¬Ã»ÓÐÒ»Ì×ͳһµÄ¹æ·¶¡£
ÔÚSQL Server Management StudioÖУ¬ÒѾ¸ø´ó¼ÒÌṩÁ˺ܶೣÓõÄÏÖ³ÉSQL¹æ·¶Ä£°å¡£
SQL Server Management ......