Archive for the “MySQL” category
Optimizing the MySQL tables of a WordPress Website
by Nazly on February 4, 2011
If you are running a WordPress Website or a Blog where the content is updated and/or deleted frequently, you will need to optimize the MySQL tables more often than not so that you don’t run into database issues and down (…)
Basics of maintaing a WordPress site
by Nazly on November 18, 2010
WordPress is simple, yet powerful. Those are the key ingredients why it is popular among the Bloggers and Web Developers alike. WordPress will always be the first choice as a blogging platform. In the recent times it has moved far (…)
Protect your website against SQL injection
by Nazly on February 17, 2010
SQL injection is one of the deadliest techniques attackers use to exploit the weakness in your database code of your website. Regardless of the technology/scripting language you must make sure your code is 100% perfect against SQL injection. Here I (…)
Restoring Large MySQL dumps
by Nazly on November 26, 2007
A lot of things influenced me to write this post. In fact I wanted to write on this sometime back but finally I was able to squeeze some time. Lately I have been moving data between servers and the main (…)
Copying records in MySQL
by Nazly on May 17, 2007
Copying records from one table to another can be a very basic requirement. But writing queries to perform this task can be bit of a work around. But there is a very simple query to get this done. Its by (…)
MySQL GUI tools
by Nazly on September 20, 2005
I have been playing around with the MySQL GUI tools lately specially with the MySQL Query Browser and its really easy to play around with SQL queries. I did use PHPMyAdmin effectively though I simply like the Query Browser. MySQL (…)
Export MySQL database to an MS Excel format
by Nazly on July 5, 2005
Here is an updated version of the script I had at PHP-Help.net which exports a specified MySQL table. After couple of requests I got, I made some changes to the script to download all the tables of a specific database. (…)
Storing Images in MySQL
by Nazly on June 30, 2005
I just wrote a quick example that explains how to store images in MySQL database using the BLOB fieldtype which can used to store Binary Data. But I have been used to store the images in the filesystem and have (…)
MySQL 4.1 authentication issue
by Nazly on June 11, 2005
I have been working on MySQL 4.0.17 till now and wanted to upgrad to MySQL 4.1. So I downloaded and installed MySQL 4.1 and the installation was successful and it was working fine. But when I tried to access it (…)
