A chronological documentation test project, nothing serious, really!
# mysql dbname -B -N -e “SELECT serial FROM serials” >/path/to/outfile -B or –batch: prints rows tab-separated and turns off the borders -N or –skip-column-names: leaves out the header row
# mysqldump -u root -p –no-create-info -T=/tmp –fields-terminated-by=’\t’ db tabell
# mysqldump -h host.com -u root -p password sourceDB | mysql -h host2.com -u username -p password -C targetDB Interestingly, you don’t actually have be on the ‘source’ machine thanks to mySQL’s -h switch. From the target machine, simply specify the remote host after the -h. This was quite useful for me as my source […]
tar -czpf – source_dir –exclude=/proc –exclude=/mnt | ssh user@desktop ‘cat > /path/to/target/dest.tar.gz’
# ps auxww | grep “udev\|devfs” | grep -v “grep” # cat filnavn.txt |grep “\”Name\”\|Description” > skrivere_navn_og_ip.txt