Download or upload a file over SSH

#Copy something from this system to some other system: $> scp /path/to/local/file username@hostname:/path/to/remote/file   #Copy something from some system to some other system: $> scp username1@hostname1:/path/to/file username2@hostname2:/path/to/other/file   #Copy something from another system to this system: $> scp username@hostname:/path/to/remote/file /path/to/local/file You can add a port with the -P param You can do it recursive with […]

Telnet

You can enter the Fritzbox – phone models via telnet. For this you have to enter special commands into your phone. To enable Telnet: #96*7* To disable Telnet: #96*8*

Add image product attribute

This is how to get a new image attribute to a given attribute set inside of a setup script (add image attribute for products): <?php /** * * Date: 5.12.2017 * Time: 0:58:0 * Last modified: 0:57:28 * Class / File: mysql4-upgrade-0.5.2-0.5.3.php * * Installs additional image attributes for customization * preview on product detail […]

Rescue-IP

The fritzbox has a permanent – non changeable – IP-address. With this address you can enter the configuration backend even if you have misconfigured the IP-settings. This IP is: 169.254.1.1

Flush DNS-Cache

In your terminal you can run the following command under MacOS $> sudo dscacheutil -flushcache $> # or $> sudo killall -HUP mDNSResponder

Copy Database directly to another Database

You can directly copy a database from one host to another host like this: $> mysqldump -u SOURCE_DB_user –password=SOURCE_DB_pass -h SOURCE_DB_HOST SOURCE_DB_name | mysql -u DB_user –password=DB_pass -h DB_host DB_name    

Import database

$> mysql -h server.host.de -u xxxxxxx -pxxxxxxx database < dump.sql or better: $> gunzip < backup-20120514151839.sql.gz | mysql -u xxxxx -pxxxxx database  

Export database

To compromise (gzip) the output: Usefull Params –single-transaction –quick –opt Export al​l Databases Through an ssh tunnel

Process list on Linux

To get a list of all running processes (process list) with CPU usage and Memory usage: $> ps -waux You can use param -r for showing only active processes. With one more additional w (f.e.: ps –wwaux) you will get the whole command. Otherwise very long commands are cut of.

Linux – Convert CR2 to JPG / PNG / etc.

To convert images taken from an Canon EOS 600D in CR2 format to the jpg format you need to install the ufraw package. $> sudo ​apt-get install ufraw After that you can navigate to the folder that contains the cr2-files and run the following bash script: $> for i in *.CR2; do ufraw-batch $i –out-type=jpeg […]