Steve Ruby wrote:
>
> Scott Baker wrote:
> >
> > That's the way that I do. I setup my server to shutdown the MySQL process
> > at 3am, zip up my var directory, and then restart the process. Can you
> > copy the data with the server running?
>
> If you are shutting down the server, why don't you just copy the files
> out to the backup and then restart? Why would you want to copy them back in?
> Save the disk IO and don't remove them in the first place, it would be
> faster and you wouldn't have to worry about....
>
> Yes, you can copy them back in but you should have locks on them through
> some thread so that something doesn't try to write to them.. still
> I'm not sure I see the need since you are backing up the data and
> should not be removing it.
Sorry to be entering this thread late and perhaps ignorantly, but, backups
should be an implementation that preserves data and (if possible) maintains
useability to the application. Log-update seems a likely candidate and pulling
the backup server into a non-update state and mysql-dumping to a file and
implementing some off-line means of getting that data somewhere useful for your
strategy should be trivial.
Perhaps, this thread applies to a situation where there's only one server. If
so, I apologize for piping up.
For the record, I understand the implications. Have had several server moves
last week that required extensive manual replications. It went well, but, with
much effort. Redundant servers is appearing more-and-more the most viable way
to keep servers up, secured, and complete. What inspires this most is uptime.
There are MySQL means to do this without shutting the server down, if there are
additional servers to play with. If I'm off-base, I apologize.
Regards,
Van
--
=========================================================================
Linux rocks!!! http://www.dedserius.com
=========================================================================
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
