copy mysql database with perl

[Wang Penghui]

Hi all.

Could perl copy mysql database just like mysqlhotcopy do?
Such as i have a database named "a" in mysql. Then i want to get a
snapshot of it. And the snapshot called "b" as another database in
mysql. Is it possible or not?

Thanks advance!

Wang

 

[Bill]

use CPAN;

use DBIx::Admin::BackupRestore;

Merry Christmas;

 

[AaronJSherman]

Of course, you could do this from the command-line easily enough:

mysqldump --opt -u root a | mysql -u root b

Replace "root" with whatever mysql user you want to do this as, of
course.