Douglas Muth on 17 Jul 2012 07:41:24 -0700

[Date Prev] [Date Next] [Thread Prev] [Thread Next] [Date Index] [Thread Index]

Re: [PLUG] Server Backup best practices...

On Tue, Jul 17, 2012 at 10:37 AM, Paul Walker
<> wrote:
> I need to do a server backup on a large production server with a 500GB
> drive, and maybe 10+GB of sql. Everything has been migrated to a new host
> over a month ago and I just want to get a canonical backup of the old server
> before wiping it. I'm thinking to just pull the whole thing down to a local
> drive with rsync.

rsync would work.  It will take awhile, but you can restart it if it
aborts partway through.

> The database stuff is a little less clear. Typically mysqldump (`or mysql
> [...] > filename.sql`) will choke before completing a dump. I'm not actually
> sure where the mysql data resides in the file system. Is a copy of the
> entire remote hard drive sufficient here?

If it's a deprecated machine, why not shut down MySQL?  Then you can
just rsync its data files.

-- Doug
Philadelphia Linux Users Group         --
Announcements -
General Discussion  --