problem of storing binary data in mysql

2001-12-02 Thread kin fai
I use MySQL rpm to install in RedHat 7.2 in one of my pc. Then I store binary data such as image in MySQL and it works normally. However, I install source MySQL in RedHat 7.2 in another pc. But it cannot store binary data. Does anybody know the reason? Is that it need some special configure opti

mysql optional file (my.cnf) problem

2001-08-17 Thread Fai
Does any body know how to prevent mysql server looking for user specific optional file ( .my.cnf)? So, user cannot put the optional file (.my.cnf) in his home directory to affect the mysql server behaviour. Thank you very much!

mysql segmentation fault on starting

2001-07-07 Thread Hung Hing Fai
SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `<' and `>'). SEND-PR: From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: mysqld segmentation fault on starting >Description: mysqld segmentat

mysql transaction related question

2001-06-29 Thread Fai
MySQL provides three transaction-safe tables including Berkeley_DB, GEMINI and InnoDB Tables, I have some queries on them: 1. What are the differences between these three type of transaction-safe table types? 2. Which type should be used for the E-Commerce web site? 3. Is true that BDB is free

mysql grant problem?

2001-03-27 Thread Fai
When we use grant as following: GRANT select(col_name_1) on db_name_1.tbl_name_1 to peter identified by "peter"; Then peter can only select the field of col_name_1 on the tbl_name_1 of db_name_1. However, when peter issue the query: DESC tbl_name_1; he can see all the structure of that table. Th

Mysql privilege question

2001-01-17 Thread Fai
According to MySQL rule, the column matching order in mysql database should be as following: ++-+- | Host | user| ++ +- |localhost| |root ||localhost| | ||pit.sample.com |root |||pit.sample.com | |