View source for Tracking changes with git

==MySQL==
Daily backup:

    mysqldump -u mysql_user -pmysql_password --skip-extended-insert mysql_database > /path/to/db_backup_`date --rfc-3339=date`.sql

==PostgreSQL==
* need the '''--inserts''' flag to act similar to MySQL's '''--skip-extended-insert'''
* Need a .pgpass file to contain the postgresql database user's password (the "no-password" flag below means don't prompt for a password, look for a .pgpass file). 

    pg_dump -h localhost -U postgres_user -p port --no-password --inserts dbname

From the manual (man) page for pg_dump:
:       ''--inserts
::           ''Dump data as INSERT commands (rather than COPY). This will make restoration very slow; it is mainly useful for making dumps that can be
::           ''loaded into non-PostgreSQL databases. However, since this option generates a separate command for each row, an error in reloading a row
::           ''causes only that row to be lost rather than the entire table contents. Note that the restore might fail altogether if you have
::           ''rearranged column order. The --column-inserts option is safe against column order changes, though even slower.''