Ä¿ÇÇÇâÀÌ ³ª´Â *NIX
Ä¿ÇǴнº
½Ã½ºÅÛ/³×Æ®¿÷/º¸¾ÈÀ» ´Ù·ç´Â °÷
*
HanIRCÀÇ #coffeenix ¹æ
[
Àåºñ ¹× ȸ¼± ÈÄ¿ø
]
> Forum <
IT ÀÏÁ¤
N
e
w
!
ÀÚµ¿È ÇÁ·ÎÁ§Æ®
HOME
>
½Ã½ºÅÛ °ü¸® / ¼¹ö¿î¿µ
>
¹é¾÷(backup) / ½Ã½ºÅÛ º¹±¸
µµ¿ò¸»
°Ë»ö :
»çÀÌÆ®
WHOIS
À¥¼¹ö Á¾·ù
Mysql Dump ¹é¾÷ Çϱ⠽ºÅ©¸³Æ®..
ÀÛ¼ºÀÏ : 2003/11/27 20:33
±Û¾´ÀÌ : mindline
Á¶È¸¼ö : 8008
[
ÀÌÀüȸé
/
¼öÁ¤
] ºñ¹Ð¹øÈ£ :
¾È³çÇϼ¼¿ä. 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
:-)
±×·³.
Ä¿ÇǴнº Ä«Æä ÃÖ±Ù ±Û
[04/25]
±¹°¡
[04/24]
º¸Çè
[04/22]
Re: OpenSSL Ãë¾àÁ¡ Á¤¸®, Logjam(·Î±×Àë)¿¡¼ Heartbleed±îÁö
[04/21]
LET¡¯S START WITH ON
[04/21]
º¸Çè
[04/20]
Á¦ÁÖ
[04/20]
±¹³»
[04/19]
Á¦ÁÖ
[04/18]
??? ?????
[04/17]
???? onion ?????? -
[04/11]
±¹°¡
[04/10]
Stride Into Dream:
[03/20]
Re: ¿Â¶óÀΰÔÀÓÀÇ Á¾ÁÖ±¹ ´ëÇѹα¹
[10/20]
Cross Compiler ±ò
[07/14]
SSL ¬¡¬°
N
e
w
! ÃÖ±Ù¿¡ µî·ÏÇÑ ÆäÀÌÁö
KiCad EDA Suite project (Free/Libre/Open-Source EDA Suite) (CAD)
¿ÀÇÂij½ºÄÉÀ̵å ijµå (OpenCASCADE CAD)
QCad for Windows --- GNU GPL (Free Software)
The Hello World Collection
IPMI¸¦ È°¿ëÇÑ ¸®´ª½º ¼¹ö°ü¸®
DNS ¼³Á¤ °Ë»ç
nagiosgraph ¼³Ä¡ ¹æ¹ý
Slony-I ¼³Ä¡ ¹æ¹ý (postgresql replication tool)
Qmail±â¹ÝÀÇ Anti spam ½Ã½ºÅÛ ±¸ÃàÇϱâ
clusterssh
[ ÇÔ²²ÇÏ´Â »çÀÌÆ® ]
¿î¿µÁø :
ÁÁÀºÁøÈ£(truefeel)
, ¾ß¼ö(yasu), ¹ü³ÃÀÌ, sCag
2003³â 8¿ù 4ÀÏ~