What Files To Back Up?
I've finally got OpenVPMS installed and working (on a W7-32 bit machine).
Whilst the PC I've installed it on is equipped with two 1TB Black Caviar drives in RAID-1 to minimise risks of hardware failure, I do understand that it's important that I have a back-up routine in place (it's a matter of WHEN hard drives fail, not IF) both to local and removeable or off-site drives.
My just-installed OpenVPMS is located in the recommended default positions with the InnoDB data file in C:\openvpms\data.
Performing a back-up in MySQL gives me a .SQL file of 2.56MB even though the data folder is 10MB.
(http://sunshinevet.com.au/openvpms/images/openvpms_files.jpg)
Does the MySQL back-up perform compression and save everything into the one .SQL; or do I need to back-up both MySQL and the data file?
Yuri.
Re: What Files To Back Up?
Hi Yuri,
Innodb typically stores its information in a single file which is the one you see in c:\openvpms\data. It sets the size of this file to a set initial value and when it needs to expand it increases the size by set incremental values. So essentially the file size will always be bigger than the amount of data stored.
It is also worth noting that becuase we set the file_per_table option the OpenVPMS data files are stored in a different location (where the standard myisam files are stored in the mysql data file area) so the innodb file you referenced will not be used (but still needs to be available).
The mysql backup is a sql dump of the database so its size is also not a true reflection of the data size.
In essence all you need to do it perform the backup and you have all th eOpenVPMS data you need for a restore. This includes all the documents, attachmenst and templates.
Cheers
Tony
Re: What Files To Back Up?
Thanks for that.
I've now set up a couple of "Projects" in mySQL to back up to separate internal hard drive on the server daily, plus external drive (well actually only a 32G USB stick at the moment while I'm starting up) on Mondays, Wednesdays, Fridays.
As soon as I can work out how to automatically back up and save to a website, I'll add that to the protocol so that I have an off-site back up as well (in case I forget to take home the USB stick and someone pinches the server and USB stick!) .
Cheers
Yuri.