needs_upgrade Posted May 27, 2009 Share Posted May 27, 2009 Hi guys! How can I dump mysql data from the server to other stations connecting to it? I would like to have many backups. Thanks a lot. Quote Link to comment Share on other sites More sharing options...
corbin Posted May 27, 2009 Share Posted May 27, 2009 mysqldump? For example, I run a backup every night that does: mysqldump -uroot -proot --all-databases > mysql.bak.sql (I think compress it and do some other stuff, but you get the point.) Quote Link to comment Share on other sites More sharing options...
needs_upgrade Posted May 28, 2009 Author Share Posted May 28, 2009 It does dump the data within the mysql backup folder. What if I wanted to save the back up in 192.168.0.2 and 192.168.0.3 workstations? Is it possible? Quote Link to comment Share on other sites More sharing options...
Daniel0 Posted May 28, 2009 Share Posted May 28, 2009 Setup replication. It's explained in the manual. Of course this is probably not a backup in the sense you mean. If you delete a row on the master server it would propagate to the slave servers as well. You could have a cron job for routinely dumping the data on the slave servers though, which will give you extra redundancy. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.