Skip to content

David Yin's Blog

Tech geek. Life geek.

  • Home
  • About & Contact
  • Advertise
  • Subscribe
  • Privacy Policy
  • Gallery 3 – G3Grey Theme
David Yin's Blog
  • Home
  • About & Contact
  • Advertise
  • Subscribe
  • Privacy Policy
  • Gallery 3 – G3Grey Theme

Tag: database

Posted on November 14, 2019 L.A.M.P.

Make the PHP support Microsoft Access MDB file on Ubuntu 18.04

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

Posted on March 28, 2019March 27, 2019 Freeware Review

Use Adminer to manage the MySQL database

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

Posted on February 25, 2014February 25, 2014 L.A.M.P.

Convert MyISAM tables to InnoDB without Touching Data

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

Posted on November 15, 2013February 24, 2014 Web & Network

Classic ASP program with Access database on Windows server 2008

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

Posted on February 27, 2012February 22, 2014 Software Web & Network

How to fix the error of collating sequence not supported with the specified file format

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

Posted on February 21, 2012March 19, 2019 Software Web & Network

Solved MySQL 5 – Incorrect integer value: ” for column ‘id’ at row 1

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

Posted on May 26, 2009March 17, 2019 Software

7z command to compress file with date as file name

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

Posted on November 4, 2008April 20, 2018 DreamHost Log

Server Upgrade and Database moveing

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

Posted on April 14, 2008November 21, 2018 L.A.M.P.

Types of Table Relationships

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

Posted on April 13, 2008March 16, 2019 L.A.M.P.

Main Features of MySQL

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

Posted on January 11, 2008February 18, 2014 L.A.M.P.

PHP connect DBF file

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



Tags

"new features" "phpBB 3" "speed test" "Windows 7" backup beta Blog bug calibre Canada Centos Code dreamhost error Firefox firmware freeware game Google how-to installation internet Linux MovableType MT MySQL performance PHP plugin release review router security server software SSD test tool ubuntu update upgrade voip VPS windows wordpress

Useful links

  • Alive Math Worksheet
  • Free InOut Board
  • Web Site Directory
  • Free Thinking
  • Dba notes
  • aw’s Blog
  • OneLaunch

Categories

  • Digest (77)
  • DreamHost Log (41)
  • Hardware (366)
  • Independent Thinking (28)
  • Insurance (5)
  • jQuery (9)
  • L.A.M.P. (249)
  • Money Maker (22)
  • My Life (117)
    • Journey of Faith (1)
    • Shanghai food (1)
  • Notes of MovableType (127)
  • phpBB Mod & Tips (14)
  • Reviews (171)
    • Freeware Review (43)
  • Save Money (2)
  • SEO & SEM (9)
  • Software (266)
  • Two Week Campaign (13)
  • Uncategorized (1)
  • Vehicles (15)
  • VOIP (38)
  • Web & Network (390)
  • WordPress Notes (52)

Archives

© 2023 David Yin's Blog / Powered by WordPress / Theme by Design Lab