harmy / db-archiver Goto Github PK

• Copy config template to actual config file cp db-archiver-config.yml.sample db-archiver-config.yml
• Modify config file with actual credentials vi db-archiver-config.yml

python src/db_archiver.py --table my_table_name --where "created < now() - interval 6 month" --column_name_to_log id

CREATE USER 'db_archiver' IDENTIFIED BY 'somepassword';
GRANT SELECT, DELETE ON `<db_to_archive>`.`<table_to_archive>` TO 'db_archiver';
GRANT CREATE, INSERT, SELECT, DROP ON `<db_to_archive>`_archive.`<table_to_archive>`_archive TO 'db_archiver';