How to Backup & Restore MySQL Database

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.

June 8th, 2008 Traditionally WordPress is backed up by backing the database and the files separately, if required. WordPress 2.5.1 introduces a much simpler way to backup the database in xml format on your desktop.

July 31st, 2007 HSQLDB is a high performance RDBMS written in pure Java. It can be used as a in-memory database or regular file based database.

April 26th, 2009 A comforting day indeed. Matt Mullenweg is the author of the popular blogging software , WordPress.

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

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.

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.

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.

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.

October 23rd, 2006 First of all I want to make it clear that having a MySQL database without a password set (on your root account) is a very very bad idea. However I wanted to set it up on my home machine which has XAMPP installed.

July 14th, 2006 Joomla Content Management System was forked off Mambo CMS after most of the core Mambo developers disagreed with Mambo Management. The current stable release is 1.0.10.

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.

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.

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.

November 23rd, 2007 In MySQL you can use the GRANT statement to create users and assign privileges to them at the same time. It is extremely convenient and beats create user or directly hacking the mysql.user table.