Export and Import options for Mysql & Postgresql Databases

DataBase Dump & Restore for MYSQL

 

Take dump from database or Export from database

   Terminal : mysqldump -h localhost --user test --password testing > testingdb.sql

Import dump files to Database or Import

  Terminal : mysql -u root -p testing_new < testingdb.sql

DataBase Dump & Restore for POSTGRESQL

 

Take dump from database or Export 

  Terminal : pg_dump -h localhost -U postgres -d testing > testdb.sql

Import dump files to Database or Import

 
  Terminal : psql -h localhost -U postgres -d testing_new < testdb.sql