Archive For mysql
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... [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... [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.... [More...]
![[HowTo] Install ODBC Driver For MySQL On Ubuntu](http://www.ivankristianto.com/wp-content/themes/codemaniac/tools/timthumb.php?src=wp-content/uploads/2009/07/Ubu_Icon2.png&h=30&w=30&zc=1){kind=small}
[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... [More...]
![[HowTo] Check And Repair MySQL Database](http://www.ivankristianto.com/wp-content/themes/codemaniac/tools/timthumb.php?src=wp-content/uploads/2010/04/mysql_logo.jpg&h=30&w=30&zc=1){kind=logo}
[HowTo] 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... [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... [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.... [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... [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... [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... [More...]
AutoMySQLBackup: Regularly Backup Your MySQL
If you have blogs or websites, you databases is one the most important thing. Your data will be store on your database, for this case it is MySQL. MySQL is a free database management system (DBMS) and... [More...]
[HowTo] Install FTP Server With User Management In Ubuntu
Linux especially Ubuntu have many FTP server applications. And PureFTPd is one of the most stable and good FTP server application. We can configure PureFTPd to use virtual user stored on MySQL database... [More...]
Backup All Your MySQL Database With One Script
MySQL is a relational database management system (RDMS), and one of the most powerful DBMS. Most of the websites including this blog using MySQL technology behind it. Since it free and it always bundled... [More...]
[HowTo] Extract Database Information From Information_schema Table in Mysql
INFORMATION_SCHEMA provides access to database metadata. Metadata is data about the data, such as the name of a database or table, the data type of a column, or access privileges. Other terms that sometimes... [More...]
[HowTo] Replace String In Mysql With One Query
Yesterday i was helping my friend’s blog. She want to change her domain and move her hosting server for some reasons. She is using wordpress as her blog engine and of course using mysql as database... [More...]
[HowTo] Install Apache, PHP, MySQL, and PHPMyAdmin on Ubuntu
After a while i haven’t write on my blog. Now i’m ready to start writing again. Probably you notice that i changed my theme. Yes i was busy redesign my theme from the start. Anyway i will tell... [More...]
