How to add one string to all rows of one column
I have a MySQL database. There is one table has thousands rows of data. I need to add one string to every rows of one column. It is a very popular scenario. Looks like in the middle of using one...
Tag: MySQL
Large mySQL database transferring
To transfer the the large mySQL database, you need to learn how to use command to do it. Large, means the database is bigger than 8 MB after compressing. phpmyadmin, is a wonderful web tool for mySQL. But the limitation...
Three steps to make your own VPS
It is not that easy for a newbie to make a workable VPS by himself. I have three year experience on VPS. I can make it as simple as possible to show you how to do it in three steps....
Schedule Backup MySQL database and FTP offsite in Centos
I have a VPS powered by Centos 5.2. There are some very important forum on it. I would like to backup it every day. Now because HyperVM/LxAdmin – Backup Home, can not backup MySQL or not easy to get it....
Upgrade to MovableType 4.26 successfully
I have not upgrade to 4.25 when MovableType 4.25 released. Because I failed to upgrade my Unofficial MT site at that time. But I did a wonderful upgrade from MT 4.25 to 4.26. And this blog is based on MovableType...
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...
Slow queries log for MySQL
To enable slow query log, it is have to add one line into my.cnf. I have MySQL installation on a Centos server. It is MySQL 5.0.22 i686. Let’s go through the details of setting of it. Open my.cnf which is...
FULLTEXT search of MySQL
I have a web-based program with MySQL database. I need to do a full text search on three fields. How can I do it? Use ‘LIKE’ is very slow, when I need combination of different situation. So I find FULLTEXT...
phpMyAdmin can help to access MySQL
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...
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...
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...
Database on Dreamhost
This blog has some error last week. Some pages were not build correctly. I diagnosed it and found the template was broken. A bunch of codes were missing. I want to find the backup of MySQL database. Go to Dreamhost...
Repaire corrupted MyISAM tables
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 Backup and Recovery Methodologies
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...
Upgrade my blog from Movable Type 4.01a to MovableType 4.1 on Dreamhost
I have tested the upgrade on the MT unofficial blog. It is smooth. Now I recorded the detailed upgrade procedures of David Yin’s Blog. Backup 1) Login the MovableType system, Backup all blogs of this system, by tab system >...