Re: Problem under Solaris
Yes, it looks like the permissions are skewed. YOu might just want to do a chown -R mysql:mysql /usr/local/mysql The out-of-the-package permissions should be correct, ownership could be the issue. Regards, Bhavin. - Original Message - From: Emiliano Marmonti [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, June 21, 2002 7:36 AM Subject: Fw: Problem under Solaris Dear people I have a problem installing under Solaris. I've downloaded a compiled mysql, installed under /usr/local, create mysql group and mysql user, the owner of mysql/data is the group mysql and everything looks well. But when I try: bin/safe_mysqld --user=mysql The mysql starts and inmediatly ends. Looking the log file I can see that it says: 020621 20:49:05 mysqld started 020621 20:49:05 /usr/local/mysql/bin/mysqld: Can't create/write to file '/usr/l ocal/mysql/data/bdu.pid' (Errcode: 13) 020621 20:49:05 /usr/local/mysql/bin/mysqld: Can't find file: './mysql/host.frm ' (errno: 13) 020621 20:49:05 /usr/local/mysql/bin/mysqld: Error on delete of '/usr/local/mys ql/data/bdu.pid' (Errcode: 13) 020621 20:49:05 mysqld ended it looks like has no rights to write the file, isn´t it. I tried to use scripts/mysql_install_db but It says that could not find mysqld and I 've seen that my.cnf does not exists. Is there a way to put it working or must I download source code and compile it from scratch? Thanks a lot in advance Emiliano H.Marmonti - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Perl/DBI load data local
At 10:23 -0800 6/21/02, nellA hciR wrote: iH running mySQL 3.23.51, i have a my.cnf file with local-infile=1 and am able to use the load data local file command when running run the interactive mysql app (command line). my problem is that i can not use the load data local command from a Perl script. i am connecting as the same user and i do with the command line. other command such as connect, disconnect, insert, select do work what am i missing to allow the same access via Perl as with the command line Add: ;mysql_read_default_group=client to the end of your DSN string. thanks - hcir [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Build errors with 3.23.51
Below are what I believe to be the relevant lines from the config.log... Running Debian, 2.4.19pre1 kernel, gcc 3.0.4, glib-2.2.2 with linuxthreads and the mysql-supplied linuxthreads patch. After re-reading my original post as well, I realize that I forgot to mention that I compiled the glibc libraries with gcc 2.95; configure would fail saying that gcc 3.0.4 was a bad compiler, and I'm not good enough with autoconf to hack the check out of the configure script (despite several attempts to do so). I don't know if that is information worth noting or not; but it can't hurt I suppose. Thanks again. configure:12730: checking style of gethost* routines configure:12773: gcc -c -O -DDBUG_OFF -O3 -felide-constructors -fno-exceptions -fno-rtti -fpermissive -I/usr/local/mysql-glibc-2.2.2/include conftest.cc 5 gcc: installation problem, cannot exec `cc1plus': No such file or directory configure:12776: $? = 1 configure: failed program was: #line 12750 configure #include confdefs.h #undef inline #if !defined(SCO) !defined(__osf__) !defined(_REENTRANT) #define _REENTRANT #endif #include pthread.h #include sys/types.h #include sys/socket.h #include netinet/in.h #include arpa/inet.h #include netdb.h int main () { int skr; struct hostent *foo = gethostbyaddr_r((const char *) 0, 0, 0, (struct hostent *) 0, (char *) NULL, 0, skr); return (foo == 0); ; return 0; } configure:12792: result: other configure:12813: checking style of gethostname_r routines configure:12854: gcc -c -O -DDBUG_OFF -O3 -felide-constructors -fno-exceptions -fno-rtti -fpermissive -I/usr/local/mysql-glibc-2.2.2/include conftest.cc 5 gcc: installation problem, cannot exec `cc1plus': No such file or directory configure:12857: $? = 1 configure: failed program was: #line 12830 configure #include confdefs.h #undef inline #if !defined(SCO) !defined(__osf__) !defined(_REENTRANT) #define _REENTRANT #endif #include pthread.h #include sys/types.h #include sys/socket.h #include netinet/in.h #include arpa/inet.h #include netdb.h int main () { int skr; skr = gethostbyname_r((const char *) 0, (struct hostent*) 0, (char*) 0, 0, (struct hostent **) 0, skr); ; return 0; } configure:12873: result: other configure:12892: checking 3 argument to gethostname_r routines configure:12932: gcc -c -O -DDBUG_OFF -O3 -felide-constructors -fno-exceptions -fno-rtti -fpermissive -I/usr/local/mysql-glibc-2.2.2/include conftest.cc 5 gcc: installation problem, cannot exec `cc1plus': No such file or directory configure:12935: $? = 1 configure: failed program was: #line 12909 configure #include confdefs.h #undef inline #if !defined(SCO) !defined(__osf__) !defined(_REENTRANT) #define _REENTRANT #endif #include pthread.h #include sys/types.h #include sys/socket.h #include netinet/in.h #include arpa/inet.h #include netdb.h int main () { int skr; skr = gethostbyname_r((const char *) 0, (struct hostent*) 0, (struct hostent_data*) 0); ; return 0; } On Sat, Jun 22, 2002 at 03:09:15AM +0200, Jocelyn Fournier wrote: Hi, It seems to be linked with the gethostname_r detection checking style of gethostname_r routines... other I think you should have the following line instead : checking style of gethostname_r routines... glibc2 Can you take a look at the config.log file and tell us what is wrong ? (in my case I have the following lines : configure:15261: checking style of gethostname_r routines configure:15309: gcc -c -O3 -DDBUG_OFF -Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcommen t -W -Wchar-subscripts -Wformat -Wparen theses -Wsign-compare -Wwrite-strings -Woverloaded-virtual -Wsign-promo -Wre order -Wctor-dtor-privacy -Wnon-virtual-dtor -felide-con structors -fno-exceptions -fno-rtti -mcpu=pentiumpro -O3 -fno-omit-frame-poi nter -fno-implicit-templates -fno-exceptions -fno-rtti -DUSE_MYSYS_NEW -Werror conftest.cc 5 configure:15312: $? = 0 configure:15315: test -s conftest.o configure:15318: $? = 0 configure:15328: result: glibc2 ) Regards, Jocelyn - Original Message - From: Shane Allen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, June 22, 2002 3:05 AM Subject: Build errors with 3.23.51 Running Debian, 2.4.19pre1 kernel, gcc 3.0.4, glib-2.2.2 with linuxthreads and the mysql-supplied linuxthreads patch. I'm using the following configure line: CFLAGS=-O3 -march=pentiumpro CXX=gcc CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno-rtti /configure --with-client-ldflags=-all-static --with-mysqld-ldflags=-all-sta tic --enable-thread-safe-client --with-other-libc=/usr/local/mysql-glibc-2.2 .2 I have not successfully built against this glibc yet, however I did not receive any unusual warnings, and no errors occured during any part of the build. Following is the output of the configure: checking build system type... i686-pc-linux-gnu checking host system type... i686-pc-linux-gnu checking target system type... i686-pc-linux-gnu checking
Re: Error on insert statement...
At 17:30 -0400 6/21/02, Michael Jessop wrote: Can someone tell me what this means? I mean, I guess I *know* what it means, but why? Placeholders for Python scripts using MySQLdb should be %s, not ?. Convert your ? characters to %s and see what happens. The insert statement into a mysql database is... 'insert into works values(?, ?, ?, ?, ? ,?)' The invocation of the dynamic sql is... status = cur_mysql.execute(sql, (wrk_inst, ZERO, trs_inst, aas_inst, title, NADA)) (ZERO = 0L and NADA = 'N/A') I do a print of the wrk_inst, trs_inst, aas_inst (and zero and nada) followed by a print of title before the error... 80956 177802 0 0 N/A WANTED ... A BROTHER ...here is the error... Exception in Tkinter callback Traceback (most recent call last): File C:\Python22\lib\lib-tk\Tkinter.py, line 1292, in __call__ return apply(self.func, args) File C:\Documents and Settings\mjessop\My Documents\Python Development\Catalo g\catalog_gui.py, line 82, in engage catalog.extract_works() File C:\Documents and Settings\mjessop\My Documents\Python Development\Catalo g\catalog_model.py, line 249, in extract_works (wrk_inst, ZERO, trs_inst, aas_inst, title, NADA)) File C:\Python22\Lib\site-packages\MySQLdb\cursors.py, line 70, in execute raise ProgrammingError, m.args[0] ProgrammingError: not all arguments converted == here is a description of the database table... mysql describe works - ; +--+--+--+-+-+---+ | Field| Type | Null | Key | Default | Extra | +--+--+--+-+-+---+ | wrk_inst | int(11) | | MUL | 0 | | | sinker | int(11) | | MUL | 0 | | | trs_inst | int(11) | YES | | 0 | | | aas_inst | int(11) | YES | | 0 | | | title| varchar(255) | YES | | NULL| | | pub_name | varchar(80) | YES | | NULL| | +--+--+--+-+-+---+ 6 rows in set (0.03 sec) Any thoughts? Thank you, in advance... +++-+++--+++ + Michael S. Jessop+ | Senior Web Developer | + Copyright Clearance Center, Inc. + +++-+++--+++ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
garbage data stored ! ! ! !
hi guys im working with some unicode data , store it in mysql db and retrieve it now its storing the data fine when i use longtext or mediumtext EXCEPT for a few characters it gives BOXes fo those characters in the web-browser the boxes suddenly increase their numbr of existance if i change the encoding in the web-browser to unicode ( from arabic or auto ) gives garbage charactes when i check the stored data in mysql prompt . now i NO mysql supports unicode . well sort of though thnx to u guys it iS storin most part of the unicode which proves this too now id be eternally gratefull if someone could pleez help me out with the rest of storing the unicode thnx a million billion in advance toby _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: confirm subscribe to mysql@lists.mysql.com
- Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, June 22, 2002 9:48 AM Subject: confirm subscribe to [EMAIL PROTECTED] Hi! This is the ezmlm program. I'm managing the [EMAIL PROTECTED] mailing list. To confirm that you would like [EMAIL PROTECTED] added to the mysql mailing list, please send an empty reply to this address: [EMAIL PROTECTED] Usually, this happens when you just hit the reply button. If this does not work, simply copy the address and paste it into the To: field of a new message. This confirmation serves two purposes. First, it verifies that I am able to get mail through to you. Second, it protects you in case someone forges a subscription request in your name. Some mail programs are broken and cannot handle long addresses. If you cannot reply to this request, instead send a message to [EMAIL PROTECTED] and put the entire address listed above into the Subject: line. --- Administrative commands for the mysql list --- I can handle administrative requests automatically. Please do not send them to the list address! Instead, send your message to the correct command address: To subscribe to the list, send a message to: [EMAIL PROTECTED] To remove your address from the list, send a message to the address in the List-Unsubscribe header of messages from the list. If you don't know how to display headers and haven't changed E-mail addresses since subscribing, you'll be successful with an e-mail to: [EMAIL PROTECTED] Send mail to the following for info and FAQ for this list: [EMAIL PROTECTED] [EMAIL PROTECTED] Similar addresses exist for the digest list: [EMAIL PROTECTED] [EMAIL PROTECTED] To get messages 123 through 145 (a maximum of 100 per request), mail: [EMAIL PROTECTED] To get an index with subject and author for messages 123-456 , mail: [EMAIL PROTECTED] They are always returned as sets of 100, max 2000 per request, so you'll actually get 100-499. To receive all messages with the same subject as message 12345, send an empty message to: [EMAIL PROTECTED] The messages do not really need to be empty, but I will ignore their content. Only the ADDRESS you send to is important. You can start a subscription for an alternate address, for example [EMAIL PROTECTED], just add a hyphen and your address (with '=' instead of '@') after the command word: [EMAIL PROTECTED] To stop subscription for this address, mail: [EMAIL PROTECTED] In both cases, I'll send a confirmation message to that address. When you receive it, simply reply to it to complete your subscription. If despite following these instructions, you do not get the desired results, please contact my owner at [EMAIL PROTECTED] Please be patient, my owner is a lot slower than I am ;-) --- Enclosed is a copy of the request I received. Return-Path: [EMAIL PROTECTED] Received: (qmail 6990 invoked from network); 22 Jun 2002 07:48:34 - Received: from fep01.tuttopmi.it (HELO fep01-svc.flexmail.it) (212.131.248.100) by www.mysql.com with SMTP; 22 Jun 2002 07:48:34 - Received: from Alighiero ([81.72.233.61]) by fep01-svc.flexmail.it (InterMail vM.5.01.05.09 201-253-122-126-109-20020611) with SMTP id 20020622075653.GVUZ3717.fep01-svc.flexmail.it@Alighiero for [EMAIL PROTECTED]; Sat, 22 Jun 2002 09:56:53 +0200 Message-ID: 001b01c219c2$60925db0$3de94851@Alighiero Reply-To: Softal [EMAIL PROTECTED] From: Softal [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: MySQL news Date: Sat, 22 Jun 2002 09:56:55 +0200 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary==_NextPart_000_0018_01C219D3.23DFAB50 X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600. X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600. This is a multi-part message in MIME format. --=_NextPart_000_0018_01C219D3.23DFAB50 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable --=_NextPart_000_0018_01C219D3.23DFAB50 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META http-equiv=3DContent-Type content=3Dtext/html; = charset=3Diso-8859-1 META content=3DMSHTML 6.00.2716.2200 name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVnbsp;/DIV/BODY/HTML --=_NextPart_000_0018_01C219D3.23DFAB50-- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 help !! urgent
Hello, In phpmyadmin I accidentaly gave root no privlegaes.. Now I cannot do anything as phpmyadmin wont work because root can't do anything at all... I have complete ssh access etc to the server, Please help me out what do i do to give root full privs again?!? please help me make mysql work again as I really need it. -- Jesse Angell PalaceUnlimited.com #1 Palace Host - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
root priv help
Hello, In phpmyadmin I accidentaly gave root no privlegaes.. Now I cannot do anything as phpmyadmin wont work because root can't do anything at all... I have complete ssh access etc to the server, Please help me out what do i do to give root full privs again?!? Please help me get mysql running again -- Jesse Angell PalaceUnlimited.com #1 Palace Host - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Time variable in php and sql db
I have a mysql dbase. I use a time field to save a number of hours (think about number of houres spent out of office, or anything else). A table holds the global values for people and their status, another table holds every single entry of data, so john smith 5 hours and 2 minutes outside on 16-06-2002 james dillon 10 hours and 25 minutes outside on 22-06-2002 and so on. Now i need to update the global values (john smith total hours outside 69:53 for example) according to the single entries. Globally i've already made the algorithm, my problem is: when in php i read a single time value (eg 5:02 for john smith) and add it to the global, it si not calculated in the exact time form. Is it? So what can i do? I can't use a time stamp, because i need only times and greater than 24 houres. So what? Thank you Claudio - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: restart/flush needed when using symlinks?
Christian, Friday, June 21, 2002, 5:42:58 PM, you wrote: CH Is a restart/reload or a flush tables necessary when creating or removing CH databases? Nope. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.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: Re: corrupt index in BDB table
Dicky, Friday, June 21, 2002, 11:04:32 AM, you wrote: i have a problem with an index of a BerkeleyDB table because this is corrupted and crashes Mysql (v. 3.23.49). The size of table file is correct 8Mb for 15.000 records but from a select I view only the first 957 If I launch mysqldump or a select or alter table drop index.. the result is the same. Mysql crashes How can I fix index in BDB table, I did not find any tools in mysql package... Check http://sleepycat.com, you can find some utilities there ... DWP just do from mysql prompt : DWP mysql repair table [tablename] REPAIR TABLE doesn't repair BDB tables! -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.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: root priv help
Hi Jesse, On Sat, Jun 22, 2002 at 03:42:57AM -0500, Jesse Angell wrote: Hello, In phpmyadmin I accidentaly gave root no privlegaes.. Now I cannot do anything as phpmyadmin wont work because root can't do anything at all... I have complete ssh access etc to the server, Please help me out what do i do to give root full privs again?!? Please help me get mysql running again Oops! Take a look at http://www.mysql.com/doc/R/e/Resetting_permissions.html on how to restart your MySQL daemon with privilege checking. Then login with: # mysql -u root And type: grant all on *.* to root@localhost; And restart your MySQL daemon again. I never tried this, but I guess it should work. Good luck! Fred. -- Fred van Engen XO Communications B.V. email: [EMAIL PROTECTED] Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: corrupt index in BDB table
You wrote: From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Date: Sat, 22 Jun 2002 12:10:01 +0300 Subject: Re: Re: corrupt index in BDB table Dicky, Friday, June 21, 2002, 11:04:32 AM, you wrote: i have a problem with an index of a BerkeleyDB table because this is corrupted and crashes Mysql (v. 3.23.49). The size of table file is correct 8Mb for 15.000 records but from a select I view only the first 957 If I launch mysqldump or a select or alter table drop index.. the result is the same. Mysql crashes How can I fix index in BDB table, I did not find any tools in mysql package... Check http://sleepycat.com, you can find some utilities there ... DWP just do from mysql prompt : DWP mysql repair table [tablename] REPAIR TABLE doesn't repair BDB tables! Infact I can not repair BDB table, but when a index is corrupted what can I do ??? Please I am in large difficulty, data is more important Thanks Giuseppe - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Build errors with 3.23.51
Hi, It seems to be linked with the gethostname_r detection checking style of gethostname_r routines... other I think you should have the following line instead : checking style of gethostname_r routines... glibc2 Can you take a look at the config.log file and tell us what is wrong ? (in my case I have the following lines : configure:15261: checking style of gethostname_r routines configure:15309: gcc -c -O3 -DDBUG_OFF -Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcommen t -W -Wchar-subscripts -Wformat -Wparen theses -Wsign-compare -Wwrite-strings -Woverloaded-virtual -Wsign-promo -Wre order -Wctor-dtor-privacy -Wnon-virtual-dtor -felide-con structors -fno-exceptions -fno-rtti -mcpu=pentiumpro -O3 -fno-omit-frame-poi nter -fno-implicit-templates -fno-exceptions -fno-rtti -DUSE_MYSYS_NEW -Werror conftest.cc 5 configure:15312: $? = 0 configure:15315: test -s conftest.o configure:15318: $? = 0 configure:15328: result: glibc2 ) Regards, Jocelyn - Original Message - From: Shane Allen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, June 22, 2002 3:05 AM Subject: Build errors with 3.23.51 Running Debian, 2.4.19pre1 kernel, gcc 3.0.4, glib-2.2.2 with linuxthreads and the mysql-supplied linuxthreads patch. I'm using the following configure line: CFLAGS=-O3 -march=pentiumpro CXX=gcc CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno-rtti /configure --with-client-ldflags=-all-static --with-mysqld-ldflags=-all-sta tic --enable-thread-safe-client --with-other-libc=/usr/local/mysql-glibc-2.2 .2 I have not successfully built against this glibc yet, however I did not receive any unusual warnings, and no errors occured during any part of the build. Following is the output of the configure: checking build system type... i686-pc-linux-gnu checking host system type... i686-pc-linux-gnu checking target system type... i686-pc-linux-gnu checking for a BSD compatible install... /usr/bin/install -c checking whether build environment is sane... yes checking whether make sets ${MAKE}... yes checking for working aclocal... missing checking for working autoconf... missing checking for working automake... missing checking for working autoheader... missing checking for working makeinfo... found checking whether to enable maintainer-specific portions of Makefiles... no checking whether build environment is sane... yes checking whether make sets ${MAKE}... (cached) yes checking for mawk... mawk checking for gcc... gcc checking for C compiler default output... a.out checking whether the C compiler works... yes checking whether we are cross compiling... no checking for executable suffix... checking for object suffix... o checking whether we are using the GNU C compiler... yes checking whether gcc accepts -g... yes checking whether we are using the GNU C++ compiler... no checking whether gcc accepts -g... no checking how to run the C preprocessor... gcc -E checking C Compiler version... gcc 3.0.4 checking C++ compiler version... gcc 3.0.4 checking for ranlib... ranlib checking for ld used by GCC... /usr/bin/ld checking if the linker (/usr/bin/ld) is GNU ld... yes checking for BSD-compatible nm... /usr/bin/nm -B checking whether ln -s works... yes loading cache /dev/null within ltconfig checking for object suffix... o checking for executable suffix... no checking for gcc option to produce PIC... -fPIC checking if gcc PIC flag -fPIC works... yes checking if gcc supports -c -o file.o... yes checking if gcc supports -c -o file.lo... yes checking if gcc supports -fno-rtti -fno-exceptions ... yes checking if gcc static flag -static works... -static checking if the linker (/usr/bin/ld) is GNU ld... yes checking whether the linker (/usr/bin/ld) supports shared libraries... yes checking command to parse /usr/bin/nm -B output... ok checking how to hardcode library paths into programs... immediate checking for /usr/bin/ld option to reload object files... -r checking dynamic linker characteristics... Linux ld.so checking if libtool supports shared libraries... yes checking whether to build shared libraries... yes checking whether to build static libraries... yes checking for objdir... .libs creating libtool updating cache /dev/null checking for a BSD compatible install... /usr/bin/install -c checking for bison... bison -y checking for pdftex... manual.pdf checking return type of sprintf... int checking for uname... /bin/uname checking operating system... Linux checking if we should use 'skip-locking' as default for linux-gnu... yes checking for ln... /bin/ln checking for ln... /bin/ln checking for mv... /bin/mv checking for rm... /bin/rm checking for cp... /bin/cp checking for sed... /bin/sed checking for cmp... /usr/bin/cmp checking for chmod... /bin/chmod checking for hostname... /bin/hostname checking for gnutar... no checking for gtar... no checking for tar... tar checking for perl... /usr/bin/perl checking for ps... /bin/ps
config fails
[localhost:/usr/local/mysql-3.23.51] root# ./configure --prefix=/usr/local/mysql --with-unix-socket-path=/usr/local/mysql/run/mysql_socket --with-mysqld-user=mysql --with-comment --with-debug checking build system type... powerpc-apple-darwin5.5 checking host system type... powerpc-apple-darwin5.5 checking target system type... powerpc-apple-darwin5.5 checking for a BSD compatible install... /usr/bin/install -c checking whether build environment is sane... yes checking whether make sets ${MAKE}... yes checking for working aclocal... missing checking for working autoconf... found checking for working automake... missing checking for working autoheader... found checking for working makeinfo... missing checking whether to enable maintainer-specific portions of Makefiles... no checking whether build environment is sane... yes checking whether make sets ${MAKE}... (cached) yes checking for mawk... no checking for gawk... no checking for nawk... no checking for awk... awk checking for gcc... no checking for cc... cc checking for C compiler default output... configure: error: C compiler cannot create executables [localhost:/usr/local/mysql-3.23.51] root# _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: config fails
Hi, It seems you've not installed automake. checking for working automake... missing Download automake 1.4-p5 and then try to run configure again. (you can also download texinfo to make makeinfo avalaible) Regards, Jocelyn - Original Message - From: Olivier Schildt [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, June 22, 2002 2:38 PM Subject: config fails [localhost:/usr/local/mysql-3.23.51] root# ./configure --prefix=/usr/local/mysql --with-unix-socket-path=/usr/local/mysql/run/mysql_socket --with-mysqld-user=mysql --with-comment --with-debug checking build system type... powerpc-apple-darwin5.5 checking host system type... powerpc-apple-darwin5.5 checking target system type... powerpc-apple-darwin5.5 checking for a BSD compatible install... /usr/bin/install -c checking whether build environment is sane... yes checking whether make sets ${MAKE}... yes checking for working aclocal... missing checking for working autoconf... found checking for working automake... missing checking for working autoheader... found checking for working makeinfo... missing checking whether to enable maintainer-specific portions of Makefiles... no checking whether build environment is sane... yes checking whether make sets ${MAKE}... (cached) yes checking for mawk... no checking for gawk... no checking for nawk... no checking for awk... awk checking for gcc... no checking for cc... cc checking for C compiler default output... configure: error: C compiler cannot create executables [localhost:/usr/local/mysql-3.23.51] root# _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Nasty LIMIT/multi-table DELETE bug?
Heikki Tuuri writes: Jon, - Original Message - From: Jon Frisby [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Saturday, June 22, 2002 12:51 AM Subject: Nasty LIMIT/multi-table DELETE bug? I just discovered a very scary behavior. We're using MySQL 4.0.1 on Linux, both tables are InnoDB, AUTO_COMMIT is on (default) and these queries are being issues from the MySQL interactive console. If I do a query of the form: SELECT transaction_report.*, confirmed FROM transaction_report, user WHERE user_id = user.id AND DATE_FORMAT(when_reported, '%Y-%m-%d') = '2002-06-21' AND transaction_report.partner_id = 1 AND confirmed != 1 LIMIT 50; This bug was fixed meanwhile ... Now, with multi-table delete you get a syntax error with LIMIT. This has been done so as LIMIT is ambiguous in delete with more then one table involved. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.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
replication error
Placed At : Hi.. I run a replicated mysql server set up..The version i use on the master is 3.23.49 and on the slave is 3.23.46. following is the problem I'm facing.. the binlog postion on the master and the slave are always in sync with each other..whenever the master has an update then the change in the binlog pos happens fine and the slave also picks up from the master. and the log positions are in sync..but the data never gets copied to the slave.. in short the log positions are always in sync with each other but the data is never replicated to the server. has anybody com across this wierd error..? any help would be greatly appreciated regards kannan ** Quality Policy To be the best-in-class service provider by practising international standards in providing world-class services and end-to-end network solutions. ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 help !! urgent
mysqld --skip-grant-tables -Original Message- From: Jesse Angell [mailto:[EMAIL PROTECTED]] Sent: Saturday, June 22, 2002 3:38 AM To: [EMAIL PROTECTED] Subject: mysql help !! urgent Hello, In phpmyadmin I accidentaly gave root no privlegaes.. Now I cannot do anything as phpmyadmin wont work because root can't do anything at all... I have complete ssh access etc to the server, Please help me out what do i do to give root full privs again?!? please help me make mysql work again as I really need it. -- Jesse Angell PalaceUnlimited.com #1 Palace Host - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: replication error
I think somewhere in the manual it warns against running slave and master as different versions. =C= -Original Message- From: Kannan R [mailto:[EMAIL PROTECTED]] Sent: Saturday, June 22, 2002 7:15 AM To: [EMAIL PROTECTED] Subject: replication error Placed At : Hi.. I run a replicated mysql server set up..The version i use on the master is 3.23.49 and on the slave is 3.23.46. following is the problem I'm facing.. the binlog postion on the master and the slave are always in sync with each other..whenever the master has an update then the change in the binlog pos happens fine and the slave also picks up from the master. and the log positions are in sync..but the data never gets copied to the slave.. in short the log positions are always in sync with each other but the data is never replicated to the server. has anybody com across this wierd error..? any help would be greatly appreciated regards kannan ** Quality Policy To be the best-in-class service provider by practising international standards in providing world-class services and end-to-end network solutions. ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: corrupt index in BDB table
On Sat, 22 Jun 2002 11:37:29 +0200 (CEST) Careri Giuseppe [EMAIL PROTECTED] wrote: DWP just do from mysql prompt : DWP mysql repair table [tablename] REPAIR TABLE doesn't repair BDB tables! Infact I can not repair BDB table, but when a index is corrupted what can I do ??? Please I am in large difficulty, data is more important have you tried this ? mysql optimize table [tablename] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Referring Page in PHP/SQL
if(ok) { include('zap.htm') } else { include('zip.htm') } --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473 --- -Original Message- From: Tokunboh Oladejo [mailto:[EMAIL PROTECTED]] Sent: 21 June 2002 15:56 To: '[EMAIL PROTECTED]' Subject: Referring Page in PHP/SQL Hi All, Can anyone help me on how to call up an HTML page in PHP after a succesful entry, example ?php if(!sql_result){ call 'try_again.html' } else { call 'yadiyadiya.html' } ? I don't want to have to type the HTML code again in between the php code because the page I need is already at another URL. If anyone knows what I am talking about please help. Toks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
bug in 3.23.51 for windows ?
Is there any particular reason that anyone knows of that would prevent mysql 3.23.51 for windows from working upon the execution of the SHOW STATUS FROM tablename query? In Linux it works fine, in windows it crashes mysqld with an illegal op. Any other SHOW command works but the one I really need for a PHP app to work. thanks brandon - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: auto_increment and clustering sequence
At 15:41 +0100 6/21/02, Bill Ferrett wrote: I would like to have a MySql table where each row has a unique id (using auto-increment) but is clustered, i.e. physically stored, in a different sequence, e.g. name. This is so that an sql query to order by namew will be quicker. I don't want the auto-increment id to be duplicated - I believe this happens when the auto_increment column is not the first column - so a multi-column index of name,id seems to be out. Can I do this and if so how? No. You have no say in how the server stores rows in tables. You can control the order in which it retrieves by, by using an ORDER BY clause. For fast lookups on the name column, index it. Many thanks -- Bill Ferrett Accroserve Systems Ltd. Office: 01702 342148 Mobile: 07855 868565 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: replication error
Also, if you are doing any 'LOAD DATA INFILE' where the master has access to the file but the slave does not, then this could happen. On most errors, the slave stop replicating and slave status will be turned to OFF. The error file, hostname.err might tell you some thing too. Regards, Bhavin. - Original Message - From: Cal Evans [EMAIL PROTECTED] To: Kannan R [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, June 22, 2002 9:26 AM Subject: RE: replication error I think somewhere in the manual it warns against running slave and master as different versions. =C= -Original Message- From: Kannan R [mailto:[EMAIL PROTECTED]] Sent: Saturday, June 22, 2002 7:15 AM To: [EMAIL PROTECTED] Subject: replication error Placed At : Hi.. I run a replicated mysql server set up..The version i use on the master is 3.23.49 and on the slave is 3.23.46. following is the problem I'm facing.. the binlog postion on the master and the slave are always in sync with each other..whenever the master has an update then the change in the binlog pos happens fine and the slave also picks up from the master. and the log positions are in sync..but the data never gets copied to the slave.. in short the log positions are always in sync with each other but the data is never replicated to the server. has anybody com across this wierd error..? any help would be greatly appreciated regards kannan ** Quality Policy To be the best-in-class service provider by practising international standards in providing world-class services and end-to-end network solutions. ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Strange FULLTEXT search results in 4.0.2alpha
I've compiled mysql 4.0.2-alpha from source. I've created table: create table test ( id_test int4, body text); Next: create fulltext index test_body on test (body); insert into test (id_test,body) values (1,'test rpm'); insert into test (id_test,body) values (2,'test rpm'); insert into test (id_test,body) values (3,'test rpm'); insert into test (id_test,body) values (4,'test rpm'); And now: mysql select * from test where match (body) against ('+rpm' IN BOOLEAN MODE); Empty set (0.00 sec) But: mysql select * from test where match (body) against ('+test' IN BOOLEAN MODE); +-+--+ | id_test | body | +-+--+ | 1 | test rpm | | 2 | test rpm | | 3 | test rpm | | 4 | test rpm | +-+--+ 4 rows in set (0.00 sec) I read http://www.mysql.com/doc/F/u/Fulltext_Fine-tuning.html and see there : ... search using IN BOOLEAN MODE instead, which does not observe the 50% threshold. This is right for test word but not for rpm word. Why ? I've done even more: insert into test (id_test,body) values (5,'test'); insert into test (id_test,body) values (6,'test'); insert into test (id_test,body) values (7,'test'); insert into test (id_test,body) values (8,'test'); insert into test (id_test,body) values (9,'test'); insert into test (id_test,body) values (10,'test'); And still: mysql select * from test where match (body) against ('+rpm' IN BOOLEAN MODE); Empty set (0.00 sec) Am I doing something wrong ? I checked ft_static.c file and there isn't rpm word. Regards. -- Grzegorz - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Strange FULLTEXT search results in 4.0.2alpha
Hi, This problem is probably due to the fact the ft_min_word_len variable is set to 4 by default. Try to add set-variable= ft_min_word_len=3 in your my.cnf, and then recreate your table (or do a REPAIR TABLE test USE_FRM). Regards, Jocelyn Fournier - Original Message - From: Grzegorz Paszka [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, June 22, 2002 9:38 PM Subject: Strange FULLTEXT search results in 4.0.2alpha I've compiled mysql 4.0.2-alpha from source. I've created table: create table test ( id_test int4, body text); Next: create fulltext index test_body on test (body); insert into test (id_test,body) values (1,'test rpm'); insert into test (id_test,body) values (2,'test rpm'); insert into test (id_test,body) values (3,'test rpm'); insert into test (id_test,body) values (4,'test rpm'); And now: mysql select * from test where match (body) against ('+rpm' IN BOOLEAN MODE); Empty set (0.00 sec) But: mysql select * from test where match (body) against ('+test' IN BOOLEAN MODE); +-+--+ | id_test | body | +-+--+ | 1 | test rpm | | 2 | test rpm | | 3 | test rpm | | 4 | test rpm | +-+--+ 4 rows in set (0.00 sec) I read http://www.mysql.com/doc/F/u/Fulltext_Fine-tuning.html and see there : ... search using IN BOOLEAN MODE instead, which does not observe the 50% threshold. This is right for test word but not for rpm word. Why ? I've done even more: insert into test (id_test,body) values (5,'test'); insert into test (id_test,body) values (6,'test'); insert into test (id_test,body) values (7,'test'); insert into test (id_test,body) values (8,'test'); insert into test (id_test,body) values (9,'test'); insert into test (id_test,body) values (10,'test'); And still: mysql select * from test where match (body) against ('+rpm' IN BOOLEAN MODE); Empty set (0.00 sec) Am I doing something wrong ? I checked ft_static.c file and there isn't rpm word. Regards. -- Grzegorz - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Understanding relational database setup/construction
I've looked through Google and the MySQL website without luck. I'm looking to find a place which discusses the theory of how one should create a database, how to organize the information, etc. There's got to be a good site out there, but I'm obviously plugging in the wrong search terms or something. Thanks TjL - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Unable to add/ edit records - Help needed!
Hi, We have been using a simple mySQL database successfully for some time. The database has a couple of tables and 1000 records in the primary table. It has been well behaved and performing well. Development record maintenance is taking place locally under Delphi/ dbExpress applications and on a web site using php. All of a sudden we can no longer add/ edit records. One tell tale message is that we constantly get error dialogs Action not possible on a uni-directional database I have repaired the database etc. But we haven't changed anything in the mySQL installations, development environments etc. I have removed all keys (except and autoinc primary key) and restrictions on the records and fields. The problem persists. I'm stumped and I'd be most grateful if someone could point me in the direction of a solution. Thanks -- Pierre du Parté Final Filer Software 349 Worrigee Road Worrigee, NSW, Australia 2540 http://www.finalfiler.com Phone 61 2 44216374 Mobile 0413 483 066 If it feels good, do it! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Understanding relational database setup/construction
Hi Not sure about sites but try searching for 'database normalisation tutorial' I found http://www.codelearn.com/rdb/rdbd_nt1_s.html which looks to be a reasonable start. Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473 --- -Original Message- From: Timothy J. Luoma [mailto:[EMAIL PROTECTED]] Sent: 22 June 2002 22:06 To: MySQL List Subject: Understanding relational database setup/construction I've looked through Google and the MySQL website without luck. I'm looking to find a place which discusses the theory of how one should create a database, how to organize the information, etc. There's got to be a good site out there, but I'm obviously plugging in the wrong search terms or something. Thanks TjL - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Unable to add/ edit records - Help needed!
Nevermind- I just re-installed mySQL and rebooted. everything works again. Pierre Pierre du Parte wrote: Hi, We have been using a simple mySQL database successfully for some time. The database has a couple of tables and 1000 records in the primary table. It has been well behaved and performing well. Development record maintenance is taking place locally under Delphi/ dbExpress applications and on a web site using php. All of a sudden we can no longer add/ edit records. One tell tale message is that we constantly get error dialogs Action not possible on a uni-directional database I have repaired the database etc. But we haven't changed anything in the mySQL installations, development environments etc. I have removed all keys (except and autoinc primary key) and restrictions on the records and fields. The problem persists. I'm stumped and I'd be most grateful if someone could point me in the direction of a solution. Thanks -- Pierre du Parté Final Filer Software 349 Worrigee Road Worrigee, NSW, Australia 2540 http://www.finalfiler.com Phone 61 2 44216374 Mobile 0413 483 066 If it feels good, do it! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: insert BLOB values
- Original Message - From: Hytham Shehab [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, June 22, 2002 12:15 AM Subject: Fw: insert BLOB values - Original Message - From: Hytham Shehab [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 21, 1999 11:06 PM Subject: insert BLOB values hi all of you, i have a column of type blob, that i wish to store images in it, but how can i right the sql statement to insert the image? i mean : insert into tblImages set imageField = ??? where id=999 now what the ??? should be ? thx guys. -- Hytham Shehab - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Understanding relational database setup/construction
For theory and history, I found the manual to be an excellent place to start... http://www.mysql.com/manual.php and have a walk through the tutorial starting with: http://www.mysql.com/doc/C/o/Connecting-disconnecting.html At 05:05 PM Saturday, 6/22/2002, Timothy J. Luoma wrote -= I've looked through Google and the MySQL website without luck. I'm looking to find a place which discusses the theory of how one should create a database, how to organize the information, etc. There's got to be a good site out there, but I'm obviously plugging in the wrong search terms or something. Ed Kasky Los Angeles, CA . . . . . . . . A closed mind is a beautiful thing to lose. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Understanding relational database setup/construction
TjL, To start with: http://www.amazon.com/exec/obidos/ASIN/0764507370/qid=1024783081/sr=8-1/ref= sr_8_1/104-4398960-1440757 If the title bothers you, take a Sharipe, cross out Dummies and write Managers, no one will ever know. :) This book gives an excellent primer in theory and normalization and some helpful hints. WARNING: The version I read (lo, these many years ago) was very MS-SQL centric. Once you have mastered these concept it presents try: http://www.amazon.com/exec/obidos/ASIN/1558605762/qid=1024783163/sr=1-1/ref= sr_1_1/104-4398960-1440757 This one has a bit more meat on it but boy is it good. Work your way through both books in a couple of months and then spend every waking hour organizing data into tables for a couple of years and you'll be there. (You know you have arrived when start assigning family members primary keys beause, well everybody knows that SSN's aren't unique!) ;) HTH, =C= -Original Message- From: Timothy J. Luoma [mailto:[EMAIL PROTECTED]] Sent: Saturday, June 22, 2002 4:06 PM To: MySQL List Subject: Understanding relational database setup/construction I've looked through Google and the MySQL website without luck. I'm looking to find a place which discusses the theory of how one should create a database, how to organize the information, etc. There's got to be a good site out there, but I'm obviously plugging in the wrong search terms or something. Thanks TjL - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Understanding relational database setup/construction
I haven't tried it, yet, but this looks like an interesting alternative for a try-before-you-buy method of selecting books: http://safari.informit.com/mainhom.asp?home You can subscribe to a list of books monthly and have full access to them online. If you take a look at this, I would recommend the New Riders title MySQL by Paul DuBois. There's just enough in there to explain how an RDBMS works and it's MySQL specific, so you can use it right away. If you want to get deeper into theory, you can move on from there -- but the basic concepts are pretty simple and can be applied to any relational db system. --jeff - Original Message - From: Timothy J. Luoma [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Saturday, June 22, 2002 2:05 PM Subject: Understanding relational database setup/construction I've looked through Google and the MySQL website without luck. I'm looking to find a place which discusses the theory of how one should create a database, how to organize the information, etc. There's got to be a good site out there, but I'm obviously plugging in the wrong search terms or something. Thanks TjL - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Hi CPU on FreeBSD
On Mon, May 27, 2002 at 11:46:44AM +0100, Simon Green wrote: Re Gunnar Helliesen e-mail I have FreeBSD4.2 and MySQL 3.23.49. I two have hi cpu (99%) on a twin cpu system. (Compaq DL380) After making the suggested changes to my.cnf we rebooted the system. For 3 days all ran fine (low cpu) then at 2am cpu went back up to 99%. Has any body know why FreeBSD with MySQL had this problem? Simon PS apart from that it kicks ass.as MySQL should... We've managed to reproduce this pretty reliably at Yahoo and are working to track and fix the bug. If we find a resolution, I'll post a note here. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.51: up 23 days, processed 517,327,740 queries (249/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Understanding relational database setup/construction
On 22/6/02 at 17:05, [EMAIL PROTECTED] (Timothy J. Luoma) wrote: I've looked through Google and the MySQL website without luck. I'm looking to find a place which discusses the theory of how one should create a database, how to organize the information, etc. There's got to be a good site out there, but I'm obviously plugging in the wrong search terms or something. Try the second edition of O'Reilly books' Managing and Using MySQL ISBN:0596002114. That'll get you started. Regards, Phil. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Hi CPU on FreeBSD
At 06:59 PM 6/22/2002, you wrote: On Mon, May 27, 2002 at 11:46:44AM +0100, Simon Green wrote: Re Gunnar Helliesen e-mail I have FreeBSD4.2 and MySQL 3.23.49. I two have hi cpu (99%) on a twin cpu system. (Compaq DL380) After making the suggested changes to my.cnf we rebooted the system. For 3 days all ran fine (low cpu) then at 2am cpu went back up to 99%. Has any body know why FreeBSD with MySQL had this problem? Simon PS apart from that it kicks ass.as MySQL should... We've managed to reproduce this pretty reliably at Yahoo and are working to track and fix the bug. If we find a resolution, I'll post a note here. There have been a few threads regarding high CPU utilization on FreeBSD systems. The 2nd processor may be causing the problem. You may want to contact the original authors to see if they've come up with a solution. Mike Here are 3 threads: Thread #1: X-Sieve: CMU Sieve 2.1 Received: from www.fastmail.fm ([unix socket]) by www.fastmail.fm (Cyrus v2.1.3) with LMTP; Tue, 11 Jun 2002 04:13:55 -0500 Received: from www.fastmail.fm (localhost [127.0.0.1]) by localhost.localdomain (Postfix) with ESMTP id 398FF6D9FB for [EMAIL PROTECTED]; Tue, 11 Jun 2002 04:13:55 -0500 (CDT) X-Mail-from: [EMAIL PROTECTED] X-Delivered-to: [EMAIL PROTECTED] Received: from web.mysql.com (web.mysql.com [192.58.197.162]) by www.fastmail.fm (Postfix) with SMTP id 43FE26D9E5 for [EMAIL PROTECTED]; Tue, 11 Jun 2002 04:13:54 -0500 (CDT) Received: (qmail 1417 invoked by uid 7797); 11 Jun 2002 09:04:38 - Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm (http://www.ezmlm.org) List-ID: mysql.mysql.com Precedence: bulk List-Help: mailto:[EMAIL PROTECTED] List-Unsubscribe: mailto:[EMAIL PROTECTED] List-Post: mailto:[EMAIL PROTECTED] List-Subscribe: mailto:[EMAIL PROTECTED] Delivered-To: mailing list [EMAIL PROTECTED] Received: (qmail 1341 invoked from network); 11 Jun 2002 09:04:17 - Content-Type: text/plain; charset=iso-8859-1 From: Leo De Geer [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Organization: Kristianstad Teknikverkstad To: Simon Green [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: problem with mysql threads on freebsd Date: Tue, 11 Jun 2002 11:12:46 +0200 X-Mailer: KMail [version 1.4] References: [EMAIL PROTECTED] In-Reply-To: [EMAIL PROTECTED] MIME-Version: 1.0 Message-Id: [EMAIL PROTECTED] On Tuesday 11 June 2002 10.48, Simon Green wrote: We are ruing a box with freeBSD and MySQL with twin processors It looked like it was using only on processor but we decided that it was the way FreeBSD's threads work? There seems to be two problems with ruing MySQL on FreeBSD. One: Seems not to use both processors (on twin system) Two: All ways a load on 1 even when the system in not at hi load (seem to go down when it is!) What is up with freeBSD or MySQL. Simon -Original Message- From: Leo De Geer [mailto:[EMAIL PROTECTED]] Sent: 11 June 2002 09:35 To: Alexander V Zubchenko Cc: Dicky Wahyu Purnomo; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: problem with mysql threads on freebsd On Tuesday 11 June 2002 09.57, Alexander V Zubchenko wrote: Greetings! On Tue, 11 Jun 2002, Leo De Geer wrote: but in my case its not good to have it that way im having one dedikated dual server for the sql and now im yust using one cpu for the sql questions. i nead it to start sub conections to the sql to serv all my conections good. In such case provide, please additional info. AFAIU, You want to use both cpu for sql, in other words, optimal use of Your server. Than, do You recompile (or compile) kernel with SMP support (afaik, this is only arch for multicpu systems, supported by fbsd)? You can b sure, that if mysql will run separate process for each request, it will slowdown perfomance, but never increase it. In fact, balancing load on many cpus is OS task. And multithreaded processes _must_ b processed similarly to multiprocess environment (but i don't know, how exactly fbsd smp-support built). Check Your kernel config /usr/src/sys/i386/conf/name. You may find also this name interesting: LINT - list [almost?] all options recognized in config-file. With respect, Alexander V Zubchenko, E-Mail: [EMAIL PROTECTED] System Administrator, WWW: http://www.hermes-comp.zp.ua/ Hermes-comp, Ukraine, Zaporizhzhya, Geroev Stalingrada 50 phone/fax: +380 612 64-19-72 the kernel is runing both cpu. and the balancing is working good on everything but the sql! i have on my linux sql server aproximatly 100 simultanius conections that du you think that the standard memory size of 128 do you think i nead to put it up to 256 meg in the kernel the problen nr 2 i dont have but the server we have dont handle the load on one cpu. at the moment we are runing the sql on a linux