Category: MySQL

MySQL – The world’s most popular open source database

Using Views to avoid cross database connection – MySQL

Table Views can be used as an unconventional way to avoid cross/multiple database connections sometimes..! Yes, it can be. I came across such case and found that it can be handy in some simple cases when we just want to avoid connection to another database on the same MySQL server and we can’t afford to create that table in the same database due to some reasons.

HeidiSQL 5.1 – good has got better

have been using HeidiSQL since more than three and half years now and I am really happy with it. I must say that we work with heavy database consisting of more than 400 tables and database size exceeding few GBs but HeidiSQL has never let us down. I have tried loading my development database with phpMyAdmin and SQL Buddy both but they just failed to load such a large database with few hundreds of tables..! But with HeidiSQL I never had any problem except I got some crashing sometime in newer 5.x version but I am sure all such things will be fixed in coming builds. I am not telling that there are no other good tools are available in the market but HeidiSQL is in premium open-source tool at free of cost. I remember I had written a post on HeidiSQL 4.x more than a year ago and today we are up with HeidiSQL 5.1.

Export/Import CSV files with MySQL – No external tool required

Loading data from and to CSV or other tab delimited or similar file format is essential in day to day operation. With MySQL it is easy to load data into table using files and exporting data into CSV files is quite easy. No need to use any external tool it can be done right there from the query tool/command prompt, no specific GUI tool required.

backup/restore MySQL db using MYSQLDUMP (quick reference)

In my projects we have to deal with exporting system/meta data sync with production server on a regular basis and this seems to be easier than using utilities provided by GUI tools, be it HeidiSQL, PHPMySQL, SQLYog or anything else. Though it depends on project to project and person to person but many times when we have to restore big backup created with HeidiSQL or SQLYog I have seen programs/database exhausted such that increasing packet size won’t help either. But mysqldump/mysql restore always been a piece of cake to walk with.

HeidiSQL 4.0 RC1 released

I am not sure how many MySQL developers are using HeidiSQL for development but I am sure those who are using it will be fan of some of it’s features.!

I have been using HeidiSQL tool for my php/mySQL development for a while now. (more than a year and half..!). Before few months I have upgraded to newer version of HeidiSQL which is 4.1 RC1. It has got quite new and exciting features, looks and skins are improved.