7 posts with tag "databases"

Update Postgres Major Version in Debian Jessie

January 24th, 2016 30,408

postgresql databases update sysadmin debian jessie

Upgrading to a minor version is done through the upgrade process of Debian. For major versions, the process is much more complex.

How to Install PostgreSQL 9.3 on Debian 7 Wheezy

March 2nd, 2014 123,073

postgresql debian wheezy linux databases how-to open source

How to Install PostgreSQL 9.1 or the latest PostgreSQL version 9.3 on Debian 7 Wheezy. Basic settings after installation.

How and When To Enable MySQL Logs

October 21st, 2013 300,844

mysql mariadb log performance databases memcached sysadmin Debian how-to

Logs is the best place to start troubleshooting. Concerning MySQL (or MariaDB), you need to refer to: General query Log, Error Log and Slow Query Log

Is it time to Remove MySQL in favor of MariaDB in Production Servers?

April 1st, 2013 36,707

mysql mariadb databases debian squeeze how-to

Recently, many popular Linux distributions have moved from MySQL to MariaDB. Think if you have to move to MariaDB in your production servers.

How to Use PHP Improved MySQLi extension (and Why You Should)

March 29th, 2013 405,939

php mysqli pdo mysql mariadb prepared statements transactions databases how-to

PHP MySQL extension is deprecated. PHP MySQLi extension is Object Oriented, supports Transactions and protects from SQL Injection, using Prepared Statements.

How to Write Code for Any Database with PHP ADODB

March 18th, 2013 56,488

php adodb databases how-to

Using php ADODB database abstraction layer, you can create PHP applications, which are functioning with many databases without modification to source code.

MySQL in a Nutshell

March 17th, 2013 9,121

mysql cli mysqldump databases how-to

Using MySQL command line client and mysqldump to perform the most important tasks for everyday use, every administrator or web developer needs to know.