Thanks for your quick reply. I have a ? about MySQL. See below.
Dan,
I'm a newbie so I'll need pretty detailed instructions. I would like the two machine to sync nightly. Do apache, mysql on the server have to shut down in other to sync or can they sync "on the fly"?
Any suggestions? Thanks in advance.
I'd suuggest using rsync for most of that stuff. There should be extensive HOWTO articles online on rsync; I remember one in Linux Magazine, for example.
For MySQL, I'm not sure. I believe that MySQL still lacks a open source hot backup tool, meaning that you would either have to pay $$ for a commercial tool, or shutdown MySQL and rsync the files.
Embarrassing question, eh, but where are the data files for MySQL stored? What files do I need to backup?
However, I'm not terribly up to date on MySQL ... we use Postgres here.
-- -Josh Berkus Aglio Database Solutions San Francisco
-- Check the headers for your unsubscription address For additional commands send e-mail to suse-linux-e-help@suse.com Also check the archives at http://lists.suse.com Please read the FAQs: suse-linux-e-faq@suse.com