Restore dump python

python restore dump

https://stackoverflow.com/questions/12124959/import-sql-dump-with-subprocess


with open(dump_filename, 'r') as f: 
       command = ['mysql', '-u%s' % db_settings['USER'], '-p%s' % db_settings['PASSWORD'], db_settings['NAME']]
       proc = subprocess.Popen(command, stdin = f)
       stdout, stderr = proc.communicate()
       
       
Also check https://codepoets.co.uk/2010/python-script-to-backup-mysql-databases-on-debian/ for dumps

Download the dump from S3 example:

http://boto3.readthedocs.io/en/latest/guide/s3-example-download-file.html

Use aws cli inside docker:
docker run -it --rm -e AWS_DEFAULT_REGION='[your region] -e AWS_ACCESS_KEY_ID='[your access ID] -e AWS_SECRET_ACCESS_KEY='[your access key] image:version