This script should enable, you to pull data from one (table) of database and dump to tmp folder, and import it to diff database.

#!/bin/bash

echo "Deleting dump from /tmp"
`rm -f /tmp/myDump.csv`

mysql -u tikejhya -pPASSWORD --database mail -h db.ashishnepal.com --port 3306 -ss -e "SELECT * FROM database.tablename WHERE search_string='this';" | sed 's/t/","/g;s/^/"/;s/$/"/;s/n//g' > /tmp/myDump.csv

echo "Data Copied Across"
sleep 10;

echo "Ready to Insert Data"

mysql -u tikejhya -pPASSWORD --database mail -h db.ashishnepal.com --port 3306 <
Tips: (dumping date wise)

# mysql -u tikejhya -pPASSWORD --database mail -h db.ashishnepal.com --port 3306 -ss -e "SELECT * FROM database.tablename WHERE search_string='this' AND  event_date > date(now()) - 8;" | sed 's/t/","/g;s/^/"/;s/$/"/;s/n//g' > /tmp/myDump.csv
+16
0
 
 
			
			

How to dump and restore mysql with compression (gz)

mysqldump –all-database | gzip -9 > backup.sql.gz
gzip < backup.sql.gz | mysql dbname only selected databases mysqldump --databases db1 db2 | gzip -9 > backup.sql.gz

+16

0

Mysql Dump OUTFILE
Dumping mysql database table

This way we can dump any particular database table (as csv export) and Restore (as csv import).

SELECT * FROM database.table WHERE filed='string' INTO OUTFILE '/tmp/orders.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY 'n';

LOAD DATA INFILE "/tmp/orders.csv" INTO TABLE table FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY """" LINES TERMINATED BY "n";

+19

0