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. Link to comment https://forums.phpfreaks.com/topic/159788-dumping-data-backups-from-server-to-other-workstations/ 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.) Link to comment https://forums.phpfreaks.com/topic/159788-dumping-data-backups-from-server-to-other-workstations/#findComment-842794 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? Link to comment https://forums.phpfreaks.com/topic/159788-dumping-data-backups-from-server-to-other-workstations/#findComment-843939 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. Link to comment https://forums.phpfreaks.com/topic/159788-dumping-data-backups-from-server-to-other-workstations/#findComment-843955 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.