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 write this post.
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.
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 into the Access database file. But the browser return 500 internal error. The detail error
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. The solution was to go to the File tab in 2010, click the options link
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 server. After I move it to new one, it gives me the error as subject.
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 more format and compress methods. The command program is 7z.exe under the installation of 7z
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 lot of extension upgrade too. Later I found I can not add new database and
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 a one-to-one relationship, a key will appear only once in a related table. It is
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 is started. If you have to switch operating systems or languages mid-stream, use the mysqldump
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 Source Administrator I have a source named dd.