Dumping and restoring a backup.

MySQL

Use mysqldump to export. And mysql to import.

PostgreSQL

Use pg_dump to export. Use psql to import.

Oracle

Use exp to export, and imp to import.