FW: make problems on solaris 8 x86
Can anybody help me with this please -Original Message- From: suresh [mailto:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 2:20 PM To: [EMAIL PROTECTED] Subject: make problems on solaris 8 x86 Hello I am installing mysql 3.23.37 on solaris 8 x86. I am having problem with strings-x86.s when running make Has anybody come accross this problem and is there a work around I am using gtar and gmake I am using latest gcc also Thanx in advance Suresh _ gmake[2]: Entering directory `/install/mysql-3.23.37/strings' gcc -DHAVE_CONFIG_H -I. -I. -I.. -I./../include -I../include-O3 -DDBUG_O FF - O3 -DHAVE_CURSES_H -I/install/mysql-3.23.37/include -DHAVE_RWLOCK_T -c strings- x86.s Assembler: strings-x86.s, line 3 : Illegal mnemonic strings-x86.s, line 3 : Syntax error strings-x86.s, line 3 : Illegal mnemonic strings-x86.s, line 3 : Illegal mnemonic strings-x86.s, line 3 : Illegal mnemonic strings-x86.s, line 3 : Illegal mnemonic strings-x86.s, line 3 : Illegal mnemonic strings-x86.s, line 3 : Syntax error strings-x86.s, line 3 : Illegal mnemonic strings-x86.s, line 3 : Illegal mnemonic strings-x86.s, line 3 : Illegal mnemonic strings-x86.s, line 4 : Illegal mnemonic strings-x86.s, line 4 : Syntax error strings-x86.s, line 4 : Illegal mnemonic strings-x86.s, line 4 : Illegal mnemonic strings-x86.s, line 4 : Illegal mnemonic strings-x86.s, line 4 : Illegal mnemonic strings-x86.s, line 4 : Illegal mnemonic strings-x86.s, line 4 : Illegal mnemonic strings-x86.s, line 4 : Illegal mnemonic strings-x86.s, line 4 : Illegal mnemonic strings-x86.s, line 4 : Illegal mnemonic strings-x86.s, line 4 : Illegal mnemonic strings-x86.s, line 4 : Illegal mnemonic strings-x86.s, line 4 : Illegal mnemonic strings-x86.s, line 5 : Illegal mnemonic strings-x86.s, line 5 : Syntax error strings-x86.s, line 5 : Illegal mnemonic strings-x86.s, line 5 : Illegal mnemonic strings-x86.s, line 5 : Illegal mnemonic strings-x86.s, line 5 : Illegal mnemonic Too many errors - Goodbye gmake[2]: *** [strings-x86.o] Error 1 gmake[2]: Leaving directory `/install/mysql-3.23.37/strings' gmake[1]: *** [all-recursive] Error 1 gmake[1]: Leaving directory `/install/mysql-3.23.37' gmake: *** [all-recursive-am] Error 2 _ - 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
Backups, Replication and the binlog
Hi all! I have been attempting to set up a system that involves replication and have run into some minor problems. I am only replicating one database but not all of the tables in the database. So when changes are made to the replicated dataase, it is logged to the binary log even if it is from a table i do not want to replicate. This causes problems because if i take the binary log from one machine to another and try to use it to update that machine, won't it also update the tables i explicitly wanted to not replicate. Basically in my config file i have set binlog-do-db=replicated_db replicate-do-db=replicated_db and in the slaves replicate-ignore-table=replicated_db.table1 replicate-ignore-table=replicated_db.table2 replicate-ignore-table=replicated_db.table3 what i basically wanted to knwo is if there was an option like binlog-ignore-table so that when i take the binary log over to the replicated machine and pump it in to update it, it won't change the tables which have been defined as not to be replicated? Is there any way of doing this? Thanks in advance! William - 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
High availability anyone?
Hi. I'd like to build an HA MySQL server using shared storage over Fibre Channel. Having a look at the mailing list archives, the issue was addressed earlier on (I could find traces of it as early as 1999) but AFAICS no definitive solution has been reached. I know there is a commercial solution from SteelEye tecnologies, but it's very expensive and I'd like to see if there is some other way (i.e. GFS). Has anybody tried this? Any success stories? Is there any reason why this COULDN'T work? (i.e. two+ mysql processes accessing concurrently the same storage space would stomp on each other's feet, have problems of cache incoherency or who-knows-what-else) Thanks in advance for any replies. -- /kinkie - 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
set auto commit problem
Hi, I'm tring to make connection.setAutoCommit(false) with org.gjt.mm.mysql.Driver driver, I recieve an exception that says : cannot disable AUTOCOMMIT . Is it the driver, should I use different driver, and suggestion ? Thanks a lot einav. Einav Lavi-Pdut software engineer [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
How can one validate a date in mysql ?
Dear Colleagues, How can one validate a date in mysql ? Kind regards, Pieter
Re: How can one validate a date in mysql ?
Validate a date? see Date and Time functions in the manual. Vankeerberghen, Pieter wrote: Dear Colleagues, How can one validate a date in mysql ? Kind regards, Pieter - 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 can one validate a date in mysql ?
Thank you, Ok, I looked in the manual but I coul dnot obtain an answer. How can I check that a date I'm importing is valid, e.g. how to check for 20001131 (MMDD) ? Kind regards, Pieter -Original Message- From: Colin Faber [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 11:18 AM To: Vankeerberghen, Pieter Cc: [EMAIL PROTECTED] Subject: Re: How can one validate a date in mysql ? Validate a date? see Date and Time functions in the manual. Vankeerberghen, Pieter wrote: Dear Colleagues, How can one validate a date in mysql ? Kind regards, Pieter
Re: mysql++ and Programming with MFC
Gilfether, Ryan writes: Anyone have success in using mysql++ with MFC in Visual C++ 6.0, if so what did you do to get it to work? I emailed the guy who did the mysql++ port for Visual C++ and he told me that it is a major problem getting it to work with MFC. I tried all the stuff he suggested to get it to work, changing run time libraries and stuff ... no luck, I get a bunch of linker errors ... anyone ever done this successfully? Thanks Ryan Gilfether Programmer Praxis, Inc. www.pxi.com (703)837-8400 x5412 Hi! No, I have not and I never used MFC. But what you can do is change the order of include files. Also, you might try including undef_short, in which case you will have to write longer variants of class names. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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 in CAPI of My Sql
VVM Ravikumar Sarma Chengalvala writes: Hi Sinisa, Thanks for spending the time.Here are few observations on mysql_escape_string().I have checked it up and found to be working but with the following problems. i) It works well when I want to insert strings like: 'xyz or x'yz. ii) When I use x\yz with the function I see a junk character appearing like x(junt char)yz in mysql console window and as x|yz in GUI window. Please note that the line shown ablove appears as a thick line. iii) If I want to store something like\x\yz,it even ignores the first backslash. iv) This happens when I pass it through the function.Otherwise if I send something like\\x\\yz directly without going through the function then it stores it as \x\yz. v) This is the problem with the function itself or shall I have to do something else. Regards, Ravi Hi! Depends what you mean by appearing in mysql window or in GUI window. If you use the above function, then the only place it should appear is in your program. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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: my sql_escape_string()--Bug?
VVM Ravikumar Sarma Chengalvala writes: Hi Sinisa, 1. Thanks for the detailed mails .I got to the problem I am facing with '\' character. 2. Actually I am expecting the function to add an additional \ when a single '\' comes as a part of string.For example: I want to insert a File path like \Program Files\xy\xyz.geo I n expecting the function mysql_escape_string() to convert it into \\Program Files\\xy\\xyz.geo which it is not doing precisely. Am I right in my perspective?i.e mysql_escape_string does not provide support for a single backslash characher which comes as part of the string. Even the function code which you have sent does not say anything about it. Shall I have to write a small code to replace '\' with a '\\'? Then :Is it a Bug? 3. Once again thanks for your patience .I am putting down the problem in detail as it provides scope for improvement in next version. Regards, Ravi Regards, Ravi The function will add another backslash to backslash. Only it does not have to appear on screen that way. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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 can one validate a date in mysql ?
On Tue, May 15, 2001 at 11:27:19AM +0200, Vankeerberghen, Pieter wrote: Thank you, Ok, I looked in the manual but I coul dnot obtain an answer. How can I check that a date I'm importing is valid, e.g. how to check for 20001131 (MMDD) ? You'll have to do this kind of validation checks in your actual program that uses the MySQL interface, *before* executing the SQL statement itself. G'luck, Peter -- yields falsehood, when appended to its quotation. yields falsehood, when appended to its quotation. - 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: PROPOSAL mysqldump change for InnoDB
Steve Ruby writes: Due to the fact that piping a table from mysqldump to an INNODB table can be as much as 30X slower if the insert is not done with transactions, would it make sense to add some option to mysqldump to make every X inserts a transaction. for example mysqldump --transactionrows=10 mydatabase | mysql -hsomeserver database where the above would wrap every 100,000 inserts with begin; commit; right now it is non-trivial to insert the transaction lines every so often, or even around all of the data. Hi! I guess you mean autocommit=0 insert .. commit It makes sense. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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: Changing Data Fields through GUI?
Peter Kovari writes: Could someone tell us, how to change individual data fields with MYSQLGUI, or when is this feature going to be available? Does anyone know about any other tool that enables you to change individual data fields in tables? Thanks, -Peter HI! For the moment, to change data, you can use UPDATE commands with ?var? values for columns. It is MS Access style of custom forms. This will create custom forms for each query. This is more explained in the manual. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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 3.23.38 released
Florin Andrei writes: On 12 May 2001 00:51:11 +0300, Michael Widenius wrote: That's great news!!! Congratulations, guys! Now the problems: :-) cut Best regards, and keep up the good work! -- Florin Andrei Remember, son: if you never try, you never fail - Homer Simpson --- mysql-3.23.38.spec.orig Wed May 9 13:56:54 2001 +++ mysql-3.23.38.specMon May 14 16:09:46 2001 @@ -18,7 +18,7 @@ URL: http://www.mysql.com/ Packager:David Axmark [EMAIL PROTECTED] Vendor: MySQL AB -Provides:msqlormysql MySQL-server +Provides:msqlormysql MySQL-server mysql Obsoletes: mysql # Think about what you use here since the first step is to Hi! Thank you for your fix for RPM. The reason why you are having problems in building from source is that you are most probably using gcc 2.96, which is simply broken. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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: Problem with Sig11 stack trace.
Jeffrey Mulliken writes: If I am posting this to the wrong list, please let me know which is the more appropriate list. Thanks. I am trying to get a new installation of Bugzilla, v 2.12 installed and working. I used a binary tarball of 3.23.36 for the installation. I am also using the Msql-MySQL modules 1.2215. While performing a variety of functions with Bugzilla, MySQL is crashing with the following output in the 'hostname.err' file: cut Now, as I got a binary distro, the 'resolve_stack_dump' tool for decoding the stack trace wasn't included. So, I was hoping that someone on the list would be able to tell me why I am likely getting this error. The info on the machine platform.; RedHat 6.2 Kernel 2.2.17 Bugzilla v. 2.10 Perl v. 5.6.1 MySQL v. 3.23.36 If there is any other info that I can supply, just let me know. Getting this installation up and working is my highest priority job assignment, so I will be very grateful for any help offered. Thanks in advance... Jeff Mulliken '[EMAIL PROTECTED]' Please try our latest 3.23.38 binary and see if you continue to have problems. If you do, please let us know exactly which command crashes MySQL. You can turn binary log to find out that. When you have exact data on which command crashes our binary, please mail your findings to [EMAIL PROTECTED] Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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 get Sig 11 during query from Bugzilla
root writes: Description: When I sent this problem to the list earlier, I hadn't read about mysqlbug, so please excuse the improper question submission. Here is the repeat; I am trying to get a new installation of Bugzilla, v 2.12 installed and working. I used a binary tarball of 3.23.36 for the installation. I am also using the Msql-MySQL modules 1.2215. While performing a variety of functions with Bugzilla, MySQL is crashing with the following output in the 'hostname.err' file: mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a readable backtrace that may help in finding out why mysqld died. Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Stack range sanity check OK, backtrace follows: 0x81402ca 0x8077d5f 0x80c9858 0x80b0aa2 0x80b0341 0x8087de2 0x808ab9c 0x808617d 0x808569e Stack trace successful, trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x827ba40 = insert into logincookies (userid,cryptpassword,hostname) values (1, 'lv8RdtnjowP22', '10.200.70.5') thd-thread_id = 2 Successfully dumped variables, if you ran with --log, take a look at the details of what thread 2 did to cause the crash. In some cases of really bad corruption, this value may be invalid Please use the information above to create a repeatable test case for the crash, and send it to [EMAIL PROTECTED] Now, as I got a binary distro, the 'resolve_stack_dump' tool for decoding the stack trace wasn't included. So, I was hoping that someone on the list would be able to tell me why I am likely getting this error. How-To-Repeat: Fix: Submitter-Id:submitter ID Originator: [EMAIL PROTECTED] Organization: V-Stor LLC MySQL support: none Synopsis:MySQL get Sig 11 during query from Bugzilla Severity:critical Priority:high Category:mysql Class: support Release: mysql-3.23.36 (Official MySQL binary) Environment: System: Linux services.v-stor.com 2.2.17 #1 Tue Dec 19 17:13:10 EST 2000 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) Compilation info: CC='gcc' CFLAGS='-O6 -mpentium ' CXX='gcc' CXXFLAGS='-O6 -mpentium -felide-constructors' LDFLAGS='-static' LIBC: lrwxrwxrwx1 root root 13 Dec 19 20:40 /lib/libc.so.6 - libc-2.1.3.so -rwxr-xr-x1 root root 4101324 Feb 29 2000 /lib/libc-2.1.3.so -rw-r--r--1 root root 20272704 Feb 29 2000 /usr/lib/libc.a -rw-r--r--1 root root 178 Feb 29 2000 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --enable-assembler --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --disable-shared Hi! Beside what I wrote in the previous mail, please check with CHECK TABLE whether logincookies table is OK. If that is not OK, it is the most probable cause of the crash. If it is OK, please send us it's CREATE TABLE statement. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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[2]: MySQL FullText improvements in V4.0
You can do this yourself, pretty easily by building an index in advance. I've been using the following technique to implement full text searching since before it existed in MySQL in any form. Tokenize each unique word in a document and store the word count in tables: tbl_tokens: token_id int token varchar tbl_doc_index: token_id int doc_id int word_count int Populate the tables from your document database either what documents are saved or in some other offline process. When someone searches on words, first convert to tokens using the first table and look up in the 2nd table using whatever search/join technique works best in your situation. Jamie At Monday, May 14, 2001 on 2:18:38 PM, you wrote: I too am curious! I think one feature that I'd really like to see is the ability to tell the number of times a string appears inside another string. This would help a lot when trying to do search results weighting. -Chris - 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 3.23.38 released
hunter writes: Are you saying that the current version of gcc for RedHat Linux 7.1 (i.e. 2.96) is not working for you and thus preventing the rpm from building? Thats awfully interesting, and you should report the bug, if that is indeed what you are seeing, to bugzilla... Yes, the above is right. We do not use 2.96 as it has a long list of bugs, especially in C++ compiler. Yes, we have reported bugs. We use 2.96 only on Intel IA 64 CPU, as it is the only compiler available for it. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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
Create MULTIPLE TABLES ?
I would like to create multiple tables in a database. HowTo Use REFERENTIAL INTEGRITY with MySQL ? May I use FOREIGN KEY or REFERENCES? Note: MySQL Release = 3.23.36 Thanks for help :) - 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: Create MULTIPLE TABLES ?
On Tue, May 15, 2001 at 12:43:02PM +0200, RAZAKA wrote: I would like to create multiple tables in a database. HowTo Use REFERENTIAL INTEGRITY with MySQL ? May I use FOREIGN KEY or REFERENCES? Note: MySQL Release = 3.23.36 Thanks for help :) In short, you can't.. From the MySQL manual (Reference CREATE TABLE): * The `FOREIGN KEY', `CHECK', and `REFERENCES' clauses don't actually do anything. The syntax for them is provided only for compatibility, to make it easier to port code from other SQL servers and to run applications that create tables with references. G'luck, Peter -- What would this sentence be like if pi were 3? - 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 question
How would I login to mysql in telnet and create tables Regards,Terrell Johnson Dedicated support Technician Catalog.com, Inc. http://www.catalog.com ICQ#113201638
ISAM v.s. MYISAM
Hi there I am working on a site where they are using ISAM files, (.ISM .IS1), I want to know if there is a way of accessing these from MYSQL? From what I have been able to tell they appear totally differently in comparison to some of my MYISAM table when I open them in Notepad. Can anyone shed some light? ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31) 767-0249 - 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 question
mysql -u username -p enter your password use yourdatabase; create table mytablename(... (see the manual for proper syntax on creating tables) - Original Message - From: Terrell Johnson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, May 15, 2001 12:28 PM Subject: Mysql question How would I login to mysql in telnet and create tables Regards,Terrell Johnson Dedicated support Technician Catalog.com, Inc. http://www.catalog.com ICQ#113201638 - 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: ISAM v.s. MYISAM
I'm working a project with the same exact scenario right now. My ver. of mySQL is 3.23.xx and my client's is 3.22.xx. there table sturcturing is ISAM and mine is myISAM. The only I've been able to transfer succesfully is by dumping all the data and re-importing on the clients end. -Original Message- From: Warren van der Merwe [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 7:27 AM To: [EMAIL PROTECTED] Subject: ISAM v.s. MYISAM Hi there I am working on a site where they are using ISAM files, (.ISM .IS1), I want to know if there is a way of accessing these from MYSQL? From what I have been able to tell they appear totally differently in comparison to some of my MYISAM table when I open them in Notepad. Can anyone shed some light? ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31) 767-0249 - 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 can one validate a date in mysql ?
Dear Colleagues, How can one validate a date in mysql ? Kind regards, Pieter The simplest way that i know is: date_add(datestring, interval 0 day) This function wil return the correct date or NULL with months outside 1..12 and days outside 1..31. Here are some examples: select date_add('1999023', interval 0 day) - null select date_add('19990223', interval 0 day) -1999-02-23 select date_add('19990232', interval 0 day) - null select date_add('19990231', interval 0 day) -1999-03-03 Regards, Paul Paul B. van den Berg email: [EMAIL PROTECTED] Department of Social Pharmacy and Pharmacoepidemiology University Centre for Pharmacy tel:31-50-361 fax:31-50-3632772 Ant. Deusinglaan 1 9713 AV Groningen Netherlands - 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
Known problem without solution
Hi, I'm new on the list. I subscribed because I need help about a problem I have. I heard that this problem is well-known and well-documented, but it never work ... In fact, I'm unable to start MySQL(-3.23.38) (even with 3.23.32) on a RedHat 7.0. It doesn't say anything wrong, but MySQL is immediatly stopping like this : snip Starting mysqld daemon with databases from /var/lib/mysql 010515 14:21:02 mysqld ended /snip With version 3.23.32, logs said something like this : snip /usr/libexec/mysqld: Can't find file: './mysql/host.frm' /snip I read that there's a known problem with RedHat 7.0 and MySQL, and read that I've to do a chown -R mysql on /var/lib/mysql. I did that but it doesn't change anything. I downloaded the last version of MySQL but it doesn't change anything. Is there some other patches/packages I've to dowload from redhat.com ? Please help. thanks, [bastien] PS.: Another question : is it possible to copy a running configuration from another machine on which MySQL well runs ? - 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
Varchar binary field auto-trimmed??
Hi Help! I would like to store some short binary data (encrypted). I used a varchar(24) binary field for this. But it seems that MySQL cuts white-spaces from the end when storing the data in the table. When the encrypted string now has a white-space at end, MySQL will cut it and this will result in a wrong decryption (next time when the string is read and decrypted). When using TinyBlob instead of varchar binary, all works fine. Is this a feature of varchar binary? In my opinion, binary data shouldn't be trimmed! Please answer me via mail as I don't receive the mailing list. Thanks for your support! ... tobias wiersch - 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: Re[2]: MySQL FullText improvements in V4.0
What kind of speed can you expect to get from this after tbl_doc_index fills up with tens of millions of rows? Is this scheme suitable for that magnitude of data? Also, if you wish to generate a query that generates all documents that contain token x or token y, would mysql neglect to use the keys? I remember reading that field1=x OR field2=x wont use the index because a general way of optimizing that query hasnt been found. Correct me if im wrong. AND queries on the other hand should work well. thanks, ryan You can do this yourself, pretty easily by building an index in advance. I've been using the following technique to implement full text searching since before it existed in MySQL in any form. Tokenize each unique word in a document and store the word count in tables: tbl_tokens: token_id int token varchar tbl_doc_index: token_id int doc_id int word_count int Populate the tables from your document database either what documents are saved or in some other offline process. When someone searches on words, first convert to tokens using the first table and look up in the 2nd table using whatever search/join technique works best in your situation. Jamie At Monday, May 14, 2001 on 2:18:38 PM, you wrote: I too am curious! I think one feature that I'd really like to see is the ability to tell the number of times a string appears inside another string. This would help a lot when trying to do search results weighting. -Chris - 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: Varchar binary field auto-trimmed??
Varchar fields are not binary, blobs are. ryan Hi Help! I would like to store some short binary data (encrypted). I used a varchar(24) binary field for this. But it seems that MySQL cuts white-spaces from the end when storing the data in the table. When the encrypted string now has a white-space at end, MySQL will cut it and this will result in a wrong decryption (next time when the string is read and decrypted). When using TinyBlob instead of varchar binary, all works fine. Is this a feature of varchar binary? In my opinion, binary data shouldn't be trimmed! Please answer me via mail as I don't receive the mailing list. Thanks for your support! ... tobias wiersch - 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
configure error cross compiling
Description: Trying to compile mysql source on a Intel-Compaq running Solaris 8. Get the following error: checking return type of sprintf... configure: error: can not run test program while cross compiling config.log says: configure:2369: checking return type of sprintf How-To-Repeat: code/input/activities to reproduce the problem (multiple lines) CC=gcc CFLAGS=-O3 CXX=gcc CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno-rtti ./configure --prefix=/usr/local/mysql --with-low-memory --enable-assembler Fix: how to correct or work around the problem, if known (multiple lines) Submitter-Id: submitter ID Originator:Super-User Organization: organization of PR author (multiple lines) MySQL support: [none | licence | email support | extended email support ] Synopsis: synopsis of the problem (one line) Severity: [ non-critical | serious | critical ] (one line) Priority: [ low | medium | high ] (one line) Category: mysql Class: [ sw-bug | doc-bug | change-request | support ] (one line) Release: mysql-3.23.37 (Source distribution) Environment: machine, os, target, libraries (multiple lines) System: SunOS shams 5.8 Generic_108529-03 i86pc i386 i86pc Architecture: i86pc Some paths: /usr/bin/perl /usr/local/bin/make /usr/local/bin/gcc /usr/ucb/cc GCC: Reading specs from /usr/local/lib/gcc-lib/i386-pc-solaris2.8/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS='' LIBC: -rw-r--r-- 1 root bin 1574456 Jul 20 2000 /lib/libc.a lrwxrwxrwx 1 root root 11 Nov 22 14:52 /lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 933380 Jul 20 2000 /lib/libc.so.1 -rw-r--r-- 1 root bin 1574456 Jul 20 2000 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Nov 22 14:52 /usr/lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 933380 Jul 20 2000 /usr/lib/libc.so.1 Configure command: ./configure --with-unix-socket-path=/var/tmp/mysql.sock --with-low-memory --with-mit-threads=yes --without-perl --enable-thread-safe-client --with-berkeley-db --with-innodb Perl: This is perl, version 5.005_03 built for i86pc-solaris - 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
Run Mysql command from a file.
Hi all. I'm new in this list, so may be this questions has already done here. I need to update my database daily at midnight. I want some file from which I can connect to mysql, switch to some database and work into tables (basically with delete and load commands). How can I do this? I had a look to Using mysql in batch mode and How to run SQL commands from a text file but they wasn't clear for me. Does anybody can share with me old experience or a real example about this case? Thanks in advance. Aires Trindade. - 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 report
Oops, I read the file size wrong in the printout. It was only 300 MB. Then we can suspect that you ran out of disk space. But knowing the MySQL version would help. Regards, Heikki ... Eugene, does your operating system support over 2 GB files? Which MySQL version you are running? What is the opeerating system? I guess the problem is that the OS does not support over 2 GB files. You should create smaller data files. I will add to os0file.c a more informative error message than an assertion failure :). Regards, Heikki http://www.innobase.fi InnoDB: The first specified data file /space/work1/karpov/data/ibdata1 did not exist:InnoDB: a new database to be created! InnoDB: Setting file /space/work1/karpov/data/ibdata1 size to 26214400 InnoDB: Database physically writes the file full: wait... InnoDB: Data file /space/work1/karpov/data/ibdata2 did not exist: new to be createdInnoDB: Setting file /space/work1/karpov/data/ibdata2 size to 38797312 InnoDB: Database physically writes the file full: wait... InnoDB: Data file /space/work1/karpov/data/ibdata3 did not exist: new to be created InnoDB: Setting file /space/work1/karpov/data/ibdata3 size to 104857600 InnoDB: Database physically writes the file full: wait... InnoDB: Data file /space/work1/karpov/data/ibdata4 did not exist: new to be created InnoDB: Setting file /space/work1/karpov/data/ibdata4 size to 314572800 InnoDB: Database physically writes the file full: wait... Innobase: Assertion failure in thread 1 in file os0file.c line 205 Innobase: we intentionally generate a memory trap. Innobase: Send a bug report to [EMAIL PROTECTED] mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a readable backtrace that may help in finding out why mysqld died. B.R. Eugene - 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 report
Max file size is 300M, not 2G. Isn't it? B.R. Eugene On Tue, 15 May 2001, Heikki Tuuri wrote: Eugene, does your operating system support over 2 GB files? Which MySQL version you are running? What is the opeerating system? I guess the problem is that the OS does not support over 2 GB files. You should create smaller data files. I will add to os0file.c a more informative error message than an assertion failure :). Regards, Heikki http://www.innobase.fi InnoDB: The first specified data file /space/work1/karpov/data/ibdata1 did not exist:InnoDB: a new database to be created! InnoDB: Setting file /space/work1/karpov/data/ibdata1 size to 26214400 InnoDB: Database physically writes the file full: wait... InnoDB: Data file /space/work1/karpov/data/ibdata2 did not exist: new to be createdInnoDB: Setting file /space/work1/karpov/data/ibdata2 size to 38797312 InnoDB: Database physically writes the file full: wait... InnoDB: Data file /space/work1/karpov/data/ibdata3 did not exist: new to be created InnoDB: Setting file /space/work1/karpov/data/ibdata3 size to 104857600 InnoDB: Database physically writes the file full: wait... InnoDB: Data file /space/work1/karpov/data/ibdata4 did not exist: new to be created InnoDB: Setting file /space/work1/karpov/data/ibdata4 size to 314572800 InnoDB: Database physically writes the file full: wait... Innobase: Assertion failure in thread 1 in file os0file.c line 205 Innobase: we intentionally generate a memory trap. Innobase: Send a bug report to [EMAIL PROTECTED] mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a readable backtrace that may help in finding out why mysqld died. B.R. Eugene B.R. Eugene - 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
problem stopping mysqld
Hello, i'm running mysqld on darwin (mac os x client)...Start is good, but then i can't stop the server...i tried ./mysqladmin shutdown, ./mysqladmin -u root shutdown, but it doesn't work..any one can help??? mysql 3.23.37 Thank you, EISSEN Chalrie - 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
Starting up mysqld at boot time as NOT root
Hello, This is more like a UNIX question: In our LINUX box startup file, we have an entry to start mysql. However, when the machine boots, mysql starts as root. How do we make it to start as mysqladm (the user we setup for mysql) Any help is much appreciated. Christopher Lambrou, CGL Computer Services, Inc. Empire State Building, PMB 16J Suite 3304 New York, NY 10118 Tel: (212) 971-9723 Fax: (212) 564-1135 URL: http://www.cglcomputer.com Email: [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
Re: Bug report
mysql Ver 11.15 Distrib 3.23.37, for sun-solaris2.7 (sparc) SunOS 5.7 Generic_106541-02 sun4u sparc SUNW,Ultra-5_10 On Tue, 15 May 2001, Heikki Tuuri wrote: Hi! Ok, the error turned out to be out of disk space. But for some reason the error handling code in os0file.c did not recognize the error number given by the operating system, it tests for ENOSPC. I will change the error handling code so that it prints the operating system error message number and does not assert. It still would be very helpful if you told the operating system and MySQL versions. Regards, Heikki http://www.innobase.fi At 06:00 PM 5/15/01 +0400, you wrote: Max file size is 300M, not 2G. Isn't it? B.R. Eugene On Tue, 15 May 2001, Heikki Tuuri wrote: Eugene, does your operating system support over 2 GB files? Which MySQL version you are running? What is the opeerating system? I guess the problem is that the OS does not support over 2 GB files. You should create smaller data files. I will add to os0file.c a more informative error message than an assertion failure :). Regards, Heikki http://www.innobase.fi InnoDB: The first specified data file /space/work1/karpov/data/ibdata1 did not exist:InnoDB: a new database to be created! InnoDB: Setting file /space/work1/karpov/data/ibdata1 size to 26214400 InnoDB: Database physically writes the file full: wait... InnoDB: Data file /space/work1/karpov/data/ibdata2 did not exist: new to be createdInnoDB: Setting file /space/work1/karpov/data/ibdata2 size to 38797312 InnoDB: Database physically writes the file full: wait... InnoDB: Data file /space/work1/karpov/data/ibdata3 did not exist: new to be created InnoDB: Setting file /space/work1/karpov/data/ibdata3 size to 104857600 InnoDB: Database physically writes the file full: wait... InnoDB: Data file /space/work1/karpov/data/ibdata4 did not exist: new to be created InnoDB: Setting file /space/work1/karpov/data/ibdata4 size to 314572800 InnoDB: Database physically writes the file full: wait... Innobase: Assertion failure in thread 1 in file os0file.c line 205 Innobase: we intentionally generate a memory trap. Innobase: Send a bug report to [EMAIL PROTECTED] mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a readable backtrace that may help in finding out why mysqld died. B.R. Eugene B.R. Eugene B.R. Eugene - 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: upgrade from SUSE7.0
Andy Woo wrote: I have the same problem. Whatsssup? :-) /usr/bin/mysqladmin: connect to server at 'breguet' failed error: 'Host 'breguet.experia.com' is not allowed to connect to this MySQL server' what can I do to solve this ?... I don't know i removed the things, and tried to install the 3.23.38 release instead, my the problem is not solved I've tried every thing to get connected, but nothing went right I could do a mysqladmin version, and the answer was correct, but no connection... So, I re-install the whole box (it's a test box...) in order to see if i was wrong somewhere, and where i could have messed things up but I'm curious to find an answer... Stephane - 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: Starting up mysqld at boot time as NOT root
On Tue, May 15, 2001 at 10:24:38AM -0400, Chris Lambrou [CGL] wrote: Hello, This is more like a UNIX question: In our LINUX box startup file, we have an entry to start mysql. However, when the machine boots, mysql starts as root. How do we make it to start as mysqladm (the user we setup for mysql) Any help is much appreciated. Look at the startup script, see where it invokes the safe_mysqld script or mysqld itself, see what flags/options it invokes that with, and find a way to add -u mysqladm to the command line. G'luck, Peter -- If you think this sentence is confusing, then change one pig. - 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: Microsoft Access and Mysql
Chris Wilkinson wrote: I am attempting to upload an Access db to a remote mysql server - at dsvr in the UK. I get connected (I think) but receive the following error message: Microsoft Access ODBC - call failed [Microsoft][ODBC Driver Manager #0] Can you point me in the right direction for this or offer some help. Thanks CHRIS -- Chris Wilkinson You need to explain better what you are doing. You cannot upload an Access DB to a MySQL server. You can upload and insert the data, you can write some program to make calls to both DBs and insert the data but you can't just upload the database? And where are you getting the error from, that error is from Access not mysql? - 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
Problem with MySQl and ADO 2.6
My name is Martin Leduc from Solution Globale, Chicoutimi. We are interested by a MySQL Solution, but we have a big problem and we dont know how to solve this one. We use MyODBC 2.50.37 and MySQL 3.23.36 to 38 (bug fixed) and we have anytime the same trouble. Null value with NOT NULL TEXT fields. This is our Test Example: We use de DB Test: CREATE TABLE t_testnull ( ID tinyint(4) NOT NULL auto_increment, TestTEXTNotNULL text NOT NULL , TestTEXTNull text, PRIMARY KEY (ID) ); We use Visual Basic 6.0 with SP 5, and our code is: Private WithEvents con_Test As ADODB.Connection Private WithEvents rs_Test As ADODB.Recordset Private Sub Form_Load() Set con_Test = New ADODB.Connection Set rs_Test = New ADODB.Recordset str_ConnectionString = DRIVER={MySQL} _ ;DB=test _ ;SERVER=localhost _ ;UID=root _ ;PWD= _ ;PORT=3306 _ ;OPTION=131072;STMT=; con_Test.ConnectionString = str_ConnectionString con_Test.Open rs_Test.Open INSERT INTO t_TestNull (testTEXTNotNULL,TestTEXTNull) VALUES ('','');, con_Test rs_Test.Open SELECT * FROM T_TestNULL, con_Test Do Until rs_Test.EOF = True Debug.Print rs_Test.Fields(1).Value; rs_Test.Fields(2).Value rs_Test.MoveNext Loop End Sub and this code give me always NULL from MySQL database. I tried many options of MyODBC but these didn't work. We have tried with the Addnew Method but it gave the same results. On your FAQ Site, you tel to use the Recordset.Cursorlocation = adUseClient, but this action return me a E-FAIL Status and when I tried to use the MoveLast method ADO tell me that Rowset does not support fetching backward. Our Server is Windows 2000 Server with AMD K62-380 CPU, 97Mo RAM. We have tried with a PIII 600 with 380 MoRAM with Windows 98, and the same things is happening. Did someone can tell me what happend because this NULL value is a nightmare. We are not familiar with this technologie and we want to change for MySQL but we have to find this problem fastly. Do you know how to link libMYSQL.dll like a Windows DLL in VB? DECLARE FUNCTION mysql_init FROM. and the kind of TYPE we had to declare. The NULL Value is the most important think to solve. -- Martin Leduc Project Manager, Solution Globale Chicoutimi, Québec Canada (418) 545-0005 [EMAIL PROTECTED]
RE: upgrade from SUSE7.0
Anyway, I'm running SuSE 7.1 and here is my error messages:- jedi:/usr/bin # safe_mysqld Starting mysqld daemon with databases from /var/lib/mysql 010516 06:05:54 mysqld ended I checked my log, it said 010516 06:05:54 mysqld started 010516 6:05:54 /usr/sbin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 010516 06:05:54 mysqld ended But actually, host.frm is in my /var/lib/mysql/mysql. Whatsssup... Best Regards, Andy -Original Message- From: stephane parenton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 10:43 PM To: Andy Woo Cc: 'mysql' Subject: Re: upgrade from SUSE7.0 Andy Woo wrote: I have the same problem. Whatsssup? :-) /usr/bin/mysqladmin: connect to server at 'breguet' failed error: 'Host 'breguet.experia.com' is not allowed to connect to this MySQL server' what can I do to solve this ?... I don't know i removed the things, and tried to install the 3.23.38 release instead, my the problem is not solved I've tried every thing to get connected, but nothing went right I could do a mysqladmin version, and the answer was correct, but no connection... So, I re-install the whole box (it's a test box...) in order to see if i was wrong somewhere, and where i could have messed things up but I'm curious to find an answer... Stephane - 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: upgrade from SUSE7.0
I'm not for sure but when you create a user you can allow that user to only connect from specific locations. Such as localhost or from anywhere or even a specfied locationm 123.222.111.2. Not sure if this will help at all?? Good Luck. -Original Message- From: stephane parenton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 9:43 AM To: Andy Woo Cc: 'mysql' Subject: Re: upgrade from SUSE7.0 Andy Woo wrote: I have the same problem. Whatsssup? :-) /usr/bin/mysqladmin: connect to server at 'breguet' failed error: 'Host 'breguet.experia.com' is not allowed to connect to this MySQL server' what can I do to solve this ?... I don't know i removed the things, and tried to install the 3.23.38 release instead, my the problem is not solved I've tried every thing to get connected, but nothing went right I could do a mysqladmin version, and the answer was correct, but no connection... So, I re-install the whole box (it's a test box...) in order to see if i was wrong somewhere, and where i could have messed things up but I'm curious to find an answer... Stephane - 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:InnoDB tablespace tools
Steve, I cannot promise any such tools in the next 6 months. My TODO list has the two important items currently: support for arbitrary size BLOBs and CHECK TABLE. The right way to proceed now is to test existing tools and their speed. Could you measure the speed of the following options in dumping and importing a table: 1) a) SELECT INTO outfile; b) LOAD DATA INFILE ... 2) a) ALTER TABLE yourtable TYPE = MYISAM; b) then copy the MyISAM .frm, data, and index files to another database; c) in the other database ALTER TABLE yourtable TYPE = INNODB 3) a) create a MyISAM table yourplaintable with the same columns but no indexes; b) INSERT INTO yourplaintable SELECT * FROM yourtable; c) copy the MyISAM data and .frm files to another tablespace; d) in the other database create yourtable with the indexes defined; e) INSERT INTO yourtable SELECT * FROM yourplaintable. I can update the InnoDB manual if one of these methods is much faster than the ordinary mysqldump and then mysql ... . When the mysql client is used in importing a table, I guess much of the CPU goes to client server communication. Above methods might be much faster as long as they are not disk bound. Now I recall the following solution if you find it cumbersome to add set autocommit = 0; ...; commit to your table dump files: before you start MySQL, set innodb_flush_log_at_trx_commit=0 in my.cnf. Then the commits will not take extra time. Regards, Heikki http://www.innobase.fi Is there a plan to have any tablespace management tools for innobase? I personaly dont' care if these are via a separate program or through the mysql SQL interface but the following would be very handy. move tables between tablespaces list tables in a tablespace shrink tablespace It is very handy with BDB and MyISAM tables to be able to back them up directly or move them across different machines. If I have a large database server with gigs of InnoDB tablespace and we need to move a single database or table to another server it would require mysqldump and reloading the tables, which can be very slow for large tables. This seems to be the main disadvantage of the table space method. It would be nice if one could move a binary table with the following steps. - shutdown the server - copy a table into a new tablespace by itself - move the portable table space to the new server - expand the tablespace for growing room or copy the table to an existing tablespace I realize these are major things, I'm just curious if there are plans for any of the above sort of tools. - 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
New user InnoDB comments
Just installed MaxSQL 3.23.38 on a test system to check out InnoDB. Here are my observations: 1) Manual is not clear on permissions of directories - They should be mysql.root owned. The error in the error log just says cannot create file. This could be one of many things! I had to use my initiative, but newbie user will never pick this up. 2) The error logs format is not consistent across InnoDB and normal Mysql: 010514 17:11:32 mysqld started InnoDB: Error in creating or opening /data/ibdata/ibdata1 InnoDB: Could not open data files 010514 17:11:33 Can't init databases 010514 17:11:33 mysqld ended This makes it almost impossible to do something useful (like parse) the log file. 3) Initial data file creation is VERY slow. I am still waiting after 15 minutes for the first file to complete - It is only 606megs now. I have two files. What happens if you run out of table space and quickly need to create more extents? Shutting down the database does not sound like a good option in a mission critical 24/7 environment. This is on a linux Redhat 6.2 (latest patches) box with Raid 5 disks on an IBM Serveraid controller. 4) Ok, datafiles created overnight. Now trying alter table ... type=innodb on a file with 1.2mil records. Still waiting after about 12 hours. Dumping files this size is going to be problematic. Machine pegs with load of around 12! I suggest LOTS more testing on BIG tables. Small stuff normally works quite well, but HUGE tables is where it counts. Thanks for the help. PS: I am willing to test stuff on my development machine. -- Richard Ellerbrock [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
Re: problem stopping mysqld
This is a known bug when running MySQL on Darwin / Mac OS X right now. Last I heard some listy was submitting a diff or a patch to the maintainers, but I haven't heard anything about it for a little while. Any news, folks? Works a treat on Darwin, otherwise. Zach On Tuesday, May 15, 2001, at 10:24 AM, EISSEN Charlie wrote: Hello, i'm running mysqld on darwin (mac os x client)...Start is good, but then i can't stop the server...i tried ./mysqladmin shutdown, ./mysqladmin -u root shutdown, but it doesn't work..any one can help??? mysql 3.23.37 Thank you, EISSEN Chalrie - 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 mysql-unsubscribe- [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: EXCEPT statement in MYSQL?
On Tue, May 15, 2001 at 04:45:22PM +0200, Viktor van den Berg wrote: Hi, I am new to this list, so maybe this question is asked before. I like to know how to use the except statement in MYSQL. EXCEPT is (almost?) the same as an exlusive or (XOR): select userid from user1 except select userid from user2 The result is a data set containing userid's that are only availlable in user1 or in user2. If the userid is availlable in user1 AND user2, then it won't be availlable in the result. The question is what syntax to use in MYSQL to achieve this result! One of the possible ways would be SELECT u1.userid FROM user1 u1 LEFT JOIN user2 u2 ON u2.userid=u1.userid WHERE u2.userid IS NULL; G'luck, Peter -- This inert sentence is my body, but my soul is alive, dancing in the sparks of your brain. - 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: InnoDB and concurrent operations
Steve, your observations suggest that it is MySQL which is holding some semaphore while it is aborting a connection (which in your case required a big rollback). The operating system seems to be innocent. On Windows NT I have seen that disk operations will freeze the computer almost totally. Linux is better I think. I do not see this as a big problem, if the unresponsiveness is only when MySQL aborts a connection. Especially, Monty's TODO list is overflowing, and better not add yet another item there. Your buffer pool of 20 MB is small. When the tables grow your operation can become disk bound and really slow down. During big table imports you might want to allocate a much bigger buffer pool. Regards, Heikki At 05:09 PM 5/14/01 -0600, you wrote: Heikki Tuuri wrote: Steve, on what operating system you are running? linux, intel 2.2.12 Was the rollback (and the table load) disk bound? Did you configure much memory to the InnoDB buffer pool? I would say the rollback was processor bound, the machine was running with almost no CPU idletime and this event was about the only thing taking place. the machine as 192 megs ram and buffer pool=20M Was MySQL responsive during the table loading? Yes, very responsive for other MyISAM tables, select count(*) from the table I was loading was taking about 4 minutes each, but simple select queries looking for data that had not been commited were much faster. Is MySQL responsive if you do a big rollback without cancelling (ctrl-c) the client process? If the file ends in ROLLBACK; then it works fine, it rolls back and mysql is reponsive through the whole process. If the file ends with an insert and there is never a commit or rollback then mysql is unresponsive even if the load is not cancelled (ctrl-c). I will have to test further but it seems that if I do only 100,000 rows and then the file terminates, then it is okay but for 200,000 rows it can take 20 minutes or more to clean up while mysql is unresponsive. The unresponsiveness may be because MySQL reserves some semaphore while it is aborting the client connection. Or it may be due to the operating system which lets other threads starve. I'm not familiar with OS level thread control in the process itself, but the machine (other than mysql) was very responsive.. Unlike when I try to start mysql with a 1 gig table space to be built, then the load goes up to about 15 and the machine is very slow to respond (obviously). The above questions help track the reason for the unresponsiveness. If the problem is the operating system, I could try adding some calls to pthread_yield inside the InnoDB code and that might help. When InnoDB writes the 1 GB data file full, then MySQL is unresponsive because it does the initialization of the database with just one thread before creating other, listener threads. Regards, Heikki http://www.innobase.fi There seem to be some operations that cannot be performed on the server whie InnoDB is doing something. For example I inserted about 200,000 rows in to a table from a file (mysql database file) the file starts with begin; and contains many inserts, I cancelled (ctrl-c) in the middle of the operation which caused InnoDB to rollback (as expected) but the mysql database whas unresponsive for about 10 minutes while innoDB did the rollback. The server would not respond to any processlist requests, connections or anything. This is not so good for the increased read/write concurrency expected from innodb. Also.. If a new table space has been added, it can take a while for innoDB to format 1Gig of tablespace (a long while on a 400mhz pentium). Is there a reason why the whole mysql database must be unresponsive durring this time? Why can't the system only lock out InnoDB format tables if need be and allow MySQL to startup and respond to questions. - 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: Re[2]: MySQL FullText improvements in V4.0
Excuse me but what do you mean by FullText ? Is this a full-text search engine in MySQL ??? -Original Message- From: ryc [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 3:29 PM To: James Treworgy; Chris Nichols Cc: [EMAIL PROTECTED] Subject: Re: Re[2]: MySQL FullText improvements in V4.0 What kind of speed can you expect to get from this after tbl_doc_index fills up with tens of millions of rows? Is this scheme suitable for that magnitude of data? Also, if you wish to generate a query that generates all documents that contain token x or token y, would mysql neglect to use the keys? I remember reading that field1=x OR field2=x wont use the index because a general way of optimizing that query hasnt been found. Correct me if im wrong. AND queries on the other hand should work well. thanks, ryan You can do this yourself, pretty easily by building an index in advance. I've been using the following technique to implement full text searching since before it existed in MySQL in any form. Tokenize each unique word in a document and store the word count in tables: tbl_tokens: token_id int token varchar tbl_doc_index: token_id int doc_id int word_count int Populate the tables from your document database either what documents are saved or in some other offline process. When someone searches on words, first convert to tokens using the first table and look up in the 2nd table using whatever search/join technique works best in your situation. Jamie At Monday, May 14, 2001 on 2:18:38 PM, you wrote: I too am curious! I think one feature that I'd really like to see is the ability to tell the number of times a string appears inside another string. This would help a lot when trying to do search results weighting. -Chris - 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: New user InnoDB comments
Richard, thank you for the observations. Some comments: Just installed MaxSQL 3.23.38 on a test system to check out InnoDB. Here are my observations: 1) Manual is not clear on permissions of directories - They should be mysql.root owned. The error in the error log just says cannot create file. This could be one of many things! I had to use my initiative, but newbie user will never pick this up. Ok, I promised in a posting an hour ago that InnoDB will print the OS error number in future. I will also update the manual. 2) The error logs format is not consistent across InnoDB and normal Mysql: 010514 17:11:32 mysqld started InnoDB: Error in creating or opening /data/ibdata/ibdata1 InnoDB: Could not open data files010514 17:11:33 Can't init databases 010514 17:11:33 mysqld ended This makes it almost impossible to do something useful (like parse) the log file. Many people wish that it would print the time before the error message. It is on the TODO list :). 3) Initial data file creation is VERY slow. I am still waiting after 15 minutes for the first file to complete - It is only 606megs now. I have two files. What happens if you run out of table space and quickly need to create more extents? Shutting down the database does not sound like a good option in a mission critical 24/7 environment. This is on a linux Redhat 6.2 (latest patches) box with Raid 5 disks on an IBM Serveraid controller. I am just running on our Linux Xeon, and the the initial writing to a file proceeds only 1 MB/second. It seems to have slowed down a lot when I added the fsync to all file writes in .38. It writes 1 MB chunks to the file at a time, and there is no reason why it should be so slow. I guess that the problem is in Linux. I have to do so that in the initial writing fsync is not used, but the file is closed, and opened again. Or we could try writing smaller chunks than 1 MB. Maybe we should contact Linux developers. fsync should not cause these kinds of problems. 4) Ok, datafiles created overnight. Now trying alter table ... type=innodb on a file with 1.2mil records. Still waiting after about 12 hours. Dumping files this size is going to be problematic. Machine pegs with load of around 12! I suggest LOTS more testing on BIG tables. Small stuff normally works quite well, but HUGE tables is where it counts.Thanks for the help. It sounds like that the operation is disk bound. What is the CPU and disk load? How big is the table in MBs? What kind of indexes you have? How much buffer pool you have configured in my.cnf? PS: I am willing to test stuff on my development machine. Good :). Best regards, Heikki http://www.innobase.fi - 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: InnoDB and concurrent operations
Steve, At 09:48 AM 5/15/01 -0600, you wrote: Heikki Tuuri wrote: Steve, your observations suggest that it is MySQL which is holding some semaphore while it is aborting a connection (which in your case required a big rollback). The operating system seems to be innocent. If the large data file simply dones't end in COMMIT; then mysql should not abort the connection it closes gracefully no? Then rollback should be run after timeout? If the thread doesn't exit with (ctrl-c) should the ROLLBACK; be graceful? ending a connection without a commit or a rollback from the user is really abnormal termination. The user should decide whether his work is committed or rolled back. Now the default is that if autocommit=0 and the user end the connection his work is rolled back. But that is not what the user normally wants. Regards, Heikki On Windows NT I have seen that disk operations will freeze the computer almost totally. Linux is better I think. I do not see this as a big problem, if the unresponsiveness is only when MySQL aborts a connection. Especially, Monty's TODO list is overflowing, and better not add yet another item there. Your buffer pool of 20 MB is small. When the tables grow your operation can become disk bound and really slow down. During big table imports you might want to allocate a much bigger buffer pool. Regards, Heikki At 05:09 PM 5/14/01 -0600, you wrote: Heikki Tuuri wrote: Steve, on what operating system you are running? linux, intel 2.2.12 Was the rollback (and the table load) disk bound? Did you configure much memory to the InnoDB buffer pool? I would say the rollback was processor bound, the machine was running with almost no CPU idletime and this event was about the only thing taking place. the machine as 192 megs ram and buffer pool=20M Was MySQL responsive during the table loading? Yes, very responsive for other MyISAM tables, select count(*) from the table I was loading was taking about 4 minutes each, but simple select queries looking for data that had not been commited were much faster. Is MySQL responsive if you do a big rollback without cancelling (ctrl-c) the client process? If the file ends in ROLLBACK; then it works fine, it rolls back and mysql is reponsive through the whole process. If the file ends with an insert and there is never a commit or rollback then mysql is unresponsive even if the load is not cancelled (ctrl-c). I will have to test further but it seems that if I do only 100,000 rows and then the file terminates, then it is okay but for 200,000 rows it can take 20 minutes or more to clean up while mysql is unresponsive. The unresponsiveness may be because MySQL reserves some semaphore while it is aborting the client connection. Or it may be due to the operating system which lets other threads starve. I'm not familiar with OS level thread control in the process itself, but the machine (other than mysql) was very responsive.. Unlike when I try to start mysql with a 1 gig table space to be built, then the load goes up to about 15 and the machine is very slow to respond (obviously). The above questions help track the reason for the unresponsiveness. If the problem is the operating system, I could try adding some calls to pthread_yield inside the InnoDB code and that might help. When InnoDB writes the 1 GB data file full, then MySQL is unresponsive because it does the initialization of the database with just one thread before creating other, listener threads. Regards, Heikki http://www.innobase.fi There seem to be some operations that cannot be performed on the server whie InnoDB is doing something. For example I inserted about 200,000 rows in to a table from a file (mysql database file) the file starts with begin; and contains many inserts, I cancelled (ctrl-c) in the middle of the operation which caused InnoDB to rollback (as expected) but the mysql database whas unresponsive for about 10 minutes while innoDB did the rollback. The server would not respond to any processlist requests, connections or anything. This is not so good for the increased read/write concurrency expected from innodb. Also.. If a new table space has been added, it can take a while for innoDB to format 1Gig of tablespace (a long while on a 400mhz pentium). Is there a reason why the whole mysql database must be unresponsive durring this time? Why can't the system only lock out InnoDB format tables if need be and allow MySQL to startup and respond to questions. - 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:
Re: problem stopping mysqld
Well, if you really just want it stopped, the usual unix rule is to ps -ax | grep mysql, read the PIDs then kill -11 [PID] kill the safe_mysqld script first or it will restart the mysql daemon. EISSEN Charlie wrote: Hello, i'm running mysqld on darwin (mac os x client)...Start is good, but then i can't stop the server...i tried ./mysqladmin shutdown, ./mysqladmin -u root shutdown, but it doesn't work..any one can help??? mysql 3.23.37 Thank you, EISSEN Chalrie - 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: Microsoft Access and Mysql
Steve Thanks for replying. I have an Access 2000 database called webugnet and I am attempting to Export it. I have installed MyODBC and configured a mysql connection to the sql server on DSVR. So, in the table window right click on the database and select Export This brings up an Export table to: window In Save As select ODBC and this brings up a window Export webugnet to webugnet in ODBC database. Click OK and this brings up a window Select Data Source and on this select Machine Data Source Select the mysql connection with the correct database and click OK Then up comes the error. I previously got a wrong user name and password error but solved that one by correct configuration. Hope you can follow what I am doing or doing wrong from this. CHRIS In message [EMAIL PROTECTED], Steve Ruby [EMAIL PROTECTED] writes Chris Wilkinson wrote: I am attempting to upload an Access db to a remote mysql server - at dsvr in the UK. I get connected (I think) but receive the following error message: Microsoft Access ODBC - call failed [Microsoft][ODBC Driver Manager #0] Can you point me in the right direction for this or offer some help. Thanks CHRIS -- Chris Wilkinson You need to explain better what you are doing. You cannot upload an Access DB to a MySQL server. You can upload and insert the data, you can write some program to make calls to both DBs and insert the data but you can't just upload the database? And where are you getting the error from, that error is from Access not mysql? -- Chris Wilkinson - 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: Microsoft Access and Mysql
On the mysql.com website under downloads: contributed there is a chunk of VBA code you can put in an access database to make it export to a SQL text file, use that, you are better off, otherwise export from Access to text (comma separated for example) and use LOAD DATA in mysql to load the file. Chris Wilkinson wrote: Steve Thanks for replying. I have an Access 2000 database called webugnet and I am attempting to Export it. I have installed MyODBC and configured a mysql connection to the sql server on DSVR. So, in the table window right click on the database and select Export This brings up an Export table to: window In Save As select ODBC and this brings up a window Export webugnet to webugnet in ODBC database. Click OK and this brings up a window Select Data Source and on this select Machine Data Source Select the mysql connection with the correct database and click OK Then up comes the error. I previously got a wrong user name and password error but solved that one by correct configuration. Hope you can follow what I am doing or doing wrong from this. CHRIS In message [EMAIL PROTECTED], Steve Ruby [EMAIL PROTECTED] writes Chris Wilkinson wrote: I am attempting to upload an Access db to a remote mysql server - at dsvr in the UK. I get connected (I think) but receive the following error message: Microsoft Access ODBC - call failed [Microsoft][ODBC Driver Manager #0] Can you point me in the right direction for this or offer some help. Thanks CHRIS -- Chris Wilkinson You need to explain better what you are doing. You cannot upload an Access DB to a MySQL server. You can upload and insert the data, you can write some program to make calls to both DBs and insert the data but you can't just upload the database? And where are you getting the error from, that error is from Access not mysql? -- Chris Wilkinson - 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 for user root
After installing mysql, when i try to connect the server reply access denied for root@localhost How is it possible? I set the password for user root, and all seems to be right ++ SIMONE LUCARELLI | _ | agenzia giornalistica ||___ ___| | TUTTOCALCIO | / / | editrice TuttoPress | / / /--\| tel. 0572.75204 r.a. | /_ / \__/|fax 0572.766622 ++ [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
Re: Which MySQL to install
It looks like they're running Sun Solaris version 2.6 (SunOS 5.6) on an Intel-based system (as apposed to a SPARC based Sun server). The MySQL site only shows binaries available for the SPARC version of Solaris, so you'll have to download and compile the 'source' distribution... - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, May 15, 2001 6:17 AM Subject: Which MySQL to install I've been using MySQL happily on Linux for the past few years; however now I have to develop a web application for a client who insists that I use his server. The server doesn't have MySQL installed, so I naturally want to install it. I'm actually quite lame when it comes to server stuff and I don't really even know which version I should install. When I run uname -a I get: SunOS j-sky 5.6 Generic_105182-21 i86pc i386 i86pc Could someone please advise me on which flavor of MySQL to download? Thanks in advance! - Anatole - 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
Making MySQL DB Remotely Accessible
I am new to the world of mySQL and have just installed it on a Windows 2000 Advanced Server and I need to figure out how make the db accessible from a remote PC for administration. Can anyone provide me with some direction in that area? Bear in mind, I am a newbie. Thanks very much, Ray
Re: MyODBC Access Denied Error
In message 1D9A6579106BD411BA9700A0C9A50975191A97@AFTERBURNER, Randy Davis [EMAIL PROTECTED] writes I was wondering if anybody would be able to help me with this. I've got a MySQL database set up on my Linux server. I want to be able to access it remotely, but all we get when we try to access is the following message: ODBC - call failed [MyODBC] Access denied for user: 'user@hostname' (Using password: YES) Background: user has been set up in the mysql user table, with host = % the database has been set up in the mysql host table with host = % Any clues or information would be extrememely appreciated! Thanks! Ciao Randy I think I have got past this one. It looks as though the password may not have been correctly set up. You should get a response message to say that a line has been entered. Also have you used mysqladmin reload -p to update the password entries. In ODBC the user name and password should be that for the mysql database and not for logon to the domain server. Hope that helps. CHRIS -- Chris Wilkinson - 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 4.0 FULLTEXT SPEED
Hi Everyone, I've compiled the mysql 4.0 version on my computer to test the speed of creating full text indexes. I read that it was supposed to be 100 x faster than 3.23. However, it seems just as slow to me. I've been building an index on my 400+MB table for 5 days now. Does anyone have any experience with 4.0 to know how the FULLTEXT indexing is working. Would you say that it's much faster than 3.23? P - 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
Just a small typo in Manual (at least PDF version)
4.12.18.1 Mac OS X Public beta MySQL should work without any probelms on Mac OS X public beta. (Darwin); You don't need the pthread patches for this os! typo: probelms _ Get Your Private, Free E-mail from MSN Hotmail at 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
problem updating recordset with MyODBC
When I try and update a recordset I get the following problem- Microsoft OLE DB Provider for ODBC Drivers error '80004005' Query based update failed. The row to update could not be found. /Part1_Section1_Process.asp, line 82 Line 82 happens to be when I call rs.Update() The problem only occurs when I update certain records. Other records have no problems. Before I had no problems (all records were fine updating). Then I migrated my tables from Win2000 mySQL to a mySQL running on Linux. That is when I noticed that it would not update in some cases. It isn't clear why some records give me problems and others do not. What makes it frustrating is that there seems to be no obvious cause of problem. The code has not been altered one bit. If I move back to Win2000 I'm sure it will work again. But I really want this to work consistently for our Linux DB server. Has anybody seen anything like this before. Can anybody help? David -- David Green Northwestern University, Evanston, IL USA [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
Re: MySQL 3.23.38 released
On 15 May 2001 13:21:12 +0300, Sinisa Milivojevic wrote: The reason why you are having problems in building from source is that you are most probably using gcc 2.96, which is simply broken. Will you accept further patches to the spec file that will try to autodetect the compiler and make use of a better one if available? Of course, provided that the autodetection puts safety above everything else, so it will NOT screw up the compilation on other platforms. ;-) I'm willing to take the time and figure out a solution (detect the buggy 2.96, see if 2.95 a.k.a. kgcc is available, and use the latter instead) -- Florin Andrei database, we have a problem - 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 number for selected set?
Hello All, is there any kind of row number pseudo-column that identifies a particular row's position in the query's result set? Something like RowNum in oracle. Thanks! -- john -- === John Cartwright Professional Research Assistant / Associate Scientist CIRES, SEG/NGDC/NOAA (303) 497-6284 [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
RE: Making MySQL DB Remotely Accessible
Try this program. Go to http://www.artronic.hr/mysql/index.htm and get mysqladmin. Its a windows client to manage mysql databases. You then can put in the ip address of the computer you want to connect to that is running a mysql database. So you would put your win2000 server ip. Then put in a user and a password. Leave the port at 3306 unless you changed it. Probably need to use root user to get in the first time. Hope this helps some. Robert -Original Message- From: Ray Pollard [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 11:42 AM To: '[EMAIL PROTECTED]' Subject: Making MySQL DB Remotely Accessible I am new to the world of mySQL and have just installed it on a Windows 2000 Advanced Server and I need to figure out how make the db accessible from a remote PC for administration. Can anyone provide me with some direction in that area? Bear in mind, I am a newbie. Thanks very much, Ray - 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 user InnoDB comments
Richard, I made some measurements with fsync. If I create first the big data file without O_SYNC and after that make a single fsync, I get a write speed of 5 MB/s, which is 5 times more than with O_SYNC. On the other hand, opening a log file in the O_SYNC mode makes commits much faster than by calling a separate fsync after each write. I will change the initial file writing so that it first opens the file without O_SYNC, the does the writes, calls fsync, closes the file, and then opens the file with O_SYNC. These are Linux-specific optimizations. There is no real reason why the OS should do writes faster with these tricks. I realize that Linux developers have not got enough feedback from database implementors. Regards, Heikki Richard, thank you for the observations. Some comments: Just installed MaxSQL 3.23.38 on a test system to check out InnoDB. Here are my observations: 1) Manual is not clear on permissions of directories - They should be mysql.root owned. The error in the error log just says cannot create file. This could be one of many things! I had to use my initiative, but newbie user will never pick this up. Ok, I promised in a posting an hour ago that InnoDB will print the OS error number in future. I will also update the manual. 2) The error logs format is not consistent across InnoDB and normal Mysql: 010514 17:11:32 mysqld started InnoDB: Error in creating or opening /data/ibdata/ibdata1 InnoDB: Could not open data files010514 17:11:33 Can't init databases 010514 17:11:33 mysqld ended This makes it almost impossible to do something useful (like parse) the log file. Many people wish that it would print the time before the error message. It is on the TODO list :). 3) Initial data file creation is VERY slow. I am still waiting after 15 minutes for the first file to complete - It is only 606megs now. I have two files. What happens if you run out of table space and quickly need to create more extents? Shutting down the database does not sound like a good option in a mission critical 24/7 environment. This is on a linux Redhat 6.2 (latest patches) box with Raid 5 disks on an IBM Serveraid controller. I am just running on our Linux Xeon, and the the initial writing to a file proceeds only 1 MB/second. It seems to have slowed down a lot when I added the fsync to all file writes in .38. It writes 1 MB chunks to the file at a time, and there is no reason why it should be so slow. I guess that the problem is in Linux. I have to do so that in the initial writing fsync is not used, but the file is closed, and opened again. Or we could try writing smaller chunks than 1 MB. Maybe we should contact Linux developers. fsync should not cause these kinds of problems. 4) Ok, datafiles created overnight. Now trying alter table ... type=innodb on a file with 1.2mil records. Still waiting after about 12 hours. Dumping files this size is going to be problematic. Machine pegs with load of around 12! I suggest LOTS more testing on BIG tables. Small stuff normally works quite well, but HUGE tables is where it counts.Thanks for the help. It sounds like that the operation is disk bound. What is the CPU and disk load? How big is the table in MBs? What kind of indexes you have? How much buffer pool you have configured in my.cnf? PS: I am willing to test stuff on my development machine. Good :). Best regards, Heikki http://www.innobase.fi - 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
Bad Magic Number binary log
When I run mysqlbinlog on my binary.log file (I specified that filename), under some situations I cannot read the file, I get Bad Magic Number error. /etc/my.cnf log-bin=/usr/local/mysql/data/binary.log Results: - On mysql 3.23.35 on Solaris 7 I have to run flush master from the mysql client to restart the binary log before mysqlbinlog can read it, if I don't run that and try to read the file I get the bad magic number. (ERROR: Bad magic number; The file is probably not a MySQL binary log) - On mysql 3.23.32 on Solaris 7 nothing works On all versions, if I don't specify the log-bin=filename and just do log-bin mysqlbinlog reads the auto created file fine! Any ideas on why this is happening? Bill Elvis Gibbs goEbusiness.com - putting e-motion in your business email - [EMAIL PROTECTED] work - 301-668-5090 cell - 301-748-6938 -Original Message- From: Chris Wilkinson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 12:53 PM To: Randy Davis Cc: '[EMAIL PROTECTED]' Subject: Re: MyODBC Access Denied Error In message 1D9A6579106BD411BA9700A0C9A50975191A97@AFTERBURNER, Randy Davis [EMAIL PROTECTED] writes I was wondering if anybody would be able to help me with this. I've got a MySQL database set up on my Linux server. I want to be able to access it remotely, but all we get when we try to access is the following message: ODBC - call failed [MyODBC] Access denied for user: 'user@hostname' (Using password: YES) Background: user has been set up in the mysql user table, with host = % the database has been set up in the mysql host table with host = % Any clues or information would be extrememely appreciated! Thanks! Ciao Randy I think I have got past this one. It looks as though the password may not have been correctly set up. You should get a response message to say that a line has been entered. Also have you used mysqladmin reload -p to update the password entries. In ODBC the user name and password should be that for the mysql database and not for logon to the domain server. Hope that helps. CHRIS -- Chris Wilkinson - 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: Run Mysql command from a file.
I'll maybe say something stupid, but if you have your files with your SQL commands, couldn't you use this command ? : mysql -u your_user -pyour_password /path/to/your/SQL/commands/file ? -Original Message- From: Aires Lima Trindade [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 3:54 PM To: Myql List Subject: Run Mysql command from a file. Hi all. I'm new in this list, so may be this questions has already done here. I need to update my database daily at midnight. I want some file from which I can connect to mysql, switch to some database and work into tables (basically with delete and load commands). How can I do this? I had a look to Using mysql in batch mode and How to run SQL commands from a text file but they wasn't clear for me. Does anybody can share with me old experience or a real example about this case? Thanks in advance. Aires Trindade. - 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 4.0 FULLTEXT SPEED
correct me if I'm mistaken, but I believe the latest version of mysql is 3.23.38 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, May 15, 2001 1:04 PM To: [EMAIL PROTECTED] Subject: MySQL 4.0 FULLTEXT SPEED Hi Everyone, I've compiled the mysql 4.0 version on my computer to test the speed of creating full text indexes. I read that it was supposed to be 100 x faster than 3.23. However, it seems just as slow to me. I've been building an index on my 400+MB table for 5 days now. Does anyone have any experience with 4.0 to know how the FULLTEXT indexing is working. Would you say that it's much faster than 3.23? P - 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: Varchar binary field auto-trimmed??
Hi, We can decalre a varchar field as BINARY if we need case sensitive storage of field values. Regards, Ravi --- ryc [EMAIL PROTECTED] wrote: Varchar fields are not binary, blobs are. ryan Hi Help! I would like to store some short binary data (encrypted). I used a varchar(24) binary field for this. But it seems that MySQL cuts white-spaces from the end when storing the data in the table. When the encrypted string now has a white-space at end, MySQL will cut it and this will result in a wrong decryption (next time when the string is read and decrypted). When using TinyBlob instead of varchar binary, all works fine. Is this a feature of varchar binary? In my opinion, binary data shouldn't be trimmed! Please answer me via mail as I don't receive the mailing list. Thanks for your support! ... tobias wiersch - 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 Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - 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
My Sql Database memory(new bie to admin)
Hi, Can some one tell me the default memory the mysql allocates when we initially create a database and how to increase the memory subsequently. Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - 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: Making MySQL DB Remotely Accessible
At 09:42 15/05/2001 -0700, Ray Pollard wrote: Hi, There are several ways to do this. For example you can use script languages like PHP (you find in our contribution pages applications ready), also you can use SSH (maybe you need a commercial SSH server to run on Windows) or you can use telnet together the MySQL clients. Anyway you need to study first the MySQL security system, to know how to connect with the server from a remote machine. You find in our Manual all the relevant informations. Regards, Miguel I am new to the world of mySQL and have just installed it on a Windows 2000 Advanced Server and I need to figure out how make the db accessible from a remote PC for administration. Can anyone provide me with some direction in that area? Bear in mind, I am a newbie. Thanks very much, Ray __ ___ __ / |/ /_ __/ __/ __ \/ / http://www.mysql.com/ / /|_/ / // /\ \/ /_/ / /__ Miguel Solórzano [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ São Paulo, Brazil ___/ Development Team - 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: problem updating recordset with MyODBC
I've encountered this before. Several of my clients use mySQL and most of them Linux, however my servers that run mySQL all are W2k. The issue happened like you said when migrating data from w2k to linux. It was a few versions ago in 3.22 however, but the auto-increment field didn't translate for some reason, and so when people inserted records on the linux-mysql version of the db, it didn't auto-increment in the field it was supposed to. The error would happen when I would call the data/update it, and it would look for the field with the auto-increment data, and lo- it was not there hence the error. Check to make sure any auto-increment data is inserting like it should. my (2cents(US)) (2.5 cents(UK)) (.9 cents(CA)) (God only know how many pesos, rubbles, yen, or euros) Dave Carter Chief Web Architect Accelerated Business Technologies, Inc. http://www.abti.cc 717.464.2970 -Original Message- From: David S. Green [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 1:06 PM To: [EMAIL PROTECTED] Subject: problem updating recordset with MyODBC When I try and update a recordset I get the following problem- Microsoft OLE DB Provider for ODBC Drivers error '80004005' Query based update failed. The row to update could not be found. /Part1_Section1_Process.asp, line 82 Line 82 happens to be when I call rs.Update() The problem only occurs when I update certain records. Other records have no problems. Before I had no problems (all records were fine updating). Then I migrated my tables from Win2000 mySQL to a mySQL running on Linux. That is when I noticed that it would not update in some cases. It isn't clear why some records give me problems and others do not. What makes it frustrating is that there seems to be no obvious cause of problem. The code has not been altered one bit. If I move back to Win2000 I'm sure it will work again. But I really want this to work consistently for our Linux DB server. Has anybody seen anything like this before. Can anybody help? David -- David Green Northwestern University, Evanston, IL USA [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: Re[2]: MySQL FullText improvements in V4.0
It wasnt my original post, however the problem with the full-text engine built into mysql is at the current time it is very slow with many records. I was inquiring if this other method would be any faster. ryan Excuse me but what do you mean by FullText ? Is this a full-text search engine in MySQL ??? -Original Message- From: ryc [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 3:29 PM To: James Treworgy; Chris Nichols Cc: [EMAIL PROTECTED] Subject: Re: Re[2]: MySQL FullText improvements in V4.0 What kind of speed can you expect to get from this after tbl_doc_index fills up with tens of millions of rows? Is this scheme suitable for that magnitude of data? Also, if you wish to generate a query that generates all documents that contain token x or token y, would mysql neglect to use the keys? I remember reading that field1=x OR field2=x wont use the index because a general way of optimizing that query hasnt been found. Correct me if im wrong. AND queries on the other hand should work well. thanks, ryan You can do this yourself, pretty easily by building an index in advance. I've been using the following technique to implement full text searching since before it existed in MySQL in any form. Tokenize each unique word in a document and store the word count in tables: tbl_tokens: token_id int token varchar tbl_doc_index: token_id int doc_id int word_count int Populate the tables from your document database either what documents are saved or in some other offline process. When someone searches on words, first convert to tokens using the first table and look up in the 2nd table using whatever search/join technique works best in your situation. Jamie At Monday, May 14, 2001 on 2:18:38 PM, you wrote: I too am curious! I think one feature that I'd really like to see is the ability to tell the number of times a string appears inside another string. This would help a lot when trying to do search results weighting. -Chris - 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 - 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: Run Mysql command from a file.
Hello, On Tue, 15 May 2001, Aires Lima Trindade wrote: How to run SQL commands from a text file but they wasn't clear for me. Does anybody can share with me old experience or a real example about this case? C:\mysql\bincopy con upd.sql USE akw; INSERT INTO tmp (id,c1) VALUES(NULL,1),(NULL,2); INSERT INTO tmp (id,c1) VALUES(NULL,3),(NULL,4); SELECT * FROM tmp; ^Z 1 Datei(en) kopiert. C:\mysql\binmysql upd.sql id c1 1 1 2 2 3 3 4 4 Andreas Karl Wittwer Phone: +49-7052-92206 FAX: +49-7052-92208 Mobil: +49-172-542 541 4 - 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 user InnoDB comments
Hello, From: Richard Ellerbrock [EMAIL PROTECTED] Just installed MaxSQL 3.23.38 on a test system to check out InnoDB. Here are my observations: May I add my ones ... If there are some missing entries in the my.cnf or the INNODB handler can't be started because of permission problems and you do a CREATE TABLE ... TYPE=INNODB the table is 'silently' create as (i guess) MyISAM. No warnings, errors or hints ... Is this WAD? Andreas Karl Wittwer Phone: +49-7052-92206 FAX: +49-7052-92208 Mobil: +49-172-542 541 4 - 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
alter table change enum set
Can anyone shed light on why this doesn't work, and perhaps tell me how I can ALTER the enum values .. or is this just not possible? mysql ALTER TABLE nt_zone_record_log CHANGE COLUMN action action ENUM('added','modified','deleted') NOT NULL DEFAULT added; ERROR 1064: You have an error in your SQL syntax near 'added' at line 1 Thanks, Abe - 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
alter table change enum set (fwd)
Doh! mysql ALTER TABLE nt_zone_record_log CHANGE COLUMN action action ENUM('added','modified','deleted','recovered') NOT NULL DEFAULT 'added'; Query OK, 25 rows affected (0.01 sec) Records: 25 Duplicates: 0 Warnings: 0 Time to squash this bug in MysqlTool (http://dajoba.com/projects/mysqltool). --ai -- Forwarded message -- Date: Tue, 15 May 2001 11:39:44 -0700 (PDT) From: Abraham Ingersoll [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: alter table change enum set Can anyone shed light on why this doesn't work, and perhaps tell me how I can ALTER the enum values .. or is this just not possible? mysql ALTER TABLE nt_zone_record_log CHANGE COLUMN action action ENUM('added','modified','deleted') NOT NULL DEFAULT added; ERROR 1064: You have an error in your SQL syntax near 'added' at line 1 Thanks, Abe - 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: Varchar binary field auto-trimmed??
I'm not a database god, but why would you want to store binary data in a varchar feild when there are feilds of type binary to do store that type of data? How can binary be upper or lower case? -Original Message- From: VVM Ravikumar Sarma Chengalvala [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 1:04 PM To: ryc Cc: [EMAIL PROTECTED] Subject: Re: Varchar binary field auto-trimmed?? Hi, We can decalre a varchar field as BINARY if we need case sensitive storage of field values. Regards, Ravi --- ryc [EMAIL PROTECTED] wrote: Varchar fields are not binary, blobs are. ryan Hi Help! I would like to store some short binary data (encrypted). I used a varchar(24) binary field for this. But it seems that MySQL cuts white-spaces from the end when storing the data in the table. When the encrypted string now has a white-space at end, MySQL will cut it and this will result in a wrong decryption (next time when the string is read and decrypted). When using TinyBlob instead of varchar binary, all works fine. Is this a feature of varchar binary? In my opinion, binary data shouldn't be trimmed! Please answer me via mail as I don't receive the mailing list. Thanks for your support! ... tobias wiersch - 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 Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - 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: Re[2]: MySQL FullText improvements in V4.0
At 03:53 PM 5/15/01 +0200, DEVOS BASTIEN wrote: Excuse me but what do you mean by FullText ? Is this a full-text search engine in MySQL ??? FULLTEXT is a kind of index in MySQL that allows for faster queries and search-engine like relevance values for sorting the results. Here's a link to some documentation: http://www.mysql.com/doc/M/y/MySQL_full-text_search.html -=bill - 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: Run Mysql command from a file.
Maybe he's running in some windows version?? It seems to me that your example using std-in is the easiest. I would suggest also writing a perl program but in this case I thing your example is right on. Then again if he's using the windows version, I have no idea. -Original Message- From: DEVOS BASTIEN [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 7:39 AM To: '[EMAIL PROTECTED]' Subject: RE: Run Mysql command from a file. I'll maybe say something stupid, but if you have your files with your SQL commands, couldn't you use this command ? : mysql -u your_user -pyour_password /path/to/your/SQL/commands/file ? -Original Message- From: Aires Lima Trindade [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 3:54 PM To: Myql List Subject: Run Mysql command from a file. Hi all. I'm new in this list, so may be this questions has already done here. I need to update my database daily at midnight. I want some file from which I can connect to mysql, switch to some database and work into tables (basically with delete and load commands). How can I do this? I had a look to Using mysql in batch mode and How to run SQL commands from a text file but they wasn't clear for me. Does anybody can share with me old experience or a real example about this case? Thanks in advance. Aires Trindade. - 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
Hardware
I need am looking for a server for virtual hosting of websites. Ideally it would be running Linux and be rack mounted. Right now we have a couple of websites that require database support on another companies server and we are looking at hosting them on-site. Currently we have a couple of racs for web hosting. If possible we would like to get 40-80 databases on one server. We are not looking at much traffic 10 hits per minute or less for each site. We do web design for other companies, and it is mostly just dynamic web pages and E-commerce It is critical that it stays up, as we could lose a lot of revenue if it doesn't. We looked at raqs, but we want something with a little more processing power. Any suggestions on hardware would be appreciated and if I forgot anything important just E-mail me. Thank you Dan Mouw
Re: alter table change enum set
You need to quote the default value. --zak - Original Message - From: Abraham Ingersoll [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, May 15, 2001 12:39 PM Subject: alter table change enum set Can anyone shed light on why this doesn't work, and perhaps tell me how I can ALTER the enum values .. or is this just not possible? mysql ALTER TABLE nt_zone_record_log CHANGE COLUMN action action ENUM('added','modified','deleted') NOT NULL DEFAULT added; ERROR 1064: You have an error in your SQL syntax near 'added' at line 1 Thanks, Abe - 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
Subselect in mysql 3.23
Here is what I am trying to do: I am creating a clockin/out utility with php and mysql. I need to do some error checking and look at the last record of the current employee to make sure it is a completed transaction. In other words, I want to make sure that before I clock someone in, that they successfully clocked out the day before. I think I need to stick a subselect inside an if/then statement. Something like: Table definition: id, employee, timein, timeout when client tries to clock in: ? //find out of the person forgot to clock out yesterday if((timeoutof last record of table where employee=$employee_id) = 0) { //clock them in //send me a message email($myemailaddress, $subject, $body); } //clock them in mysql_query(Insert into time values(NULL, $employee_id, unix_timestamp(), 0)); ? I can't figure out how to find out that condition in my if statement Sincerely, Clay Stuckey - MIS, MCSE Charleston Housing Authority (843) 224-9141 - 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: alter table change enum set
hi. put quotes around 'added'. -ravi. -Original Message- From: Abraham Ingersoll [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 2:40 PM To: [EMAIL PROTECTED] Subject: alter table change enum set Can anyone shed light on why this doesn't work, and perhaps tell me how I can ALTER the enum values .. or is this just not possible? mysql ALTER TABLE nt_zone_record_log CHANGE COLUMN action action ENUM('added','modified','deleted') NOT NULL DEFAULT added; ERROR 1064: You have an error in your SQL syntax near 'added' at line 1 Thanks, Abe - 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: alter table change enum set
DEFAULT 'added'; ? Abraham Ingersoll wrote: Can anyone shed light on why this doesn't work, and perhaps tell me how I can ALTER the enum values .. or is this just not possible? mysql ALTER TABLE nt_zone_record_log CHANGE COLUMN action action ENUM('added','modified','deleted') NOT NULL DEFAULT added; ERROR 1064: You have an error in your SQL syntax near 'added' at line 1 Thanks, Abe - 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 -- Gerald L. Clark [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
Re: MySQL 4.0 FULLTEXT SPEED
On Tue, May 15, 2001 at 02:06:32PM -0400, Dave Carter wrote: correct me if I'm mistaken, but I believe the latest version of mysql is 3.23.38 That's the released version, yes. But you can pull a source copy of the MySQL 4.0 tree and compile it yourself if you're in the mood for some fun. :-) Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 132 days, processed 818,902,134 queries (71/sec. avg) - 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
Adding columns/tables to the mysql permissions database
- This was posted before, but under a title that made it sound like a read the manual, silly type of question. Hopefully someone can answer this. I would like to be able to filter users based on other criteria than just their name/host. Will mysql complain/refuse to work if I add columns to the mysql database user table, or any other table in the mysql permissions database? If I could do that, it would greatly simplify things for me. Thanks. j- k- -- Joshua Kugler Associated Students of the University of Alaska Fairbanks Information Services Director [EMAIL PROTECTED] 907-474-7601 - 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: Hardware
Look on Ebay for Compaq 1850R 'rackmount' servers... You can find one with 'dual' Pentium II CPU's, dual power supplies (which you can plug into 2 different circuits or UPS's), and enough SCSI drive slots to provide the disk space (and the different number of storage devices to 'mirror' and spread the databases across) to handle the job. I picked up a couple of 'stripped down' versions for around $1200 and then bid on the 'add ons'... I have Redhat 6.2 (with all the patches) running on them, which have an 'uptime' of 6 months now... (except for when I rebooted them after updating the kernel). They're usually about 99% idle at any given time... (the MySQL activity doesn't really make a dent in their performance). P.S. Order the latest Compaq 'ROM update' CD, which now adds Linux options to the BIOS settings... Daniel Mouw wrote: I need am looking for a server for virtual hosting of websites. Ideally it would be running Linux and be rack mounted. Right now we have a couple of websites that require database support on another companies server and we are looking at hosting them on-site. Currently we have a couple of racs for web hosting. If possible we would like to get 40-80 databases on one server. We are not looking at much traffic 10 hits per minute or less for each site. We do web design for other companies, and it is mostly just dynamic web pages and E-commerce It is critical that it stays up, as we could lose a lot of revenue if it doesn't. We looked at raqs, but we want something with a little more processing power. Any suggestions on hardware would be appreciated and if I forgot anything important just E-mail me. Thank you Dan Mouw - 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
Error creating database
When i try to create a database with the command : mysql create gnudip2; Told me an error : ERROR 1064: You have an error in your SQL syntax near 'gnudip2' at line 1 Why this error ??, What is wrong ?? Thanks Ana Elisa Martinez
Re: Error creating database
try: mysqlCREATE DATABASE gnudip2; From: Ana Elisa Martinez [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Error creating database Date: Tue, 15 May 2001 16:09:09 -0400 When i try to create a database with the command : mysql create gnudip2; Told me an error : ERROR 1064: You have an error in your SQL syntax near 'gnudip2' at line 1 Why this error ??, What is wrong ?? Thanks Ana Elisa Martinez _ Get Your Private, Free E-mail from MSN Hotmail at 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
RE: Run Mysql command from a file.
With windows, you can use type filename.sql | mysql ... Maybe he's running in some windows version?? It seems to me that your example using std-in is the easiest. I would suggest also writing a perl program but in this case I thing your example is right on. Then again if he's using the windows version, I have no idea. - 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
What would be faster?
Hi! I wonder what would be faster. Let's say I want to run two kinds of SQL queries on the table: SELECT id FROM mytable WHERE key1=? AND key2=? AND key3=?; DELETE FROM mytable WHERE key1=? AND key2=? AND id=?; What's better? This: CREATE TABLE mytable ( key1 CHAR(20) NOT NULL, key2 CHAR(20) NOT NULL, key3 CHAR(100) NOT NULL, id INT UNSIGNED NOT NULL, UNIQUE KEY (key1,key2,key3), INDEX (key1,key2,id) ); Or this: CREATE TABLE mytable ( key1 CHAR(20) NOT NULL, key2 CHAR(20) NOT NULL, key3 CHAR(100) NOT NULL, id INT UNSIGNED NOT NULL, INDEX (key1,key2), INDEX (key1,key2), INDEX (key3), INDEX (id) ); Or even this: CREATE TABLE mytable ( key1 CHAR(20) NOT NULL, key2 CHAR(20) NOT NULL, key3 CHAR(100) NOT NULL, id INT UNSIGNED NOT NULL, INDEX (key1), INDEX (key2), INDEX (key3), INDEX (id) ); First I thought that the first is most efficient, but then I noticed that it would create keys of 140 bytes in length. And most of the time values of keys would be much shorter then limits, so may be separate keys would work faster? And take less space in memory - be better cached? I will run some tests on my own now, but if anybody have any suggestions I'd really appreciate them.. Thanx. Andrew. - 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: Error creating database
create database gnudip2; make sure you have the right permissions as well! - Original Message - From: Ana Elisa Martinez [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, May 15, 2001 9:09 PM Subject: Error creating database When i try to create a database with the command : mysql create gnudip2; Told me an error : ERROR 1064: You have an error in your SQL syntax near 'gnudip2' at line 1 Why this error ??, What is wrong ?? Thanks Ana Elisa Martinez - 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
FreeBSD 4.2 vs. Linux query speeds ?
I have some complex multi-step queries that take over 60 seconds on Free BSD 4.2. They seemed much faster on Linux. Should FreeBSD 4.2 be just as fast as Linux on comparable hardware ? When I simulate concurrent users the query times go up oddly. 1 user 66 seconds 2 users 157 seconds 3 users 232 seconds Does this seem odd ? - Sam. - Do You Yahoo!? Yahoo! Auctions $2 Million Sweepstakes - Got something to sell?
Re: Error creating database
I also get somthing like that, much mor productive to do somthing like create database gnudip2(id int(10),some_colum varchar(255)); Trying to show that you add columns with the same command. Darrell On Tue, 15 May 2001, Ana Elisa Martinez wrote: When i try to create a database with the command : mysql create gnudip2; Told me an error : ERROR 1064: You have an error in your SQL syntax near 'gnudip2' at line 1 Why this error ??, What is wrong ?? Thanks Ana Elisa Martinez - 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: Microsoft Access and Mysql
there is no command line.. you go to the mysql.com site, download the access converter on the contributed programs page, copy the code into an access module (macro), edit the code to tell it where to save the result and run it. It will produce a text file, then you can do mysql mydatabase mytextfile_fromaccess Chris Wilkinson wrote: Can you give me a sample command line please CHRIS In message [EMAIL PROTECTED], Steve Ruby [EMAIL PROTECTED] writes Chris Wilkinson wrote: I am attempting to upload an Access db to a remote mysql server - at dsvr in the UK. I get connected (I think) but receive the following error message: Microsoft Access ODBC - call failed [Microsoft][ODBC Driver Manager #0] Can you point me in the right direction for this or offer some help. Thanks CHRIS -- Chris Wilkinson You need to explain better what you are doing. You cannot upload an Access DB to a MySQL server. You can upload and insert the data, you can write some program to make calls to both DBs and insert the data but you can't just upload the database? And where are you getting the error from, that error is from Access not mysql? -- Chris Wilkinson - 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: Hardware
Try: http://eliteukserve.net/dedicatedservers/dedicated_servers.html We specialise in managed custom server solutions. We have great experience in providing mass virtual solutions incorporating Linux based systems such as SuSE and RedHat with MySQL. I would say perhaps a Dual PIII 1GHz SCSI would handle your needs with ease. As you will see from our site we offer a broad range sure to meet your circumstances. David Simmons EliteUKServe.Net - Original Message - From: Daniel Mouw [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, May 15, 2001 9:28 PM Subject: Hardware I need am looking for a server for virtual hosting of websites. Ideally it would be running Linux and be rack mounted. Right now we have a couple of websites that require database support on another companies server and we are looking at hosting them on-site. Currently we have a couple of racs for web hosting. If possible we would like to get 40-80 databases on one server. We are not looking at much traffic 10 hits per minute or less for each site. We do web design for other companies, and it is mostly just dynamic web pages and E-commerce It is critical that it stays up, as we could lose a lot of revenue if it doesn't. We looked at raqs, but we want something with a little more processing power. Any suggestions on hardware would be appreciated and if I forgot anything important just E-mail me. Thank you Dan Mouw - 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 newbie question
Hi there, I'm trying to install MySql and Mysql client (including MySql GUI) both on Windows and Unix/Linux. I'm having trouble reset the root password: I ran: ./bin/mysqladmin -u root password 'mysqlroot' ./bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: NO)' and when I install MySql RPM on Linux, mysql user will be automatically created, and do I need to change the password for mysql too? Please pardon my stupidity, but I just can't pass the first step, help! Thanks, Wei __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.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
Re: alter table change enum set
I have a similar mysql enum question. What if I have the following: enum('foo','bar','baz') default 'bar' not null. What if I want to change the value of bar to bee? What is the best way to implement this? Nicole Sweeney Software Configuration Engineer Akamai Technologies 858-909-3654 work 858-442-7011 cell - 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
server variables
hello, is it possible to set server varibales through SQL and if so what user-rights do i need? thanx in advance regards peet
Re: Looking for info on Fuzzy Searching with MySQL
I found FULLTEXT (MATCH/AGAINST) indexes and the SOUNDEX function. Are there other MySQL features that help with Fuzzy searching? Soundex seems very useful, but I'm not sure how to apply it to multi-word strings. I'd also be interested in pointers to general info on writing fuzzy searches. A Perl example would be great. I think what I want it a kind of combination of SOUNDEX and the relevance value from MATCH/AGAINST. Is something like this possible? I looked into soundex (in general, not just wrt MySQL), and didn't like what I found all that much, so rolled my own and ended up re-inventing phonex without realising it. What I've ended up with is a modified-phonex-encoded name in a database table which works really well for fuzzy matching. YMMV of course. If you're interested, email me off the list and I'll outline what I did and why. Paul Wilson iiNet Ltd - 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