Restoring Insurance Companies

aperezcrespo wrote on Sunday, August 12, 2007:

Hi
  In hopes avoiding having to reenter Inurance Companies I have exported the insurance_companies.  Unfortunatly when I import them into a new install they are not visible in OpenEMR.  They ARE in MySQL but unavailable to in the OEMR Insurance companies option.

Am I missing something?  Or is there another way of doing this?

Thanks
Alfonso

bklambdin wrote on Sunday, August 12, 2007:

Sorry this may not help you this time, but the next time it will.
Test it for yourself to make sure it really does work for you.

Here is a backup script I use, it copies a lot of extra stuff that is not needed, but it will copy everything that has been customised inside the VM.

You may have to tweak it a bit to fit your VM, maybe add a couple of directories.
I don’t have the CD burning option at the bottom working yet.
After you do the back, just http into the /backups and click on the newly created backup and save to whatever you like.
This will make one large compressed file with the date the backup was ran.

mkdir /var/www/backups/tmp
# dump the sql database
mysqldump --opt --all-databases | gzip > /var/www/backups/tmp/mysql.bak`date -I`
#dump the postgre database
sudo -u postgres pg_dumpall | gzip > /var/www/backups/tmp/postgresql.bak`date -I`
# copies the openemr site, will get all the custom mods that were made
tar -cvf /var/www/backups/tmp/openemr.`date -I` /var/www/openemr
#copies the sql-ledger site, will get the custom mods
tar -cvf /var/www/backups/tmp/sql-ledger.`date -I` /var/www/sql-ledger
#copies the acl site, will get the custom mods
tar -cvf /var/www/backups/tmp/acl.`date -I` /var/www/acl
tar -cvf /var/www/backups/tmp/apache2-default.`date -I` /var/www/apache2-default
#copies the /usr/share/freeb directory
tar -cvf /var/www/backups/tmp/freeb.`date -I` /usr/share/freeb
tar -cf /var/www/backups/backup.`date -I` /var/www/backups/tmp/*.*
rm -R /var/www/backups/tmp
# wodim dev=dev/hdc -dao -v -data -eject -multi allfiles