combatpoodle/gist:7816443

Created December 6, 2013 00:07

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/combatpoodle/7816443.js"></script>
Save combatpoodle/7816443 to your computer and use it in GitHub Desktop.

Download ZIP

pt-archiver

Raw

gistfile1.txt

pt-archiver --user USER --password PASSWORD --no-check-charset --host=127.0.0.1 --file '/PATH/TABLE_%Y-%m-%d-%D.%t' --for-update --check-slave-lag h=HOST,u=USER,p=PASSWORD --source D=DATABASE,t=TABLE --where 'modified <= DATE_SUB(NOW(), INTERVAL 4 WEEK)'

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment