Take a look at the the MySQL replication documentation and see if it might do what you are looking for. I use it to back up a local in-house database to a cloud hosted server, which is accessible to a variety of websites without being behind my firewall.
But your issues appear to be somewhat different and maybe more complex than the ones I deal with. http://dev.mysql.com/doc/refman/5.0/en/replication.html Bob Lee -----Original Message----- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Rafael Copquin Sent: Friday, December 27, 2013 7:25 AM To: profoxt...@leafe.com Subject: Re: back end They do have power backups, but they last about 20 minutes. And yes, the infrastructure is toast, as you say. But going to phone apps is not suitable. These are stores that sell over the counter. They need to issue invoices, control stocks, receivables, payables, cash... As for web apps, I am looking into FoxInCloud, as an alternative. But what about the rest of my questions? >I do not think the DB is the critical choice here. The infrastructure is toast or so it seems. I would move to phone >apps or Web apps and get away 100% from desktop environment. Is the internet stable from provider to HQ? If so >does HQ have power backups to allow a graceful shutdown over 20+ min of dead time? Would HQ consider >putting in a generator to feed the IT power as needed? [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/028d01cf0318$e81432d0$b83c9870$@1amsoftware.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.