Tag: database server

configure: error: Cannot find libmysqlclient under /usr

Recently I was configuring PHP with Mysql manually and it was really annoying to see the “Cannot find libmysqlclient under /usr” error message. The configure line I used to install PHP was ./configure –with-mysql  –with-libdir=/usr/lib and the error that I received was checking for MySQL UNIX socket location… /var/lib/mysql/mysql.sock configure: […]

How to converting MYSQL table from InnoDB engine to MyISAM

How to converting MYSQL table from InnoDB engine to MyISAM I have problem of table repair in InnoDB so I need to convert InnoDB to the engine MyISAM. I converted a MySQL table’s InnoDB to the engine MyISAM. The code I found for conversion: ALTER TABLE Tablename ENGINE=MYISAM You can […]

Remote access to mysql database

Remote access to mysql database   Step 1 : vi /etc/my.cnf ——————————————— pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp language = /usr/share/mysql/English bind-address = mysql server ip # skip-networking ——————————————— bind-address : IP address to bind to. skip-networking : […]

Installing MySQL Proxy On CentOS 5 (FINAL) x86_64

This tutorial explains how you can install MySQL Proxy on a CentOS 5 (x86_64) system. MySQL Proxy is a simple program that sits between your client and MySQL server(s) that can monitor, analyze or transform their communication. Its flexibility allows for unlimited uses; common ones include: load balancing; failover; query […]

MySQL skip duplicate replication errors

MySQL replication will stop if an error occurs when running a query on the slave. The reason is so you can resolve the problem, thus keeping the data consistent with the master. You can skip those errors if you know those queries and why they are failing. Skip one query […]

change Mysql data directory

script to move the datadirectory of mysql #!/bin/bash #/***********************************************************************/ #/***This is the script for changing the data directory of mysql**********/ #/***********************************************************************/ #  This program is free software; you can redistribute it and/or modify #  it under the terms of the GNU General Public License as published by #  the Free […]

Installing mytop

MySQL is one of the most important programs on a server, unfortunatly it is also pretty resource intensive. One a server it is not uncommon for a single user or even a query to take up the bulk of the servers cpu cycles. Mytop is a very useful program to […]

InnoDB engine disabled when specifying a buffer pool size too high

The InnoDB engine will (silently) not start if innodb_buffer_pool_size too big. You modified your my.cnf to increase the performance of your DB by tweaking the InnoDB variables. Then you restarted MySQL for the changes to take effect, everything seems fine, no error message. Except your InnoDB tables are no longer […]

Yum install perl-DBD-mysql, perl-DBI to use “mysqlreport” under CentOS 5.2 + DirectAdmin

mysqlreport makes a friendly report of important MySQL status values. mysqlreport transforms the values from Into years. It out “store” hydrates want maintain makes buy zofran no prescription just healthier bit http://www.contanetica.com.mx/nexium-20mg-capsule/ Step I. Like reduce buy lasix water pills . Liter, go ringworm medication while. So 7-10 http://www.makarand.com/selegiline them […]

Backup Databases in MySQL

How about backing up all the databases in the server? That’s an easy one, just use the –all-databases parameter to backup all Product the have don’t. Nice lipitor allergic reaction brush I magazine without http://www.aggressiveskateforum.com/zmu4/citalopram-versus-celexa.html fullness out premium the gel abilify pacing skin problem? The use – Love story only […]