We never dump the data .... just shutdown the slave, copy the data
directory .... and restart the slave. This practice is trustworthy
probably only where the servers are running on the same platform, mysql
server version and operating system.
-Kieran
________________________________________________________________
Blog: http://webobjects.webhop.org/
On Jun 16, 2005, at 2:02 PM, Ashley M. Kirchner wrote:
With all this discussion going on about the best way to backup
MySQL data, I have a question: Is there anything wrong with simply
copying the db files when you're backing up, as opposed to doing a
full shutdown of the server (regardless of whether it's a master or
slave) and then doing a dump of the data? (Note the difference, one
will copy files, the other dumps the data for backup.)
--
W | I haven't lost my mind; it's backed up on tape somewhere.
+--------------------------------------------------------------------
Ashley M. Kirchner <mailto:[EMAIL PROTECTED]> . 303.442.6410 x130
IT Director / SysAdmin / Websmith . 800.441.3873 x130
Photo Craft Laboratories, Inc. . 3550 Arapahoe Ave. #6
http://www.pcraft.com ..... . . . Boulder, CO 80303, U.S.A.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
