BIP KB Tag: mysql

How To Compile PHP On CentOS 5 (64Bit) With MySQL Support

If you try to build PHP 5.x.x on a 64bit CentOS install you may get this error: checking for specified location of the MySQL UNIX socket... no checking for MySQL UNIX socket location... /var/lib/mysql/mysql.sock checking for mysql_close in -lmysqlclient... no checking for mysql_error in -lmysqlclient... no configure: error: mysql configure failed. Please check config.log for more information. Looking further ...
By wen, January 24, 2015


MySQL: How To Show All Tables Running INNODB Engine

mysql server This short tutorial will show you how to show all database tables running INNODB engine on a mysql server. Login into MySQL mysql> use mysql; mysql> SELECT table_schema, table_name, engine FROM INFORMATION_SCHEMA.TABLES WHERE engine = 'innodb'; Results: +--------------+-----------------------+--------+ | table_schema | table_name | engine | +--------------+-----------------------+---...
By daniel, March 18, 2015


How To Install Drupal 7 On Ubuntu Linux

Install Drupal 7 In this tutorial you will learn how to Install Drupal 7 ( CMS ) on Ubuntu Linux using Apache web server and MySQL database. This installation guide assumes that Apache web server and MySQL database are already installed on your Linux system. These instructions can be also used on a Debian server or any other Debian based Linux systems. All commands below are run as root. If you are a sudo user, prefix all comma...
By peggy, May 6, 2015


How To Install testlink On CentOS

Install testlink Introduction In this Tutorial you will learn how to install Testlink 1.9.3 on CentOS 6.2: Using yum to install required packages yum install mysql-server php php-mysql php-gd php-ldap Modify /etc/php.ini to optimize php configuration for TestLink session.gc_maxlifetime = 2400 max_execution_time = 120 Set up web server and mysql services chkconfig httpd on chkconfig mysqld o...
By jill, May 7, 2015


How To Do A PDO Query

Introduction to PDO Now that we can open and close a connection to the database with PDO, we can make use of it for what databases are made for, storing and retrieving information. The simplest form of query is the PDO query method. As the name suggests, this is used to perform database queries. Before we begin to query a database, lets create a small database with a table for animals. This will be a MySQL database for use throughout...
By salem, November 4, 2015


How to Install Graphite On A CentOS/RHEL Server

Install Graphite. Graphite is highly scalable real-time graphing system. It is seen as a replacement for more traditional graphing systems such as cacti and munin. Install Graphite Requirements Graphite requires: python2.4 or greater pycairo (with PNG backend support) mod_python django python-ldap (optional - needed for ldap-based webapp authentication) python-memcached (optional - needed for webapp caching, big performance bo...
By lee, November 10, 2015


How To Install LIFERAY CentOS / RedHat Linux 6.x

In this Tutorial you will learn how to Install LIFERAY CentOS. Liferay CentOS is a lightweight yet powerful open-source platform for developing web portals. It is a popular choice by users across a range of industries because of its flexibility and ease of use. Liferay CentOS Portal includes a portal, web content management system, document management system and social collaboration services. Install LIFERAY CentOS P...
By addy, December 2, 2015


How to update Joomla! 2.5 to the current version (3.4.x)

Introduction to Joomla Support for Joomla Version 2.5 ended at version 2.5.28 on December 31, 2014. It is vitally important for you to upgrade your older Joomla! 2.5 site to the current version of Joomla! (Version 3.4.8) to ensure that your site stays secure and its add-ons remain compatible. Joomla! 3.x is a totally re-written script that streamlined the core code so it would run more efficiently, provide fewer opportunities for hacke...
By rita01, February 14, 2016


Table | Use one file per table with MySQL's INNODB storage

  Introduction to MySQL INNODB engine table storage InnoDB is a general-purpose storage engine that balances high reliability and high performance. In MySQL 5.6, InnoDB is the default MySQL storage engine. Unless you have configured a different default storage engine, issuing a CREATE TABLE statement without an ENGINE= clause creates an InnoDB table. InnoDB includes all the features that were part of the InnoDB Plugin for MySQL 5.1, p...
By BIP, December 8, 2016