Home › Forums › implementation › Implementation discussion ›

Back Up openVPMS

Submitted by Yuri on Sat, 08/03/2014 - 14:35
in

Just preparing to perform 1.6->1.7 upgrade and step 1 is to back up my database.

If I use MySQL Admin -> Backup, I get an 835MB file. 

However, if I open a command prompt and type in the instruction
mysqldump -u openvpms -p openvpms > openvpms.sql
as per the readme instructions, I get a 509MB file.

Which is correct? Are both correct? Is mysqldump better at compressing data?

Yuri.
(suddenly nervous!)

‹ SQL subreport problems Problems entering Date/Time as report parameter ›

Comment viewing options

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

Re: Back Up openVPMS

Submitted by tanderson on Sat, 08/03/2014 - 18:55.

The mysqldump command above is only dumping the openvpms database.

Perhaps the MySQL Admin backup is backing up all databases?

Also note that backups taken using mysqldump may not be compatible with MySQL Admin: http://bugs.mysql.com/bug.php?id=20645

-Tim

Re: Back Up openVPMS

Submitted by Yuri on Tue, 11/03/2014 - 15:45.

Thank you - did a backup each way to be covered.

Yuri.

Syndicate content