Restore postgres database from sql file -
psql <databasename> -U <username> < ~/Downloads/<filename>.sql
Find and replace a word in a directory -
find path-to-directory -type f -not -path "./directory/*" -exec sed -i '' 's/old-word/new-word/g' {} \;
To compress directory with Tar -
tar -zcvf compressFileName folderToCompress
To uncompress file with gzip -
gzip -d file_name.gz
To scp files from remote machine -
scp user@ip:/path /local_machine_path
To scp files from local to remote machine -
scp -P port_no local_file user@remote_host:remote_file
Create Mysql dump -
mysqldump -h hostname -u user --password=password databasename > filename
Load Mysql dump -
mysql -h hostname -u user --password=password databasename < filename
Copy one Mysql database to another -
mysqldump -h [server] -u [user] -p[password] db1 | mysql -h [server] -u [user] -p[password] db2
Export csv from Mysql Table -
SELECT order_id,product_name,qty
FROM orders
INTO OUTFILE '/tmp/orders.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n';