I received some large CSV files that needed importing into a database, but unfortuntely there were hundreds of lines that
contained line feeds so they would not import correctly.
[Read More]
This is my personal summary of the book Software Architecture: The Hard Parts: Modern Trade-Off Analyses for Distributed Architectures. It’s important to note that this is only written to jog my memory - it is almost impossible to capture this book as a summary as there is so much in...
[Read More]
MariaDB backup and restore is really simple from the command line. If you have a problem with a database caused by a change (see: Wordpress), and want to restore to a previous version, you need a mysql dump file, and that’s it. All you need to do is run the...
[Read More]
When scripting SFTP jobs, it’s a good idea to include the host key fingerprint to prevent man
in the middle attacks. The easiest way I have found to get this information (if not provided) is
to use WinSCP.
[Read More]