databases - Page 4 - ricardo malla's blog

July 21, 2015postgresql, tibco - jasper reports

pgsql: cannot use extract function inside a where clause

For Exmple: AND (date_part('YEAR',fin_finacc_transaction.statementdate) = $P{Año}) or AND ((extract(Year from fin_finacc_transaction.statementdate) LIKE $P{Año}) OR $P{Año} = 'ALL') Neither of these work, […]

February 8, 2014April 5, 2023mysql

mysql: external connection to database blocked

Cannot establish an external MySQL connection to the server. Error 1. Error 10061: connect to MySQL server failed Fixed it using the […]

December 11, 2013May 18, 2014postgresql

postgresql: relevant commands

Connecting to Postgress Shell psql -U postgres -d postgres List Users select * from pg_shadow; usename | usesysid | usecreatedb | usesuper […]

November 28, 2013May 18, 2014postgresql

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 […]

August 18, 2013April 16, 2021mysql

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 […]

April 5, 2013May 18, 2014mysql

mysql: relevant commands

Connect to Database Linux: mysql -u root -p Show All Databases: show databases; Reference: http://www.cyberciti.biz/faq/mysql-command-to-show-list-of-databases-on-server/