7 posts with tag "databases"

Update Postgres Major Version in Debian Jessie

January 24th, 2016 30,004

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 122,319

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 296,298

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,479

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 400,671

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 55,767

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,001

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.