정재익님 안녕하세요..

저는 deja.com의 discussion(news group)을 자주 들르는데요.

여기에서 db backup에 관련하여 mysqlhotcopy란게 많이 보이더라구요..

그냥 스크립트같은데...잘 모르겠네요..

오늘 데자에 방문해서 찝어온걸 올립니다.

(영어도 짧고 db도 잘몰르고...해서 원문으로 올림)

===> Here's a modified version of mysqlhotcopy.

>

> New features:

>

> copies multiple databases in one go

>

> databases can be selected with a Perl regexp (eg. '.*' )

>

> option to flush logs before copy

>

> option to write checkpoint records before copy

I should add that I'm happy for Martin to take over development of mysqlhotcopy and I'm happy with the concept of these changes.

I'd also be happy for this version to be included in MySQL 3.23.x since there's a fairly subtle change in the semantics of the command line and I'd rather that got made with mysqlhotcopy and MySQL 3.23 are both still labeled alpha.======