Class
- Tip&Tech
[½ºÅ©¸³Æ®] À©µµ¿ë MySQL ¹é¾÷ | |||||
±Û¾´ÀÌ | ÇÒ¹è | ³¯ Â¥ | 06-11-22 18:05 | Á¶ ȸ | 8718 |
---|---|---|---|---|---|
°£ÆíURL |
https://phpschool.com/link/tipntech/49868
|
||||
°£´ÜÇÑ MySQL¿ë ¹é¾÷ ¼Ò½ºÀÔ´Ï´Ù.
À¯·á ¹é¾÷ÇÁ·Î±×·¥À» »ç¿ë ÇÒ ¼ö ¾ø¾î¼.... DOS ¸í·É¾î¿Í ¾ËÁýÀ» ÀÌ¿ëÇÏ¿´½À´Ï´Ù. Ȥ½Ã ÇÊ¿äÇÑ ºÐ ÀÖÀ»±îÇؼ ¿Ã¸³´Ï´Ù »ç¿ë¹ýÀº ¾Æ·¡ ¼Ò½º¸¦ bat ÆÄÀÏ·Î ÀúÀåÇϽŠÈÄ À©µµ¿ìÁî¿¡¼ Áö¿øÇÏ´Â "¿¹¾àµÈ ÀÛ¾÷"À¸·Î ½ºÄÉÁÙ Àâ¾Æ¼ »ç¿ëÇÏ½Ã¸é µË´Ï´Ù. @echo off SET today=%DATE% SET backup_dir="e:\webthink_backup\db_backup" SET db_exe="c:\mysql\bin\mysqldump" SET db_user="root" SET db_pass="1234" SET db_option="-A" SET db_name="" REM REM sqlÀ» dump ¹Þ´Â´Ù REM echo SQL DB¸¦ DUMPÇÏ´Â ÁßÀÔ´Ï´Ù. %db_exe% %db_option% "-u"%db_user% "-p"%db_pass% %db_name% > "%backup_dir%\dump_%today%.sql" echo DUMP ¿Ï·áµÈ ÆÄÀÏÀ» ¾ÐÃàÇÏ°í ÀÖ½À´Ï´Ù. REM REM alzip -a "%backup_dir%\dump_%today%.sql" echo DUMP ¿Ï·áµÈ ÆÄÀÏÀ» ¾ÐÃàÀ» ¿Ï·áÇÏ¿´½À´Ï´Ù. REM REM echo SQL DB¸¦ DUMPÇÑ ÆÄÀÏÀ» »èÁ¦ÇÏ°í ÀÖ½À´Ï´Ù. REM REM del "%backup_dir%\dump_%today%.sql" REM REM echo ¸ðµç ¹é¾÷ÀÌ ¿Ï·áµÇ¾ú½À´Ï´Ù. ´ÙÀ½Àº µð·ºÅ丮 ¹é¾÷ @echo off SET today=%DATE% SET backup_dir="D:\home\public_html" SET backup_zip="D:\webthink_backup\home_backup" REM REM ȨÆäÀÌÁö ÆÄÀÏÀ» ALZipÀ¸·Î ¾ÐÃàÇÏ°í, ÆÄÀÏÀº Áö¿î´Ù REM echo %backup_dir% Æúµå¸¦ ¾ÐÃàÇÏ°í ÀÖ½À´Ï´Ù. REM REM alzip -a "%backup_dir%" "%backup_zip%\home_%today%.zip" REM REM echo ¸ðµç ¹é¾÷ÀÌ ¿Ï·áµÇ¾ú½À´Ï´Ù. |
|||||
|
Àüü´ñ±Û¼ö 7
-
Ƽó 06-11-23 01:15
¼Ò½ºº¸±â
-
ÀÌ°Å À©µµ¿ì2000¿¡¼´Â date ÇÔ¼ö¶§¸Å °è¼Ó µ¤¾î¾¯¾îÁú²®´Ï´Ù.
dateÇÔ¼ö°¡ À©µµ¿ì2000¿¡¼´Â ¾È¸ÔÈ÷´õ¶ó±¸¿ä....
¸í·É ÇÁ·ÒÇÁÆ®¿¡¼ Á÷Á¢Âï¾îº¸¸é µÇ´Âµ¥.. bat ÆÄÀÏ·Î µ¹¸®¸é ¾ÈÂïÈ÷´õ¶ó´Â..
xp¿¡¼´Â Á¦´ë·Î ÀÛµ¿µÇ°í... ¿Ö±×·¯´ÂÁö´Â ¾ÆÁ÷µµ ¸ð¸£°Ú»ï...
-
¶±ÀÙ 06-11-23 08:25
¼Ò½ºº¸±â
-
À©µµ¿ì¿¡¼ »ç¿ëÇÒÀÏÀº ¾øÁö¸¸, Çѹø »ç¿ëÇØ ºÁ¾ß °Ú³×¿ä..
ÁÁÀº TIP À̳׿ä..
1 2 3 4 5 6 7