PDA

View Full Version : Backup databases on a per file basis



daniel
December 13th, 2007, 04:05 AM
Hello

is there way to dump each database to a seperate file (not all in one big
gzipped backup-data file) ?.

For examples if i choose all-database=1 in the mysql-zrm.conf i need something like this

Database mysql -> mysql
Databse usr_x_1 > user_x_1
Databse usr_x_2 > user_x_2
Databse usr_x_3 > user_x_3

and so on.

Is this possible at the moment or is it in developement for a next release ?

Thanks in advice

Daniel

sunil
December 13th, 2007, 10:52 PM
Hello

is there way to dump each database to a seperate file (not all in one big
gzipped backup-data file) ?.


Instead you can create separate backup set for each database

utdrmac
February 29th, 2008, 08:46 AM
Instead you can create separate backup set for each database

But if you do that then you can't create a consistent 'server-wide' snapshot can you?

kkg
March 3rd, 2008, 12:30 AM
Hello

is there way to dump each database to a seperate file (not all in one big
gzipped backup-data file) ?.

For examples if i choose all-database=1 in the mysql-zrm.conf i need something like this

Database mysql -> mysql
Databse usr_x_1 > user_x_1
Databse usr_x_2 > user_x_2
Databse usr_x_3 > user_x_3

and so on.

Is this possible at the moment or is it in developement for a next release ?

Thanks in advice

Daniel

What is the basic functionality that you are trying to achieve?
ZRM supports restore of a single database from a mysqldump of all databases. So if the intent is that you need to restore on a per database basis, that is already supported.

--kkg