Mysql Dump ¹é¾÷ Çϱ⠽ºÅ©¸³Æ®.. | ÀÛ¼ºÀÏ : 2003/11/27 20:33 |
Á¶È¸¼ö : 7990 |
¾È³çÇϼ¼¿ä. mindline ÀÔ´Ï´Ù. º°°Ç ¾Æ´Ñµ¥... Á¦°¡ ÇÊ¿ä¿¡ µû¶ó ¸¸µé¾î ¾²´Â ½ºÅ©¸³Æ®ÀÔ´Ï´Ù. Ȥ½Ã µµ¿òÀÌ µÉ±î Çؼ ¿Ã·Á º¾´Ï´Ù. ------------ ½ÃÀÛ ----------------- #!/bin/sh backup_dir="/home/mysqlbackup" dat=`date +%Y%m%d` if [ ! -d "$backup_dir/$dat" ]; then mkdir $backup_dir/$dat fi cd /var/lib/mysql for dbdir in * do if [ -d $dbdir ]; then mkdir $backup_dir/$dat/$dbdir cd $dbdir for table in *MYI do tname=`basename $table .MYI` mysqldump -pºñ¹Ð¹øÈ£ -uroot $dbdir $tname > $backup_dir/$dat/$dbdir/$tname.dump done cd .. sleep 1 fi done #pastdat=`date --date '7 days ago' +%Y%m%d` #rm -rf $backup_dir/$pastdat ---------------- ³¡ ------------------------ ´ë·« ¿ä·É²¯ µð·ºÅ丮 °æ·ÎµîÀº º¯°æÇϼ¼¿©. ^^; ¸ÅÀÏ Å©·Ð¿¡ µî·ÏÇØ ³õ±¸ ¾²¸é µÇ°ÚÁ®... Á¦ÀÏ ¹Ø¿¡ µÎÁÙÀº °è¼Ó ½×À̱⸸ Çϸé Çϵ尡 Full µÉÅ×´Ï... 7ÀÏÀÏ ÀüÀÇ µð·ºÅ丮´Â Áö¿ì¶ó´Â ¸í·É¾î ÀÔ´Ï´Ù. ( rm -rf Á¶½ÉÇϼ¼¿©. ÇöÀç ÁÖ¼® ó¸® ÀÔ´Ï´Ù. ^^ ) ´ë·« ÀÌ·¸°Ô µË´Ï´Ù. 20031127/dbname1/tablename1.dump 20031127/dbname1/tablename2.dump 20031127/dbname2/tablename1.dump 20031127/dbname2/tablename2.dump :-) ±×·³. |
Ä¿ÇǴнº, ½Ã½ºÅÛ ¿£Áö´Ï¾îÀÇ ½°ÅÍ / URL : http://coffeenix.net/board_view.php?bd_code=136 |