Tutorial Tag

mysql

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

    By BIP admin tagged in Engine,INNODB,INNODB Engine,mysql
     Introduction to MySQL INNODB engine table 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, plus new features specific to MySQL 5.5 and higher.Note: The mysql and INFORMATION_SCHEMA databases that implement some of the MySQL internals...
  2. 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 hackers and web bots to attack sites and greatly enhance native Joomla! features such as permissions and groups, mobile...
  3. 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 CentOSPART 1Step-1$ yum install java-1.6.0-openjdk-devel –yThen, set up JAVA_HOME environment variable. ...
  4. 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 boost) python-sqlite2 (optional - a django-supported database module is required) bitmap and bitmap-fonts required on some systems, notably Red HatTo install graphite, first you will need to enable the EPEL repository first. Once enabled pull in the required RPMS.# yum install graphite-web graphite-web-selinux mysql mysql-server...
  5. How To Do A PDO Query

    By Salem chammam tagged in database,FETCH,mysql,PDO,PDO Query,php
    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 much of this tutorial. Remember, because PDO...
  6. 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 packagesyum install mysql-server php php-mysql php-gd php-ldapModify /etc/php.ini to optimize php configuration for TestLinksession.gc_maxlifetime = 2400 max_execution_time = 120Set up web server and mysql serviceschkconfig httpd on chkconfig mysqld on ...
  7. 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 commands below with sudo.Prerequisites Installation # apt-get install php5-mysql apache2 \ mysql-server...
  8. 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 MySQLmysql> use mysql; mysql> SELECT table_schema, table_name, engine FROM INFORMATION_SCHEMA.TABLES WHERE engine = 'innodb'; Results: +--------------+-----------------------+--------+ | table_schema | table_name | engine | +--------------+-----------------------+--------+ | pdns | domains | InnoDB | | pdns ...
  9. 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 into the config.log you will also see:configure:60376: checking for mysql_error in -lmysqlclient configure:60395: gcc -o conftest -I/usr/include -g -O2  -Wl,-rpath,/usr/lib/mysql -L/usr/lib/mysql -L/usr/lib  -Wl,-rpath,/usr/kerberos/lib64 -L/usr/kerberos/lib64 -Wl,-rpath,/usr -L/usr conftest.c -lmysqlclient ...