Often it is useful to export a SQL query result into a file. Especially CSVfiles are nice for this task. The following SQL query saves the result in a file called output.csv into the /tmp directory: SELECT * FROM my_table INTO OUTFILE ‘/tmp/output.csv’ FIELDS TERMINATED BY ‘,’ ENCLOSED BY ‘”‘ LINES TERMINATED BY ‘\n’;
I just had trouble to install the Sun Java6 JDK after updating to Ubuntu 10.04 for my project on Faculty. The problem was that the system couldn’t find the package sun-java6-sdk and apt-get gave me the following message: Package sun-java6-jdk is not available, but is referred to by another package. This may mean that the package is missing, has been obsoleted, or […]
Boot-Repair is a small graphical tool to restore access to Ubuntu and other OS (Windows..). It is a free software, licensed under GNU-GPL. Boot-Repair is not officially supported by Canonical, use it at your own risks. Installing : sudo add-apt-repository ppa:yannubuntu/boot-repair sudo apt-get update && sudo apt-get install -y boot-repair && boot-repair Boot-Repair can be installed […]
To remove multiple files such as *.jpg or *.sh with one command find, use find . -name “FILE-TO-FIND”-exec rm -rf {} \; OR find . -type f -name “FILE-TO-FIND” -exec rm -f {} \; The only difference between above two syntax is that first command can remove directories as well where second command only removes […]