MySQL Tip: How To Check, Repair & Optimize All Tables in All Databases

August 20th, 2007 Nowadays my WordPress comments table is frequently getting corrupted and I have to repair it. The MySQL table repair command does the trick.

January 17th, 2009 Do you want to recover the MySQL root password. its by no means, easy.

April 20th, 2008 AWK is an extremely versatile and powerful language for processing files and text data. Often you can use awk to perform complex tasks on Unix / Linux / Mac OS command line which would otherwise take a full-fledged programming effort.

June 12th, 2007 ANALYZE TABLE analyzes and stores the key distribution for a table. The MySQL query optimizer is the magic inside MySQL that decides which keys, if any, to use to in the query.

August 30th, 2008 Here are few tips (with undocumented features) to help you export huge MS Access database (production database with real data) to MySQL. Use mdbtools utilities as described below: mdb-tables displays the list of tables in MS Access mdb-scheme export the MS Access schema to MySQL database.

September 1st, 2007 Working with replication systems is not easy. Learning and testing different kind of MySQL replications and fine-tuning it to your specific needs is a time-consuming endeavor.

February 17th, 2006 MyDBO is an object-oriented code generator for PHP-MySQL Web application developers. It is designed to automate CRUD operations when creating Web applications.

July 20th, 2007 What is auto reconnect in MySQL? The MySQL client library can perform an automatic reconnect to the server if it finds that the connection is down when you attempt to send a statement to the server to be executed. In this case, the library tries once to reconnect to the server and send the statement again.

April 27th, 2009 Suppose you want to change and enable the remote access to MySQL DB on your linux server (Debian). By default, you don't get such privileges so you will have to work your way through this.

April 10th, 2009 When you started using MySQL, I am sure you never considered that it might have some limits on the maximum size of a table, did you? Soon you may be facing the prospect of having tables over 4GB, the default limit imposed by MySQL. Fortunately MySQL provides a simple, but time-consuming, way to store data way beyond 4GB.

January 17th, 2009 MySQL stores usernames and passwords in the user table inside the MySQL database. You can directly update a password using the following method to update or change passwords: 1) Login to the MySQL server, type the following command at the shell prompt: $ mysql -u root -p 2) Use the mysql database (type commands at the mysql> prompt): mysql> use mysql; 3) Change password for a user: mysql> update user set password=PASSWORD("newpass") where User='YOUR-USER-NAME'; 4) Reload privileges: mysql> flush privileges; mysql> quit [P.S.

July 13th, 2007 This is a very interesting presentation (see below) on the technologies used to make Digg, the challenges faced along the way and how they overcame it. I would recommend it to any Web 2.0 startup architects.

May 12th, 2007 Mantis is popular php based defect tracking application which works on top of RDBMS like MySQL and PostgreSQL. Recently I ported our Windows based Mantis installation to Linux.

May 13th, 2005 Note: My WordPress database name is wordpress. I will use it in the example below.

August 13th, 2008 I mean every word of it. I found this simple configuration tip after days of continuously looking at MySQL logs (mytop), top, slow log queries, debugging the hell out of applications, reading tons of MySQL optimization tips (and pulling my remaining hairs in frustration) on the web.