Export schema/ data out from mysql
To export schema and/or data, you can use mysqldump command:

mysqldump -u [username] -p[password] -d [schema_name] > [filename].sql

-d means no data (just gives me the schema).
-B is needed for multiple schema output
-h (hostname)

Export data out from postgresql

Export table data from postgresql to csv format
Backup and restore database in postgresql

However, if you want [...]

Continue reading " Common DBA jobs "