HeidiSQL: Another Free MySQL Client Tools

I bet many of you know what is MySQL and probably use it a lot. One of the best MySQL client tools is MySQL Workbench as it have all fancy features. But it is too heavy to use. So instead of design the database structure, i'm using HeidiSQL to administrate my MySQL server. I found it extremely light and easy to use. [quote sourceurl="http://www.heidisql.com/" sourcename="HeidiSQL Official"]HeidiSQL is a lightweight, Windows based interface for MySQL databases. It enables you to browse and … Read more...

Web Development Using PHP, MySQL and Flash

PHP and Adobe Flash (formerly Macromedia Flash) are popular scripts used for creating web pages and online multimedia presentations. The two scripts can be combined to create dynamic, interactive pages similar to those used by big movie studios to promote their latest film releases. PHP (Hypertext Preprocessor) is similar to the standard static HTML script and it recognizes the elements of HTML, but it also uses active server-side processing in creating dynamic pages. PHP can deliver varied … Read more...

Free Database Designer For MySQL With MySQL Workbench

If you are looking for a nice and good database designer for MySQL, then i'm very recommend you to use MySQL Workbench. Beside it is free (GPL License for Community Edition), it is also easy to use. Before i found this, i used to make database designer with other tools or make a hand writing database design (ERD/Entity Relationship Diagram) then i manually make the all tables through PhpMyAdmin. This took a long time. After i tried MySQL Workbench, i'm very happy about it. It is easy to use. … Read more...

[HowTo] Install ODBC Driver For MySQL On Ubuntu

ODBC or Open Database Conectivity provides a standard software interface for accessing database management systems (DBMS). ODBC could work in multi platform. With ODBC API, the application only needs to know ODBC syntax, and the driver can then pass the query to the DBMS in its native format, returning the data in a format the application can understand. As ODBC work in multi platform, ODBC could work in Ubuntu as well. For software developer they are using ODBC so their application could … Read more...

How to Check And Repair MySQL Database

Sometimes your MySQL database data is corrupted. Usually it is not properly close when querying to the database, because of high server load or MySQL server suddenly down. This will make your database files or tables corrupted. And your web application won’t run normal or even show Internal server error or cannot connect to the mysql database server. There are many ways to to fix this error: 1. Use MySQL check and repair function 2. Use mysqlcheck to check and repair database 3. Use … Read more...

Install And Configure Nginx, PHP, MySQL On Ubuntu

Nginx is simple webserver yet powerful. It is widely know for stable webserver. If it is well configured, nginx rarely have spike in the cpu load and have low memory consumption. Nginx is known for its stability, rich feature set, simple configuration, and low resource consumption. In this article i want to share how to install and configure your Ubuntu server to use Nginx as web server, PHP5 support (using fastcgi) and MySQL support. Open your ssh terminal. Install … Read more...

504 Gateway Timeout With Nginx And Apache

Well these couple days i spent a lot of my time debugging the nginx 504 gateway timeout error. As far as my understanding this error 504 caused by proxy timeout, or nginx wait too long for apche response. By the way i installed nginx as reverse proxy with Apache to server my static files. You can refer to my previous post: Install nginx as Reverse Proxy With Apache. As i’m digging with Google, there are lot of possibilities of this problem. Some says because of fastcgi_read_timeout, but … Read more...

Local Server For Testing Environment With XAMPP On Windows

If you are a php web developer or want to be, it is a must that you need to have a testing environment. A testing environment means you have our own local server and test and run your application that you are developing before you go live on your production server. You need to develop, and testing your application in your local rather than testing it in your production server. So to have your local server in Windows environment you can use XAMPP. XAMPP is a free and open source cross-platform … Read more...

Beginners Guide: Backup And Restore Compressed MySQL Dump File

As you know your website data is stored in your database server, in this case is MySQL. To prevent disaster, backup your data regularly is a must for you and every website owner. There are many ways to backup MySQL data, one of them is using mysqldump to dump your MySQL data to a file. But mysqldump output is plaint text files with full of SQL commands. And in linux you can compress it using gzip with pipelining command. To backup and compress MySQL dump file: Explanation: the … Read more...

Copy MySQL Data Across The Server

If you move or change your hosting server, beside the files you also need to move your mysql data as well. MySQL database hold all your website data including content, configuration, user account and other thing. So please be careful with this data you need to backup it regularly. See my other post about how to regularly backup your mysql. But when you move to another server you can do it with 2 ways: 1. Backup it from the old server and upload it to another server You can do this with … Read more...