Example task: Multiply the table holidays between several stages.

Open two terminals:

shell-for stage_1
shell-for stage_2

Get the stage1 and stage2 MySQL credentials:

cat /opt/www/the_stage.host.tld/current/config/database.yml
cat config/database.yml # should do it

Dump the table to a path reachable by the stage2 user (e.g. home):

mysqldump -h mysql1 -u stage_1_user -p stage_1_database table_name > ~/table_name_dump.mysql # Select certain records using --where "some_id > 666"

(-h stands for hostname and it is in deed 'mysql1')

Import the dump:

mysql -h mysql1 -u stage_2_user -p stage_2_database < /home/stage_1_user/table_name_dump.mysql # attention to stage1 and stage2

Note that importing a table overwrites an existing table. There won't be a magic merge.

Last edit

About 10 years ago

Keywords

backup, dump, restore

License

Source code in this card is licensed under the MIT License.

Async control flow in JavaScript: Promises, Microtasks, async/await

Slides for Henning's talk on Sep 21st 2017.

Understanding sync vs. async control flow

Talking to synchronous (or "blocking") API

print('script start')
html = get('/foo')
print(html)
print('s...

Delivering Carrierwave attachments to authorized users only

Preparation

To attach files to your records, you will need a new database column representing the filename of the file. To do this, add a new migration (rails g migration <name>) with the following content:

class AddAttachmentToNotes...

Posted to makandra dev (2012-09-27 10:13)

Howto transfer a single mysql table between several deployment stages

Related cards:

Understanding sync vs. async control flow

Talking to synchronous (or "blocking") API

Summary

Introduction

Preparation