Articles, notes and random thoughts on Software Development and Technology
This website running this blog has been running in Docker containers on a small-ish 4GB VPS for the past 9 months pretty much issue free. You can follow by journey to migrate this site to Docker in posts here and here. Since I’ve been spending time recently getting up to speed with Kubernetes, the next …
Continue reading “Next steps: From NGINX WordPress and MySQL running on Docker, to Kubernetes”
Atlassian Confluence is already available as a Docker Image from the Docker Hub but you still need to provide a database instance for a production setup. Let’s build a docker-compose file to create a container from this image together with a container running MySQL. First, per the docs on the Docker Hub page, create an …
Continue reading “Installing and Configuring Atlassian Confluence with MySQL in Docker Containers”
I can never remember how to do this, so leaving this here: select post_title, post_content from wp_posts order by post_date asc into outfile ‘/var/lib/mysql-files/yourfile.txt’; Also see: mysql ‘select … into outfile’ access denied Exporting select result from MySQL and getting the error ‘ERROR 1290 (HY000): The MySQL server is running with the –secure-file-priv option’
To use ‘select … into outfile’ on MySQL the user needs to have the FILE permission as described here. Even with this privilege however, if there server is running with the –secure-file-priv option you’ll see this error: ERROR 1290 (HY000): The MySQL server is running with the –secure-file-priv option When this option is enabled there’s usually …