Tech geek. Life geek.
I use phpMyAdmin when I need to access MySQL database directly. The phpMyAdmin application requires not only the MySQL server, but also PHP and a Web server to be installed. This application is commonly found in a virtual hsoting envirnment...
To create a good database, I have to know the relationship between tables. It is clear, the database I talking about is relationship database. There are three types of table relationships. One-to-one relationships One-to-many relationships Many-to-many relationships One-to-one relationships In...
I choose MySQL as my program’s database. The main features of MySQL are: Speed Portability Ability to interface with any programming languare Price MySQL is a multithreaded server, meaning that each time a connection is made, a new server process...
I have a phpBB board with some modification. To upgrade it from 3.0.0 to 3.0.1 is not that difficult. Previously, I have to record all modification I made on it and backup everything and upgrade it through a patched package...
phpBB 3.0.1 released yesterday. It is normal to download it and upgrade phpBB 3.0.0 of my Support Board. This is a bug fix release. It fixed lots of bugs and change some security issue.
Ubuntu 8.04 will release in 22 days. I have a Ubuntu 7.10 installed on my desktop. Before I can upgrade to the new version. Let’s go through the new features from 8.04. Xorg 7.3 The latest Xorg, Xorg 7.3, is...
I have some USB flash disks. I’d like to make it a bootable with Ubuntu 7.10. Let me show you how to do it. 1. Grab the Ubuntu 7.10 ISO and burn it to a CD 2. Insert the CD...
I posted PHP connect DBF file with a sample. Now Pierre left the message and asked why error comes up. I doing some tests and get the answer. 1) The database.dbf is reserved name. 2) The field name is always...
I have some site on the Dreamhost. To monitor the traffic and performance, I have Awstats on site and runing many cron jobs every day. I have the experience of how to install AwStats on the Ubuntu server. The cron...
To repare the corrupted MyISAM tables, just cd to the directory that holds the MyISAM datafiles, then run this: $ myisamchk -r -q table_name If it doesn’t work, try this command, $ myisamchk –safe-recover table_name The above two commands can...
MySQL is very popular. Many open source or free software use MySQL as their main database engine. To make our data safe, please remember to backup your data regularly. There are two methodologies you can use to back up MySQL...
I have a HTTP status check online tool here. It is made by PHP with cURL extension. The trouble is some responses are good. Someone tell me that the url should be 302 redir or 200 Ok, but the tool...
I am noticed that one strange folder name on my hosting. MM_CASETEST4291 It is an empty folder. After some search, I found it is a temporary folder which is used to test server connection and writing permission. MM_CASETEST4291 is created...
When I am doing some programing, I may need the Regular Expression rule to validate the data user submit. It is used to protect the program and save the resource of server. To write a perfect Regular Expression Rule is...
The following IP Ports and Protocols are excerpted from Networking Fundamentals. Port number – Protocols name 20 – File Transfer Protocol (FTP) data 21 – File Transfer Protocol (FTP) control 23 – Telnet 25 – Simple Mail Transfer Protocol (SMTP)...