You could do an online backup, rsync it and then restore. But it would use a lot more resources than just doing a one way transaction replication. And it would need to take the slave down while restoring. I'll be doing this on a project coming up, but it is acceptable for me to take the slave down on a sync. And my db is only a few hundred mb so it should backup and restore in acceptable time.
Ryan Apoptosis wrote: > I thought you couldn't cp or rsync the database while its running. I > can't take down the master to make a copy on slave. Also incrementals > are preferable to copying whole files when your db is pushing 10GB. > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/h2-database?hl=en -~----------~----~----~----~------~----~------~--~---
