471,108 Members | 1,264 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,108 software developers and data experts.

Fast MySQL Backup with rsync

Hi List,

wouldn't it be possible to do a fast backup of the MySQL data in this
way:

1.) rsync the MySQL data (with running mysqld)
2.) Stop mysqld
3.) rsync the MySQL data again

Please answer. I have found a similiar post in the year 2001, but no
replies. I think, if this is possible, it would be very useful for a
whole bunch of tasks. (For example changing hard drives in servers:
You could rsync everything, including the mysql data. The only
downtime would be from the point of shutting down all daemons to get a
consistent snapshot to the point of rebooting the server.)

Thank you in advance.

Regards
Kurt Tragant
Jul 20 '05 #1
0 2088

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by James | last post: by
6 posts views Thread by Mosher | last post: by
4 posts views Thread by news | last post: by
4 posts views Thread by kingskar | last post: by
1 post views Thread by mohitanchlia | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.