how to export sqlite3 db to SQL
The shell allows redirection, and sqlite3 can get the command as a …
Databases
Articles dedicated to SQL and non-Sql databases/
Howto Set Up Named Time Zones in MySQL
Check Your System Before jumping in, it’s probably a good …
Changing column collation and character set in mysql database / schema
In the examples below, change: To create the ALTER SQLs, …
Changing column collation and character set in mysql database / schema Read More »
postgresql: how to reset forgotten postgres password
Everything flows and changes, and sometimes is forgotten over time. …
postgresql: how to reset forgotten postgres password Read More »
postgresql: Could not open file “pg_clog/0000”: No such file or directory
I am getting the error like following while accessing a …
postgresql: Could not open file “pg_clog/0000”: No such file or directory Read More »
postresql: move data directory to another location
Databases grow over time, sometimes outgrowing the space on their …
postresql: move data directory to another location Read More »
change / reset root password in mysql
Resetting the Root Password: Generic Instructions The preceding sections provide …
how to install apache cassandra on ubuntu 20.04
First, we must connect via ssh. Add the Cassandra Repository File …
ORA-39065: unexpected master process exception in DISPATCH
### Full Error ORA-39006: internal errorORA-39065: unexpected master process exception …
ORA-39065: unexpected master process exception in DISPATCH Read More »
oracle: how to create directory and grant permissions to users
Create & grant permission to directory in Oracle Create directory in …
oracle: how to create directory and grant permissions to users Read More »
how to upgrade postgresql 11 to 12 using pg_upgradecluster
We assume that we have version PostgreSQL v 11 server …
how to upgrade postgresql 11 to 12 using pg_upgradecluster Read More »
how to install PostgreSQL 12 on Ubuntu / Debian 10,11
Step 1: Update system It is recommended to update your …
how to install PostgreSQL 12 on Ubuntu / Debian 10,11 Read More »