Souleymane Mato souleymatoo
souleymatoo
/ mysql-docker.sh
Created
March 15, 2018 12:54
— forked from spalladino/mysql-docker.sh
Backup and restore a mysql database from a running Docker mysql container
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # Backup | |
| docker exec CONTAINER /usr/bin/mysqldump -u root --password=root DATABASE > backup.sql | |
| # Restore | |
| cat backup.sql | docker exec -i CONTAINER /usr/bin/mysql -u root --password=root DATABASE | |
souleymatoo
/ pg_to_es.py
Created
November 11, 2017 16:41
Postgres to Elasticsearch conversor script. It will assumes: - Database is equivalent as an index
- Tables are equivalent as a mapping types You must pass a query for retreive data.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/usr/bin/python | |
| import psycopg2 | |
| import psycopg2.extras | |
| from pyes import * | |
| import argparse | |
| import traceback | |
| import math | |
| def ResultIter(cursor, arraysize=100): | |
| # An iterator that uses fetchmany to keep memory usage down |