Mysql and Postgres transfer case

1：backup  database
postgres
/usr/pgsql-9.3/bin/pg_dumpall -c >/opt/backup/postgres/pg_dumpall.dmp
mysql
 mysqldump -uroot -p --skip-lock-tables --all-databases > /opt/backup/mysql/mysql.sql

 

2：scp databases
postgres
cd /opt/backup/postgres/
scp pg_dumpall.dmp conversant@192.168.1.22:/opt/app/
mysql
cd /opt/backup/mysql/
scp mysql.sql conversant@192.168.1.22:/opt/app



3：restore database
postgres
psql -f /opt/app/pg_dumpall.dmp postgres


mysql
SOURCE /opt/app/mysql.sql;