Home › Forums › Users › General User's Discussion ›

Bakups

Submitted by Guest on Wed, 01/01/2020 - 19:35
in

i am new to the openvpms application and I am trying to find where the database is stored so I can generate routine backups.

Can any assist

thanks 

‹ Application error when clicking on insurance tab after upgrading to 2.1.2 Orders ›

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Re: Bakups

Submitted by tanderson on Thu, 02/01/2020 - 08:02.

The most common way of performing a backup is to use the mysqldump tool shipped with MySQL.

See https://www.openvpms.org/documentation/csh/2.1/topics/how/backup for more details.

Note that the 'raw file copy' option described on that page should only be used if you find the performance of mysqldump to be too slow. Done incorrectly, it will lead to database corruption. If you need a faster backup, use Percona XtraBackup. Note that this is not available on Windows.

 

 

Re: Bakups

Submitted by Glen (not verified) on Fri, 03/01/2020 - 18:41.

Thanks

 

So there's no way in picking out the data base files directly to back up

 

Re: Bakups

Submitted by tanderson on Sat, 04/01/2020 - 07:31.

You can, as per the 'raw file copy' section on the page linked above, but it isn't recommended. The MySQL server needs to be shut down before copying the files to avoid database corruption. If you do use this technique, make sure you can actually restore the backup on another machine; backups are no good if they don't work.

Syndicate content