Export mysql data to a tab-separated file
# mysqldump -u root -p –no-create-info -T=/tmp –fields-terminated-by=’\t’ db tabell
A chronological documentation test project, nothing serious, really!
# 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
Run this command from a console window ps axo “%u,%U,%p,%a,%z”