Archiwa: tip - Information Architect

[How To] Change character set and collate for all tables (and fields)

This is the template: Running this query will produce a list of ALTER TABLE queries you can adjust (remove/modify lines for some tables etc.). Just replace [CHARACTER-SET], [COLLATE] and [DBNAME] with values you want to set. If you want to run the code right away just modify statement like this: For example below you can… Read more [How To] Change character set and collate for all tables (and fields)

Posted on 21 May 201813 November 2018 by Michał Zięba

[Tip] Running methods at once in bash

Run always all the listed methods: It will run A then B and then C command – regardless of result of any previous method C-like code example: Run all the listed methods until the first fail (exit code different than 0): Run B only if A ended with success then run C only if B… Read more [Tip] Running methods at once in bash

Posted on 4 May 201813 November 2018 by Michał Zięba

[Tip] Bash: Move new/current task to and from the background

Starting the task in the background (add the & to the end of a command): Moving the task to the background: Restoring the task from the background: Ending the task: Example of use:

Posted on 21 April 201813 November 2018 by Michał Zięba