Skip to content

Instantly share code, notes, and snippets.

@Gamblt

Gamblt/Database

Last active December 4, 2015 09:45
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save Gamblt/592a9b1d168c7306e906 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save Gamblt/592a9b1d168c7306e906 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Database
Clients
http://www.sqltabs.com/ - cool postgresql client with chats drawing and sharing
http://dbeaver.jkiss.org/ - universal client
Backup DB
#!/bin/bash
#MySQL Dump
mysqldump DBNAME > dump-$( date '+%Y-%m-%d_%H-%M-%S' ).sql --single-transaction -u USERNAME -pPASSWORD
#PostgreSQL Dump
PGPASSWORD="PASSWORD" pg_dump -h localhost -U USERNAME --encoding UTF8 DBNAME -f pgdump-$( date '+%Y-%m-%d_%H-%M-%S' ).sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment