Tech geek. Life geek.
The very first step is to prepare the Ubuntu server. I installed the Ubuntu 18.04 on a VM with 1CPU, 1024MB memory and 16GB storage room. After the installation. Start the Ubuntu server and ssh to it. Read more
I am used to using phpmyadmin to manage the MySQL database for many years. Just recently, I saw an alternative way to do it. Adminer, a full-featured database management tool written in PHP. The latest version is v4.7.1 when I... Read more
It is a smoothly converting without hurting data inside of the tables. I have phpmyadmin installation on my VPS. So just goto there and select database, click SQL tab of it. Enter following sql and click Go. Read more
Got error 800a0cb3 from the Web log file at Windows Server 2008. It is IIS7. The Web application is made by ASP. Actually classic ASP, not ASP.Net. And also with Access database. The page is try to add new record... Read more
When I use a ASP script to retrieve the data from a Access MDB file, I got an error: collating sequence not supported with the specified file format. Actually, it happened when I move the site to a new server.... Read more
I move one site to a new server with Windows 2003. It is a MySQL database. I use PHP script to connect the database file and query it. I run the same script more than 5 years on the old... Read more
It is one step of my backup script under Windows 2000. Of course it works under Windows XP. First, I use 7z as my default compress tool. Not because of it is a free, Open Source software, but it supports... Read more
Last weekend, the server which I put my Blog on, is upgraded based on the Dreamhost schedule. The new server is 64bit, and Linux is 64bit too. SO I have to rebuild my customized PHP on it, and doing a... Read more
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... Read more
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... Read more
DBF is very old format databse type. About 10 years ago, I use dBase which use DBF format. Now I will show you how to connect the DBF file from PHP script. 1) Add a system DSN in ODBC Data... Read more