postgresql: not listening

http://stackoverflow.com/questions/12286886/postgresql-server-doesnt-listen ERROR 1 could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host “xxx.xxx.xxx.xxx” and accepting TCP/IP connections on port 5432? listen_addresses = ‘*’ in /etc/postgresql/9.1/main/postgresql.conf. ERROR 2 FATAL: no pg_hba.conf entry for host “xxx.xx.xxx.xxx”, user […]

mysql: backup databases

Backups all databases mysqldump -u [user] -p[password] –all-databases > [filename].sql   specific databases mysqldump -u [user] -p[password] [database_name] > [filename].sql   specific database but omitting specific tables mysqldump -u [user] -p[password] [database_name] –ignore-table=db1.tbl1 –ignore-table=db2.tbl1 > [filename].sql   restore mysql -u […]