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 analysis; query filtering and modification; [...]
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 see what queries a server [...]
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 mysql>SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVE; [...]
How about backing up all the databases in the server? That’s an easy one, just use the –all-databases parameter to backup all the databases in the server in one step. mysqldump –all-databases> alldatabases.sql How to Backing up only the Database Structure in MySQL You can backup only the database structure by telling mysqldump not to [...]
1.Create database with same name as MDF file you have. USE [master] GO ALTER DATABASE [MyDatabase] SET EMERGENCY GO ALTER DATABASE [MyDatabase] SET SINGLE_USER GO 2.Stop SQL Server and swap MDF files. Make sure you also keep new database you just created. 3.Start SQL Server. Database will be now in suspect state because log file [...]
Unofficial, No mess, No thrills, No fluff, No Explanation, Absolutely No Guarantee, Ruff and Gruff howto fix MySQL Databases – Make a temp directory to work in cd /root mkdir mysql_tmp cd mysql_tmp – Locate the database, ussualy a directory in /var/mysql or /var/lib/mysql ls -la /var/mysql/_database_name_ – Stop the mysql service, might be called [...]
After performing a mysql upgrade, you may run into a problem where Mysql won’t start successfully and will result in a “Table ‘mysql.plugin’ doesn’t exist” error message. The mysql error logs will state something like follows: /usr/libexec/mysqld: Table ‘mysql.plugin’ doesn’t exist 110620 01:01:01 [ERROR] Can’t open the mysql.plugin table. Please run mysql_upgrade to create it. [...]
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: error: Cannot find libmysqlclient under [...]
Somtimes you may want to change the Mysql table from MyISAM to InnoDB engine to setup foreign keys, to use row level locks, improve performace etc. The conversion of the MyISAM table to InnoDB is easy however, if the table is setup with “FULLTEXT indexes”, it cannot be converted as this feature is not supported [...]
For some reason, under CentOS, Custombuild in DirectAdmin use “MySQL – Generic Linux (glibc 2.3) (x86, 64-bit) RPM file” instead of MySQL RPM files for Redhat. The different for these 2 packages are that, RPM for Redhat contain “ha_innodb_plugin.so” but not in Generic RPM package. Compare files in Plugin folder on two different RPM. [...]
