Re: Problem with MySQLImport utility
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 c:\mysql\binmysqlimport - - local - -fields-terminated-by=, test newtest.txt ERROR: The used command is not allowed with this MySQL version, when using table: newtest P.S. My SQL version is Ver. 11.16 Distrib 3.23.49 for Win95/98 (i32) Also i created a txt file with the following structure 100,200 200,200 300,300 . My table is newtest with 2 fields of char datatype of size 10. Please help. Thanks. Regards, Eric. ** NOTICE OF CONFIDENTIALITY ** This message and any files transmitted with it may be privileged and/or confidential and are intended only for the use of the addressee. If you, the reader of this message, are not the intended recipient, you should not disseminate, distribute or copy this message. If you have received this message in error, please notify us immediately by return email and delete the original message. Thank you. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: I know
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 it over !the question is that i couldn't configure and make the mysql,so i can't install and run it .i don't know why .i try it as book!please give me the oringal software! __ === ÐÂÀËÃâ·Ñµç×ÓÓÊÏä (http://mail.sina.com.cn) ÐÂÀË·ÖÀàÐÅÏ¢£º¶þÊÖÊг¡×ßÒ»×ߣ¬¸Ã³öÊÖʱ¾Í³öÊÖ£¡ (http://classad.sina.com.cn/2shou/) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MYSQL Auto-Increment Field increment by itself
I solved the problem, it was application problem. but, Joseph, your method doesn't work becos application is not continually logged in to the DB. if the process is newly login, last_insert_id is 0 then the update will update the auto increment field to 0 becos select last_insert_id() returns 0. 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 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 contained tables in which I used them as sequence, this way: Create table: create table my_num (id int not null auto_increment, primary key (id)); Insert table: insert into my_num values (null); Select table: select last_insert_id(); for ASP and VB or call mysql_insert_id() for C program then I got a sequence number. but unfortunately, after some time of running, I found the sequence increase by itself.. and the table gradually became very large. I though there must be a bug in my application. then I stopped all the applications including C processes and ASP. but the sequences keep on increasing. If the database is shutdown and start again, the tables back to normal for some time... it is unaffordable to repeatedly restart the system from time to time and it is sure that the sequence number will run out of stock soon. I still don't know how this error happened, but it just happened. Do anyone encountered similar problem before? now, some experiement is being performed on another machine to repeat the problem. please help Borus Hi, If the sole purpose of 'my_num' table is to generate a unique sequence number, you should not use inserts. One solution is to create a table with a single record and update it: create table my_num (id int not null); insert into my_num (id) values (1); and each time you want a new sequence number: update my_num set id=LAST_INSERT_ID(id+1); select LAST_INSERT_ID(); Of course, you will have to change all your VB, C,... apps :( Regards -- Joseph Bueno NetClub/Trader.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MYSQL Auto-Increment Field increment by itself
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 contained tables in which I used them as sequence, this way: Create table: create table my_num (id int not null auto_increment, primary key (id)); Insert table: insert into my_num values (null); Select table: select last_insert_id(); for ASP and VB or call mysql_insert_id() for C program then I got a sequence number. but unfortunately, after some time of running, I found the sequence increase by itself.. and the table gradually became very large. I though there must be a bug in my application. then I stopped all the applications including C processes and ASP. but the sequences keep on increasing. If the database is shutdown and start again, the tables back to normal for some time... it is unaffordable to repeatedly restart the system from time to time and it is sure that the sequence number will run out of stock soon. I still don't know how this error happened, but it just happened. Do anyone encountered similar problem before? now, some experiement is being performed on another machine to repeat the problem. please help Borus - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Licenseing Issue
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日 AM 11:24 主旨: Licenseing Issue I do not fully understand the license requirements and have a question. The application that I am developing will be able to work with either MySql, Postgres, or Oracle. Will I still need a license if the user decides to connect to a MySql database? --Michael __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Is View supported?
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 these 12 tables I can save a lots of program change thankx Borus - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: can't connect to server2
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 it for errors, check the file [mysql installation dir]/var/[server name].err borus - Original Message - ±H¥óªÌ: Hoa Doan [EMAIL PROTECTED] ¦¬¥óªÌ: [EMAIL PROTECTED] ¶Ç°e¤é´Á: 2002¦~5¤ë23¤é PM 01:49 ¥D¦®: can't connect to server2 Okay so it says that I can't connect through socket '/var/lib/mysql/mysql.sock'. So I checked and the UNIX socket is located here: /tmp/mysql.sock. I'm relatively new to Linux. What does this mean? -Hoa _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Backslash BUG?
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 special handling in UNIX/C
program. Method is just to add another back slash whenever a back slash
is detected.
this is sure also a problem in load data, insert ...infile , etc commands.
let me say it another way
if there is a X sequence in UNIX/C
whenever X is encountered , you must add another X to it in order to
let the string normally insert into table, what do you think?
the problem is whether you think back slash can be part of a string.
FYI, database like oracle, informix, sybase all support multicharacter set
with back slash contained string support, consider it, please~
:)
Borus
- Original Message -
寄件者: Benjamin Pflugmann [EMAIL PROTECTED]
收件者: Bruno Batarelo [EMAIL PROTECTED]
副本: [EMAIL PROTECTED]
傳送日期: 2002年5月23日 AM 06:58
主旨: Re: Backslash BUG?
Hi.
Because the backslash is the escaping character and therefore has a
special meaning, you have to escape it itself to get a plain
backslash. I.e.
mysql insert into table (Field1) values ('\\');
This will insert one backslash. This is documented here:
http://www.mysql.com/doc/m/y/mysql.html
The above statement is only true for the command line client and any
other interface which uses backslash this way (e.g. C/C++ strings).
Regards,
Benjamin.
On Wed, May 22, 2002 at 11:58:15PM +0200, [EMAIL PROTECTED]
wrote:
Greetings
I use latest stabile version of MySQL. Please, try to create temp table
or
normal table and from mysql.exe try to insert a backslash symbol into a
field. Here is an example:
Enter password: **
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 441 to server version: 3.23.49-max
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql \u elba
Database changed
mysql create temporary table TTable(Field1 mediumtext);
Query OK, 0 rows affected (0.04 sec)
mysql insert into ttable (Field1) values ('\');
'
'
'
'
That means that query ok message is skipped. The same problem occur if I
try
the same operation with blob data type. Please report me about this.
Bruno
--
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Bug? - AIX 4.3.3 ML10, IBM C/C++ 5.0.2
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 version, MySQL cannot shutdown I must use kill -9 [PID] to kill the safe_mysqld script and mysql processes. my AIX version is 4.3.3 but the good news is the binary compiled in 4.3.3 machine can run in 4.3.1 my way is absolutely not good, but it seems work. I used this to configure: CC=gcc CXX=gcc CXXFLAGS=-O3 ./configure --prefix=/mysql/mysql \ --with-extra-charsets=complex --with-low-memory and you? Borus - Original Message - 寄件者: morgan henning [EMAIL PROTECTED] 收件者: [EMAIL PROTECTED] 傳送日期: 2002年5月21日 AM 08:49 主旨: Bug? - AIX 4.3.3 ML10, IBM C/C++ 5.0.2 Hi. I am trying to build MySQL 3.23.49, and I am having some problems. If anyone has any suggestions, they would be **much** appreciated :) I have tried to compile MySQL 3.23.49 a couple of ways under AIX, and I have gotten this twice (more info below): xlC -DUNDEF_THREADS_HACK -I./../include -I../include -I./.. -I.. -I.. -O3 -DDBUG_OFF -Wa,-many -DUNDEF_HAVE_INITGROUPS -DSIGNALS_DONT_BREAK_READ -c mysql.cc /usr/include/curses.h, line 1751.14: 1540-0063 (S) The text bool is unexpected. gmake[2]: *** [mysql.o] Error 1 gmake[2]: Leaving directory `/home/morgan/mysql-3.23.49/client' gmake[1]: *** [all-recursive] Error 1 gmake[1]: Leaving directory `/home/morgan/mysql-3.23.49' gmake: *** [all-recursive-am] Error 2 I got this on both AIX 4.3.3 (maintenance level 10 applied), and AIX 5.1.0 (maintenance level 2 applied). Both times I got the error, I was using the IBM C Compiler v5.0.2 and IBM C++ Compiler v5.0.2 (Visual Age C++ packages). The configure command line was CC=xlc CXX=xlC ./configure --prefix=/opt/mysql. I am using GNU make 3.79.1. The machine both times was an RS6000 43P-132 (type 7248-132). I can provide all kinds of more information if you like :) I tried gcc-3.0.4, but that failed also, although I forget the exact error. I am build gcc-2.95.3 in an effort to try the recommended gcc now. Nothing on that front yet. Am I just missing something with IBM C/C++ ?? The compiler is not patched to the latest level, although I can patch it. It's just a big download ( 500 MB). Please advise if you think that's the solution. Thanks!! :) -- Morgan Henning [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Concurrency control
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 PROTECTED] 收件者: [EMAIL PROTECTED] 傳送日期: 2002年5月20日 PM 12:36 主旨: Concurrency control How does MySQL handle concurrency control between two or more concurrent quires (not transactions), on their website they say they use multi-versioned concurrency control, but i guess this between transactions, not queries. Consider the case we have two queries Q1: select * from table1 EXCEPT select * from table1 where id50; Q2:update table1 set id = id+1; Concurrent execution of these two queries could result in incorrect results, if no appropriate concurrency control is used, specifically if the update query is executed between the first half of Q1 and the second half. there are many other examples to this problem, so i wonder how MySQL handles it. Thanks, Khaled. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: how to turn off query logging in mysql, redhat linux
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 Blumer [EMAIL PROTECTED]
¦¬¥óªÌ: [EMAIL PROTECTED]
¶Ç°e¤é´Á: 2002¦~5¤ë16¤é AM 11:02
¥D¦®: how to turn off query logging in mysql, redhat linux
Hello
I am trying to turn off the query log in mysql on redhat linux. It
generates
huge log files (in /var/lib/mysql/hostname.log) that I dont need, and
impacts performance.
safe_mysqld was run with --log, and it seems like I want to turn that off
but I cant find any script or config file where the --log was specified,
perhaps it was compiled in?
I only have a binary distribution of mysql. Is there some way to override
the --log?
I have looked at section 4.9 of the mysql manual and
/etc/my.cnf (see below) and these scripts
/etc/rc.d/rc[0-6].d/K12mysqld
/etc/rc.d/init.d/mysqld
/usr/share/mysql/mysql.server
Does anyone know which of these scripts is really the one that starts
safe_mysql?
(note that the err-log setting in my.cnf refers to an error log (empty on
my
machine) not
the query log that I am trying to get rid of.
-thanks Tom
$ ps -ax |grep mysql
6010 ?S 0:00 /bin/sh /usr/bin/safe_mysqld --log
6036 ?S 0:45 /usr/libexec/mysqld --basedir=/usr
--datadir=/var/lib
# uname -a
Linux {mydomain.com} 2.4.9-13 #1 Tue Oct 30 20:11:04 EST 2001 i686 unknown
# mysqladmin --version
mysqladmin Ver 8.21 Distrib 3.23.41, for redhat-linux-gnu on i386
# cat my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
_
Chat with friends online, try MSN Messenger: http://messenger.msn.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
AIX RS6000 installation problem
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 under /mysql/mysql, I try to run the script for GRANT command, I got the following errors: exec(): 0509-036 Cannot load program ./bin/mysqld because of the following errors: 0509-130 Symbol resolution failed for mysqld because: 0509-136 Symbol stpcpy (number 137) is not exported from dependent module /usr/lib/libc.a(shr.o). 0509-136 Symbol strnlen (number 138) is not exported from dependent module /usr/lib/libc.a(shr.o). 0509-136 Symbol strcpy (number 179) is not exported from dependent module /usr/lib/libz.a(shr.o). 0509-136 Symbol strcat (number 180) is not exported from dependent module /usr/lib/libz.a(shr.o). 0509-136 Symbol memmove (number 182) is not exported from dependent module /usr/lib/libz.a(shr.o). 0509-136 Symbol bcopy (number 183) is not exported from dependent module /usr/lib/libz.a(shr.o). 0509-192 Examine .loader section symbols with the 'dump -Tv' command. Installation of grant tables failed! I check the /usr/lib/libz.a, there is shr.o inside and in /usr/lib/libc.a, there is shr.o too. I don't understand what is the problem. then I try to skip the script and start the MySQL deamon by typing ./bin/safe_mysqld then I got the following errors, (similar) # ./bin/safe_mysqld exec(): 0509-036 Cannot load program ./bin/my_print_defaults because of the following errors: 0509-130 Symbol resolution failed for my_print_defaults because: 0509-136 Symbol stpcpy (number 45) is not exported from dependent module /usr/lib/libc.a(shr.o). 0509-136 Symbol strnlen (number 46) is not exported from dependent module /usr/lib/libc.a(shr.o). 0509-136 Symbol strcat (number 60) is not exported from dependent module /usr/lib/libz.a(shr.o). 0509-136 Symbol memmove (number 61) is not exported from dependent module /usr/lib/libz.a(shr.o). 0509-136 Symbol bcopy (number 62) is not exported from dependent module /usr/lib/libz.a(shr.o). 0509-192 Examine .loader section symbols with the 'dump -Tv' command. chown: 3002-131 mysql is an unknown username. Starting mysqld daemon with databases from /mysql/mysql-3.23.49-ibm-aix4.3.3.0-r s6000/data 020514 19:22:43 mysqld ended do anyone have suggestion for me? what should I check for? thankx Borus - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL AIX RS6000 installation problem
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 running without problem.) I tar everything in /mysql directory then under /mysql/mysql, I try to run the script for GRANT command, I got the following errors: exec(): 0509-036 Cannot load program ./bin/mysqld because of the following errors: 0509-130 Symbol resolution failed for mysqld because: 0509-136 Symbol stpcpy (number 137) is not exported from dependent module /usr/lib/libc.a(shr.o). 0509-136 Symbol strnlen (number 138) is not exported from dependent module /usr/lib/libc.a(shr.o). 0509-136 Symbol strcpy (number 179) is not exported from dependent module /usr/lib/libz.a(shr.o). 0509-136 Symbol strcat (number 180) is not exported from dependent module /usr/lib/libz.a(shr.o). 0509-136 Symbol memmove (number 182) is not exported from dependent module /usr/lib/libz.a(shr.o). 0509-136 Symbol bcopy (number 183) is not exported from dependent module /usr/lib/libz.a(shr.o). 0509-192 Examine .loader section symbols with the 'dump -Tv' command. Installation of grant tables failed! I check the /usr/lib/libz.a, there is shr.o inside and in /usr/lib/libc.a, there is shr.o too. I don't understand what is the problem. then I try to skip the script and start the MySQL deamon by typing ./bin/safe_mysqld then I got the following errors, (similar) # ./bin/safe_mysqld exec(): 0509-036 Cannot load program ./bin/my_print_defaults because of the following errors: 0509-130 Symbol resolution failed for my_print_defaults because: 0509-136 Symbol stpcpy (number 45) is not exported from dependent module /usr/lib/libc.a(shr.o). 0509-136 Symbol strnlen (number 46) is not exported from dependent module /usr/lib/libc.a(shr.o). 0509-136 Symbol strcat (number 60) is not exported from dependent module /usr/lib/libz.a(shr.o). 0509-136 Symbol memmove (number 61) is not exported from dependent module /usr/lib/libz.a(shr.o). 0509-136 Symbol bcopy (number 62) is not exported from dependent module /usr/lib/libz.a(shr.o). 0509-192 Examine .loader section symbols with the 'dump -Tv' command. chown: 3002-131 mysql is an unknown username. Starting mysqld daemon with databases from /mysql/mysql-3.23.49-ibm-aix4.3.3.0-r s6000/data 020514 19:22:43 mysqld ended do anyone have suggestion for me? what should I check for? thankx Borus - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL on IBM AIX tar problem!!
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 -sql,mysql,oracle,sol, 692 bytes, 2 media blocks. tar: 0511-188 Cannot create ././@LongLink: The file access permissions do not al low the specified action. x mysql-3.23.49/sql-bench/Results-win32/ATIS-informix_odbc-NT_4.0-cmp-db2,info rm ix,ms-sql,mysql,oracl, 694 bytes, 2 media blocks. tar: 0511-188 Cannot create ././@LongLink: The file access permissions do not al low the specified action. x mysql-3.23.49/sql-bench/Results-win32/ATIS-ms-sql_odbc-NT_4.0-cmp-db2,inform ix ,ms-sql,mysql,oracle,, 727 bytes, 2 media blocks. tar: 0511-188 Cannot create ././@LongLink: The file access permissions do not al low the specified action. x mysql-3.23.49/sql-bench/Results-win32/ATIS-mysql-NT_4.0-cmp-db2,informix,ms- sq l,mysql,oracle,solid,, 789 bytes, 2 media blocks. x mysql-3.23.49/sql-bench/Results-win32/ATIS-mysql-win98-cmp-access,mysql, 985 b ytes, 2 media blocks. tar: 0511-188 Cannot create ././@LongLink: The file access permissions do not al low the specified action. === and then I found a strange file in the directory at the same level as mysql-3.23.49 -- 1 oracle dba 109 Jan 01 1970 @LongLink What is wrong with the tar execution? thankx for reading, Borus - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL on IBM AIX tar problem
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 -sql,mysql,oracle,sol, 692 bytes, 2 media blocks. tar: 0511-188 Cannot create ././@LongLink: The file access permissions do not allow the specified action. x mysql-3.23.49/sql-bench/Results-win32/ATIS-informix_odbc-NT_4.0-cmp-db2,info rm ix,ms-sql,mysql,oracl, 694 bytes, 2 media blocks. tar: 0511-188 Cannot create ././@LongLink: The file access permissions do not allow the specified action. x mysql-3.23.49/sql-bench/Results-win32/ATIS-ms-sql_odbc-NT_4.0-cmp-db2,inform ix,ms-sql,mysql,oracle,, 727 bytes, 2 media blocks. tar: 0511-188 Cannot create ././@LongLink: The file access permissions do not allow the specified action. x mysql-3.23.49/sql-bench/Results-win32/ATIS-mysql-NT_4.0-cmp-db2,informix,ms- sql,mysql,oracle,solid,, 789 bytes, 2 media blocks. x mysql-3.23.49/sql-bench/Results-win32/ATIS-mysql-win98-cmp-access,mysql, 985 bytes, 2 media blocks. tar: 0511-188 Cannot create ././@LongLink: The file access permissions do not allow the specified action. === and then I found a strange file in the directory at the same level as mysql-3.23.49 -- 1 oracle dba 109 Jan 01 1970 @LongLink What is wrong with the tar execution? thankx for reading, Borus - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: O2 to MySQL.....
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 in o2 database to mysql...pls. can anyone guide me on that?? Thanx... Regards, Ritu Singla For live cricket scores download Yahoo! Score Tracker at: http://in.sports.yahoo.com/cricket/tracker.html - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Using multi-byte character set
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 it as an invalid escape sequence. I can tackle the problem to add another back slash to the string when I am doing sth using C API. e.g. try to insert 1234\po, then I modify the string to 1234\\po then 1234\po can be retrieved from DB. But it seemed difficult to do using ODBC since I am using ASP and VB for the front end. So I am searching for a one time solution for the problem. Is it necesary for me to add big5 to the character set? but I don't need the to sort any double byte character field. what should I do? thanks for reading Borus - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Using multi-byte character set
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 it as an invalid escape sequence. I can tackle the problem to add another back slash to the string when I am doing sth using C API. e.g. try to insert 1234\po, then I modify the string to 1234\\po then 1234\po can be retrieved from DB. But it seemed difficult to do using ODBC since I am using ASP and VB for the front end. So I am searching for a one time solution for the problem. Is it necesary for me to add big5 to the character set? but I don't need the to sort any double byte character field. what should I do? thanks for reading Borus - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
row id
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 request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: New Setup
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 and specify the Host_Name of your server.Should be work. Eg: mysql -u root -h Your_Server_Name Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Ian Phillips [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 22, 2002 11:58 AM Subject: New Setup I thank anyone in advance who may be able to help me iron this out. 1. I am setting up mysql on my apache server. I have had it there for a while, but haven't really done much with getting my head round it. 2. I have figured out some shell commands, and have been able to set a root password. 3. I have also been able to use phpMyAdmin - which I had to modify to take into account the root password etc that is now in place. 4. I can create a database table using the phpMyAdmin forms - and it was relatively easy. However, when I go back to try and set up a new user who has permission to do a range of things on this database, (using shell now), I am given an error ERROR 1044: Access denied for user: 'root@localhost' to database 'cbaa' Shell command I am using mysql GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP - ON cbaa.* - TO cbaa@localhost - IDENTIFIED BY 'itsmeolord'; This seems strange to me, as I figured that root would have permission to do anything (even if it were 'inappropriate'. Any guidance would be appreciated. Ian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MyODBC multiple connection
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 why? thanks Borus - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: New Setup
### db set up [Linux] mysql -h localhost -u root mysql create database db_abc; ### grant to user mysqlgrant all on db_abc.* to pp@localhost - identified by 'pp_pwd'; ### ppp login [Linux] mysql -h localhost -u pp -p db_abc this is what I had done, have a look the message is becoming messy, may be I made a mistake about how u check the login :) Borus (leaving office, cu) Yes - but I haven't got the picture of what you're trying to communicate. I thought I would have to log in as root, to be able to create the user cbaa and allow that user to access the cbaa database. Ian - 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 though Tried connecting to mysql using the -h option, but I still had the same response. (with the -p option as well thanks Borus). Let me check - Your_Server_Name I think in my case is localhost I had a look (using the phpMyAdmin tool) at the records in the user table. There are four records - two of which are localhost - one which is root, with password (all privileges), and the second no user no password - no privileges. The other two records are similar, but my server's domain name appears in these two records. I could not see any % mark in the user table - however I did find the % mark in the mysql.host table - two records - one for localhost and the other my domain name, and the % mark was in the db column. Ian - Original Message - From: Gelu [EMAIL PROTECTED] To: Ian Phillips [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, April 22, 2002 9:05 PM Subject: Re: New Setup Hi, Only the root with the '%' character on the host field from table mysql.user have full priveleges.Try to connect with -h option and specify the Host_Name of your server.Should be work. Eg: mysql -u root -h Your_Server_Name Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Ian Phillips [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 22, 2002 11:58 AM Subject: New Setup I thank anyone in advance who may be able to help me iron this out. 1. I am setting up mysql on my apache server. I have had it there for a while, but haven't really done much with getting my head round it. 2. I have figured out some shell commands, and have been able to set a root password. 3. I have also been able to use phpMyAdmin - which I had to modify to take into account the root password etc that is now in place. 4. I can create a database table using the phpMyAdmin forms - and it was relatively easy. However, when I go back to try and set up a new user who has permission to do a range of things on this database, (using shell now), I am given an error ERROR 1044: Access denied for user: 'root@localhost' to database 'cbaa' Shell command I am using mysql GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP - ON cbaa.* - TO cbaa@localhost - IDENTIFIED BY 'itsmeolord'; This seems strange to me, as I figured that root would have permission to do anything (even if it were 'inappropriate'. Any guidance would be appreciated. Ian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http
access denied on use database, linux on PC
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 exit Bye then I login as ps_user /ps_ap/mysql mysql -h ps -u push Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 to server version: 3.23.49a-log Type 'help;' or '\h' for help. mysql use ps_db ERROR 1044: Access denied for user: '@ps' to database 'ps_db' mysql and cannot use the database, what had I missed out for the privilege setting? thank you for reading Borus - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
access denied on use database
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 ps_user; Query OK, 0 rows affected (0.00 sec) mysql exit Bye then I login as ps_user /ps_ap/mysql mysql -h ps -u ps_user Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 to server version: 3.23.49a-log Type 'help;' or '\h' for help. mysql use ps_db ERROR 1044: Access denied for user: '@ps' to database 'ps_db' mysql and cannot use the database, what had I missed out for the privilege setting? thank you for reading Borus - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
