SQL

Auto Backup MySQL Database

Data is important thing in company or organization. People who can’t protect their data is the loser this day. Can you imagine you lost all your data for works? it just like a heaven go away from you he he.. This happen to me yesterday and I lost 1 month production data caused by bad electrical environment. In this short articles I will share a small information how to backup your data periodically. I am using windows server and xampp to run every automation so I will write how to backup MySQL database periodically. First thing you need to know,… Read More »Auto Backup MySQL Database

How To Fix WordPress Database Error

If you are using wordpress or other cms and have a lot of data in you sql, your site usually will unavailable with common message database error. What actually error on your database? Nothing, this is all about query limitation on your hosting. Your blog will grown in time, say in the last months you got 10,000 readers and in the next month you got 1,000,000 readers. When people access your site it’s continuously reading data again from your database, when it to much some hosting will stop it to executed. This is not good for SEO because your potential… Read More »How To Fix WordPress Database Error

PHP:Read Microsoft Access Database

Hi all, This article is sample php code on how to pull data from Microsoft Access Database, Anyway this code only works on windows hosting only, when you try in linux hosting you will get message Fatal error: Class ‘COM’ not found. What is benefit to using this code? Last week I made simple SMS gateway in my personal computer then use Microsoft Access Database as my database. Now I need to show this database out into web page using PHP script. with this code it will be possible. Just learn this code below it’s very simple, you can pull… Read More »PHP:Read Microsoft Access Database