In terminal (while connected to the db) set output to the csv file
1) set field seperator to “;” by:
\f ';'2) set output format unaligned:
\a3) show only tuples
\t4) set output
\o '/tmp/yourOutputFile.csv'5) execute your query
select * from YOUR_TABLE6) output
\oyou will be able to find your cvs file in this location
cd //tmp
copy it using scp command or edit using nano:
nano //tmp/yourOutputFile.csv
You can also print to console with \o again.
A few time ago, I wrote a post about move wordpress to dokku.
What changed from that? Why another article? Well, I found better tools 🙂
First of all, I moved from dokku to standard docker, less problems, more scalable.
After that, I found a great orchestration tool for multiple docker servers: Rancher .
This great tool allow with few click to create a container that simple “works”.
In the process of running docker I accumulated several images that are not tagged. To remove these I use this command:
docker rmi $(docker images -a | grep "^" | awk '{print $3}')This works by using rmi with a list of image ids. To get the image ids we call docker images then pipe it to grep “^”. The grep will filter it down to only lines with the value “” in the repository column. Then to extract the id out of the third column we pipe it to awk “{print $3}” which will print the third column of each line passed to it.