sramzes321 0 Posted December 18, 2017 Share Posted December 18, 2017 " config this script ... but dont work .... " xD typical polish whore. DONT WORK XDDDDDDDDDDD Link to comment Share on other sites More sharing options...
Management Karbust 4884 Posted December 18, 2017 Management Share Posted December 18, 2017 4 hours ago, sramzes321 said: " config this script ... but dont work .... " xD typical polish whore. DONT WORK XDDDDDDDDDDD Why bring up a post with almost 4 years without a obvious reason? Link to comment Share on other sites More sharing options...
stahlpruegel 0 Posted July 25, 2019 Share Posted July 25, 2019 Can i use this in 2019? Im looking for mysql backup script Link to comment Share on other sites More sharing options...
Premium Shogun 4590 Posted April 4, 2020 Premium Share Posted April 4, 2020 I don't see why it shouldn't work. By the way if you run a live server and have problems with the server lagging at backup time, here's a solution $MYSQLDUMP -u $MYSQL_USER -p$MYSQL_PASS $db | $GZIP -9 | cstream -t 16m > $LOCAL_FOLDER/$FILE Installing cstream (pkg install cstream) will allow you to set a bandwidth for the dump, in this case I set it at 16 mb per second. Tune to your liking. There are other issues related to backing up a live server though, mainly the consistency - while we are backing up something, something else may get updated creating an inconsistency or worse,corrupting the table. Also MyISAM tables get locked during a backup, potentially crashing or lagging the game in the meantime. Consider switching to InnoDB. Link to comment Share on other sites More sharing options...
Recommended Posts