Re: Problem with MySQLImport utility

2002-06-25 Thread (Borus.Kung)
you don't need space between dashes --local instead of - -local Borus Hie I'm new in MySQL.anyone out there can help please? I'm actually experimenting with the mysqlimport utility to import data from a text file.however i'm always getting this error upon the command

Re: I know

2002-06-24 Thread (Borus.Kung)
you can download your binary for installation if there is supported hardware and OS made binary for you http://www.mysql.com/downloads/mysql-3.23.html - Original Message - ±H¥óªÌ: ÕÅÉƽð [EMAIL PROTECTED] ¦¬¥óªÌ: [EMAIL PROTECTED] ¶Ç°e¤é´Á: 2002¦~6¤ë24¤é PM 04:06 ¥D¦®: I know I try

Re: MYSQL Auto-Increment Field increment by itself

2002-06-13 Thread (Borus.Kung)
. insert is fine, MySQL is fast enough, I can clear useless rows daily. of cos, I am expecting the new release with Sequence support~ Borus ÅÇ´f¼Ù(Borus.Kung) a écrit : Hi all, I have a serious problem. I have a production system just launch using MySQL. auto increment field is used

MYSQL Auto-Increment Field increment by itself

2002-06-12 Thread (Borus.Kung)
Hi all, I have a serious problem. I have a production system just launch using MySQL. auto increment field is used in the system by ASP, Visual Basic and C. System is using AIX 4.3.3, MySQL 3.23.49 gcc 2.9 source code compiled MySQL There are some C compiled process using auto increment field

Re: Licenseing Issue

2002-06-11 Thread (Borus.Kung)
As far as I understand I think you don't need one, but I suggest you to buy one to support MySQL! :) for your customer, only those who install MySQL need MySQL license. Borus - Original Message - 寄件者: Michael Ivanyo [EMAIL PROTECTED] 收件者: mysqllist [EMAIL PROTECTED] 傳送日期: 2002年6月12日

Is View supported?

2002-06-06 Thread (Borus.Kung)
Is View supported by MySQL? if not supported, is there any other way to achieve it? I have a table of history data because the table is growing too much so I will divide it into 12 but I therefore have to modify all the programs if I can have a view of the original name that select from all

Re: can't connect to server2

2002-05-23 Thread (Borus.Kung)
you can try command ps -ef | grep mysql to see if safe_mysqld is alive and also one or more mysqld processes are running to check the socket type command netstat -na | grep 3306 see if you can see the processes are listening to the socket if the socket if not being listen, you cannot connect to

Re: Backslash BUG?

2002-05-22 Thread (Borus.Kung)
I think this is a bug it seems it is reasonable since UNIX/C does consider back slash a escape prefix for a sequence, in some case, it is not as nice as you think. in multi-character set, back slash can be included in one of the multi-characters. I fix the problem by writing a VB program and a

Re: Bug? - AIX 4.3.3 ML10, IBM C/C++ 5.0.2

2002-05-20 Thread (Borus.Kung)
I encountered the same problem, then I simply commented the line in the system header file curses.h. but the error I got is a bit different, it said: declaration is not declaring anything something like this... another header I modified is the pthread.h but there is a problem with the AIX

Re: Concurrency control

2002-05-19 Thread (Borus.Kung)
mysql doesn't write transaction mysql-max does write transaction for details, you can check out at mysql web site or mysql mysql-max manual if your application doesn't need transaction, I think mysql is better for better performance - Original Message - 寄件者: Khaled Elmeleegy [EMAIL

Re: how to turn off query logging in mysql, redhat linux

2002-05-15 Thread (Borus.Kung)
it was started when machine was started check /etc/rc.d and in mysql manual 2.1.1 if u don't need it now, just stop the server and start it like ./bin/safe_mysqld but u have to modify rc.d anyway for next time your server start dont log anymore. Borus - Original Message - ±H¥óªÌ: Tom

AIX RS6000 installation problem

2002-05-14 Thread (Borus.Kung)
Hi, I am having a problem running the binary installation for RS6000. I am installing MySQL in AIX 4.3.3 on RS6000 machine. (I had successfully installed MySQL in Linux PC using binary installation, and having C applications running without problem.) I tar everything in /mysql directory then

MySQL AIX RS6000 installation problem

2002-05-14 Thread (Borus.Kung)
Sending again, don't know why cannot send, sorry if duplicated Hi, I am having a problem running the binary installation for RS6000. I am installing MySQL in AIX 4.3.3 on RS6000 machine. (I had successfully installed MySQL in Linux PC using binary installation, and having C applications

MySQL on IBM AIX tar problem!!

2002-05-13 Thread (Borus.Kung)
when I try to tar the MySQL file mysql-3.23.49.tar in a RS6000 machine running AIX 4.3.3, I got some error messages like these x ././@LongLink, 109 bytes, 1 media blocks. x mysql-3.23.49/sql-bench/Results-win32/ATIS-db2_odbc-NT_4.0-cmp-db2,informix, ms

MySQL on IBM AIX tar problem

2002-05-13 Thread (Borus.Kung)
when I try to tar the MySQL file mysql-3.23.49.tar in a RS6000 machine running AIX 4.3.3, I got some error messages like these x ././@LongLink, 109 bytes, 1 media blocks. x mysql-3.23.49/sql-bench/Results-win32/ATIS-db2_odbc-NT_4.0-cmp-db2,informix, ms

Re: O2 to MySQL.....

2002-05-10 Thread (Borus.Kung)
I think a simple way is to export your o2 data into text file then load the text files into MySQL is it too hard? Borus - Original Message - 寄件者: ritu singla [EMAIL PROTECTED] 收件者: [EMAIL PROTECTED] 傳送日期: 2002年5月10日 PM 05:10 主旨: O2 to MySQL. Hi!! I want to convert all the data

Using multi-byte character set

2002-04-28 Thread (Borus.Kung)
Hi, I am using double byte character set (big5) under mandrake linux with MySQL everything seemed ok after building the DB and tables after some time of testing I found some characters cannot be inserted, like those characters include the back slash '\'. it was simply disappeared as MySQL treat

Using multi-byte character set

2002-04-28 Thread (Borus.Kung)
Hi, I am using double byte character set (big5) under mandrake linux with MySQL everything seemed ok after building the DB and tables after some time of testing I found some characters cannot be inserted, like those characters include the back slash '\'. it was simply disappeared as MySQL

row id

2002-04-23 Thread (Borus.Kung)
Do anyone know how to select or get the row id of a row in MySQL? thank you Borus - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To

Re: New Setup

2002-04-22 Thread (Borus.Kung)
I think you have to use the -p option too and type your password because the GRANT statement specified a password mysql -u root -h Your_Server_Name -p Borus Hi, Only the root with the '%' character on the host field from table mysql.user have full priveleges.Try to connect with -h option

Re: MyODBC multiple connection

2002-04-22 Thread (Borus.Kung)
I am writing web page using VB script ASP, and cannot work with MyODBC 2.5 of MySQL but can work with 3.5.1 the previous problem is : I made a page using ASP MyODBC, it is working then I try multiple connection, the second trial to open the page failed with a disastrous error do anyone know

Re: New Setup

2002-04-22 Thread (Borus.Kung)
- Original Message - From: ÅÇ´f¼Ù (Borus.Kung) [EMAIL PROTECTED] To: Ian Phillips [EMAIL PROTECTED] Sent: Monday, April 22, 2002 10:23 PM Subject: Re: New Setup I found that you Grant to cbaa user but use root to login check it Borus ;) Thanks for the idea -- still stuck

access denied on use database, linux on PC

2002-04-16 Thread (Borus.Kung)
After I installed MySQL in linux on a PC, version mysql-3.23.49a-pc-linux- gnu-i686 I created a database named 'ps_db', as followed: mysql create database ps_db; Query OK, 1 row affected (0.00 sec) mysql grant all privileges on ps_db.* to ps_user; Query OK, 0 rows affected (0.00 sec) mysql

access denied on use database

2002-04-16 Thread (Borus.Kung)
Sorry, there was a typing mistake in the previous mail. After I installed MySQL in linux on a PC, version mysql-3.23.49a-pc-linux- gnu-i686 I created a database named 'ps_db', as followed: mysql create database ps_db; Query OK, 1 row affected (0.00 sec) mysql grant all privileges on ps_db.* to