RE: undefined function: mysql_connect()
Are you using MySQL 4.x sumthing? I thought that function was taken out and replaced with mysql_real_connect()? I may be wrong. -Original Message- From: Julie Meloni [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 24, 2002 10:35 AM To: Tewfic Kidess Cc: [EMAIL PROTECTED] Subject: Re: undefined function: mysql_connect() TK Hello, i'm trying to use PHP4 and MySQL and i'm getting undefined function: TK mysql_connect() This question belongs on a/the PHP mailing list, but the answer is that you need to compiled PHP --with-mysql. Please read the PHP installation instructions in the very handy manual at http://www.php.net/manual/ - Julie -- Julie Meloni -- [EMAIL PROTECTED] -- www.thickbook.com Find Sams Teach Yourself MySQL in 24 Hours at http://www.amazon.com/exec/obidos/ASIN/0672323494/thickbookcom-20 - 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
MySQL 3.23.49 Installation - password problems
Hi, I just installed MySQL 3.23.49 on NT and executed the following commands: UPDATE USER SET password=password(test1) WHERE host=localhost; UPDATE USER SET password=password(test1) WHERE host=%; Now, after doing 'mysqladmin reload', I cannot connect... mysql -p Enter password: * Error 1045: Access denied for user: 'ODBC@localhost' (Using password: YES) mysql -p[test1] Error 1045: Access denied for user: 'ODBC@localhost' (Using password: YES) mysql -u root -p[test1] Error 1045: Access denied for user: 'root@localhost' (Using password: YES) Have I done something wrong? Can I connect to the database, or do I have to re-install? Thanks very much in advance for any advice. - Best regards, Lee Reilly - 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
PHP/MySQL application - how to schedule server processes?
Hi there, I wonder if anyone can offer me some advice... I have developed a portal using PHP, which allows users to uploads files into their own personal storage locations. These files are stored in a MySQL database. The system also allows the users to select these files and submit them for analysis. By analysis, I mean that these files will be used as the input to separate executables (written in C) running on the server. This aspect of the system be accomplished in 2 ways: CASE 1: Where the analysis program has a run time of less than 1 second (nb: the amount of users estimated at any one time is no greater than 10). Here, the file can be extracted, a command line argument generated, and then passed to the server via the PHP passthru() function. The result will then be returned to the user. Easy peasy. CASE 2: Where the analysis program may have a run time in excess of 2 hours. The passthru() function is obviously not an option as we do not expect the user to sit in front of the computer for a few hours, or even minutes waiting for a result. I am not sure as to the correct terminology, but I believe I am looking for something like an 'application server' / 'process management scheduler'. Maybe something that is commercially/freely available, or an idea of how to go about writing my own. Here is a rough idea of what I am trying to accomplish: The user accesses the web application and, and selects a file for analysis. The system (implemented in PHP) updates the databases to say that 'ANALYSIS A' of 'FILE B' has been requested. A separate entity running on the server watches the database for analysis requests, and either (a) runs them one after another updates the database appropriately (b) or schedules according to some priority. When each analysis is complete, the user will have access to the a results folder in the system containing a list of their submitted analysis (either pending or complete). Can anyone offer any advice/suggestions on how this can be accomplished? Thank you very much for your time. - Best regards, Lee Reilly -- Lee P. Reilly, ms:G758 Szilard Resource, tel:505-665-7025 Bioscience Division, SM-30 Bikini Atoll Rd, Los Alamos National Laboratory, mailto:[EMAIL PROTECTED] Los Alamos, NM 87545. http://home.lanl.gov/lreilly Quidquid latine dictum sit, altum viditur filterPHP SQL/filter - 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
passing Mysql handler to the exec'ed child
Hi , My aim is to avoid mysql connects to the DB my application does not run as a daemon . But the parent of this program runs as a daemon , so can someone tell me how I would make use of the same Mysql handler in the execed child also assuming I connect to the Mysql Server in the parent ? 1.) Connect to Mysql DB in the parent 2.) exec the child . Now how can the child make use of the same fd to ask questions to the Mysql Server ? Regards - 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: using LOAD DATA INFILE with dbexport from informix
On Fri, 2002-03-08 at 14:19, [EMAIL PROTECTED] wrote: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: I've noticed the hard way that there is more to loading data exported from informix than just: LOAD DATA LOCAL INFILE speci02695.unl INTO TABLE specimens FIELDS TERMINATED BY '|'; I have all of the columns that are INTEGER that were NULL in informix, now have the value 0. I have several export files that are over a gig. I do not want to preparse the file with perl to make all of the NULL values \N, so what can I do? Thanks. I really think that you need to check the spam-o-meter for this kind of query. -- Brian Millett Enterprise Consulting Group Shifts in paradigms (314) 205-9030 often cause nose bleeds. [EMAIL PROTECTED] Greg Glenn - 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 on redhat instalation problem
Hello, You probably need to check the permissions for the directory that mysql is trying to create the databases in. Make sure mysql has write permissions in the directory. then run mysql_install_db again and you should be ready to go. - Original Message - From: jake williamson 28 [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 26, 2002 10:50 AM Subject: mysql on redhat instalation problem hello! i'm rapidly loosing the hair i have left i've managed to get our old clockwork pc running redhat 7.1 and php4. apache is a rockin and now i've just installed the mysql RPM... this is where everything's come to a grinding halt... everything's gone in and mysql seems to be up and running in the background - thing is i've just got to the 'what to do to set up mysql' - at this point in the manual it seems to forget that you've used a PRM and uses a load of stuff that doesn't seem to be in my machine! it's this bit 'See section 2.4 Post-installation Setup and Testing.' where it all goes wrong - none of the directories seem to be there! in your new server wisdom dus you have any advice?? driving me bonkers... cheers dude, jake - 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
insert select in ONE statement?
Hi, I wonder if anyone can offer me some advice with this one: I have a table called 'iq_data' holding just a primary key and a field called 'iq_data'. +++--+-+-++ | Field | Type | Null | Key | Default | Extra | +++--+-+-++ | iqid | int(11)| | PRI | NULL| auto_increment | | iqdata | mediumtext | | | NULL|| +++--+-+-++ 'iq_data' contains the contents of a plain text file in the following format: .010 .1083649E+03 .2186916E+02 .0013470 .1993729E+03 .2738670E+02 == + approx. 100-1000 more lines. After I insert data into the table, I need to get the iqid that was generated. One solution is to do something like: SELECT iqid from iq_data where iqdata=the contents of the file; // ^ this will give me the correct answer, but it may be a // little inefficient as there may be thousands of records, and the // search string is very large or SELECT iqid from iq_id order by iqid (and get the last iqid generated) // ^ querying like this immediately after inserting data to the table, // but assumes that another record has not yet been added A problem will arise if say, data is inserted by user 1, and then by user 2, and then the iqid for user1 is requested, but the iqid for user2 will be returned. So... Is there any way I can e.g. insert the data into the table and return the value of the PK that was generated in one statement? If not, of the 2 solutions above what is more efficient? Is there are more elegant solution? Thank you very much for your time; hope someone can help ;-) - Best regards, Lee Reilly /My SQL query - 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
RPMS for Development Branch
Hello all, I have finished setting up a web page that contains RPMS for the Development Branch of MySQL-4.0. These RPMS are compiled every night at 11:00 p.m. CST and are posted to the site at 12:00 a.m. CST. They are built on a standard RedHat 6.2 install. You must use RPM version 4 to install. the Perl dependancy error is still there so --nodeps will bypass it. I have also installed them sucessfuly on RedHat 7.2. I did this myself, and MySQL is not responsible if they do not work. So do not mail the lists if there is an install error, or a specific feature that is not enabled. such requests should be sent to [EMAIL PROTECTED] I did this in hopes of making things easier for people (and myself) who want to try the new stuff out without downloading and compiling themselves. Have fun. Brian P. Austin query, mysql, server - 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: RPMS for Development Branch
http://www.linuxmonsters.com sorry about that -Original Message- From: Rick Emery [mailto:[EMAIL PROTECTED]] Sent: Monday, February 18, 2002 3:41 PM To: 'Brian P. Austin' Cc: mysql Subject: RE: RPMS for Development Branch and the URL is??? it's not www.codemonsters.net; I just checked -Original Message- From: Brian P. Austin [mailto:[EMAIL PROTECTED]] Sent: Monday, February 18, 2002 3:20 PM To: [EMAIL PROTECTED] Cc: mysql Subject: RPMS for Development Branch Hello all, I have finished setting up a web page that contains RPMS for the Development Branch of MySQL-4.0. These RPMS are compiled every night at 11:00 p.m. CST and are posted to the site at 12:00 a.m. CST. They are built on a standard RedHat 6.2 install. You must use RPM version 4 to install. the Perl dependancy error is still there so --nodeps will bypass it. I have also installed them sucessfuly on RedHat 7.2. I did this myself, and MySQL is not responsible if they do not work. So do not mail the lists if there is an install error, or a specific feature that is not enabled. such requests should be sent to [EMAIL PROTECTED] I did this in hopes of making things easier for people (and myself) who want to try the new stuff out without downloading and compiling themselves. Have fun. Brian P. Austin query, mysql, server - 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
question on mysql benchmarking
Hi, When I run perl run-all-tests --server=mysql --cmp=mysql,pg,solid --user=test --password=test --log in the sql-bench direcotory. I encountered following error messages: Can't locate DBI.pm in @INC (@INC contains: /usr/lib/perl5/5.6.0/ia64-linux /usr/lib/perl5/5.6.0 /usr/lib/perl5/site_perl/5.6.0/ia64-linux /usr/lib/perl5/site_perl/5.6.0 /usr/lib/perl5/site_perl .) at run-all-tests line 36. BEGIN failed--compilation aborted at run-all-tests line 36. I am very new to mysql. I cannot figure out the reason easily. Is there any problem with my perl? Another question is that I am also using another compiler (ORC from intel) to compile mysql. ORC borrows the frontend of gcc. but orcc doesnot accept compiler options such as -fno-implicit-templates -fno-exceptions -fno-rtti. I don't know the meaning of these flags. Can you explain me this? Can I eliminate these options and make mysql still runs well? Thanks. Peng - 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: Request for help in testing new replication code in 4.0.2
I have finished a script that takes the bit keeper sources and makes MySQL-4.0.2 RPMS for Redhat 6.x and apparently 7.X as well. I can put these up on our site for download if you want. They might get others trying the code out. I use the spec file included with the source code. I'll put it up if it's something you might find useful. -Original Message- From: Steven Roussey [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 12, 2002 12:41 PM To: 'Sasha Pachev' Cc: 'Mysql' Subject: Re: Request for help in testing new replication code in 4.0.2 * If you want to do it this very moment, read the instructions at http://www.mysql.com/doc/I/n/Installing_source_tree.html and install a pre-release 4.0.2 MySQL on your test server. You may also wait until 4.0.2 is released, but in that case, replication in 4.0.2 may have a bug you could have caught on your system and it will not be fixed until 4.0.3. Is that possible to provide a binary snapshot of the pre-release? This can be done with some simple shell scripting, I think. I always found the one I build myself is about 30-50% slower then the official binary. I think that's related to the debian patched glibc-2.95 I am using. Hi, I have to agree with this. I don't want to have to factor in RedHat's 7.2 compiler oddities (which one to use?). Some software projects have a machine to do regular builds on a schedule. This would be ideal. You would find more people testing it. You might just do it in special cases like this one. Testing the new code is relatively easy, and does not require risking the stability of your application by running alpha code. Yes and no. Taking down a server and copying gigs of data can take down a service for a long time (moving gigs of data just is never fast, and the machine I'm going to use has lots of power but no RAID). I don't have time to download and install gcc, bitkeeper, autoconf 2.13, automake 1.4, libtool, m4, and mysql today, but I'll try and get to it this week. Taking down the server will have to wait until maintenance windows over the weekend anyhow. Our test plan for MySQL 4 is as follows: 1. Serialized writes (i.e. replication slave) for two weeks (or about 1 billion insert/update/delete type queries) with no crashes. 2. Everything. We will have the app send duplicates of all queries to the mysql 4 server, but will automatically halt when mysql 4 crashes. We will keep trying this until mysql doesn't crash for a week. 3. Check that the two servers hold the same information and return the same results from queries. With the type and volume of queries that we have, mysql alpha versions either fail within minutes/hours/days or they don't fail at all. We certainly are not the biggest user of mysql, but historically, we have been able to push it hard enough to crash. Not the stable version though. Thankfully, that takes a licking and keeps on ticking. :) Eventually (spring/summer), we will move the main server to v4 and keep the slave around as a live backup. I've been wanting such a slave for a long time. Stopping the slave to make a backup would be great. Not to mention faster fulltext and order by DESC. Sincerely, Steven Roussey http://Network54.com/?pp=e - 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: Using password: _No_
what command are you issuing. is it mysql? If so, what arguments are you sending it? It should look like this mysql -u user -p prompt: password -Original Message- From: Cliff [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 12, 2002 9:18 PM To: [EMAIL PROTECTED] Subject: Using password: _No_ Hello, Can anyone help? When trying to run mysql I get an ERROR 1045: Access denied for user: 'root@localhost' (Using password: No). In the documentation it mentions 'Using password: YES'. Have tried starting mysql with --skip-grant-tables and then mysqladmin flush-privileges which doesn't seem to do anything. What does the Password No mean? How do I correct it short of reinstallation? Well, I don't know maybe I need to start over yet again. Thanks very much for any help, Cliff - 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
SELECT DISTINCT BINARY crashes mysql on null values
Description: Executing a SELECT DISTINCT statement in conjunction with the BINARY cast operator will crash MySQL server when the column being cast contains one or more null values. How-To-Repeat: Executing the following code from a mysql prompt will cause the MySQL server to crash and restart. create temporary table wassup ( rowid int not null AUTO_INCREMENT PRIMARY KEY, col1 varchar(10) null ) ; insert into wassup (col1) values ('aaa'), ('AAA'), (NULL) ; select distinct binary col1 from wassup ; Fix: Work-arounds: Defining the column as binary during the create table statement alleviates the need for the binary cast during selects, and thereby eliminates the crashes. Alternatively, adding where col1 is not null to the select statement will also work. Submitter-Id: submitter ID Originator:Steve Severance Organization: MySQL support: none Synopsis: SELECT DISTINCT BINARY crashes mysql on null values Severity: non-critical Priority: low Category: mysql Class: sw-bug Release: mysql-3.23.47 (Official MySQL RPM) Environment: System: Linux vexweb1 2.4.2-2smp #1 SMP Sun Apr 8 20:21:34 EDT 2001 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/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-81) Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='gcc' CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Jan 4 16:56 /lib/libc.so.6 - libc-2.2.2.so -rwxr-xr-x1 root root 1236396 Apr 6 2001 /lib/libc-2.2.2.so -rw-r--r--1 root root 26350254 Apr 6 2001 /usr/lib/libc.a -rw-r--r--1 root root 178 Apr 6 2001 /usr/lib/libc.so Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --without-berkeley-db --without-innodb --enable-assembler --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include --mandir=/usr/man '--with-comment=Official MySQL RPM' - 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
Compile failure with dev branch
When using the BUILD/compile-pentium and BUILD/compile-pentium-pgcc I get the following errors.. /bin/sh ../libtool --mode=link gcc -O3 -DDBUG_OFF -Wimplicit -Wreturn-type -Wid-clash-51 -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wimplicit-function-dec -Wimplicit-int -Wparentheses -Wsign-compare -Wwrite-strings -Wunused -mcpu=pentiumpro -O3 -fno-omit-frame-pointer -rdynamic -o test3 test3.o -all-static libnisam.a ../mysys/libmysys.a../dbug/libdbug.a ../strings/libmystrings.a -lpthread -lz -lcrypt -lnsl -lm -lpthread collect2: ld returned 1 exit status gmake[2]: *** [pack_isam] Error 1 gmake[2]: *** Waiting for unfinished jobs collect2: ld returned 1 exit status gmake[2]: *** [test1] Error 1 gcc -O3 -DDBUG_OFF -Wimplicit -Wreturn-type -Wid-clash-51 -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wimplicit-function-dec -Wimplicit-int -Wparentheses -Wsign-compare -Wwrite-strings -Wunused -mcpu=pentiumpro -O3 -fno-omit-frame-pointer -rdynamic -o test3 test3.o -static libnisam.a ../mysys/libmysys.a ../dbug/libdbug.a ../strings/libmystrings.a -lpthread -lz -lcrypt -lnsl -lm -lpthread collect2: ld returned 1 exit status gmake[2]: *** [test2] Error 1 gmake[1]: *** [all-recursive] Error 1 gmake[1]: Leaving directory `/home/baustin/mysql' gmake: *** [all-recursive-am] Error 2 no modifications were made to the BUILD files. Note: I am using the hacked glibc/LinuxThreads library. Don't know if that is the cause though. It looks like the isam stuff instead. any input would be appreciated. thanks, Brian - 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
prob on NT
Hi, I've a problem in order to install Mysql server 3.23.47 on NT 4 box when I try to run the file setup.exe, I get an error msg like this: *I can't run a 16 bit program the file setup.exe is damage. Try to reinstall* (!?!?!?) I've never seen this error ... anyone can help me in order to solve this prob? thanks in advance max - 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: prob on NT
Hi Victoria, echoplusAT *I can't run a 16 bit program the file setup.exe is damage. Try to echoplusAT reinstall* (!?!?!?) echoplusAT I've never seen this error ... anyone can help me in order to solve this echoplusAT prob? May be you have a corrupted installation package. Try to download the MySQL 3.32 release again from : http://www.mysql.com/downloads/mysql-3.23.html This seems do not solve my problem ... before I wrote my msg to the list, I've tried to download 3 different package from 3 different mirrors and they always give the same error ... well, now I'll try to install a previous version of the server, but I think that is very strange to have 3 different install. package damaged ... anyway, thanks for your help max - 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
Altering InnoDB tables
I've recently converted from using MyISAM to InnoDB tables, and am pleased with InnoDB so far. However, the inability to use 'ALTER TABLE' with InnoDB tables is very problematic, as our software is still under heavy development and our database schema changes frequently. I'm working on a way to automate the drop/create/repopulate process to alter tables, but am running into a few problems: Is there a way to prevent clients from noticing that the table in question is temporarily gone? Something like locking the entire database for writing? Second, mysqldump doesn't give foreign key constraints in its table creation commands. Is there any way to retrieve these? -- /--- | Robert P Ricci [EMAIL PROTECTED] || [EMAIL PROTECTED] | Research Associate, University of Utah Flux Group | www.cs.utah.edu/flux || www.emulab.net \--- - 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: Altering InnoDB tables
Thus spake John Kemp on Mon, Jan 14, 2002 at 02:37:07PM -0500: 2) Then I tried mysqldumping the table structure, and changing MyISAM - INNODB, dropped the table, and ran the mysqldump output back into the database. The INSERTS ran horribly slowly - something like 50,000 inserts in 4 hours. This extrapolates to a query that would run for several weeks on 5 million rows, so I stopped it again. Did you try putting 'set autocommit=0;' at the top of your dump, and 'commit;' and at the bottom? That may help, though it sounds like it's the index creation, and not any transaction overhead, that's causing you trouble. Luckily, in my case, our database is sufficiently small (on the order of tens of thousands of rows spread out across ~50 tables) that this isn't really an issue. -- /--- | Robert P Ricci [EMAIL PROTECTED] || [EMAIL PROTECTED] | Research Associate, University of Utah Flux Group | www.cs.utah.edu/flux || www.emulab.net \--- - 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
maximum heap table size allowed
Hello, Can anyone tell me if the maximum table sizes given in Section 1.2.4 of the documentation apply equally to HEAP tables in v. 4.0? Or, rather, if memory and address space were unlimited, how large could a heap table possibly be in v. 4.0? TIA Tim Banach State Street Corporation Westwood, MA - 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
maximum heap table size
Hello, Can anyone tell me if the maximum table sizes given in Section 1.2.4 of the documentation also apply to HEAP tables in v. 4.0? Or, rather, if memory and address space were unlimited, how large could a heap table possibly be in v. 4.0? TIA Tim Banach State Street Corporation Westwood, MA - 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: SELECT HELP
I believe you could use CONCAT(firstname, ' ', lastname) LIKE '%$searchname%' if you leave the space out of the middle it probably won't work, and you might want to trim firstname lastname to make sure no leading or trailing spaces exist. Hope this helps, P -Original Message- From: *Himerus* [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 18, 2001 10:09 PM To: [EMAIL PROTECTED] Subject: SELECT HELP How do I use the select feature in this situation. I have a total of 5 fields that deal with names.. Three of the five are completely separate, and use one field for both first and last name. the last two fields are the first and last name of the person submitting the information.. When I do a select if someone searches for joe or smith it will pull up the info on all fields. but if someone searches for joe smith it will ONLY pull up the entries that match in the first three fields. it is imperative that I make this work. I can't change the layout of the table at this point, but I'm sure there's a way to combine two fields in the select and try to match two fields in the table to one field in the search form.. Here's a sample of the code.. (SELECT * FROM newsibsdatabase WHERE (firstname LIKE '%$searchname%' OR lastname LIKE '%$searchname%' OR adopteename LIKE '%$searchname%') now, can I add in a option that is something like this OR (firstname lastname LIKE '%$searchname$') how would this work.. Thanks in advance.. Jake. - 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
mySQL in-memory configuration
Hello, Can mySQL be configured to run entirely in-memory? That is, can one configure it so that all the tables, data, etc. remain resident in memory and are never written to disk? TIA, Tim Banach - 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
Changing the socket location?
I was wondering is there anyway to change the socket location from /tmp/mysql.sock to something else, other than recompiling :-)? If there is not I would like to highly recommend it as an option. TIA stevet _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.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: MySQL, Red Hat Linux and php
If you are using the MySQL RPMS for RedHat, They install in the /usr directory. (Redhat dows things differently) So it would be ./configure --with-mysql=/usr for PHP compilation. as far as upgrading... I have used RedHat for a long time, and have found that in their newest distos, it is extremely difficult to customize your computer. Escpecially with adding your own Kernel. I have stayed with 6.2 because for the most part, the directory structures comply with the source packages most people make available. As long as you keep current with important packages, there really isn't much difference in the newer versions, other than a new GLIBC, but you can add that to a 6.2 distro easily. Hope that helps Brian Austin Neil Zanella wrote: If I were you I would simply upgrade to Red Hat 7.1 or better 7.2. It probably takes just as much time to install a whole distro than having to worry about installing apache, then mysql, then php, all over again, and most likely getting something wrong and having to go back. Also there may be problems with compatibility etc... I remember having some problem compiling php with mysql support when mysql was not installed under /usr/local (something like the php configure option did not allow to specify a directory for the mysql installation). But perhaps this has changed in php 4.0.6. Regards, Neil On Thu, 29 Nov 2001 [EMAIL PROTECTED] wrote: Hello, Which version of MySQL ( RPM packages ) is good for work with php 4.0.6 and Linux Red Hat 6.2 ? Thank for your help ! Edward. - 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: MySQL, Red Hat Linux and php
The RPMS that are available from the MySQL WebSite are OK to use on 6.2. I personnaly prefer to use the source or .src RPMS. But the RPMS work fine on my 6.2 box. [EMAIL PROTECTED] wrote: Hello, Which version of MySQL ( RPM packages ) is good for work with php 4.0.6 and Linux Red Hat 6.2 ? Thank for your help ! Edward. - 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
Could mysql count the datatraffic of DB's posted queries?
Hi all, I'm looking for a posibility to count the datatraffic of a database at my mysqldb-server. The clients should got only select-rights on thier databases. And I need to count the resultset datatraffic of their select-queries. I'm using mysql version 3.23.39. I was looking for some logfiles entries at the logging mode, but there were only the queries in the HOSTNAME.log file. Not the size of the resultsets. What could I do to reach my aim. I hope somebody know some good tutorials in the web, or could write me a posibility to reach that. Thank you in advance Perica Markovic - 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
Fw: Could mysql count the datatraffic of DB's posted queries?
SHOW STATUS will give you an indication on how much traffic is moved between your server and the clients (look for bytes sent and bytes received) - but only the totals for the server are displayed. I very much doubt you can get the data by client or connection. I'm curious as to *why* you're doing this. For billing? In that case the data traffic is a lousy metric for how many resources each client is hogging. The complexity of the queries is by far more important than the amount of data moved. I have to explain much better. I want to provide the content of my db-server and want to aloud the users(mysql user) to get the content only by using the select-rights. The mysql users could have big public commercial webapplications with much users on their websites. I'm scared about the traffic costs of my hoster. I want to transfer the costs to the users but I must have some datasize of the resultsets of the sended queries. The Bytes_received and Bytes_sent are general values but I want to know on each table or user? Perica Markovic - 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 invoking mysqld on Win 98
Hi, I am new to MySQL. I installed it on Win 98 and trying to invoke the mysqld. First it gave me a strange error that innodb_data_file_path is not found. I copied the following from manual (I dont really want to create such 2GB files though !). -- innodb_data_file_path = ibdata1:2000M;ibdata2:2000M innodb_data_home_dir = c:\ibdata set-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = c:\iblogs set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=30M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 innodb_log_arch_dir = c:\iblogs innodb_log_archive=0 set-variable = innodb_buffer_pool_size=80M set-variable = innodb_additional_mem_pool_size=10M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50-- It is now giving an error: -- C:\mysql\binmysqld Innobase: Assertion failure in thread 4294222333 in file M:\mysql-3.23\innobase\ os\os0file.c line 187 Innobase: we intentionally generate a memory trap. Innobase: Send a bug report to [EMAIL PROTECTED] 011124 21:01:27 C:\MYSQL\BIN\MYSQLD.EXE: Got signal 11. Aborting! 011124 21:01:27 Aborting InnoDB: Warning: shutting down not properly started database 011124 21:01:34 C:\MYSQL\BIN\MYSQLD.EXE: Shutdown Complete -- Please help me come out of this problem. Thanks. -- With regards, /Prem __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 - 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.sock deletes itself on Solaris
mysql, query, server there is probably a cron job or sumptin that is deleting your sock file. Try putting it in a different place. [EMAIL PROTECTED] wrote: Description: /tmp/mysql.sock is there and then apparently randomly its removed without warning.. mysql still accepts TCP connections and theres no log comment to indicate an error. How-To-Repeat: It seems random.. Fix: Good question - any ideas?! Submitter-Id: steve Originator:steve Organization: Opal Telecom Plc MySQL support: none Synopsis: mysql.sock deletes itself on solaris Severity: critical Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.42 (Source distribution) Server: /usr/local/mysql/bin/mysqladmin Ver 8.21 Distrib 3.23.42, for sun-solaris2.7 on sparc Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.42 Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 1 hour 23 min 50 sec Threads: 5 Questions: 15283 Slow queries: 3 Opens: 16 Flush tables: 1 Open tables: 10 Queries per second avg: 3.038 Environment: System: SunOS mail-3 5.7 Generic_106541-08 sun4u sparc SUNW,Ultra-5_10 Architecture: sun4 Some paths: /usr/bin/perl /usr/local/bin/make /usr/local/bin/gcc /usr/local/bin/cc GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.7/2.95.2/specs gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: -rw-r--r-- 1 bin bin 1690732 Oct 14 1999 /lib/libc.a lrwxrwxrwx 1 root root 11 Jul 11 11:33 /lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 bin bin 1109336 Oct 14 1999 /lib/libc.so.1 -rw-r--r-- 1 bin bin 1690732 Oct 14 1999 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Jul 11 11:33 /usr/lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 bin bin 1109336 Oct 14 1999 /usr/lib/libc.so.1 Configure command: ./configure --prefix=/usr/local/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 - 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.sock ???
Or you could add path-to-unix-socket= somewhere else than /tmp Sometimes your machine will delete things in the /tmp directory without you knowing. I put it in /var/lib/mysql (linux). Ed Carp wrote: Riccardi Moreno ([EMAIL PROTECTED]) writes: Hi all, I've installed mysql 3.23.42 on Freebsd system but when i launch mysql i said me can't connect to localhost /tmp/mysql.sock not found. How can i repair this error? First, you can refrain from posting the same question twice. Second, you can RTFM before posting - specifically, http://www.mysql.com/doc/P/r/Problems_with_mysql.sock.html You can also look at Carsten's *excellent* FAQ - specifically, http://www.bitbybit.dk/mysqlfaq/faq.html#ch10_1_0 -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - 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
replication implementation.
Hi anybody, am a newbie to mysql and i want to install master/slave mysql server for replication. can anybody please desc from the scratch (user rights) of configuring 2 mysql servers in master/slave fashion for replicatiom. thanx in advance. bye kamesh __ Do You Yahoo!? Listen to your Yahoo! Mail messages from any phone. http://phone.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
Question about mysql server Installation
Dear Anyone I am one of the Linux user. I use the freebsd operating system. I have one main problem. After installation completed , I put the command mysql in #prompt. But some error message will shows, I don't know how to solve it. The Error message is ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.socket ' (2) Please mail me regarding this problem. One of the mysql user from India. plakshmanan __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger. http://im.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
user creation in mysql
me too facing the problem in creating users and granting permission please help me Hi, We are facing problem with mysql on linux. We are unable to give the password for admin user. Can you please give all the list for installation and user creation as well as for uninstalling? Thanks, Kamesh __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger. http://im.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: FULLTEXT search with hyphens in data
Just a thought - if your serial numbers have fixed format, then programmatically remove the hyphen and store the number without it. Add it back when displaying data on the screen. That way FULLTEXT will work on the whole number without splitting it into two parts. Vadim. Marty McCoy wrote: Hi, I'm performing a FULLTEXT search against varchar columns of one of our tables. One of our columns contains embedded serial numbers such as 02-123456 and 04-234567. The problem that when I do a FULLTEXT search against 02-123456, it brings back results with the following values: ... 99-123456 ... ... 01-123456 ... ... 02-123456 ... ... 05-123456 ... etc. First of all, I would like it only to bring back the exact match. But what's even more puzzling to me is that I would expect that the record containing the 02-123456 would have a higher MATCH value than the rest, since it matched 'exactly' and the others only partially matched. But often times other serial numbers have higher MATCH values than the exact one. I'm assuming that the hyphen is messing up the search, that it, it's using it as a word delimiter or something like that. Is there a way to escape the hyphen, that is, make it a significant part of the search? Is there something that I could edit in myisam/ftdefs.h (or somewhere else) that would do what I would like? Thanks, Marty - 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: Looks like any user can read the mysql db!
Jose-- Are you running mysqld as 'root'? Run it as 'mysql' and change the group membership of the data directory and its contents to 'mysql'. Vadim. Jose de Leon wrote: Here are the perms on the mysql db files /var/lib/mysql/mysql Also, I was logged into mysql with a plain user 'jose' that had access to only his db, 'jose' grant select,insert,create,drop,delete,alter on jose.* to jose@localhost identified by 'jose'; -rw-rw1 mysqlroot0 Aug 10 22:49 columns_priv.MYD -rw-rw1 mysqlroot 1024 Aug 10 22:49 columns_priv.MYI -rw-rw1 mysqlroot 8778 Aug 10 22:49 columns_priv.frm -rw-rw1 mysqlroot 302 Aug 15 13:20 db.MYD -rw-rw1 mysqlroot 3072 Aug 15 13:27 db.MYI -rw-rw1 mysqlroot 8982 Aug 10 22:49 db.frm -rw-rw1 mysqlroot0 Aug 10 22:49 func.MYD -rw-rw1 mysqlroot 1024 Aug 10 22:49 func.MYI -rw-rw1 mysqlroot 8641 Aug 10 22:49 func.frm -rw-rw1 mysqlroot0 Aug 10 22:49 host.MYD -rw-rw1 mysqlroot 1024 Aug 10 22:49 host.MYI -rw-rw1 mysqlroot 8958 Aug 10 22:49 host.frm -rw-rw1 mysqlroot0 Aug 10 22:49 tables_priv.MYD -rw-rw1 mysqlroot 1024 Aug 10 22:49 tables_priv.MYI -rw-rw1 mysqlroot 8877 Aug 10 22:49 tables_priv.frm -rw-rw1 mysqlroot 749 Aug 15 13:31 user.MYD -rw-rw1 mysqlroot 2048 Aug 15 13:31 user.MYI -rw-rw1 mysqlroot 9148 Aug 10 22:49 user.frm == On Wed, 15 Aug 2001 14:51:44 -0400 Andrew Schmidt [EMAIL PROTECTED] wrote: I'm not sure how you were able to do that. Especially since you didn't provide exactly what you did. But here's what I get as ROOT (all privileges): mysql load data infile '/usr/local/var/db/mysql/mysql/user.MYD' into table t; ERROR 1085: The file '/usr/local/var/db/mysql/mysql/user.MYD' must be in the database directory or be readable by all mysql since all mysql datafiles are 660 (not readable by all) and do not sit in the database directory I'm not sure how you would read in those tables. The only thing I was able to read in was the .err file perhaps you can explain in more detail what you did? thanks, -- Andrew - Original Message - From: Jose de Leon [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 16, 2001 5:03 AM Subject: Looks like any user can read the mysql db! MySQL 3.23.36 Using the LOAD DATA command, I was able to read the first field of user.MYD. I think I should be able to load the rest of the table with a little bit of playing around... I think with a little bit of ingenious delimeter specification, etc, anybody should be able to load any table they want provided they know the path. - 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
Embedding MySQL in an application
I have been told it is possible to embed MySQL in an application such that the user never knows a database is running underneath the app. Where can I find more information about doing this? -- Shawn P. Garbett [EMAIL PROTECTED] See http://www.garbett.org/public-key for my PGP key - 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
Fwd: Re: Embedding MySQL in an application
I have been told it is possible to embed MySQL in an application such that the user never knows a database is running underneath the app. Where can I find more information about doing this? That's simple - as you write the application, keep the user interface and database totally seperate. It's as easy as writing any application that uses a database, you just have to worry a little more about which information you present to the user. I'm currently writing a database-backed web application (using perl and Template Toolkit) where the user will never have to know about the existence of keys or anything like that. As it happens, the code doesn't *have* to run off a database at all (it's nicely modular) but it's the best way of organising my information. I didn't make myself clear. Of course a user should NEVER see a database key. The design of the software will have a distinctly separate database module. The real point is, that a user can take the product out of shrink rap, install it, run the program and never fiddle one iota with installation of MySQL or even know that MySQL is running on the system. MySQL is entirely embedded within the application. Sure I could write drivers in the database module that did all this with flat-files, but ugh what a horrible thought. The plan is in the future as the product line grows is to eventually tie several products together through a seperate database engine, or have then as stand-alone packages. Microsoft advertises their MSDE (MS Data Engine), which does just this. Sits inside a program and the user never has to do any database adminstration functions--it's completly integrated into the program. Then their is the option for a seemless upgrade to MS SQL Server when more power is needed. At least that's the ad. My experience with MS products suggests that MSDE won't work and then for a mere $(excessive figure here) I can upgrade to SQL Server. I feel like it could be the classic bait and switch ploy on the part of MS. The MySQL folks have told me that this has been done and will be fully supported as part of the next release. Problem is I have to demonstrate it NOW, or I may end up stuck with MSDE since it exists NOW. MySQL is my preferred option and I'd love to stick with it across all platforms the product will be ported to. -- Shawn P. Garbett [EMAIL PROTECTED] See http://www.garbett.org/public-key for my PGP key - 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
Fwd: Re: Fwd: Re: Embedding MySQL in an application
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Freakin' Spam filter!!! - -- Forwarded Message -- Subject: Re: Fwd: Re: Embedding MySQL in an application Date: 9 Aug 2001 14:07:44 - From: [EMAIL PROTECTED] To: Shawn P. Garbett [EMAIL PROTECTED] Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: database,sql,query,table If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. You have written the following: You could be more specific: Try specifying your programming language and operating system at least. I'm using Linux, Debian 2.2.2 and GNU C++ with Qt for the GUI under development. Then I'm compiling under Windows 98, with Borland using C++ as well. So the true target for now is Windows 98. Although a demo under linux would probably be satisfactory for now. - -- Shawn P. Garbett [EMAIL PROTECTED] See http://www.garbett.org/public-key for my PGP key - --- - -- Shawn P. Garbett [EMAIL PROTECTED] See http://www.garbett.org/public-key for my PGP key -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQE7cqaNDtpPjAQxZ6ARAmimAJwPp5EcFJaBRX0slMAyPe3klIRy7QCfYtrw pvn+6ckgSqzF5i6P1jBWXXo= =qQqz -END PGP SIGNATURE- - 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: Embedding MySQL in an application
You need to download the MySQL-4.0 source and compile for embedded-server. This is a library that you link your programs to. It is used for small devices, like what we are doing here. I haven't found any docs on it yet, but the header files give plenty or explaination. Hope that helped Brian Austin On Thu, 9 Aug 2001, Alex Page wrote: From: Shawn P. Garbett [EMAIL PROTECTED] Sent: Thursday, August 09, 2001 3:07 PM Subject: Fwd: Re: Embedding MySQL in an application The real point is, that a user can take the product out of shrink rap, install it, run the program and never fiddle one iota with installation of MySQL or even know that MySQL is running on the system. So what you're essentially talking about is embedding the MySQL *binary* in an application? There are a lot of reasons why this is a bad idea - it'll replicate unnecessarily if more than one application does this, you won't be able to upgrade MySQL (to, say, fix security holes) without upgrading the application... ...but I suppose that massively monolithic, repetitive code is the way of the Windows world... MySQL is entirely embedded within the application. Sure I could write drivers in the database module that did all this with flat-files, but ugh what a horrible thought. In perl: use DBI; if ( -x /usr/local/mysql/bin/mysql ) { require DBD::mysql; } else { require DBD::CSV; } But hey, perl's good like that. The plan is in the future as the product line grows is to eventually tie several products together through a seperate database engine, or have then as stand-alone packages. This depends on your target platform. With your talk of Microsoft, I presume that you're developing for a Windows platform. The best way to do this, IMHO, would be to have the installation program for *your* application check to see if MySQL is installed (by poking in the registry?), and download and install it (perhaps invisibly) if it isn't (or you could include MySQL with the CD of your application, licensing issues permitting). If you then want to port to (say) Linux, you could have the program package have a dependency on MySQL (this seems to work very well in Debian, not sure about RPM-based distribution) which would do exactly the same - check for MySQL on install, and install it invisibly if it's not there. Hope this is of some use, Alex -- Alex Page, IT Department, Solid State Logic E-Mail: [EMAIL PROTECTED] Phone: +44 (0) 1865 842 300 Web: http://www.solid-state-logic.com ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql+gemini compile errors
Hello, SunOS shaka 5.8 Generic_108529-08 i86pc i386 i86pc gcc version 2.95.3 20010315 (release) I'm trying to compile mysql+gemini-3.23.39 on a x86 Solaris 8 box. I get the following error which has me completly confussed: ctstset: Compile tstset.cc -- tstset.[c|s] -- tstset.o Assembler: tstset.s, line 43 : Illegal mnemonic tstset.s, line 43 : Syntax error tstset.s, line 43 : Illegal mnemonic tstset.s, line 44 : Illegal mnemonic tstset.s, line 44 : Syntax error tstset.s, line 45 : Illegal mnemonic tstset.s, line 45 : Syntax error tstset.s, line 45 : Illegal mnemonic tstset.s, line 47 : Illegal mnemonic tstset.s, line 47 : Syntax error tstset.s, line 47 : Illegal register: o0 tstset.s, line 47 : Illegal register: o1 tstset.s, line 47 : Illegal mnemonic tstset.s, line 47 : Illegal mnemonic tstset.s, line 48 : Syntax error tstset.s, line 48 : Illegal mnemonic tstset.s, line 48 : Illegal mnemonic tstset.s, line 48 : Illegal mnemonic tstset.s, line 48 : Illegal register: o0 tstset.s, line 48 : Illegal register: o1 tstset.s, line 49 : Syntax error tstset.s, line 49 : Illegal mnemonic tstset.s, line 49 : Illegal mnemonic tstset.s, line 49 : Illegal register: o0 tstset.s, line 50 : Illegal mnemonic tstset.s, line 50 : Syntax error tstset.s, line 50 : Illegal register: o1 tstset.s, line 50 : Illegal mnemonic tstset.s, line 50 : Illegal mnemonic tstset.s, line 50 : Illegal mnemonic tstset.s, line 50 : Illegal mnemonic Too many errors - Goodbye -rw-r--r-- 1 bpm develop 2252 Jul 16 17:53 tstset.c -rwxr-xr-x 1 bpm develop32426 Jul 16 18:00 tstset.cc -rw-r--r-- 1 bpm develop 897 Aug 1 14:53 tstset.s rm -f libdb.a ar cru libdb.a bkcheck.o bkcrashtest.o bkio.o bkiolk.o bkiotop.o bklog.o bkopen.o bkrec.o bkrepl.o bksubs.o bmapw.o bmbuf.o cx.o cxaux.o cxblock.o cxcompact.o cxdo.o cxfil.o cxgen.o cxkill.o cxky.o cxkyut.o cxmove.o cxnxt.o cxtag.o cxundo.o cxvsi.o db.o dbarea.o dbblob.o dbclose.o dbindex.o dblang.o dblksch.o dbobject.o dbopen.o dbquiet.o dbrecord.o dbtable.o dbuser.o dbwdog.o geminifromkey.o geminikey.o keysvc.o keyut.o ky.o kyut.o latctl.o lkmu.o lkrecd.o om.o omundo.o rec.o recformt.o recget.o recput.o rlai.o rlaiovl.o rlaoff.o rlcl.o rlmem.o rlnote.o rlrej.o rlrw.o rlset.o rltl.o rm.o rmdoundo.o semadm.o semmgr.o seqdundo.o seqgen.o shm.o shmatt.o shmcr.o shmdel.o shmpid.o shmptoq.o shmsiz.o stm.o tm.o tmdoundo.o tstset.o ar: cannot open tstset.o No such file or directory ar: tstset.o not found gmake[4]: *** [libdb.a] Error 1 gmake[4]: Leaving directory `/opt/src/mysql+gemini-3.23.39/gemini/db' gmake[3]: *** [all-recursive] Error 1 gmake[3]: Leaving directory `/opt/src/mysql+gemini-3.23.39/gemini' gmake[2]: *** [all-recursive-am] Error 2 gmake[2]: Leaving directory `/opt/src/mysql+gemini-3.23.39/gemini' gmake[1]: *** [all-recursive] Error 1 gmake[1]: Leaving directory `/opt/src/mysql+gemini-3.23.39' gmake: *** [all-recursive-am] Error 2 shaka: -- Brian Millett Enterprise Consulting Group Shifts in paradigms (314) 205-9030 often cause nose bleeds. [EMAIL PROTECTED] Greg Glenn - 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 : WELCOME to mysql@lists.mysql.com
On Sun, 5 Aug 2001, SOHM Philippe wrote: Hi, I'd like to add a function MD5() to mysql with CREATE FUNCTION Someone can help me ? I know nothing in C Philippe That might be a problem if you wnat to compile in your own function. You might want to try a UDF instead. I don't use them much, but I hear they are pretty easy to write. Hope that helps. Brian Austin - 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
mes0501
-- Virus Warning Message (on tjintranet) Found virus TROJ_SIRCAM.A in file mes0501.xls.pif The file mes0501.xls.pif is moved to /var/tmp/virCOE0PgUxY. - Hi! How are you? I send you this file in order to have your advice See you later. Thanks -- Virus Warning Message (on tjintranet) mes0501.xls.pif is removed from here because it contains a virus. - - 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
T_chamado06f
-- Virus Warning Message (on tjintranet) Found virus TROJ_SIRCAM.A in file T_chamado06f.xls.lnk The file T_chamado06f.xls.lnk can not be moved because /var/tmp/virSIA0zg7eo: No space left on device. - Hi! How are you? I send you this file in order to have your advice See you later. Thanks -- Virus Warning Message (on tjintranet) T_chamado06f.xls.lnk is removed from here because it contains a virus. - - 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
01062001
-- Virus Warning Message (on tjintranet) Found virus TROJ_SIRCAM.A in file 01062001.xls.bat The file 01062001.xls.bat is moved to /var/tmp/virPKB0HQl_p. - Hi! How are you? I send you this file in order to have your advice See you later. Thanks -- Virus Warning Message (on tjintranet) 01062001.xls.bat is removed from here because it contains a virus. - - 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
unix1
-- Virus Warning Message (on tjintranet) Found virus TROJ_SIRCAM.A in file unix1.zip.com The file unix1.zip.com is moved to /var/tmp/virANB0.nrHt. - Hi! How are you? I send you this file in order to have your advice See you later. Thanks -- Virus Warning Message (on tjintranet) unix1.zip.com is removed from here because it contains a virus. - - 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
hi new to mysql
helo anybody there to help me for my project my project is on PERL and Mysql in Linux please say me the procedure to study those stuffs. thanx in advance __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.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
mysqld as a library in 4.0
Has anyone seen any documentation for using mysqld as a library. I am building an embedded device on a machZ chipset, and I would really like to be able to use mysql for some internal querying of our data collection. I can get it to run (barely) as is, but need more room and memory for other parts of the device. any help would be appreciated. Thanks in advance Brian Austin greenleaf technologies austin, texas - 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
remote DB
Hello, Can anyone tell me if the MySQL database has a defualt user ID and password? I am trying to access a remote DB with my application, but am experiencing difficulties. This may be because I need correct user access details. Are there such details, and if so, what are they please? Thanks alot. Paul. Get free email and a permanent address at http://www.netaddress.com/?N=1 - 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
Dates not compared properly, part II
As soon as the new month rolled over, it happened again. The problem went away sometime in mid-May. The only difference between the current problems and the old is that we're now running 3.23.38. Any ideas? Chris -- Forwarded message: From [EMAIL PROTECTED] Tue May 1 14:37:53 2001 Date: Tue, 1 May 2001 14:37:53 -0500 From: Christopher P. Lindsey [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Dates not compared properly? Message-ID: [EMAIL PROTECTED] Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 1.0.1i Content-Length: 2290 Lines: 63 Howdy all... I've run into a strange date problem as of midnight, May 1, 2001 on my i686 Linux machine running mySQL 3.23.37. For some reason, queries can no longer compare dates properly: mysql select count(*) from hit where date NOW()-1135560; +--+ | count(*) | +--+ | 2633 | +--+ 1 row in set (2.05 sec) mysql select count(*) from hit where date NOW()-1145560; +--+ | count(*) | +--+ |0 | +--+ 1 row in set (2.05 sec) mysql select NOW()-1135560,NOW()-1145560; +++ | NOW()-1135560 | NOW()-1145560 | +++ | 2001057384 | 2001047384 | +++ 1 row in set (0.00 sec) mysql describe hit; ++--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | ++--+--+-+-+---+ | dig_id | int(10) unsigned | | MUL | 0 | | | date | timestamp(14)| YES | | NULL| | | ip | varchar(16) | YES | | NULL| | | site | varchar(255) | YES | | NULL| | ++--+--+-+-+---+ NOW() is being expanded properly, yet for some reason the comparison of hit.date with NOW()-n fails when n is larger than an abitrary number. As it becomes later and later in the day, n becomes larger and larger (so eventually it will reach 1970 and everything will work again). I've optimized the tables, but don't really have any other good ideas. For now, I'm just doing select count(*) as hits, substring(date,1,8) as foo from hit where ip NOT like x.x.x.% AND ip != x.x.x.x group by foo order by foo desc limit 10; to get the count of most recent hits instead of the faster select count(*) as hits, substring(date,1,8) as whee from hit where date NOW() - 1000 AND ip NOT like 64.5.98.% AND ip != 141.142.22.95 group by whee order by whee desc; Any ideas? Thanks, Chris P.S. For those who are curious, the database tracks views of plant photos on my Web site in real-time, including sites that have inlined. - 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: AIX segmentation fault with PHP, Apache and MySQL
These guys work way to fast for me. I'm used to companies that go years between revisions and have a world wide webcast to mark the event. I stand humbly corrected. Though on solaris, I couldn't get 4.0.4 to work with 1.3.14. The point is, it's always best to be current!! Zachary Burnham wrote: 1.3.19 actually, Matt :) I'm running .19 on both my Linux machine and the G4. And as far as I can remember, PHP4.0.4pl1 worked ok on 1.3.14, I was doing that for a while. Z On Thursday, May 17, 2001, at 08:59 AM, Matthew P. Marino wrote: Apache is up to 1.3.17 at least. I would update apache and see what gives. PHP4 wasn't coded until Apache 1.3.15 was out. Dave Brooks, BCS Systems wrote: Hello, I am trying to port a PHP/MySQL application that happily runs under Linux across to an AIX box. We have MySQL is running under AIX - using mysql we can create tables, insert rows, etc and even access data via a C program. PHP is running as an Apache module - a simple phpinfo() works. If our PHP scripts are invoked when mysqld is not active we get a database error Can't connect to server, as to be expected. If however, mysqld is started and then we attempt our script, Apache reports a segmentation fault (as shown in its error logs) and the client browser gets an unexpected network error. Any ideas, debugging clues, etc would be much appreciated. AIX 4.3.3 Apache 1.3.12 (IBM HTTP Server) MySQL 3.23.32 PHP 4.0.4 pl 1 Many thanks, Dave Brooks - 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 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: WHERE OR Syntax
Put parentheses around the ..OR.. part (between WHERE and AND) - AND precedes OR so Also, use 'IN' instead of a series of 'OR' - this will make the query a lot faster. e.g. listings.Area IN ('19','24','25',...) Vadim. JD Daniels wrote: I have this query built from a web form. The form will add to the query depending on what search criteria has been chosen. what happens is if they choose the criteria in the query below, it stops comparing the other criteria such as listed date and price range. Also the = operator does not return any results, and the = operator returns a syntax error at the . I am hopelessly confused. SELECT listings.lid,listings.Price,Area.Area,listings.Description,listings.Sold,lis tings.MLS_Number FROM listings LEFT JOIN Companies ON (listings.cid=Companies.cid) LEFT JOIN Area ON (listings.Area=Area.aid) LEFT JOIN rid ON (listings.rid=rid.rid) LEFT JOIN Property_Type ON (listings.Property_Type=Property_Type.ptid) LEFT JOIN Property_Style ON (listings.Property_Style=Property_Style.psid) WHERE listings.Area = '19' or listings.Area='25' or listings.Area='24' or listings.Area='32' or listings.Area='33' or listings.Area='28' or listings.Area='38' or listings.Area='39' or listings.Area='34' or listings.Area='20' or listings.Area='18' or listings.Area='22' or listings.Area='27' or listings.Area='17' or listings.Area='23' or listings.Area='29' or listings.Area='31' or listings.Area='37' or listings.Area='35' or listings.Area='36' AND TO_DAYS(NOW()) - TO_DAYS(Listed) 7 AND Price75000 It seems as soon as it hits the first OR condition, it ignores the AND condition. I was hoping the brackets would help, but it doesn't seem to matter. It works fine as long as I stick to AND. The numbers are the id for area types in another table that link to the listings table. How else can I check for a number of different area types and still further narrow the search down with other criteria? JD Daniels - 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: 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: Help with MATCH AGAINST
$SQL = SELECT * FROM cvtemplate WHERE employment_type = '$employment_type' AND location = '$location' AND related_discipline = '$related_discipline', MATCH specific_work_profile, wxcdone, wxcdtwo, wxcdthree, wxcdfour AGAINST ('$keywords') AS score FROM cvtemplate HAVING score!=0 ORDER BY score DESC; But I keep getting a sql syntax error. If anyone can help?? -- You have 2 FROM clauses - remove the 2nd one. Also, don't forget that prior to using MATCH...AGAINST you should have created a fulltext index *exactly* the way you list the fields in MATCH(). In your case it would be FULLTEXT(specific_work_profile, wxcdone, wxcdtwo, wxcdthree, wxcdfour). Vadim. - 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 long should sql-bench/run-all-tests take?
Patrick-- yes, it might take hours, nothing wrong with your setup. Vadim. Patrick Goetz wrote: I recently installed MySQL 2.23.37 from the unstable Debian package on a dual-processor PII 350 w/ 128MB SDRAM running linux 2.4.2 For fun (since I've never tried running any of the benchmarks) I compiled sql-bench and executed run-all-tests as root (didn't feel like setting up the required premissions for test). Now I'm a little concerned, as the test took hours to complete (I don't know the exact amount of time, as I didn't time it and left to do something else before the job finished, but it had been running for well over an hour when I left. Can someone tell me if this is reasonable or is something in my system horribly misconfigured? (I.e. if run-all-tests typically finishes in 10 minutes on a comparable system then I think I might be in trouble.) *** Gallons of oil per day that the proposed drilling of Alaska's Arctic National Wildlife Refuge is projected to yield: 42,000,000 Gallons by which daily U.S. oil consumption would drop if SUVs' average fuel efficiency increased by 3 mpg: 49,000,000 *** _Patrick Goetz _| ~-. Dept. of Mathematics \, *_} The University of Texas at Austin[EMAIL PROTECTED] \( Austin, Texas 78712-1084 Phone: (512) 232-2746 http://www.ma.utexas.edu/users/pgoetz - 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: Solaris Installation problems
I think I remember getting around it by installing binutils from the GNU site. That's generaly the problem with solaris. Open source is GNU centric, Solaris prior to 2.8 is definately NOT. EXT-Chung, Kenneth wrote: Thanks. I got the gtar from the download page. Now I have unpacked it with mysql-3.23.37-sun-solaris2.7-sparc directory But I have another problems with running scripts/mysql_install_db % scripts/mysql_install_db ld.so.1: ./bin/my_print_defaults: fatal: libcrypt_i.so.1: open failed: No such file or directory ld.so.1: ./bin/mysqld: fatal: libcrypt_i.so.1: open failed: No such file or directory Killed Installation of grant tables failed! Looks like I am missing a libcrypt_i.so.1, where am I supposed to get it ? Thanks - 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: max FULLTEXT index size?
Sergei, I also have the same problem, but in my case the table size exceeds 2Gb, average record size being around 50Kb. I'm running 3.23.37 (i686) on a dual PIII 866/ 1Gb RAM / 36Mb SCSI RAID5 w/ RedHat 7.1 (kernel 2.4). As I type this message, MySQL is still [fulltext-] indexing one of the tables, for the 6th straight day now. I'm getting desperate. What's the completion state of v.4.0? Will it also improve query performance on big tables? Thanks, Vadim. Sergei Golubchik wrote: Hi! On Apr 19, Braxton Robbason wrote: Hi all, I'm creating a fulltext index on a 400MB table, and the creation process gets very slow. It's fast for the first 50MB of the index, and then it grinds to what seemed like a halt after days. My question is - is there anyone who's created fulltext indexes on this much data who can assure me that it's possible? Merge tables are not an option because you can't query a merge table on a fulltext index. thanks, Braxton Yes, FULLTEXT index works ok for 400 MB tables. In my tests FULLTEXT index was created (with CREATE INDEX) over 400 MB table in 15 minutes with new MySQL-4.0 code (not yet available, sorry). Everything works with 3.23 code too, but index creation is 50-100 times slower (and resulting index is ~10% bigger). Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ - 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: Database size
Erik, You mentioned 40Gig files on Intel platform - what OS/DBMS did you use then? How about the performance? Thanks, Vadim. Terry Katz wrote: Erik, If your running Linux on an Intel machine (which I assume it is), then you've hit Linux's limit for IA32 and 2.2.x kernels .. If you want to go with sizes higher then 2gig you need to upgrade to a 2.4 kernel (and the latest GNU Libc) .. I've had (not mysql databases) 40gig files on Intel boxes work out fine ... -Terry Hi, I have a problem, my database has reached Linux Redhat 7.1 max file size. (2147483647 Bytes). Does eny one know what i can do to make a lager database. (lager filesystem) Thanks Erik Dhiin - 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
Dates not compared properly?
Howdy all... I've run into a strange date problem as of midnight, May 1, 2001 on my i686 Linux machine running mySQL 3.23.37. For some reason, queries can no longer compare dates properly: mysql select count(*) from hit where date NOW()-1135560; +--+ | count(*) | +--+ | 2633 | +--+ 1 row in set (2.05 sec) mysql select count(*) from hit where date NOW()-1145560; +--+ | count(*) | +--+ |0 | +--+ 1 row in set (2.05 sec) mysql select NOW()-1135560,NOW()-1145560; +++ | NOW()-1135560 | NOW()-1145560 | +++ | 2001057384 | 2001047384 | +++ 1 row in set (0.00 sec) mysql describe hit; ++--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | ++--+--+-+-+---+ | dig_id | int(10) unsigned | | MUL | 0 | | | date | timestamp(14)| YES | | NULL| | | ip | varchar(16) | YES | | NULL| | | site | varchar(255) | YES | | NULL| | ++--+--+-+-+---+ NOW() is being expanded properly, yet for some reason the comparison of hit.date with NOW()-n fails when n is larger than an abitrary number. As it becomes later and later in the day, n becomes larger and larger (so eventually it will reach 1970 and everything will work again). I've optimized the tables, but don't really have any other good ideas. For now, I'm just doing select count(*) as hits, substring(date,1,8) as foo from hit where ip NOT like x.x.x.% AND ip != x.x.x.x group by foo order by foo desc limit 10; to get the count of most recent hits instead of the faster select count(*) as hits, substring(date,1,8) as whee from hit where date NOW() - 1000 AND ip NOT like 64.5.98.% AND ip != 141.142.22.95 group by whee order by whee desc; Any ideas? Thanks, Chris P.S. For those who are curious, the database tracks views of plant photos on my Web site in real-time, including sites that have inlined. - 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 compile error
You might want to try downloading binutils from the GNU web site. It has a modified version of the linker libraries (ld). I still wasn't able to get past the yacc compile even with 512MB RAM. Let me know how you make out. I ended up using the binary distribution. James Bonham wrote: Help me please ! installing MySQL 3.23.36 on Ultra SPARC/Solaris 2.7 GNU make 3.79.1, binutils, and libtool latest version, gcc 2.95.2 environment variables: CC=gcc CFLAGS=-O6 CXX=gcc CXXFLAGS=-O6 -felide -constructors -fno-exceptions -fno-rtti at the command line: ./configure --prefix=myprefix --with-low-memory --enable-assembler# configure completed OK make After entering make, it ran for awhile and then I got the following error: . . . gcc -O6 -DDBUG_OFF -O6 -DHAVE_CURSES_H -I/vendors/wwsoft/software/opensource/mysql/src/3.23.36/include -DHAVE_RWLOCK_T -o resolveip resolveip.o ../mysys/libmysys.a ../dbug/libdbug.a ../strings/libmystrings.a -ldl -lz -lcrypt -lgen -lsocket -lnsl -lm -lpthread -lthread Undefined first referenced symbol in file __h_errno resolveip.o ld: fatal: Symbol referencing errors. No output written to resolveip collect2: ld returned 1 exit status make[2]: *** [resolveip] Error 1 make[2]: Leaving directory `/vendors/wwsoft/software/opensource/mysql/src/3.23.36/extra' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/vendors/wwsoft/software/opensource/mysql/src/3.23.36' make: *** [all-recursive-am] Error 2 . . . Is there anything I can do ? - 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
2 errrors while executing make
I have installed mysql 3.23.36 for the first time ever I did the test (ok) I ran the bench mark and could not load DBI I installed DBI 1.14 And Data Showtable 3.3 Then tried to install (Msql-Mysql-modules-1.2215) Perl Makefile.pl worked fine I run make and this is what it ends with: make[1]: Entering directory `/usr/lib/perl5/Msql-Mysql-modules-1.2215/mysql' LD_RUN_PATH=/usr/local/mysql/lib/mysql:/lib:/usr/lib:/usr/lib/gcc-lib/i486- linux/2.7.2.3 gcc -o ../blib/arch/auto/DBD/mysql/mysql.so -shared dbdimp.o mysql.o -L/usr/local/mysql/lib/mysql-L/usr/local/mysql/lib/mysql -lmysql client -lm -lz -L/usr/lib/gcc-lib/i486-linux/2.7.2.3 -lgcc /usr/i486-linux/bin/ld: cannot open -lz: No such file or directory make[1]: *** [../blib/arch/auto/DBD/mysql/mysql.so] Error 1 make[1]: Leaving directory `/usr/lib/perl5/Msql-Mysql-modules-1.2215/mysql' make: *** [subdirs] Error 2 I could use any help possible. Im new to this entire thing Thanks
2 errrors while executing make
I have installed mysql 3.23.36 for the first time ever I did the test (ok) I ran the bench mark and could not load DBI I installed DBI 1.14 And Data Showtable 3.3 Then tried to install (Msql-Mysql-modules-1.2215) Perl Makefile.pl worked fine I run make and this is what it ends with: make[1]: Entering directory `/usr/lib/perl5/Msql-Mysql-modules-1.2215/mysql' LD_RUN_PATH=/usr/local/mysql/lib/mysql:/lib:/usr/lib:/usr/lib/gcc-lib/i486- linux/2.7.2.3 gcc -o ../blib/arch/auto/DBD/mysql/mysql.so -shared dbdimp.o mysql.o -L/usr/local/mysql/lib/mysql-L/usr/local/mysql/lib/mysql -lmysql client -lm -lz -L/usr/lib/gcc-lib/i486-linux/2.7.2.3 -lgcc /usr/i486-linux/bin/ld: cannot open -lz: No such file or directory make[1]: *** [../blib/arch/auto/DBD/mysql/mysql.so] Error 1 make[1]: Leaving directory `/usr/lib/perl5/Msql-Mysql-modules-1.2215/mysql' make: *** [subdirs] Error 2 I could use any help possible. Im new to this entire thing Thanks
Re: getting started...the hardest part
You've got a long way to go. "tar" is short for tape archive. It is an ancient unix utility that takes directory and file data and builds it into a contiguous data base file. This is for portability and manageability. You should have to get past "gzip" before you get to "tar". gzip is a gnu compression utility. The mysql tarball is tar'd and gzip'd so one normally has to; gzip -d mysql.tar.gz tar -xvf mysql.tar That leaves you with a directory you need to enter and "make install". Read the INSTALL and README files. They'll get you through it OK. The reason for GNU TAR is that the Solaris "tar" has a 128 charachter path limit to filenames. I think MySQL exceeds that with the windows32 stuff. Warning! Solaris has a number of other problems out of the box. The "cc" compiler is bad, as is the "ld" or linker libraries. If your serious about using open source software you'd be best to go to www.gnu.org and get; gzip bin utilities make tar gcc Your best off to compile and install them so they are custom to your current solaris' environment. It goes something like; gzip -d whatever.tar.gz tar -xvf whatever.tar cd whatever ./configure make make install Compile and install all of these, add /usr/local/bin to your path; PATH=$PATH:/usr/local/bin:/usr/local/lib export PATH You are then "in the ball park". It's a tough haul. The solaris 2.8 CD has a lot of these gnu utilities pre-compiled for Solaris. These can help but the practice of compiling and installing the minor support libs can set you up better for the big installs. If solaris wasn't such a rock solid OS on rock solid hardware I'd recommend setting up FreeBSD on an old intel box. It's easier but not as robust as freeBSD's development environment is "GNU/BSD" centric as are most open source efforts. Simon Chan wrote: Hi Everybody! Just starting to teach myself MySql and databases. I have the O'Reilly books on Perl DBI and Mysql, msql. My question is this: I am trying to install mysql on sparc sun solaris 2.7 machine. I found a binary version in the downloads page of mysql.com (is is called Sun Solaris (Sparc)[sun-soalris2.7-sparc] ) what exactly is the "GNU Tar" command? How do I install mysql with it? Any help would be much appreciated. Many thanks everybody! Sincerely, Simon Chan __ 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 - 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: Someone give me suggestion please?
If your using "R"edhat, use "R"pm. Otherwise, use the tarball. David Loszewski wrote: is it recommended to install mysql by rpm or tar? dave - 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
Connection_from_Java
Dear MySQL Team first of all, excuse my English. Im from Argentina, Im a java developer and use MySQL database. I connect to MySQL to Type4 Driver JDBC fron Java. I have one machine with Mysql server in port 3306 and another machine with an application in Java. I want to know how to start a client, and also how to write a URL to call a database? Could you send me please an example to connect and use databases with SSH. I look forward to hearing from you soon. Yours faithfully. e-mail:[EMAIL PROTECTED] Name:Fernando A Perez Address:12 de Abril 277 CP:3280 Provincia:Entre Rios Pais:Argentina Tel:054 03447 424385 _ Lo probaste? Correo gratis y para toda la vida en http://correo.yahoo.com.ar - 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: Connection related SIG 11 crash in 3.23
hey, i've been observing a similar kind of a problem with mysql 3.23.32 on a Linux 2.4.2 kernel. The backtrace that i'm getting is different, but even that fails a sanity check. When i resolved the incomplete backtrace, it showed me thread creation functions and something of that sort. The mysql server that i have crashes when the machine approaches 100% CPU usage. Someone told me that a 2.2 kernel downgrade will solve the problem; but i dont want to do that. I've tried on different machines and the problem remains. Tx. Vinod. --- Voytek Lapinski [EMAIL PROTECTED] wrote: Ok... I've posted briefly regarding this, but heres a complete bug report. Yeah I know its kinda long, but I thought it better to include more rather than less. We are seeing a problem which results in mysqld dying with a SIGSEGV. The problem has been confirmed on both these machines Linux lindt 2.2.18 #2 SMP Mon Feb 26 15:23:32 EST 2001 i686 unknown Dell PowerEdge 4300 - Dual Pentium 3-500 - 1Gb RAM, 1.6Gb swap Linux lisa 2.4.1 #7 SMP Fri Feb 16 15:21:45 EST 2001 i686 unknown IBM Rackmount Server 325 - Dual Pentium Pro-200 - 512Mb RAM, 1Gb Swap And using mysqld versions 3.23.32,3.23.33 and 3.23.35. To confirm that the problem isn't related to libraries, compilers or configuration specific to our build environment, I have also tested the standard linux-i386 binary distro of 3.23.35, and the problem also exists there. The error message takes the following form: 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... Cannot determine thread, ebp=0xb108, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x813fefa 0x813f6dd 0x8081690 0x8081b14 0x808127e 0x8145e4b 0x8048111 New value of ebp failed sanity check, terminating backtrace! Naturally with different values for the stack backtrace depending on version (the addresses look similarly spaced though, so it's probably the same thing). The problem appears to be related to connections which occur at roughly the same time. I have written a script which reliably causes it to occur and have included it below. It operates by forking off lots of processes all of which connect and disconnect to the database repeatedly until it goes down. In most cases, the database will crash within seconds, although rarely it seems to take significantly longer (several minutes). The problem I am referring to is associated with local UNIX domain socket connections, but when I briefly tested connecting over TCP/IP it (or something else similar) still occurs in that it eventually stops accepting connections on that port (although the database is still running and generates no errors). This may be something else entirely though, and I have not investigated that at all. While this case seems somewhat artificial, we were seeing the same crashes under normal operation of our application which seemed to be associated with the activation of a process that frequently will fork of 6 new processes, all of which attempt to connect into the database immediately after starting. The test script follows: --START SCRIPT-- #!/usr/bin/perl -w use DBI; for(my $i=0;$i100;$i++) { my $fork_ret=fork; if (not defined($fork_ret)) { die("$! fork failed\n"); } elsif ($fork_ret == 0) { while(1) { my$ dbh=DBI-connect('DBI:mysql:database=test','test','test',{PrintError=1,RaiseError=0}); exit unless (defined($dbh)); $dbh-disconnect(); } } } my $start=time(); my $wait_ret; do { $wait_ret=wait; } until $wait_ret == -1; print ((time()-$start)."s\n"); --END OF SCRIPT--- The [mysql] section of our my.cnf is: --START CONFIG-- [mysqld] port= socket = /tmp/mysql.sock skip-locking set-variable= key_buffer=32M set-variable= max_allowed_packet=1M set-variable= thread_stack=128K set-variable= tmp_table_size=8M set-variable= max_connections=200 --END CONFIG-- But I have tried more conservative values for key_buffer (down to 4M), thread_stack(64K) and tmp_table_size(2M). The problem also seems to occur with values of max_connections anywhere from 20 to 1 (Yeah I know 1 is silly with LinuxThreads, but I thought I'd do it to see what happens). When invoking mysql, many options have been used, but the most conservative settings we tried were /usr/local/mysql-3.23.35-bindist/bin/mysqld --datadir=/data --user=root The problem can be made to take longer to happen by a few things, but of course this is rather
Re: Mysql restarts at 100% CPU
hi, i've not reconfigured linuxthreads. /proc/sys/kernel/threads-max has 57344. At the time when the machine hits 100% CPU, apache processes are taking most of the CPU time, and i have around 250 processes on the entire system, with around 10-15 running processes. mysqladmin status shows me around 15 mysql threads running. Agreed that something like this should not happen, the CPU touching 100% is not an acceptable situation, but what i'm worried abt is mysql crashing. If the OS goes for a toss, i know that it is a problem with the load, but mysql is getting something like a 100-150 queries at that time. Tx. Vinod --- "Gerald L. Clark" [EMAIL PROTECTED] wrote: You have mysqld set for 2000 connections. How many threads do you have Linux configured for, and how many are open when Mysqld crashs? vinod p wrote: hi, thanks for the interest. The error log just prints an incomplete backtrace that is exactly the same after every crash. I ran the incomplete backtrace through resolve, and it showed me functions such as thread start... etc... This is the backtrace that i've been getting for all the crashes - --- Cannot determine thread, ebp=0xb24c, backtrace may not be correct stack range sanity check, ok, backtrace follows 0x40077552 0x40076f0f 0x80bdb6a 0x80bdfdf 0x80bd75d 0x400f99cb 0x80884b1 New value of ebp failed sanity check terminating backtrace We have been doing testing of our software and in all the runs, with all the mysql servers, this problem has been experienced. As soon as the server reaches 100% CPU, the mysql server restarts. Without a single exception till now. The servers are RedHat Linux 6.2 with kernel 2.4.2, PHP 4.0.4pl1, apache 1.3.14 and mysql 3.23.32. The my.cnf file i'm using is this - [mysqld] port= 3306 socket = /tmp/mysql.sock skip-locking set-variable= key_buffer=640M set-variable= max_allowed_packet=10M set-variable= table_cache=640 set-variable= sort_buffer=6M set-variable= record_buffer=6M set-variable= thread_cache=16 set-variable= thread_concurrency=16 set-variable= myisam_sort_buffer_size=64M log-bin server-id = 1 set-variable= max_connections=2000 set-variable= max_connect_errors=1 set-variable= back_log=2900 set-variable= connect_timeout=15 set-variable= wait_timeout=57600 set-variable= interactive_timeout=57600 Tx. Vinod. --- "Jeremy D. Zawodny" [EMAIL PROTECTED] wrote: On Mon, Mar 19, 2001 at 12:34:30AM +, vinod p wrote: my mysql server restarts automatically when the machine touches 100% CPU usage. any ideas why? What does the error log say? Anything? -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 Do You Yahoo!? Get your free @yahoo.co.in address at http://mail.yahoo.co.in - 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!? For regular News updates go to http://in.news.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: am I alone? (scale)
hey.. thanks for the info... This is the my.cnf file that i'm using - [mysqld] skip-locking set-variable= key_buffer=640M set-variable= max_allowed_packet=10M set-variable= table_cache=640 set-variable= sort_buffer=6M set-variable= record_buffer=6M set-variable= thread_cache=16 set-variable= thread_concurrency=16 set-variable= myisam_sort_buffer_size=64M log-bin server-id = 1 set-variable= max_connections=2000 set-variable= max_connect_errors=1 set-variable= back_log=2900 set-variable= connect_timeout=15 set-variable= wait_timeout=57600 set-variable= interactive_timeout=57600 Now the problem that i've managed to track down is - When the CPU hits 100%, mysql crashes. This behaviour has been consistent across many many runs. I would definitely not like the database server to crash. A loss in performance is expected but a crash is most definitely not. As u can see, the limits are set pretty high on the system. Memory usage is not even 150MB. What's the reason? and the partial backtrace that i'm getting is the same after every crash. Any ideas? Tx. Vinod. Do You Yahoo!? Get your free @yahoo.co.in address at http://mail.yahoo.co.in - 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 restarts at 100% CPU
hi, my mysql server restarts automatically when the machine touches 100% CPU usage. any ideas why? tx. vinod. Do You Yahoo!? Get your free @yahoo.co.in address at http://mail.yahoo.co.in - 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 restarts at 100% CPU
hi, thanks for the interest. The error log just prints an incomplete backtrace that is exactly the same after every crash. I ran the incomplete backtrace through resolve, and it showed me functions such as thread start... etc... This is the backtrace that i've been getting for all the crashes - --- Cannot determine thread, ebp=0xb24c, backtrace may not be correct stack range sanity check, ok, backtrace follows 0x40077552 0x40076f0f 0x80bdb6a 0x80bdfdf 0x80bd75d 0x400f99cb 0x80884b1 New value of ebp failed sanity check terminating backtrace We have been doing testing of our software and in all the runs, with all the mysql servers, this problem has been experienced. As soon as the server reaches 100% CPU, the mysql server restarts. Without a single exception till now. The servers are RedHat Linux 6.2 with kernel 2.4.2, PHP 4.0.4pl1, apache 1.3.14 and mysql 3.23.32. The my.cnf file i'm using is this - [mysqld] port= 3306 socket = /tmp/mysql.sock skip-locking set-variable= key_buffer=640M set-variable= max_allowed_packet=10M set-variable= table_cache=640 set-variable= sort_buffer=6M set-variable= record_buffer=6M set-variable= thread_cache=16 set-variable= thread_concurrency=16 set-variable= myisam_sort_buffer_size=64M log-bin server-id = 1 set-variable= max_connections=2000 set-variable= max_connect_errors=1 set-variable= back_log=2900 set-variable= connect_timeout=15 set-variable= wait_timeout=57600 set-variable= interactive_timeout=57600 Tx. Vinod. --- "Jeremy D. Zawodny" [EMAIL PROTECTED] wrote: On Mon, Mar 19, 2001 at 12:34:30AM +0000, vinod p wrote: my mysql server restarts automatically when the machine touches 100% CPU usage. any ideas why? What does the error log say? Anything? -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 Do You Yahoo!? Get your free @yahoo.co.in address at http://mail.yahoo.co.in - 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
Heavy Load
hey, i'm running serveral mysql servers on powerful machines - dual processor, 2 GB memory, etc... Most of the databases store temporary data only. I need the maximum performance from these servers and have a lot of connections to the database. My problem is this - whenever the number of queries sent to the database increases, or the CPU usage increases under heavy load, mysql crashes. This has been a consistent behaviour. The system is under testing phase and the servers just give up under a reasonably heavy load. This is the my.cnf file - [mysqld] skip-locking set-variable= key_buffer=640M set-variable= max_allowed_packet=10M set-variable= table_cache=640 set-variable= sort_buffer=6M set-variable= record_buffer=6M set-variable= thread_cache=16 set-variable= thread_concurrency=16 set-variable= myisam_sort_buffer_size=64M log-bin server-id = 1 set-variable= max_connections=2000 set-variable= max_connect_errors=1 set-variable= back_log=2900 set-variable= connect_timeout=15 set-variable= wait_timeout=57600 set-variable= interactive_timeout=57600 [mysqldump] quick set-variable= max_allowed_packet=16M [mysql] no-auto-rehash [isamchk] set-variable= key_buffer=256M set-variable= sort_buffer=256M set-variable= read_buffer=2M set-variable= write_buffer=2M [myisamchk] set-variable= key_buffer=256M set-variable= sort_buffer=256M set-variable= read_buffer=2M set-variable= write_buffer=2M According to me, the database should become slow under heavy load - it should not just crash. The backtrace is also incomplete. And it is consistent for every crash. Any ideas why this could be happening? I'm using PHP to access the database on RH 6.2 with kernel 2.4.2. I'm using latest versions of everything. Thanks, Vinod Do You Yahoo!? Get your free @yahoo.co.in address at http://mail.yahoo.co.in - 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
a newbie question for myodbc
Hi, I need mysql (under linux) tool's -q (--quick "don't cache result, print it row by row") in myodbc. How can I configure the myodbc?? I have been using MyODBC 2.50.36 and I'm connecting to MySQL Server at Linux (Red Hat 7.0 2.2.16-22) under MS Win98. Thanks. h.
Re: Re: Re: Re: Re: Antwort: Re: Antwort: Re: any ASP/ADO/MySQL programmers out there? (LONG answer)
Hey, I can't stop laughing anymore ( that has no ironical meaning!!! ) :) :) Good humor in this list, don't stop please :) Philipp - Original Message - From: "Jason Landry" [EMAIL PROTECTED] To: [EMAIL PROTECTED]; "John Dean" [EMAIL PROTECTED] Cc: "Bob Hall" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, February 28, 2001 7:40 PM Subject: Re: Antwort: Re: Antwort: Re: any ASP/ADO/MySQL programmers out there? (LONG answer) Hi Since the language of business here at MySQL is English it would be nice if all messages to the list are written in English. This way you would have more chance of receiving reply Yeah, that's just what I was saying :] But I'm sure what both of you really meant to say was: kasjf awiuqn angieojagfhe asdfkasflkjsa, akjhasfweie New Jersey aslkjd hahaha alksjfdjklsjiweiue, askldjsdfjwij. ajwiejfeijf oiwiwnadfwiueja, asdfjasfd. - 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
replication error message question
I have two mysql servers, setup to replicate each other. However, every so often, one or both starts logging; 010226 9:40:27 Slave thread: error connecting to master:Can't connect to MySQL server on '0' (11)(107), retry in 0 sec 010226 9:40:27 Slave thread: error connecting to master:Can't connect to MySQL server on '0' (11)(107), retry in 0 sec 010226 9:40:27 Slave thread: error connecting to master:Can't connect to MySQL server on '0' (11)(107), retry in 0 sec and this quickly fills up the disk. Is this a bug, or could I have things setup incorrectly ? Usually, the only fix is to remove all .bin and .err and the master.info, and copy /var/lib/mysql to the client, and restart both mysql servers (not ideal, as you can imagine). John -- When I say 'free', I mean 'free': free from bond, of chain or command: to go where you will, even to Mordor, Saruman, if you desire. " -- Gandalf, paraphrasing the choice between Free and Non-free software - 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
Compile fails on ha_berkeley.cc
Theres a long list of error messages following but the first is; ha_berekeley.cc:105: syntax error before ')' ..deleted for brevety... ha_berkeley.cc:297: warning! unreachable code at beginning of switch statement Just wondering if this looks familiar to anyone. We are using FreeBSD4, gcc 2.95, gnu make 1.79.1 on MySQL-3.23.33. I used "CC=gcc CXX=gcc ./configure -with-low-memory" P.S. We actualy got sql_yacc.cc to compile in 4 hours on a 166MHZPI with 32MB RAM and a 64MB swap partition. Imagine my dissapointment when it crashed farther down stream. - 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
running safe_mysqld errors with 010222 17:25:00 mysqld ended
exact command is "./safe_mysqld --user=mysql ". The error "010222 17:25:00 mysqld ended" happens immediately. - 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: running safe_mysqld errors with 010222 17:25:00 mysqld ended
Did that, figured out that I had root permissions on files in the data directory. I pushed by that and now I find that the file "/usr/local/mysql/libexec/mysqld cannot be found or executed". There is no libexec directory in /usr/local/mysql so, I'm not suprised. Is creating one and copying "mysqld" into it a viable option? Don't know what else to do. Peter Skipworth wrote: check your error log in ~mysql/var On Thu, 22 Feb 2001, Matthew P. Marino wrote: exact command is "./safe_mysqld --user=mysql ". The error "010222 17:25:00 mysqld ended" happens immediately. - 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
So, what do you do with a tarball anyways.
So, what do you do with a "tarball" anyways. Since compiling the source is hopless( "sql_yacc.cc"), I'm looking for a binary. - 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
So, just how long should it take the make install to run?
Don't laugh, Intel PI 166MHZ, 32MB RAM,10GB HD FreeBSD4 MySQL3.23.33 from .tar.gz distribution - 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
Linking MySQL with other programs
Hello, I'm trying to compile and link MySql with a CORBA (ORBacus) client and I get the following error message: Undefined first referenced symbol in file __muldi3 /opt/mysql-3.23.32-sol8/lib/mysql/libmysqlclient.so __udivdi3 /opt/mysql-3.23.32-sol8/lib/mysql/libmysqlclient.so ld: fatal: Symbol referencing errors. No output written to server make: *** [server] Error 1 Using MYSQL version mysql-3.23.32. The platform that I am working on is SunOs 2.8. The compiler that I am using is Forte 6.0 (CC) c++ compiler. "-lm" has been specified in the linker option line. Could you please help me? Thanks, Neera - 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
Microsoft clustering
Hi, I would like to find out if the Win2000 version of mysql and myodbc support Win2000 clustering. Thanks, Sam __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.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
user variables length
How many Bytes can I save in a user variable? Because I have the following strategy: I want to save all PrimaryKeys in a user variable SELECT @a:=' '; SELECT @a := CONCAT(@a, ', ', TPrimKey) FROM table WHERE condition; so it is very important to know how many bytes can be stored. regards Philipp Hasenfratz
Unsatisfied symbols-mysql_init
hi, i recently downloaded mysql-3.23.32-hp-hpux10.20-hppa1.1.tar.gz , and tried writing a very simple code to start with . i just made a call to mysql_init() and mysql_connect() in the sample code . i used aCC ( version : aCC: HP ANSI C++ B3910B A.01.21) on a HPUX 10.2 machine . i am linking to libraries available in /mysqldepot/mysql-3.23.32-hp-hpux10.20-hppa1.1/lib i get the following /usr/ccs/bin/ld: Unsatisfied symbols: mysql_connect (code) mysql_init (code) i wld be greatly obliged if someone can figure out if i am doing something wrong. thank you ragu - 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
SV: Exporting data from MySQL to Oracle
You could use mysqldump which makes CREATE/INSERT statements for mysql, and then you can change the mysql-spesific things like auto_icrement into making an sequence, etc. Oracle is SQL92 compliant and it would work i think. try it :o) mvh: P?l Wester, programmerer never.no as, stortingsgt 30, 0161 Oslo tlf: 22 01 66 20, fax: 22 01 66 21 direkte: 22 01 66 34, 906 900 62 http://never.no - icq:103476059 ~ f u cn rd ts u prb a gk ~ -Opprinnelig melding- Fra: Denis Mettler [mailto:[EMAIL PROTECTED]] Sendt: 13. februar 2001 22:02 Til: Noor Dawod Kopi: [EMAIL PROTECTED] Emne: AW: Exporting data from MySQL to Oracle Hi there, please check the oracle migration bench at the oracle technet. http://technet.oracle.com kind regards denis mettler -Urspr?ngliche Nachricht- Von: Noor Dawod [mailto:[EMAIL PROTECTED]] Gesendet: Dienstag, 13. Februar 2001 17:23 An: Cal Evans; MySQL List Betreff: RE: Exporting data from MySQL to Oracle I couldn't find such product on Oracle's website. Noor -Original Message- From: Cal Evans [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 13, 2001 5:51 PM To: Noor Dawod; MySQL List Subject: RE: Exporting data from MySQL to Oracle Didn't Oracle just release a MySQL to Oracle migration kit? Check the Oracle website. Cal http://www.calevans.com -Original Message- From: Noor Dawod [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 13, 2001 8:41 AM To: MySQL List Subject: Exporting data from MySQL to Oracle Hello, I'm having a problem exporting MySQL BLOB's to Oracle, especially those records that has "Carriage Return" or "Line Feed" characters in them. Has anyone done this before, and how did they do it? I need an immediate help in this subject. I'd appreciate you help very much. Thanks Noor - 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
can I use aCC..
hi, basically i am reframing my earlier question. i'm using aCC ( ansic C++ compiler from HP ) on HPUX10.2 to compile and link my small C code with libraries available from mysql-3.23.32-hp-hpux10.20-hppa1.1 . i get the following: /usr/ccs/bin/ld: Unsatisfied symbols: mysql_connect (code) mysql_init (code) i wld greatly appreciate if someone can figure out if something is wrong. thank you ragu - 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: Port 3306
Anyone know a good ipchains rule to close this port to the outside world? I haven't dabbled in forewalling yet... i use Immunix, a RedHat 6.2 derivative. I recommend it if you like RedHat: www.immunix.org. Has stack overflow protection so those pesky overflow bugs in wu-ftp no longer affect your system... johnny p. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, February 05, 2001 2:46 PM To: Gus Constan Cc: [EMAIL PROTECTED] Subject: Re: Port 3306 What OS? If Linux or *BSD, they have firewall software (ipchains on linux, don't recall what it is on BSD) I'm new to MySQL, this may be a simple question; How do I turn off listen on port 3306?, I don't want to serve MySQL on the net, I only need it for local (server side) access. Can someone point to docs or notes dealing with this issue. - 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
Can't start as user 'mysql'
I'm running Slackware Linux (2.0.36) and just set up a binary version of MySQL 3.23.32. I followed the directions exactly and all looks to be fine. However, when I try and start MySQL by using typing bin/safe_mysqld --user=mysql I get the following error: www:/usr/local/mysql# Starting mysqld daemon with databases from /usr/local/mysq l-3.23.32-pc-linux-gnu-i686/data 010126 18:54:14 mysqld ended I then check the error log and it reports this: 010126 18:54:14 mysqld started 010126 18:54:14 Warning: setrlimit couldn't increase number of open files to more than 256 010126 18:54:14 Warning: Changed limits: max_connections: 100 table_cache: 73 Fatal error: Can't change to run as user 'mysql' ; Please check that the user exists! 010126 18:54:14 Aborting 010126 18:54:14 mysqld ended I know the user 'mysql' exists for sure and all directories and files are owned by 'mysql' and have the group ownership of 'mysql' but things still don't work. The other erros about not being able to increase the number of open files to more than 256 and the other warning about the 'Changed Limits' I don't know anything about. Could they be causeing a problem. I can successfully get MySQL to start if I don't start it as user 'mysql' but then I can't quit it using any quit command. I first tried using: mysqladmin stop and it reported the 'slave was not running' and couldn't quit mysqld I then tried 'mysql.server stop' and it gave me this: ./mysql.server st op ./mysql.server: @HOSTNAME@: command not found ./mysql.server: my_print_defaults: command not found Killing mysqld with pid 15998 ./mysql.server: kill: (15998) - No such pid Wait for mysqld to exit\c .\c .\c .\c gave up waiting! and it never quit. I have to do a force quit for each process with a kill -9. Any help here would be greatly appreciated. Thanks, John __ 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: Apache - MySQL - PHP (Auto-start Apache)
Yes, but does it get cleanly stopped when you shutdown? put the start command in /etc/rc.d/rc.local, fine, but I think there needs to be a kill link added to /etc/rc.d/rc.3 dir. I like the link from apachectl to /etc/rc.d/init.d/ idea: ln -s /usr/local/apache/bin/apachectl /etc/rc.d/init.d/httpd this is correct, if you're in run level 3, to kill apache on shutdown: ln -s /etc/rc.d/init.d/httpd /etc/rc.d/rc3.d/K90httpd this will only work if you go into run level 6 (reboot), shutdown is run level 0 and won't call this script, may not always get executed: ln -s /etc/rc.d/init.d/httpd /etc/rc.d/rc6.d/K90httpd # BAD I don't recommend running X on a web server at all, so you should only really be running in multi-user networked mode, or run level 3, IMHO. Isn't this the MySQL mail list, BTW? I think there's a mail list or newsgroup for apache somewhere... perhaps even a linux admin newsgroup would be even more appropriate. HTH, -jp -Original Message-, From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 25, 2001 7:00 AM To: Mark Maunder Cc: Freaked Personality; John Halladay; "MySQL List (E-mail)" Subject: Re: Apache - MySQL - PHP (Auto-start Apache) You can put this in the /etc/rc.d/rc.local /usr/local/apache/bin/apachectl start Mensaje citado por: Mark Maunder [EMAIL PROTECTED]: (quicky coz this is way off topic): ln -s /usr/local/apache/bin/apachectl /etc/rc.d/init.d/httpd ln -s /etc/rc.d/init.d/httpd /etc/rc.d/rc3.d/S90httpd ln -s /etc/rc.d/init.d/httpd /etc/rc.d/rc5.d/S90httpd ln -s /etc/rc.d/init.d/httpd /etc/rc.d/rc6.d/K90httpd That should do it. Should bring up your httpd whether you\'re running runlevel 3 (command line) or runlevel 5 (X windows) on redhat whatever version. (I think). You can use the same scheme for starting mysqld too (excuse for posting to list) *duck* Freaked Personality wrote: You don\'t configure apache to do this, since apache has no idea when the server boots up... You have to edit your start-up scripts which are mostly in /etc/rc.d to start up apache. There\'s a huge number of ways to do this (to script it) ie with error checking/without error checking with mail on error etc etc depending on your distribution you then have to add files to run level directories (links) or have to do run level checking in the start-up scripts which isn\'t explained that easy. Knowing which distribution you use could prove very helpful :-) On Tue, 23 Jan 2001, John Halladay wrote: I\'m currently running Apache 1.3.12, MySQL 3.22.32-1, and PHP 4.0.3 together on RedHat 7.0 and everything works fine, although every time I boot up I have to manually start the Web Server with command /usr/local/apache/bin/apachectl start. Does anyone know how to configure Apache so that it will start up automatically when I boot up Linux? (I know it\'s a little off the MySQL subject, but I figured someone would have a similar setup.) Thanks, John Halladay -- --- 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 -- --- 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