数据库备份与还原

sqlite
直接copy  .db文件即可

postgres

pg_dump -h 164.82.233.54 -U postgres databasename > /tmp/databasename.bak

psql -h localhost -U postgres -d databasename < /tmp/databasename.bak

mysql
mysqldump –uroot –ppassword databasename > /tmp/databasename.bak
mysql -uroot –ppassword databasename  < /tmp/databasename.bak