Example for storing database dumps on S3.
yii db/export --outputPath=/app/runtime/_debug && \
yii migrate/history > /app/runtime/_debug/migrate-history.log && \
yii fs/sync runtime://_debug s3:// --interactive=0 && \
yii fs/rmdir runtime://_debug --recursive --interactive=0
Download via Filefly
Note! It is strongly recommended to remove the debug dumps after downloading them.
yii db/destroy --interactive=0 && \
yii db/create && \
yii db/import $X_DB_DUMP_SQL && \
yii migrate --interactive=0 && \
yii cache/flush-all
Transfer data from staging to migrations
- Go to
/resque
yii db/x-dump/data
- Download (via Moxiemanager or Filyfly)
- Create file migration, place into tests/codeception/_migrations/VERSION
- cd tests
- make clean all
- make run-tests (or make bash $ codecept run)
- Do not export the schema (experimental: use
yii db/x-dump-data
) - Don't export the data of tables such as
- log
- migration
- language
- auth
- Use correct time in migration history
- minimize the number of
dev-master
packages