MYSQL DELPHI COMPONENTS
I wonder if someone could tell me if I can use Delphi 6's , ClientDataSet, Query, DataSetProvider, Database and UpdateSQL components with MYSQL or I have to look at an alternative third party library. Does MYSQL supports transactions with InnoDB type tables ? Thanks Nikos - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: upgrade 3.23 - 4.0.3 question
I'm using 3.23.49 and it behaves perfectly. Okay I'll try 4.0.2 and see if it helps, thanks for the hint. Alexander Varshavchick, Metrocom Joint Stock Company Phone: (812)118-3322, 118-3115(fax) On Fri, 30 Aug 2002, Steven Roussey wrote: Date: Fri, 30 Aug 2002 10:49:28 -0700 From: Steven Roussey [EMAIL PROTECTED] To: Mysql [EMAIL PROTECTED] Cc: 'Varshavchick Alexander' [EMAIL PROTECTED] Subject: Re: upgrade 3.23 - 4.0.3 question - The real cause for the question lays in the problem which occured after I upgraded to 4.0.3 WITHOUT recompiling DBI module: the new mysql version worked without any visible errors, however it was unable to process more than about 30 queries per seconds, while the normal rate for this server is more than 100 queries/sec. How can it be so slow? Evidently something went wrong, but what could it be? - Would you be willing to try using 4.0.2 instead of 4.0.3? If you do not have the problem with 4.0.2, then the issue lies in something in 4.0.3. At least I have a problem with 4.0.3 in that it works fine for a few queries, but when I let it go at a normal 3000 queries per second it choked up and died (much like 3.23.51 -- by the way, which 3.23.x are you using now?). Thanks! 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
client-serwer communication protocol's documentation
Hi. I badly need the documentation to the mySQL client-server TCP/IP communication protocol. I'm trying to build some measurement system with VEE 6 from Agilent Technologies, mySQL and Apache. There is no possibility in VEE to use ODBC, so I've decided to make some VEE programming of the mySQL port direct string writing/receiving. I've tried to find this documentation, but I was not able. I would like to ask someone common with this topic to help me to get it somehow, or at least to answer if I can get it free for my non commercial purpose (if not I would have to discover another idea how to do it). Thanks in advance for Your answers. Regards, Krzysztof Krupa [EMAIL PROTECTED] student of Warsaw's University of Technology, Faculty of Electronics and Information Technology - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: How to run multiple mysql servers
Hi Okan, Well, the only solution I know of, to diffrentiate the two servers are to provide different argument on the command line. The server will allways read any of the files; my.ini or my.cnf first, and there set the parameters, after that it will take the command line arguments. This means that you should make sure that you override any properties in the files with the command line args, if necessary. There are couple of pages of this information in the manul; Running Multiple MySQL Server on the same Machine. Regards Tobias Tobias Eriksson ComOpt AB Michael Löfmans gata 6 254 38 Helsingborg, Sweden Direct: +46 42 389918 Phone: +46 42 389900 e-mail: [EMAIL PROTECTED] -Original Message- From: Okan CIMEN [mailto:[EMAIL PROTECTED]] Sent: 01 September 2002 11:40 To: Tobias Eriksson Subject: Re: How to run multiple mysql servers Hi Tobias, I am planning to run two servers at the same machine which are also replicating each other. But I want these servers to have different variables/my.ini files. I just wonder about the initial parameters of the second MySQL server. Does it also read the c:/winnt/my.ini values or do you refer it to some other parameter file? If so, how? Thanks for your help Regards Okan - Original Message - From: Tobias Eriksson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, August 30, 2002 3:47 PM Subject: RE: How to run multiple mysql servers I got it! Sorry, ohh... So simple The reason for the problem was ofcourse that I did not provide a --datadir=c:\\mysql\\data parameter, this superseeded the parameter set in the config file. Regards Tobias Tobias Eriksson ComOpt AB Michael Löfmans gata 6 254 38 Helsingborg, Sweden Direct: +46 42 389918 Phone: +46 42 389900 e-mail: [EMAIL PROTECTED] -Original Message- From: Tobias Eriksson Sent: 30 August 2002 14:41 To: [EMAIL PROTECTED] Subject: How to run multiple mysql servers I would like to run 2 mysqld-nt at the same time. This is because we are shipping mysql with our product and then we would like to have the database installed within our product. And also run separate from any other MySQL database that might be installed on the system. When I try to run the command: C:\mysql\binmysqld-nt --basedir=c:\\mysql --port=3321 --standalone mysqld-nt: Can't change dir to 'C:\Program Files\ComOpt\mysql\data\' (Errcode: 2) 020830 14:27:37 Aborting 020830 14:27:37 mysqld-nt: Shutdown Complete This seems to have to do with the file my.ini located in c:\winnt, because if I remove it, it will work. But according to the manual the command line arguments should have higher priority than the config files, or environment varibales. My question is thus, how do I come around this problem and make it possible to run multiple installations of MySQL ? Regards Tobias Tobias Eriksson ComOpt AB Michael Löfmans gata 6 254 38 Helsingborg, Sweden Direct: +46 42 389918 Phone: +46 42 389900 e-mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 installing
Scott, MySQL is available in two 'flavors': source code and (binary) executables. Which one did you intend to download/install? Which OpSys are you using? Please advise, =dn The instructions that I have to install MySQL, tells me to cd to the bin directory and run this command: ./mysql_install_db The problem is that my system can't find this file. Any suggestions? Thanks, Scott - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
libmysqld and connections to remote server.
Hi folks, I just started playing around with libmysqld and I would like to have some clarification concerning making connections to remote server. My first tries are pretty simple so far. I just linked some of my old lil code against libmysqld which worked (from the view compiling) immediately and without any problems. But now I got the problem that the applications are not able to connect to a remote server anymore and I wonder if this is due to some mistake in my code or if this is not possible with libmysqld at all. Just to make it clear. I am pretty aware that it is not possible to connect TO my embedded server and I am perfectly satisfied with that as stated in the manual: You can't connect to the embedded server from an outside process with sockets or TCP/IP. But what is with the other direction? I can think about a lot of examples which have a 'local' embedded server but still need the possibilty to connect to a remote MySql server as well. Is this possible with libmysqld or do I have to play around until I find out how to link against libmysql and mysqlclient to the same time (which I would find ... errr ... not that beautiful, cause it would make me do a lot of changes in my existing code I guess, and I am lazy by nature ;-) ) Actually I tried the library with the Windowssources (4.02) in case this is from some importance to answer my question. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 is driving me mad (3)
mysql is driving me mad (3) Many thanks for your help guys, I have the problem cracked. I, for the umpteenth time dropped the database and recreated it. then from the cli I put in the maximum value of characters. and there after it worked from my prog. Very strange! Thanks again bob - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
I can't understans it though. I did a mysql dump and transported that to the new server and then created the tables that way. So the two must be absolutely identical. (I include them @ the bottom of post) Again I get the same error. Could it be that the status of that particular username has changed ?? mysql show slave status; +---+-+-+---+---++---+-+-++---+--+ | Master_Host | Master_User | Master_Port | Connect_retry | Log_File | Pos| Slave_Running | Replicate_do_db | Replicate_ignore_db | Last_errno | Last_error | Skip_counter | +---+-+-+---+---++---+-+-++---+--+ | 196.25.84.193 | replicate | 3306| 60| ais-rad02-bin.004 | 987471 | Yes | | | 1054 | error 'Unknown column 'status' in 'field list'' on query 'update radcheck set status = 'active' where username = 'atlantic23419'' | 0| +---+-+-+---+---++---+-+-++---+--+ 1 row in set (0.00 sec) MASTER SERVER--- mysql desc radcheck; +---+-+--+-+--++ | Field | Type| Null | Key | Default | Extra | +---+-+--+-+--++ | id| int(10) | | PRI | NULL | auto_increment | | UserName | varchar(30) | | MUL | || | Attribute | varchar(30) | | | Password || | Value | varchar(40) | YES | | NULL || | status| varchar(16) | | | active || | op| char(2) | | | := || +---+-+--+-+--++ 6 rows in set (0.00 sec) SLAVE SERVER ysql desc radcheck; +---+-+--+-+--++ | Field | Type| Null | Key | Default | Extra | +---+-+--+-+--++ | id| int(10) | | PRI | NULL | auto_increment | | UserName | varchar(30) | | MUL | || | Attribute | varchar(30) | | | Password || | Value | varchar(40) | YES | | NULL || | status| varchar(16) | | | active || | op| char(2) | | | := || +---+-+--+-+--++ 6 rows in set (0.00 sec) Ralf Narozny wrote: Mozzi schrieb: Hallo all I am setting up replication. Now I am sure my servers can connect but I still have a problem. I setup my slave server to only replicate one table The error I get is copy'd underneath here. I am sure it is easey to solve I have just started thinking in loops now Tnx Mozzi +---+-+-+---++--+ | Master_Host | Master_User | Master_Port | Connect_retry | Log_File | Pos| Slave_Running | Replicate_do_db | Replicate_ignore_db | Last_errno | Last_error | Skip_counter | +---+-+-+---+--+--+ | 192.168.2.1 | replicate | 3306| 60| my-rad02-bin.004 | 987471 | Yes | | | 1054 | error 'Unknown column 'status' in 'field list'' on query 'update radcheck set status = 'active' where username = 'myrad23419'' | 0| +---+-+-+---+--+--+ 1 row in set (0.00 sec) As far as I can see the message is quite obvious: On your replication machine the table radcheck has no column of the name 'status' -- Ralf Narozny Besuchen Sie uns auf der DMS-Expo. SAP, Dokumenten- management oder das komplette Office ins Portal einbinden? Wir zeigen es Ihnen - vom 3. bis 5.9. auf der Messe Essen Halle 3, Stand 3255 SPLENDID Internet GmbH Co KG Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax: +49 431 660 97 20 mailto:[EMAIL PROTECTED], http://www.splendid.de
Re: MySQL 4.0.2, 4.0.3 replication circle broken.
Hello Victoria, Thursday, August 15, 2002, you wrote: AVR In case of repliacation circle (A-B-A) query 'flush log' on any of AVR this servers create endless loop, with creating new binary log file AVR on each iteration. (about 30 new files every second in my case) Thanks for bug report! I tested it yesterday and also have got thousands of log files :( 4.0.3 Already out, but bug is still exists. Does anybody something to fix this bus? -- Best regards, Artem mailto:[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: upgrade 3.23 - 4.0.3 question
No, switching to 4.0.2 didn't help either, and here is an additional clue which may help: all mysql threads on the 4.0.* are in the sending data state, while for the 3.23 the state is changing all the time to writing to the net, connecting and others. It seems as though the 4.0 version has problems in communicating with DBI module which was left unchanged. So again we're returning to the questuin should DBI be reinstalled or no? regards Alexander Varshavchick, Metrocom Joint Stock Company Phone: (812)118-3322, 118-3115(fax) On Mon, 2 Sep 2002, Varshavchick Alexander wrote: Date: Mon, 2 Sep 2002 11:02:54 +0400 (MSD) From: Varshavchick Alexander [EMAIL PROTECTED] To: Steven Roussey [EMAIL PROTECTED] Cc: Mysql [EMAIL PROTECTED] Subject: Re: upgrade 3.23 - 4.0.3 question I'm using 3.23.49 and it behaves perfectly. Okay I'll try 4.0.2 and see if it helps, thanks for the hint. Alexander Varshavchick, Metrocom Joint Stock Company Phone: (812)118-3322, 118-3115(fax) On Fri, 30 Aug 2002, Steven Roussey wrote: Date: Fri, 30 Aug 2002 10:49:28 -0700 From: Steven Roussey [EMAIL PROTECTED] To: Mysql [EMAIL PROTECTED] Cc: 'Varshavchick Alexander' [EMAIL PROTECTED] Subject: Re: upgrade 3.23 - 4.0.3 question - The real cause for the question lays in the problem which occured after I upgraded to 4.0.3 WITHOUT recompiling DBI module: the new mysql version worked without any visible errors, however it was unable to process more than about 30 queries per seconds, while the normal rate for this server is more than 100 queries/sec. How can it be so slow? Evidently something went wrong, but what could it be? - Would you be willing to try using 4.0.2 instead of 4.0.3? If you do not have the problem with 4.0.2, then the issue lies in something in 4.0.3. At least I have a problem with 4.0.3 in that it works fine for a few queries, but when I let it go at a normal 3000 queries per second it choked up and died (much like 3.23.51 -- by the way, which 3.23.x are you using now?). Thanks! 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: Replication
can you show us, your my.cnf configuration for replication only master and slave ... ;-) my first guest is : the slave working db is not being set properly ... so when master doing query on DB A on table B, the slave try to look at DB blank on table B. see on Replicate-do-db column on show slave status : empty ;-) -- Write clearly - don't be too clever. - The Elements of Programming Style (Kernighan Plaugher) MySQL 3.23.51 : up 73 days, Queries : 357.128 per second (avg). -- Dicky Wahyu Purnomo - System Administrator PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan 12790 Phone : +62 21 79199577 - HP : +62 8551044244 - Web : http://www.1rstwap.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: Query problem in Perl
Hi, You need to use two separate database and statement handles - you can only have one active query per handle. eg. $dbh1 = DBI-connect(...); $dbh2 = DBI-connect(...); $sth1 = $dbh1-prepare( ... ); $sth1-execute(...); while ( $sth1-fetch() ) { $sth2 = $dbh2-prepare( ... ); $sth2-execute(...); while ( $sth2-fetch() ) { } } On Sat, 2002-08-31 at 20:23, Almar van Pel wrote: Hello, I was trying to create a simple perl program, where my domains where listed followed by there DNS records. But It loops once, and then ends with error DBD::mysql::st fetch failed: fetch() without execute() at test.cgi line 61. I thougt this was the easyest way to do so. But no.. Does anyone have any experience with these kind of sub-statements? $dbh = DBI-connect(DBI:mysql:database=$db_database;host=$db_host, $db_user, $db_pw) || db_error(Databaseverbinding niet gemaakt: $DBI::errstr); $sql = select domain from bind_dns_header; $sth = $dbh-prepare($sql)|| error(Kan het statement niet voorbereiden: $dbh-errstr); $sth-execute || error(Fout bij het communiceren met de database: $DBI::errstr); $sth-bind_columns(\$domain); while ($sth-fetch()) { # line 61 print $domain with the following recordsbr \n; $sql2 = select dnsrecord_id from bind_dns_item where domain = '$domain'; $sth = $dbh-prepare($sql2)|| error(Kan het statement niet voorbereiden: $dbh-errstr); $sth-execute || error(Fout bij het communiceren met de database: $DBI::errstr); $sth-bind_columns(\$dnsrecord_id); while ($sth-fetch()) { print Record: $dnsrecord_id \n; } } $sth-finish(); Regards, Almar - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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-4.0.3-beta requires OpenSSL_add_all_algorithms, not in
OpenSSL-0.9.7-beta3 Description: gcc -O3 -DDBUG_OFF -O2 -fno-strength-reduce -o test-ssl test-ssl.o -L/usr/local/ssl/lib -L/usr/local/lib ../dbug/libdbug.a libvio.a ../mysys/libmysys.a ../strings/libmystrings.a libvio.a -L/usr/lib -lssl -lcrypto -lz -lcrypt -lm -pthread /usr/lib/libc.so.4: WARNING! setkey(3) not present in the system! /usr/lib/libc.so.4: warning: this program uses gets(), which is unsafe. /usr/lib/libc.so.4: warning: mktemp() possibly used unsafely; consider using mkstemp() /usr/lib/libc.so.4: WARNING! des_setkey(3) not present in the system! /usr/lib/libc.so.4: WARNING! encrypt(3) not present in the system! /usr/lib/libc.so.4: warning: tmpnam() possibly used unsafely; consider using mkstemp() /usr/lib/libc.so.4: warning: this program uses f_prealloc(), which is not recommended. /usr/lib/libc.so.4: WARNING! des_cipher(3) not present in the system! /usr/lib/libc.so.4: warning: tempnam() possibly used unsafely; consider using mkstemp() libvio.a(viosslfactories.o): In function `new_VioSSLConnectorFd': viosslfactories.o(.text+0x23e): undefined reference to `OpenSSL_add_all_algorithms' libvio.a(viosslfactories.o): In function `new_VioSSLAcceptorFd': viosslfactories.o(.text+0x34d): undefined reference to `OpenSSL_add_all_algorithms' *** Error code 1 Stop in /var/stage/mysql-4.0.3-beta/vio. *** Error code 1 Stop in /var/stage/mysql-4.0.3-beta. *** Error code 1 - - - - - - - - - - - - - - - - - - - - - - - - - strings /usr/local/ssl/lib/libcrypto.so.0.9.7 | grep OpenSSL | more OpenSSLDie DSA_OpenSSL DH_OpenSSL OpenSSL_add_all_ciphers OpenSSL_add_all_digests UI_OpenSSL %s(%d): OpenSSL internal error, assertion failed: %s OpenSSL 0.9.7-beta3 30 Jul 2002 MD2 part of OpenSSL 0.9.7-beta3 30 Jul 2002 MD4 part of OpenSSL 0.9.7-beta3 30 Jul 2002 MD5 part of OpenSSL 0.9.7-beta3 30 Jul 2002 SHA part of OpenSSL 0.9.7-beta3 30 Jul 2002 SHA1 part of OpenSSL 0.9.7-beta3 30 Jul 2002 RIPE-MD160 part of OpenSSL 0.9.7-beta3 30 Jul 2002 libdes part of OpenSSL 0.9.7-beta3 30 Jul 2002 DES part of OpenSSL 0.9.7-beta3 30 Jul 2002 !#$% !#$%'()*+,-./0123456789:;=?@ABCD./0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijk lmnopqrstuvwxyzRC2 part of OpenSSL 0.9.7-beta3 30 Jul 2002 RC4 part of OpenSSL 0.9.7-beta3 30 Jul 2002 RC5 part of OpenSSL 0.9.7-beta3 30 Jul 2002 IDEA part of OpenSSL 0.9.7-beta3 30 Jul 2002 Blowfish part of OpenSSL 0.9.7-beta3 30 Jul 2002 CAST part of OpenSSL 0.9.7-beta3 30 Jul 2002 Big Number part of OpenSSL 0.9.7-beta3 30 Jul 2002 EC part of OpenSSL 0.9.7-beta3 30 Jul 2002 RSA part of OpenSSL 0.9.7-beta3 30 Jul 2002 DSA part of OpenSSL 0.9.7-beta3 30 Jul 2002 OpenSSL DSA method OpenSSL DH Method Diffie-Hellman part of OpenSSL 0.9.7-beta3 30 Jul 2002 OpenSSL 'dlfcn' shared library method AES part of OpenSSL 0.9.7-beta3 30 Jul 2002 Stack part of OpenSSL 0.9.7-beta3 30 Jul 2002 lhash part of OpenSSL 0.9.7-beta3 30 Jul 2002 RAND part of OpenSSL 0.9.7-beta3 30 Jul 2002 You need to read the OpenSSL FAQ, http://www.openssl.org/support/faq.html EVP part of OpenSSL 0.9.7-beta3 30 Jul 2002 ASN.1 part of OpenSSL 0.9.7-beta3 30 Jul 2002 PEM part of OpenSSL 0.9.7-beta3 30 Jul 2002 X.509 part of OpenSSL 0.9.7-beta3 30 Jul 2002 CONF part of OpenSSL 0.9.7-beta3 30 Jul 2002 CONF_def part of OpenSSL 0.9.7-beta3 30 Jul 2002 OpenSSL default TXT_DB part of OpenSSL 0.9.7-beta3 30 Jul 2002 OpenSSL default user interface How-To-Repeat: repeat compile Fix: Submitter-Id: submitter ID Originator:J.D. Organization: MySQL support: none Synopsis: Requests OpenSSL_add_all_algorithms not in OpenSSL-0.9.7-beta3 Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql-4.0.3-beta Environment: System: FreeBSD freebsd2.localnet10 4.6-RELEASE FreeBSD 4.6-RELEASE #3: Sat Jul 20 04:01:32 CDT 2002 [EMAIL PROTECTED]:/usr/src/sys/compile/XSYSTEM i386 Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Using builtin specs. gcc version 2.95.3 20010315 (release) [FreeBSD] Compilation info: CC='gcc' CFLAGS='-O3 -fno-omit-frame-pointer' CXX='gcc' CXXFLAGS='-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: -r--r--r-- 1 root wheel 132 Jun 11 04:18 /usr/lib/libc.a lrwxrwxrwx 1 root wheel 9 Jul 2 03:07 /usr/lib/libc.so - libc.so.4 -r--r--r-- 1 root wheel 579412 Jun 11 04:18 /usr/lib/libc.so.4 Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --with-server-suffix= --enable-thread-safe-client --enable-local-infile --enable-assembler --with-named-z-libs=not-used --disable-shared 'CFLAGS=-O3 -fno-omit-frame-pointer' CXX=gcc CC=gcc 'CXXFLAGS=-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti' - Before posting, please check: http://www.mysql.com/manual.php (the
Re: 3.23.52 hitting system loads of 25+?
Jeremy and Michael, What compiler versions are you using? (just the gcc -v) I'm wondering especially since MySQL has a warning posted about gcc 2.96 with 2.4 kernels. Which reminds me, what specific kernel versions are you guys using? (Jeremy, is yours a custom kernel from Redhat source or Linus source?) Still trying to track this down... Thanks guys. =john Jeremy Zawodny wrote: On Sat, Aug 31, 2002 at 09:58:58AM -0400, Michael Bacarella wrote: We experienced a similar problem with 3.23.51 which went away once we compiled from source. Assume this is Linux 2.4? I've also had good luck with 3.23.51 built from source. I build on a Debian testing box and run the server on a RedHat 7.2 machine with a custom 2.4.18 SMP kernel. Jeremy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Heya Dicky How are you ? Havn't seen you in a while ;-) kay what I did was RESET MASTER and RESET SLAVE And restartted slave That worked!!! Now what I want to know is when I give the command show slave status I get the following mysql show slave status; +---+-+-+---+---+-+---+-+-+++--+ | Master_Host | Master_User | Master_Port | Connect_retry | Log_File | Pos | Slave_Running | Replicate_do_db | Replicate_ignore_db | Last_errno | Last_error | Skip_counter | +---+-+-+---+---+-+---+-+-+++--+ | 196.25.84.193 | replicate | 3306| 60| ais-rad02-bin.001 | 2575635 | Yes | | | 0 || 0| +---+-+-+---+---+-+---+-+-+++--+ 1 row in set (0.01 sec) Is it actually replicating ? my my.cnf files look like this SLAVE--- [mysqld] socket=/var/lib/mysql/mysql.sock server-id=2 master-host=myip master-user=user master-password=passwd replicate-do-table=radius.radcheck replicate-do-table=radius.usergroup log=/var/log/mysqld.log ---end MASTER-- [mysqld] socket=/var/lib/mysql/mysql.sock server-id=1 log=/var/log/mysqld.log log-bin end How long does it take normally ? Tnx all Mozzi Dicky Wahyu Purnomo wrote: can you show us, your my.cnf configuration for replication only master and slave ... ;-) my first guest is : the slave working db is not being set properly ... so when master doing query on DB A on table B, the slave try to look at DB blank on table B. see on Replicate-do-db column on show slave status : empty ;-) -- Write clearly - don't be too clever. - The Elements of Programming Style (Kernighan Plaugher) MySQL 3.23.51 : up 73 days, Queries : 357.128 per second (avg). -- Dicky Wahyu Purnomo - System Administrator PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan 12790 Phone : +62 21 79199577 - HP : +62 8551044244 - Web : http://www.1rstwap.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
select using 2 left joins
Hi all, I'm having troubles with a good selection statement in my query. I have three tables: tableAds, tableProducts and tableManufacturer. They all have unique ID's defined. In the tableProducts there is a column named manufacturerID. So I know which product was made by which manufacturer. In the tableAds I have a column ProductsID so I know what Product is advertised. Now I want to find all the adsvertisments of products which are made by a specific manufacturer. I'm trying a query like: SELECT * FROM tableAds LEFT JOIN tableProducts ON (tableProducts.productsID=tableAds.productsID) LEFT JOIN tableManufacturers ON (tableManufacturers.manufacturersID=tableProducts.manufacturersID) WHERE manufacturersID=12 However this query returns all advertisments in the tableAds and not the Ads wirth manufacturer number 12 involved. Anybody knows how to improve this query? Any help would be much appreciated. thx in advance. Wilbert Enserink - Pas de Deux Van Mierisstraat 25 2526 NM Den Haag tel 070 4450855 fax 070 4450852 http://www.pdd.nl [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: Query problem in Perl
On Mon, 2002-09-02 at 11:37, Harald Fuchs wrote: In article 1030961610.8175.5.camel@pascal, Martin Waite [EMAIL PROTECTED] writes: Hi, You need to use two separate database and statement handles - you can only have one active query per handle. eg. $dbh1 = DBI-connect(...); $dbh2 = DBI-connect(...); $sth1 = $dbh1-prepare( ... ); $sth1-execute(...); while ( $sth1-fetch() ) { $sth2 = $dbh2-prepare( ... ); $sth2-execute(...); while ( $sth2-fetch() ) { } } Nope. You can have multiple active statement handles per database handle. Harald is correct (- thanks), but you still need a separate statement handle for the query inside the loop: $dbh1 = DBI-connect(...); $sth1 = $dbh1-prepare( ... ); $sth1-execute(...); while ( $sth1-fetch() ) { $sth2 = $dbh1-prepare( ... ); $sth2-execute(...); while ( $sth2-fetch() ) { } } - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Pada Mon, 02 Sep 2002 12:51:50 +0200 Mozzi [EMAIL PROTECTED] menulis : Heya Dicky How are you ? Havn't seen you in a while ;-) kay what I did was RESET MASTER and RESET SLAVE And restartted slave That worked!!! Now what I want to know is when I give the command show slave status I get the following mysql show slave status; +---+-+-+---+---+-+---+-+-+++--+ | Master_Host | Master_User | Master_Port | Connect_retry | Log_File | Pos | Slave_Running | Replicate_do_db | Replicate_ignore_db | Last_errno | Last_error | Skip_counter | +---+-+-+---+---+-+---+-+-+++--+ | 196.25.84.193 | replicate | 3306| 60| ais-rad02-bin.001 | 2575635 | Yes | | | 0 || 0| +---+-+-+---+---+-+---+-+-+++--+ 1 row in set (0.01 sec) Is it actually replicating ? my my.cnf files look like this SLAVE--- [mysqld] socket=/var/lib/mysql/mysql.sock server-id=2 master-host=myip master-user=user master-password=passwd replicate-do-table=radius.radcheck replicate-do-table=radius.usergroup log=/var/log/mysqld.log ---end MASTER-- [mysqld] socket=/var/lib/mysql/mysql.sock server-id=1 log=/var/log/mysqld.log log-bin end How long does it take normally ? normal to me :D usually i use binlog-do-db= and replicate-do-db= that's why i found your slave status is a little not normal to me :D as long as what you need is working, then everything is ok ;-) -- Let's call it an accidental feature. -- Larry Wall MySQL 3.23.51 : up 73 days, Queries : 357.245 per second (avg). -- Dicky Wahyu Purnomo - System Administrator PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan 12790 Phone : +62 21 79199577 - HP : +62 8551044244 - Web : http://www.1rstwap.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: Query problem in Perl
Hello! Almar van Pel wrote: Hello, I was trying to create a simple perl program, where my domains where listed followed by there DNS records. But It loops once, and then ends with error DBD::mysql::st fetch failed: fetch() without execute() at test.cgi line 61. I thougt this was the easyest way to do so. But no.. Does anyone have any experience with these kind of sub-statements? $dbh = DBI-connect(DBI:mysql:database=$db_database;host=$db_host, $db_user, $db_pw) || db_error(Databaseverbinding niet gemaakt: $DBI::errstr); $sql = select domain from bind_dns_header; $sth = $dbh-prepare($sql)|| error(Kan het statement niet voorbereiden: $dbh-errstr); $sth-execute || error(Fout bij het communiceren met de database: $DBI::errstr); $sth-bind_columns(\$domain); while ($sth-fetch()) { # line 61 *look at the name of the statement handle above* print $domain with the following recordsbr \n; $sql2 = select dnsrecord_id from bind_dns_item where domain = '$domain'; $sth = $dbh-prepare($sql2)|| error(Kan het statement niet voorbereiden: $dbh-errstr); Here is your problem! You overwrite the $sth which you want to use in the outer while. Use a different variable for the inner handle. In the inner while you already fetched all rows for sth returning to the next outer loop will fail. $sth-execute || error(Fout bij het communiceren met de database: $DBI::errstr); $sth-bind_columns(\$dnsrecord_id); while ($sth-fetch()) { print Record: $dnsrecord_id \n; } } $sth-finish(); Greetings Ralf -- Ralf Narozny Besuchen Sie uns auf der DMS-Expo. SAP, Dokumenten- management oder das komplette Office ins Portal einbinden? Wir zeigen es Ihnen - vom 3. bis 5.9. auf der Messe Essen Halle 3, Stand 3255 SPLENDID Internet GmbH Co KG Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax: +49 431 660 97 20 mailto:[EMAIL PROTECTED], http://www.splendid.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
problems adding records to mysql db using odbc/access 2000
Hi, Can someone tell me how I can add a record to a mysql table via an Access 2000 interface using ODBC ver 2.50.39. The primary key on the msyql db is set to auto_increment. When I link to these tables via Access/ODBC the field type in Access is marked as a 'number' data type. Since the tables are linked I cannot change anything on the Access side of the equation. I want to add a record into the mysql table, but everytime I do this I get the following error message: You tried to assign the Null value to a variable that isn't a Variant data type. I have defined the default value (in Access) to be 'null', but in order to do this the data type needs to be 'variant'. How can I get this field to be of 'variant' type? Any help would be appreciated TIA Dean - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Inno DB Question
Hi all, I'm using MySQL 4.0.2 alpha-max with Inno DB and Borland Builder 6.0 to connect to MySQL. I'm trying to use the new dbExpress component for Borland to connect to MySQL using the libmysql.dll I have been making some tests with transactions using the dbExpress components and the normal ODBC but I can't get the ROLLBACK function to work. Here are some examples: using dbExpress TSQLConnection Q; Q= new TSQLQuery(Application); Q-SQLConnection=SQLConnection1; /* I test with and without BEGIN Q-SQL-Clear(); Q-SQL-Add(BEGIN); Q-ExecSQL(); */ Q-SQL-Clear(); Q-SQL-Add(SET AUTOCOMMIT=0); Q-ExecSQL(); Q-SQL-Clear(); Q-SQL-Add(INSERT INTO regn_info VALUES('t1','test1')); Q-ExecSQL(); Q-SQL-Clear(); Q-SQL-Add(INSERT INTO regn_info VALUES('t2','test2')); Q-ExecSQL(); Q-SQL-Clear(); Q-SQL-Add(ROLLBACK); Q-ExecSQL(); //-- Using ODBC TQuery *Q_ODBC; Q_ODBC= new TQuery(Application); Q_ODBC-DatabaseName=salsadb; /* Q-SQL-Clear(); Q-SQL-Add(BEGIN); Q-ExecSQL(); */ Q_ODBC-SQL-Clear(); Q_ODBC-SQL-Add(SET AUTOCOMMIT=0); Q_ODBC-ExecSQL(); Q_ODBC-SQL-Clear(); Q_ODBC-SQL-Add(INSERT INTO regn_info VALUES('t1','test1')); Q_ODBC-ExecSQL(); Q_ODBC-SQL-Clear(); Q_ODBC-SQL-Add(INSERT INTO regn_info VALUES('t2','test2')); Q_ODBC-ExecSQL(); Q_ODBC-SQL-Clear(); Q_ODBC-SQL-Add(ROLLBACK); Q_ODBC-ExecSQL(); In both cases the ROLLBACK dosen't work and I get the inserted values in the table. Any idea what can be happening? Thanks a lot Javier Diaz -- This e-mail is intended for the named addressee only. It may contain confidential and/or privileged information. If you have received this message in error, please let us know and then delete this message from your system. You should not copy the message, use it for any purpose or disclose its contents to anyone. This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 number of rows
Does anyone know what the maximum number of rows a MyISAM table can store is? We currently have a table (27 GB .MYD, 17GB .MYI) holding more than 2^31 rows: mysql select count(*) from BigTable; ++ | count(*) | ++ | 947945 | ++ 1 row in set (0.09 sec) We're afraid there is hard, implementation imposed limit of unsigned int (2^32) on the number of rows. Before trying to verify this by loading 4.3 billion records into a table, I thought it would be worth asking... Thanks, Lukas Knecht - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 ?
Why mysql corrupt tables if filesystem if full ... ? On good database servers (eg. PROGRESS) process shutdown server (protetcting data). sytem: linux-2.2.19 mysql-3.23-38 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: problems adding records to mysql db using odbc/access 2000
Dean, Which MDAC version do you use with ODBC ? Henk -Original Message- From: Dean Browett [mailto:[EMAIL PROTECTED]] Sent: maandag 2 september 2002 13:38 To: [EMAIL PROTECTED] Subject: problems adding records to mysql db using odbc/access 2000 Hi, Can someone tell me how I can add a record to a mysql table via an Access 2000 interface using ODBC ver 2.50.39. The primary key on the msyql db is set to auto_increment. When I link to these tables via Access/ODBC the field type in Access is marked as a 'number' data type. Since the tables are linked I cannot change anything on the Access side of the equation. I want to add a record into the mysql table, but everytime I do this I get the following error message: You tried to assign the Null value to a variable that isn't a Variant data type. I have defined the default value (in Access) to be 'null', but in order to do this the data type needs to be 'variant'. How can I get this field to be of 'variant' type? Any help would be appreciated TIA Dean - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php ** The information in this message is confidential and may be legally privileged. It is intended solely for the addressee. Access to this message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, or distribution of the message, or any action or omission taken by you in reliance on it, is prohibited and may be unlawful. Please immediately contact the sender if you have received this message in error. ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Don't understand it still It doesn't give me errors in logfile orf when I type show server stutus. Yet it isn't replicating !! Any ideas ? I even tryed checking file sizes between servers on the .MYD file and it isn't working Mozzi Dicky Wahyu Purnomo wrote: Pada Mon, 02 Sep 2002 12:51:50 +0200 Mozzi [EMAIL PROTECTED] menulis : Heya Dicky How are you ? Havn't seen you in a while ;-) kay what I did was RESET MASTER and RESET SLAVE And restartted slave That worked!!! Now what I want to know is when I give the command show slave status I get the following mysql show slave status; +---+-+-+---+---+-+---+-+-+++--+ | Master_Host | Master_User | Master_Port | Connect_retry | Log_File | Pos | Slave_Running | Replicate_do_db | Replicate_ignore_db | Last_errno | Last_error | Skip_counter | +---+-+-+---+---+-+---+-+-+++--+ | 196.25.84.193 | replicate | 3306| 60| ais-rad02-bin.001 | 2575635 | Yes | | | 0 || 0| +---+-+-+---+---+-+---+-+-+++--+ 1 row in set (0.01 sec) Is it actually replicating ? my my.cnf files look like this SLAVE--- [mysqld] socket=/var/lib/mysql/mysql.sock server-id=2 master-host=myip master-user=user master-password=passwd replicate-do-table=radius.radcheck replicate-do-table=radius.usergroup log=/var/log/mysqld.log ---end MASTER-- [mysqld] socket=/var/lib/mysql/mysql.sock server-id=1 log=/var/log/mysqld.log log-bin end How long does it take normally ? normal to me :D usually i use binlog-do-db= and replicate-do-db= that's why i found your slave status is a little not normal to me :D as long as what you need is working, then everything is ok ;-) -- Let's call it an accidental feature. -- Larry Wall MySQL 3.23.51 : up 73 days, Queries : 357.245 per second (avg). -- Dicky Wahyu Purnomo - System Administrator PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan 12790 Phone : +62 21 79199577 - HP : +62 8551044244 - Web : http://www.1rstwap.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: Maximum number of rows
Hi Lucas, | Does anyone know what the maximum number of rows a | MyISAM table can store is? We currently have a table | We're afraid there is hard, implementation imposed limit | of unsigned int (2^32) on the number of rows. Before trying My guess is that the limit is not in terms of rows, but how large the filesize is because the filesystem imposes constraints. I am assuming you read this already? http://www.mysql.com/doc/en/Table_size.html A few things I'd like to draw your attention to: 1. With the new MyISAM table type in MySQL Version 3.23, the maximum table size is pushed up to 8 million terabytes (2 ^ 63 bytes). 2. If your big table is going to be read-only, you could use myisampack to merge and compress many tables to one. myisampack usually compresses a table by at least 50%, so you can have, in effect, much bigger tables. 3. You can go around the operating system file limit for MyISAM data files by using the RAID option. Hope this is useful? -Shanx. Shashank Tripathi www.shanx.com 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
Help! Recovering corrupt table
I'm using MySQL 3.23.51. I have a table which started giving 127 errors. Running myisamchk -i on it gives: Checking MyISAM file: /Users/rolf/WBD/back/clip.MYI Data records: 27497 Deleted blocks: 0 ./bin/myisamchk: warning: 9 clients is using or hasn't closed the table properly - check file-size ./bin/myisamchk: error: Size of datafile is: 8236926 Should be: 8238220 - check key delete-chain - check record delete-chain - check index reference - check data record references index: 1 Key: 1: Keyblocks used: 91% Packed:0% Max levels: 3 - check data record references index: 2 Key: 2: Keyblocks used: 89% Packed:0% Max levels: 3 - check data record references index: 3 Key: 3: Keyblocks used: 56% Packed: 97% Max levels: 2 - check data record references index: 4 Key: 4: Keyblocks used: 87% Packed: -12% Max levels: 3 Total:Keyblocks used: 80% Packed: 88% - check record links ./bin/myisamchk: error: Wrong bytesec: 44-45-49 at linkstart: 7127940 MyISAM-table '/Users/rolf/WBD/back/clip.MYI' is corrupted Running myiasmchk -r -q fails with - check key delete-chain - check record delete-chain - recovering (with sort) MyISAM-table '/Users/rolf/WBD/back/test/clip.MYI' Data records: 27497 - Fixing index 1 Wrong bytesec: 44- 45- 49 at7127940; Skipped MyISAM-table '/Users/rolf/WBD/back/test/clip.MYI' is not fixed because of errors Try fixing it by using the --safe-recover (-o) or the --force (-f) option Running myisamchk -r -o produces a ton of output - recovering (with keycache) MyISAM-table '/Users/rolf/WBD/back/test/clip.MYI' Data records: 1 Wrong bytesec: 44- 45- 49 at7127940; Skipped Found link that points at 3980867614565072899 (outside data file) at 6376 Found link that points at 3980867614565072899 (outside data file) at 6528 Found link that points at 3980867614565072899 (outside data file) at 6752 Found link that points at 3980867614565072899 (outside data file) at 6904 Found link that points at 3980867614565072899 (outside data file) at 7056 .. Found link that points at 3983412983983374339 (outside data file) at 229808 Wrong bytesec: 55- 54- 57 at7969612; Skipped Found link that points at 4025635330001666051 (outside data file) at 231384 .. Found link that points at 3480453488780115971 (outside data file) at 1069456 Wrong bytesec: 55- 54- 57 at7703144; Skipped Found block with too small length at 1081248; Skipped Wrong bytesec: 44- 45- 50 at7707776; Skipped Wrong bytesec: 45- 50- 49 at7712448; Skipped Wrong bytesec: 76-105-118 at7795904; Skipped Found link that points at 3501284836079960067 (outside data file) at 1129552 Found link that points at 3501284836079960067 (outside data file) at 1129712 .. Found block that points outside data file at 8221756 Found link that points at 3980602636557746179 (outside data file) at 848 Found block that points outside data file at 8222804 Found block that points outside data file at 8222828 Found block with too small length at 8222952; Skipped Found block that points outside data file at 8223048 Found link that points at 3980602636557746179 (outside data file) at 8223128 .. Found block that points outside data file at 8230212 Found block that points outside data file at 8231828 Data records: 1030 It recovers my table but I end up with only 1030 out of 27497 rows, so that's not a log of help! Running myisamchk -r -e gives a similar result (only 1030 rows are recovered), as does truncating the table first then restored the MYD file and running myiasmchk. Any other suggestions as to what to try? I'm happy to try to write some code of my own to walk through the MYD file and extract anything that looks like valid data. Is the MYD file format documented anywhere? Many thanks, -Rolf -- Rolf Howarth, Square Box Systems Ltd, Stratford-upon-Avon UK. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
sysdate or curdate as default date in mysql
Dear All! Can we define sysdate or curdate as default date for a column of datatype 'date' while creating a table? Regards Sql, mysql, 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
MyISAM and Lock table question
Hi all, Just a little question on the MyISAM table lock implementation ... I just see ( with show full processlist ) that my version of mysql ( 3.23.45 binary linux tar.gz ) locked my MyISAM table at every query and not only for update / delete / insert. Why is it locking table for select query ? Did i miss something somewhere ? Thanks David - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: query crashes 4.03 every time
Matthew, Saturday, August 31, 2002, 10:41:27 PM, you wrote: MM Here is the evil query: MM SELECT DISTINCT * FROM b2posts WHERE 1=1 AND ID = 124 AND ((post_title MM LIKE '%%') OR (post_content LIKE '') OR (post_title LIKE '%%') OR MM (post_content LIKE '%%')) AND post_date '2002-08-31 14:31:55' AND post_category 0 ORDER BY post_date DESC MM Here's a structure dump of the table it's trying to select from: MM CREATE TABLE b2comments ( MM comment_ID int(11) unsigned NOT NULL auto_increment, MM comment_post_ID int(11) NOT NULL default '0', MM comment_author tinytext NOT NULL, MM comment_author_email varchar(100) NOT NULL default '', MM comment_author_url varchar(100) NOT NULL default '', MM comment_author_IP varchar(100) NOT NULL default '', MM comment_date datetime NOT NULL default '-00-00 00:00:00', MM comment_content text NOT NULL, MM comment_karma int(11) NOT NULL default '0', MM PRIMARY KEY (comment_ID) MM ) TYPE=MyISAM; May be I'm blind, :-) but you provided dump of another table than you used in the query. What is the structure of table 'b2posts'? What type of errors do you get? Is there anything in the error log? What OS do you use? How did you installed MySQL: from binary or from source? MM This is my first time posting to the list, so do you need any more MM information? I'll be happy to provide any other information needed, PHP MM or SQL code, etcetera. -- 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: Wrong Sorting in arabic alphabets
abdul, Saturday, August 31, 2002, 8:05:27 PM, you wrote: aÚÇ Wrong Sorting in arabic alphabets aÚÇ Hi, aÚÇ This bug is for Arabic alphabets. aÚÇ I am using mysql 32.23.52 What character set do you use? There is no character set for arabic language in MySQL. -- 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: mysql default charset
Alexander, Sunday, September 01, 2002, 11:33:56 PM, you wrote: AP How can I set my mysqld-nt.exe to run different charset AP for example cp1251. Currently you can't use different character sets with one MySQL server. AP I tried mysqld-nt.exe --default-charset-set=cp1251 AP but it started second instance of mysqld-nt and my MySQL did not order AP correctly cyrillic. What version of MySQL do you use? How did you INSERT data into table, i.e. via GUI client, via mysql.exe client program or anything else? -- 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: Problem installing
Scott, Sunday, September 01, 2002, 9:23:38 PM, you wrote: SB The instructions that I have to install MySQL, tells me to cd to the bin SB directory and run this command: ./mysql_install_db SB The problem is that my system can't find this file. Any suggestions? Scott, you provided not enough info.. What OS are you using? How did you install MySQL? -- 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
build under Win32
Hi, All. I cannot build mysql mysql-3.23.52-win-src.zip (and mysql-3.23.51-win-src.zip, and mysql-max-4.0.1-alpha-win.zip). Error arise when I build string.lib. Configuration: strings - Win32 Debug Performing Custom Build Step on .\Strxmov.asm ' tempfile.bat' is not recognized as an internal or external command, operable program or batch file. Error executing c:\winnt\system32\cmd.exe. strings.lib - 1 error(s), 0 warning(s) I have Windows NT 6SP and VC6. what does it matter? Best, Nick. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Euro sign mysql
Hello everyone, how can I insert records with the Euro sign into the mysql database? When i try to insert the euro sign i get the err message 'query is empty'. Can somebody help? thanks Derk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: sysdate or curdate as default date in mysql
If what you are looking for is the current date to be used as date of creation, then remain unchanged, you will have to specify sysdate as a value during an insert. You may benefit from the timestamp datatype, which sets itself to the current date when any DML statements (insert, update) are performed. Mike -Original Message- From: Chugh Shalini [mailto:[EMAIL PROTECTED]] Sent: Monday, September 02, 2002 6:41 AM To: [EMAIL PROTECTED] Subject: sysdate or curdate as default date in mysql Dear All! Can we define sysdate or curdate as default date for a column of datatype 'date' while creating a table? Regards Sql, mysql, 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: sysdate or curdate as default date in mysql
Dear Chugh, Can we define sysdate or curdate as default date for a column of datatype 'date' while creating a table? The question is ambiguous: - if a table is created with a column defined to be a TIMESTAMP data type, then every time a row is INSERTed or UPDATEd, the current date will be entered into the field (a two-edged sword!). - if you want to define the date/time under which MySQL is running, eg run it as if the server was in London instead of India, then the way to do that is to run the whole serverPC with such a system clock setting. - if you want the table's creation date/time to be the default value for a particular column, then I think you will have to hard-code that as a literal value into the column definition within CREATE TABLE (I don't think it is possible to ask MySQL to evaluate and plug in the time value for you) Have you studied the manual? Regards, =dn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
build under Win32
Hi, All. I cannot build mysql mysql-3.23.52-win-src.zip (and mysql-3.23.51-win-src.zip, and mysql-max-4.0.1-alpha-win.zip). Error arise when I build string.lib. Configuration: strings - Win32 Debug Performing Custom Build Step on .\Strxmov.asm ' tempfile.bat' is not recognized as an internal or external command, operable program or batch file. Error executing c:\winnt\system32\cmd.exe. strings.lib - 1 error(s), 0 warning(s) I have Windows NT 6SP and VC6. what does it matter? Best, Nick. Sql, mysql, 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
Re: Maximum number of rows
Shashank Tripathi wrote: Hi Lucas, | Does anyone know what the maximum number of rows a | MyISAM table can store is? We currently have a table | We're afraid there is hard, implementation imposed limit | of unsigned int (2^32) on the number of rows. Before trying My guess is that the limit is not in terms of rows, but how large the filesize is because the filesystem imposes constraints. I am assuming you read this already? http://www.mysql.com/doc/en/Table_size.html A few things I'd like to draw your attention to: 1. With the new MyISAM table type in MySQL Version 3.23, the maximum table size is pushed up to 8 million terabytes (2 ^ 63 bytes). 2. If your big table is going to be read-only, you could use myisampack to merge and compress many tables to one. myisampack usually compresses a table by at least 50%, so you can have, in effect, much bigger tables. 3. You can go around the operating system file limit for MyISAM data files by using the RAID option. Hope this is useful? Not really, but thanks anyway. We already hit and successfully exceeded the 2/4GB table size limit almost two years ago thanks to MyISAM and LFS, so table size is not a problem (Typically, one instance of our DBs is currently about 130 GB in ~35 tables...). What made me think about there being a hard limit is the fact that if you create table T (A integer, B integer) max_rows=50; [btw don't use max_rows=5e9, you will end up with max_rows=5 in 3.23.38] you get show table status like 'T'; +--+++--++-+-+--+---++-+-++-+-+ | Name | Type | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | |Index_length | Data_free | Auto_increment | Create_time | Update_time || Check_time | Create_options | Comment | +--+++--++-+-+--+---++-+-++-+-+ | T| MyISAM | Fixed |0 | 0 | 0 | 38654705663 | |1024 | 0 | NULL | 2002-09-02 15:47:35 | 2002-09-02 15:47:35 || NULL | max_rows=4294967295 | | NB 4294967295*9 bytes per row = 38654705663 -- Lukas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Hello Mozzi wrote: Don't understand it still It doesn't give me errors in logfile orf when I type show server stutus. Yet it isn't replicating !! Any ideas ? I even tryed checking file sizes between servers on the .MYD file and it isn't working 1. On the server do a: mysqlbinlog /path/to/your/data-dir/ais-rad02-bin.001 | grep '#2575635' 2. If the position exists you have some trouble I cannot help you with ;-) 3. If there is no such position look, if there is a position around that; adjust the slave to read the right position (I had some occurences of a position pointing beyond the end of the binlog file) Like: slave stop; change master to master_log_file='ais-rad02-bin.002' master_position=4; slave start; show slave status; Greetings Ralf Mozzi Dicky Wahyu Purnomo wrote: Pada Mon, 02 Sep 2002 12:51:50 +0200 Mozzi [EMAIL PROTECTED] menulis : Heya Dicky How are you ? Havn't seen you in a while ;-) kay what I did was RESET MASTER and RESET SLAVE And restartted slave That worked!!! Now what I want to know is when I give the command show slave status I get the following mysql show slave status; +---+-+-+---+---+-+---+-+-+++--+ | Master_Host | Master_User | Master_Port | Connect_retry | Log_File | Pos | Slave_Running | Replicate_do_db | Replicate_ignore_db | Last_errno | Last_error | Skip_counter | +---+-+-+---+---+-+---+-+-+++--+ | 196.25.84.193 | replicate | 3306| 60| ais-rad02-bin.001 | 2575635 | Yes | | | 0 || 0| +---+-+-+---+---+-+---+-+-+++--+ 1 row in set (0.01 sec) Is it actually replicating ? my my.cnf files look like this SLAVE--- [mysqld] socket=/var/lib/mysql/mysql.sock server-id=2 master-host=myip master-user=user master-password=passwd replicate-do-table=radius.radcheck replicate-do-table=radius.usergroup log=/var/log/mysqld.log ---end MASTER-- [mysqld] socket=/var/lib/mysql/mysql.sock server-id=1 log=/var/log/mysqld.log log-bin end How long does it take normally ? normal to me :D usually i use binlog-do-db= and replicate-do-db= that's why i found your slave status is a little not normal to me :D as long as what you need is working, then everything is ok ;-) -- Let's call it an accidental feature. -- Larry Wall MySQL 3.23.51 : up 73 days, Queries : 357.245 per second (avg). -- Ralf Narozny Besuchen Sie uns auf der DMS-Expo. SAP, Dokumenten- management oder das komplette Office ins Portal einbinden? Wir zeigen es Ihnen - vom 3. bis 5.9. auf der Messe Essen Halle 3, Stand 3255 SPLENDID Internet GmbH Co KG Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax: +49 431 660 97 20 mailto:[EMAIL PROTECTED], http://www.splendid.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Bug ?
Marian wrote: Why mysql corrupt tables if filesystem if full ... ? On good database servers (eg. PROGRESS) process shutdown server (protetcting data). sytem: linux-2.2.19 mysql-3.23-38 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php What table types are you using? MySQL doesn't usually corrupt tables when the disk is full, it handles it in the following way: http://www.mysql.com/doc/en/Full_disk.html Also, you're using a pretty old version of MySQL, you might want to upgrade to a newer version if possible. The latest version in the 3.23 series is 3.23.52 -- For technical support contracts, visit https://order.mysql.com/?ref=mmma __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mark Matthews [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA ___/ 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: build under Win32
Hi, This error occur because you don't have in your computer ml.exe. For this you must install MASM32 or NT DDK. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Nick Kostirya [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 02, 2002 4:14 PM Subject: build under Win32 Hi, All. I cannot build mysql mysql-3.23.52-win-src.zip (and mysql-3.23.51-win-src.zip, and mysql-max-4.0.1-alpha-win.zip). Error arise when I build string.lib. Configuration: strings - Win32 Debug Performing Custom Build Step on .\Strxmov.asm ' tempfile.bat' is not recognized as an internal or external command, operable program or batch file. Error executing c:\winnt\system32\cmd.exe. strings.lib - 1 error(s), 0 warning(s) I have Windows NT 6SP and VC6. what does it matter? Best, Nick. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
.MYD/.MYI file formats
Are the MySQL MYD/MYI file formats documented anywhere? Are they any utilities that will dump these out for debug purposes? -Rolf -- Rolf Howarth, Square Box Systems Ltd, Stratford-upon-Avon UK. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Euro sign mysql
On Monday 02 September 2002 09:27 am, Derk van der Harst wrote: Hello everyone, how can I insert records with the Euro sign into the mysql database? When i try to insert the euro sign i get the err message 'query is empty'. Can somebody help? thanks Derk What happens if you escape the string first, like with DBD's quoting function? Not knowing what encoding you're trying to use for your string I would have to guess that it contains what MySQL is interpreting as an illegal character. Still, the error message is a bit odd. Perhaps it isn't even Mysql's fault... How are you connecting? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Bug ?
On Mon, 2 Sep 2002, Marian wrote: Why mysql corrupt tables if filesystem if full ... ? On good database servers (eg. PROGRESS) process shutdown server (protetcting data). sytem: linux-2.2.19 mysql-3.23-38 Good sys admins don't let filesystems become full Andy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Just being prudent - upgrade MySql v3.23 to v4.0.2
Still haven't recieved a simple answer when i unzip the mysql-4.0.2-alpha-win.zip Do i simply extract into C:\mysql Folder and override everthing . as i have working db's so i just would like confirmation prior to proceeding. The MySql Doc's don't clarify this I assume you do but i thought i'll remain prudent. Plz confirm ASAP as I have another MySql Project that'll conbine Transactions (Innodb) Table TimeStamp datatype field for all the Project Tables . -- Regards Chuck Amadi ICT Dept Systems Programmer Rhaglenydd Systemau Adran ICT - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Just Prudent Dumb
Hi Sorry but i nedd to be spoon fed can i just unzip the MySql-4.0.2-alpha-win.zip into my C:\mysql folder to upgrade and confirm Yes to All at the prompt as i don't want to loose any Projects that are currently in MySql v3.2.3. Sorry 4 sounding dumb but i feel abit queesey prior upgrade I have read the Doc's but it feels it's relating to after you've upgrade and run whats neccessarry so Plz can someone confirm. -- Regards Chuck Amadi ICT Dept Systems Programmer Rhaglenydd Systemau Adran ICT - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ERROR 2004
I downloaded mysql, i am not sure about the version, number but i think is the last stable version. And i use it under Win98. when i type: mysql -u root to try to login for the first time, i get the following error message: ERROR 2004: Can´t create TCP/IP socket (10047) I did the same thing with my computer at my job place, but in the computer i have at home i get this error. What could it be? Thanks, Guilherme __ AcessoBOL, só R$ 9,90! O menor preço do mercado! Assine já! http://www.bol.com.br/acessobol - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Viewing TIME columns from Access 2000
I am trying to link to a MySQL table from MS Access 2000. All columns are OK apart from the TIME column which is displayed as a varying date and a fixed time e.g. 27/02/2001 23:51:12 and 30/12/2002 23:51:12. Also the the TIME field for the first record is empty the rest are not. Any ideas? Thanks, David Wardle - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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! Recovering corrupt table
Rolf, Monday, September 02, 2002, 3:38:06 PM, you wrote: RH I'm using MySQL 3.23.51. I have a table which started giving 127 errors. [skip] RH It recovers my table but I end up with only 1030 out of 27497 rows, RH so that's not a log of help! RH Running myisamchk -r -e gives a similar result (only 1030 rows are RH recovered), as does truncating the table first then restored the MYD RH file and running myiasmchk. RH Any other suggestions as to what to try? RH I'm happy to try to write some code of my own to walk through the MYD RH file and extract anything that looks like valid data. Is the MYD file RH format documented anywhere? Could you repair table with REPAIR TABLE .. USE_FRM ? Does it also deletes records? -- 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: sysdate or curdate as default date in mysql
Chugh, Monday, September 02, 2002, 3:41:27 PM, you wrote: CS Can we define sysdate or curdate as default date for a column of CS datatype 'date' while creating a table? You can't define result of function as a default value. Take a look at TIMESTAMP column type: http://www.mysql.com/doc/en/DATETIME.html -- 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: Re: MySQL 4.0.2, 4.0.3 replication circle broken.
Artem, Monday, September 02, 2002, 12:44:30 PM, you wrote: AVR Thursday, August 15, 2002, you wrote: AVR In case of repliacation circle (A-B-A) query 'flush log' on any of AVR this servers create endless loop, with creating new binary log file AVR on each iteration. (about 30 new files every second in my case) Thanks for bug report! I tested it yesterday and also have got thousands of log files :( AVR 4.0.3 Already out, but bug is still exists. AVR Does anybody something to fix this bus? Hi! No, this bug is not fixed yet. -- 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: Bug ?
On good database servers (eg. PROGRESS) It's unjust to make this comparison For example, you can not compare what you don't know about one RDBMS(doesn't matter if is MySQL or not) with other RDBMS which is familiar for you. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Marian [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 02, 2002 2:50 PM Subject: Bug ? Why mysql corrupt tables if filesystem if full ... ? On good database servers (eg. PROGRESS) process shutdown server (protetcting data). sytem: linux-2.2.19 mysql-3.23-38 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Inno DB Question
Hi Tod, thanks for your answer. I changed the code to this Q-SQL-Clear(); Q-SQL-Add(SET AUTOCOMMIT=0); Q-ExecSQL(); Q-SQL-Clear(); Q-SQL-Add(BEGIN); Q-ExecSQL(); Q-SQL-Clear(); Q-SQL-Add(INSERT INTO regn_info VALUES('t1','test1')); Q-ExecSQL(); Q-SQL-Clear(); Q-SQL-Add(INSERT INTO regn_info VALUES('t2','test2')); Q-ExecSQL(); Q-SQL-Clear(); Q-SQL-Add(ROLLBACK); Q-ExecSQL(); And now for the ODBC connection is working fine, but the same code using TSQLQuery (dbExpress Component) dosen't work. Do you have any idea what can be the reason? Thanks Javier -Original Message- From: Tod Harter [mailto:[EMAIL PROTECTED]] Sent: 02 September 2002 15:58 To: Javier Diaz Subject: Re: Inno DB Question On Monday 02 September 2002 07:37 am, you wrote: I would think you would want to set autocommit BEFORE you call BEGIN since that starts your transaction. My guess would be that setting autocommit clears any existing transaction. In the case without the begin and autocommit set to 0 I don't really know what is going to happen... Essentially you're telling the database I'll tell you when to create a transaction and then you don't create one. I can only assume the behaviour is that mysql goes back to the 'autocommit 1' state at that point since otherwise whatever you're doing makes no sense. Hi all, I'm using MySQL 4.0.2 alpha-max with Inno DB and Borland Builder 6.0 to connect to MySQL. I'm trying to use the new dbExpress component for Borland to connect to MySQL using the libmysql.dll I have been making some tests with transactions using the dbExpress components and the normal ODBC but I can't get the ROLLBACK function to work. Here are some examples: using dbExpress TSQLConnection Q; Q= new TSQLQuery(Application); Q-SQLConnection=SQLConnection1; /* I test with and without BEGIN Q-SQL-Clear(); Q-SQL-Add(BEGIN); Q-ExecSQL(); */ Q-SQL-Clear(); Q-SQL-Add(SET AUTOCOMMIT=0); Q-ExecSQL(); Q-SQL-Clear(); Q-SQL-Add(INSERT INTO regn_info VALUES('t1','test1')); Q-ExecSQL(); Q-SQL-Clear(); Q-SQL-Add(INSERT INTO regn_info VALUES('t2','test2')); Q-ExecSQL(); Q-SQL-Clear(); Q-SQL-Add(ROLLBACK); Q-ExecSQL(); //-- Using ODBC TQuery *Q_ODBC; Q_ODBC= new TQuery(Application); Q_ODBC-DatabaseName=salsadb; /* Q-SQL-Clear(); Q-SQL-Add(BEGIN); Q-ExecSQL(); */ Q_ODBC-SQL-Clear(); Q_ODBC-SQL-Add(SET AUTOCOMMIT=0); Q_ODBC-ExecSQL(); Q_ODBC-SQL-Clear(); Q_ODBC-SQL-Add(INSERT INTO regn_info VALUES('t1','test1')); Q_ODBC-ExecSQL(); Q_ODBC-SQL-Clear(); Q_ODBC-SQL-Add(INSERT INTO regn_info VALUES('t2','test2')); Q_ODBC-ExecSQL(); Q_ODBC-SQL-Clear(); Q_ODBC-SQL-Add(ROLLBACK); Q_ODBC-ExecSQL(); In both cases the ROLLBACK dosen't work and I get the inserted values in the table. Any idea what can be happening? Thanks a lot Javier Diaz -- This e-mail is intended for the named addressee only. It may contain confidential and/or privileged information. If you have received this message in error, please let us know and then delete this message from your system. You should not copy the message, use it for any purpose or disclose its contents to anyone. This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk -- This e-mail is intended for the named addressee only. It may contain confidential and/or privileged information. If you have received this message in error, please let us know and then delete this message from your system. You should not copy the message, use it for any purpose or disclose its contents to anyone. This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working
Maximum number of tables
Subject: Maximum number of tables Does anyone know what the maximum number of tables a INNODB can store is? Thanks, José Lourenço - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Another bug with create table ... select ... and control flow functions
Another bug with create table ... select ... statement and control flow functions: see Threads for July 2002. This bug affects Version 4.0.3 (I have experienced it with LinuxRH7.3, Windows NT SP6, Windows 2000 SP2). Try this: create table ciccio select if('2002'='2002','Y','N') select * from ciccio The query returns always 0 values for that making-me-mad field. I think that now I have to wait for 4.0.4 version to see this bug fixed, am I wrong? Thanks Danilo Maurizio - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Just being prudent - upgrade MySql v3.23 to v4.0.2
Please see http://www.mysql.com/downloads/mysql-4.0.html, specifically the link for You can find how to upgrade from MySQL 3.23 Here (http://www.mysql.com/doc/en/Upgrading-from-3.23.html) ... In general what you have to do when upgrading to 4.0 from an earlier MySQL version: Run the mysql_fix_privilege_tables to add new privileges and features to the MySQL privilege tables. Edit any MySQL startup scripts or configure files to not use any of the deprecated options listed below. Convert your old ISAM files to MyISAM files with the command: mysql_convert_table_format database. Note that this should only be run if all tables in the given database is ISAM or MyISAM tables. If this is not the case you should run ALTER TABLE table_name TYPE=MyISAM on all ISAM tables. Ensure that you don't have any MySQL clients that uses shared libraries (like the perl Msql-Mysql-modules). If you have, you should recompile them as structures used in `libmysqlclient.so' have changed. ... HTH, Dw. -Original Message- From: Chuck Amadi [mailto:[EMAIL PROTECTED]] Sent: 02 September 2002 08:02 To: [EMAIL PROTECTED] Subject: Just being prudent - upgrade MySql v3.23 to v4.0.2 Still haven't recieved a simple answer when i unzip the mysql-4.0.2-alpha-win.zip Do i simply extract into C:\mysql Folder and override everthing . as i have working db's so i just would like confirmation prior to proceeding. The MySql Doc's don't clarify this I assume you do but i thought i'll remain prudent. Plz confirm ASAP as I have another MySql Project that'll conbine Transactions (Innodb) Table TimeStamp datatype field for all the Project Tables . -- Regards Chuck Amadi ICT Dept Systems Programmer Rhaglenydd Systemau Adran ICT - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: build under Win32
At 16:14 02/09/02 +0300, Nick Kostirya wrote: Hi, Hi, All. I cannot build mysql mysql-3.23.52-win-src.zip (and mysql-3.23.51-win-src.zip, and mysql-max-4.0.1-alpha-win.zip). Error arise when I build string.lib. Please read the instructions at (you need the assembler compiler): http://www.mysql.com/doc/en/Windows_source_build.html -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel Angel Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ São Paulo - Brazil ___/ 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: select using 2 left joins
I'm a little surprised that MySQL isn't giving you an error on the ambiguity of manufacturersID=12. What happens if you specify tableName.manufacturersID=12? HTH, Jed On the threshold of genius, Wilbert Enserink wrote: Hi all, I'm having troubles with a good selection statement in my query. I have three tables: tableAds, tableProducts and tableManufacturer. They all have unique ID's defined. In the tableProducts there is a column named manufacturerID. So I know which product was made by which manufacturer. In the tableAds I have a column ProductsID so I know what Product is advertised. Now I want to find all the adsvertisments of products which are made by a specific manufacturer. I'm trying a query like: SELECT * FROM tableAds LEFT JOIN tableProducts ON (tableProducts.productsID=tableAds.productsID) LEFT JOIN tableManufacturers ON (tableManufacturers.manufacturersID=tableProducts.manufacturersID) WHERE manufacturersID=12 However this query returns all advertisments in the tableAds and not the Ads wirth manufacturer number 12 involved. Anybody knows how to improve this query? Any help would be much appreciated. thx in advance. Wilbert Enserink - Pas de Deux Van Mierisstraat 25 2526 NM Den Haag tel 070 4450855 fax 070 4450852 http://www.pdd.nl [EMAIL PROTECTED] - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Just Prudent Dumb
Chuck Amadi [EMAIL PROTECTED] wrote: Hi Sorry but i nedd to be spoon fed can i just unzip the MySql-4.0.2-alpha-win.zip into my C:\mysql folder to upgrade and confirm Yes to All at the prompt as i don't want to loose any Projects that are currently in MySql v3.2.3. Sorry 4 sounding dumb but i feel abit queesey prior upgrade I have read the Doc's but it feels it's relating to after you've upgrade and run whats neccessarry so Plz can someone confirm. You should back up everything either with mysqldump, phpMyadmin or just copy the directory in Data that is your database name to somewhere. then just plop the directory back this is fine unless you have an enormous db. John Coder __ The NEW Netscape 7.0 browser is now available. Upgrade now! http://channels.netscape.com/ns/browsers/download.jsp Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.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: ERROR 2004
You don't have TCP/IP networking installed on your computer. guilherme.afm wrote: I downloaded mysql, i am not sure about the version, number but i think is the last stable version. And i use it under Win98. when i type: mysql -u root to try to login for the first time, i get the following error message: ERROR 2004: Can´t create TCP/IP socket (10047) I did the same thing with my computer at my job place, but in the computer i have at home i get this error. What could it be? Thanks, Guilherme __ AcessoBOL, só R$ 9,90! O menor preço do mercado! Assine já! http://www.bol.com.br/acessobol - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: 3.23.52 hitting system loads of 25+?
On Mon, Sep 02, 2002 at 03:35:28AM -0700, John Stanforth wrote: Jeremy and Michael, What compiler versions are you using? (just the gcc -v) I'm wondering especially since MySQL has a warning posted about gcc 2.96 with 2.4 kernels. gcc version 2.95.4 20011002 (Debian prerelease) Which reminds me, what specific kernel versions are you guys using? 2.4.18 SMP. (Jeremy, is yours a custom kernel from Redhat source or Linus source?) I'm 95% sure that it's a Linus kernel. The only adjustements we've made are for VIP support so that it can work with a hardware load-balancer. That's a simple patch from the LVS code. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 27 days, processed 549,221,822 queries (232/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: ERROR 2004
Sounds like TCP/IP is not running on your machine. - Original Message - From: guilherme.afm [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 02, 2002 10:45 AM Subject: ERROR 2004 I downloaded mysql, i am not sure about the version, number but i think is the last stable version. And i use it under Win98. when i type: mysql -u root to try to login for the first time, i get the following error message: ERROR 2004: Can´t create TCP/IP socket (10047) I did the same thing with my computer at my job place, but in the computer i have at home i get this error. What could it be? Thanks, Guilherme __ AcessoBOL, só R$ 9,90! O menor preço do mercado! Assine já! http://www.bol.com.br/acessobol - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Install questions
I just installed MySQL from RPM and can connect to it via shell using the MySQL command, but I can't get anything else to connect to it. MySQL Connection Failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Thoughts? Matt Wiseman - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Inno DB Question
Javier, it may be that the dbExpress interface is still lagging behind MySQL development. If I recall right, people have complained loudly in Borland newsgroups that dbExpress created a new connection for each SQL query it issues to MySQL. That makes the use of transactions impossible with it. If this has not been fixed in the latest version of dbExpress, it would be good if you would write to Borland people about this, or to the Borland newsgroups. Regards, Heikki Innobase Oy - Original Message - From: Javier Diaz [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Monday, September 02, 2002 3:06 PM Subject: Inno DB Question Hi all, I'm using MySQL 4.0.2 alpha-max with Inno DB and Borland Builder 6.0 to connect to MySQL. I'm trying to use the new dbExpress component for Borland to connect to MySQL using the libmysql.dll I have been making some tests with transactions using the dbExpress components and the normal ODBC but I can't get the ROLLBACK function to work. Here are some examples: using dbExpress TSQLConnection Q; Q= new TSQLQuery(Application); Q-SQLConnection=SQLConnection1; /* I test with and without BEGIN Q-SQL-Clear(); Q-SQL-Add(BEGIN); Q-ExecSQL(); */ Q-SQL-Clear(); Q-SQL-Add(SET AUTOCOMMIT=0); Q-ExecSQL(); Q-SQL-Clear(); Q-SQL-Add(INSERT INTO regn_info VALUES('t1','test1')); Q-ExecSQL(); Q-SQL-Clear(); Q-SQL-Add(INSERT INTO regn_info VALUES('t2','test2')); Q-ExecSQL(); Q-SQL-Clear(); Q-SQL-Add(ROLLBACK); Q-ExecSQL(); //-- Using ODBC TQuery *Q_ODBC; Q_ODBC= new TQuery(Application); Q_ODBC-DatabaseName=salsadb; /* Q-SQL-Clear(); Q-SQL-Add(BEGIN); Q-ExecSQL(); */ Q_ODBC-SQL-Clear(); Q_ODBC-SQL-Add(SET AUTOCOMMIT=0); Q_ODBC-ExecSQL(); Q_ODBC-SQL-Clear(); Q_ODBC-SQL-Add(INSERT INTO regn_info VALUES('t1','test1')); Q_ODBC-ExecSQL(); Q_ODBC-SQL-Clear(); Q_ODBC-SQL-Add(INSERT INTO regn_info VALUES('t2','test2')); Q_ODBC-ExecSQL(); Q_ODBC-SQL-Clear(); Q_ODBC-SQL-Add(ROLLBACK); Q_ODBC-ExecSQL(); In both cases the ROLLBACK dosen't work and I get the inserted values in the table. Any idea what can be happening? Thanks a lot Javier Diaz -- This e-mail is intended for the named addressee only. It may contain confidential and/or privileged information. If you have received this message in error, please let us know and then delete this message from your system. You should not copy the message, use it for any purpose or disclose its contents to anyone. This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: query crashes 4.03 every time
| May be I'm blind, :-) but you provided dump of another table than you used | in the query. What is the structure of table 'b2posts'? You're right, here it is: CREATE TABLE b2posts ( ID int(10) unsigned NOT NULL auto_increment, post_author int(4) NOT NULL default '0', post_date datetime NOT NULL default '-00-00 00:00:00', post_content text NOT NULL, post_title text NOT NULL, post_category int(4) NOT NULL default '0', post_karma int(11) NOT NULL default '0', PRIMARY KEY (ID), UNIQUE KEY ID (ID) ) TYPE=MyISAM; | What type of errors do you get? Is there anything in the | error log? What OS do you use? How did you installed MySQL: from binary | or from source? Installed from binary. Linux kernel 2.4.17. Here's the dump from the error log. Warning: long. ***Here's the query I asked about originally*** mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=6287360 read_buffer_size=520192 sort_buffer_size=524280 max_used_connections=19 max_connections=225 threads_connected=6 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 235638 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=0x8856320 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, fp=0xbfdfea78, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x8072b1a 0x827b7b8 0x80c817d 0x80c7010 0x80a4025 0x809d8b4 0x8096913 0x80a3a86 0x807ceda 0x8080af5 0x807bfe3 0x8081eae 0x807b1be 0x8278e9c 0x82ae29a New value of fp=(nil) failed sanity check, terminating stack trace! Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x88b3798 = SELECT DISTINCT * FROM b2posts WHERE 1=1 AND ID = 124 AND ((post_title LIKE '%%') OR (post_content LIKE '') OR (post_title LIKE '%%') OR (post_content LIKE '%%')) AND post_date '2002-08-31 14:31:55' AND post_category 0 ORDER BY post_date DESC thd-thread_id=539 Successfully dumped variables, if you ran with --log, take a look at the details of what thread 539 did to cause the crash. In some cases of really bad corruption, the values shown above may be invalid. The manual page at http://www.mysql.com/doc/C/r/Crashing.html contains information that should help you find out what is causing the crash. ***Here's another query that gave the same results*** mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=6287360 read_buffer_size=520192 sort_buffer_size=524280 max_used_connections=1 max_connections=225 threads_connected=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 235638 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=0x872eff8 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, fp=0xbfe7ea78, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x8072b1a 0x827b7b8 0x809da5f 0x809d89e 0x8096913 0x80a3a86 0x807ceda 0x8080af5 0x807bfe3 0x8081eae 0x807b1be 0x8278e9c 0x82ae29a New value of fp=(nil) failed sanity check, terminating stack trace! Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x872f8c0 = SELECT DISTINCT ibf_posts.author_id, ibf_topics.* from ibf_topics LEFT JOIN ibf_posts ON (ibf_topics.tid = ibf_posts.topic_id AND ibf_posts.author_id = '9') WHERE ibf_topics.forum_id='2' and (ibf_topics.last_post '0' OR ibf_topics.pinned='1') and ibf_topics.approved='1' ORDER BY pinned DESC,
Maximum number of tables
- Original Message - From: JSL [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 02, 2002 5:05 PM Subject: Maximum number of tables Subject: Maximum number of tables Does anyone know what the maximum number of tables a INNODB can store is? Thanks, José Lourenço - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
stored procedures and triggers
Hello list, Here in my company people are concerned about which database to choose to start implementing a new application client-server. As the only person here with large experience in this field of activity is me, I am not very much inclined to our mysql due to its lack of resources like triggers and stored procedures, which are the kernel of my development. I would like to know from you if someone is in touch with the develolpment of these resources and know something about when they will be ready. And as second question I would like to know if some of you have had experience with interbase/firebird and know if it will always be a free database as well. hope you from the list are all well and healthy, yf marcello miorelli - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Just Prudent Dumb
At 12:39 -0400 9/2/02, [EMAIL PROTECTED] wrote: Chuck Amadi [EMAIL PROTECTED] wrote: Hi Sorry but i nedd to be spoon fed Ýcan i just unzip the MySql-4.0.2-alpha-win.zip into my C:\mysql folder to upgrade and confirm Yes to All at the prompt as i don't want to loose any Projects that are currently in MySql v3.2.3. Sorry 4 sounding dumb but i feel abit queesey prior upgrade I have read the Doc's but it feels it's relating to after you've upgrade and run whats neccessarry so Plz can someone confirm. You should back up everything either with mysqldump, phpMyadmin or just copy the directory in Data that is your database name to somewhere. then just plop the directory back this is fine unless you have an enormous db. One problem is that the structure of the grant tables in the mysql database changed in 4.0.2. Under Unix, you could use the strategy above and then run the mysql_fix_privilege_tables script to update the grant tables. But that's a shell script; unfortunately, there is no equivalent Windows script. John Coder - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: MyISAM and Lock table question
At 14:41 +0200 9/2/02, David Bordas wrote: Hi all, Just a little question on the MyISAM table lock implementation ... I just see ( with show full processlist ) that my version of mysql ( 3.23.45 binary linux tar.gz ) locked my MyISAM table at every query and not only for update / delete / insert. Why is it locking table for select query ? Did i miss something somewhere ? It's a read lock. Allows other clients to read the table, but prevents other clients from writing (updating) it. Thanks David - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Just being prudent - upgrade MySql v3.23 to v4.0.2
At 10:20 -0700 9/2/02, Sqlcoders.com Programming Dept wrote: Please see http://www.mysql.com/downloads/mysql-4.0.html, specifically the link for You can find how to upgrade from MySQL 3.23 Here (http://www.mysql.com/doc/en/Upgrading-from-3.23.html) ... In general what you have to do when upgrading to 4.0 from an earlier MySQL version: Run the mysql_fix_privilege_tables to add new privileges and features to the MySQL privilege tables. That doesn't help much for Windows, which has no mysql_fix_privilege_tables script. Edit any MySQL startup scripts or configure files to not use any of the deprecated options listed below. Convert your old ISAM files to MyISAM files with the command: mysql_convert_table_format database. Note that this should only be run if all tables in the given database is ISAM or MyISAM tables. If this is not the case you should run ALTER TABLE table_name TYPE=MyISAM on all ISAM tables. Ensure that you don't have any MySQL clients that uses shared libraries (like the perl Msql-Mysql-modules). If you have, you should recompile them as structures used in `libmysqlclient.so' have changed. ... HTH, Dw. -Original Message- From: Chuck Amadi [mailto:[EMAIL PROTECTED]] Sent: 02 September 2002 08:02 To: [EMAIL PROTECTED] Subject: Just being prudent - upgrade MySql v3.23 to v4.0.2 Still haven't recieved a simple answer when i unzip the mysql-4.0.2-alpha-win.zip Do i simply extract into C:\mysql Folder and override everthing . as i have working db's so i just would like confirmation prior to proceeding. The MySql Doc's don't clarify this I assume you do but i thought i'll remain prudent. Plz confirm ASAP as I have another MySql Project that'll conbine Transactions (Innodb) Table TimeStamp datatype field for all the Project Tables . -- Regards Chuck Amadi ICT Dept Systems Programmer Rhaglenydd Systemau Adran ICT - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SQL JOIN query problem
Hello, Im not sure that im sending this mail to the correct people, but Im really desperate right now. I have a problem with a SELECT JOIN query. I have two tables, one which contains Articles, and one which contains ArticleUpdates. What I would like to do, is to have a report of Articles, which has some special values set in both ArticleUpdates and Articles. BUT in ArticleUpdates we have a column named EditedDate. We are ONLY interested in the last update of each Article. ArticleUpdates is linked to Articles by a column named ArticleID. So, an example query could be: We want to know about all articles that have been changed by user 1 (column: ArticleUpdates.EditedUser) and at the same time it has to be a member of department 20 (Articles.Department) If you could make a such query for me, I would very much appriciate it. A final note is, that it has to support Access databases aswell, so it should follow the SQL standard. Please get back to me as soon as possible, as I needed this done a week ago. Please write to this email address, as im not subscribed to the mailling list. Sincerely, Christian Rytter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysock.sql problem
I have installed mysql from the ports collection on FreeBSD and it was working fine. I would like to move the /tmp/mysql.sock file ( or is it safe to leave it there?) so I Created a my.cnf file with the following options [mysqld] port=3306 socket=/usr/local/mysql/mysql.sock I take down the mysql server and restart but it refuses to work. It is still looking in the /tmp directory What am I doing wrong? Could this be a permission thing on the sock file? What permissions does this file need? Cheers Guy Sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Crash when adding field
Hi all... MySQL version 4.0.3-beta Compaq Deskpro PIII 933MHz 256MB RAM, 92MB SWAP Binary distribution uname -a Linux homer 2.4.19 #2 Thu Aug 15 19:53:55 NZST 2002 i686 unknown I don't have another test machine unfortunately, so I don't know if the problem is specific to my machine/database or not. I have included below what happened when I tried to add a new ENUM field to a table, but this problem now occurs when I also try to add any type of field to the table, or drop any field. I have checked the archives, and have not found anything like this relating to the 4.0.x versions. One thing I did think of - how many versions of 4.0.3-beta-linux were rolled? I downloaded my copy from the site before the official announcement was made - pretty much as soon as it was put up on the site. ~~ mysql SHOW CREATE TABLE users; CREATE TABLE `users` ( `ID` int(10) unsigned NOT NULL auto_increment, `FullName` char(50) NOT NULL default '', `UserName` char(50) NOT NULL default '', `Password` char(50) NOT NULL default '', `Level` enum('1','2') NOT NULL default '1', PRIMARY KEY (`ID`,`UserName`), UNIQUE KEY `ID` (`ID`), KEY `ID_2` (`ID`) ) TYPE=MyISAM matt@homer:/usr/local/mysql/bin# ./mysql -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 30 to server version: 4.0.3-beta Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql USE zeviwm; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql ALTER TABLE `users` ADD `Level` ENUM('1','2') DEFAULT 1 NOT NULL; ERROR 2006: MySQL server has gone away No connection. Trying to reconnect... Connection id:1 Current database: zeviwm Query OK, 3 rows affected (0.01 sec) Records: 3 Duplicates: 0 Warnings: 0 mysql Results in this in the error log: mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=8388600 read_buffer_size=131072 sort_buffer_size=2097144 max_used_connections=0 max_connections=100 threads_connected=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 225791 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=0x8706148 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, fp=0xbfe7e918, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x806ebdb 0x8261718 0x8289f35 0x8289e13 0x82472c6 0x8230e84 0x80c0662 0x808f779 0x808a6c8 0x80cdd29 0x8079738 0x807c76a 0x807799b 0x80773e5 0x8076c2e 0x825edfc 0x82941fa New value of fp=(nil) failed sanity check, terminating stack trace! Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow instructions on how to r esolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x8706af0 = ALTER TABLE `users` ADD `Level` ENUM('1','2') DEFAULT 1 NOT NULL thd-thread_id=1 Successfully dumped variables, if you ran with --log, take a look at the details of what thread 1 did to cause the crash. In some cases of really bad corruption, the values shown above may be invalid. The manual page at http://www.mysql.com/doc/C/r/Crashing.html contains information that should help you find out what is causing the crash. Number of processes running now: 1 020903 10:17:28 mysqld restarted 020903 10:17:28 InnoDB: Out of memory in additional memory pool. InnoDB: InnoDB will start allocating memory from the OS. InnoDB: You may get better performance if you configure a bigger InnoDB: value in the MySQL my.cnf file for InnoDB: innodb_additional_mem_pool_size. 020903 10:17:28 InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 43922 InnoDB: Doing recovery: scanned up to log sequence number 0 43922 020903 10:17:28 InnoDB: Flushing modified pages from the buffer pool... 020903 10:17:28 InnoDB: Started /usr/local/mysql/bin/mysqld: ready for connections ~~ If you need any more info, please get back to me. Thanks, Matt Parlane __ _ _ |__ /_ _(_) / // _ \ \ / / | / /| __/\ V /| | /\___| \_/
Re: Help! Recovering corrupt table
RH I'm using MySQL 3.23.51. I have a table which started giving 127 errors. [skip] RH It recovers my table but I end up with only 1030 out of 27497 rows, RH so that's not a log of help! RH Running myisamchk -r -e gives a similar result (only 1030 rows are RH recovered), as does truncating the table first then restored the MYD RH file and running myiasmchk. RH Any other suggestions as to what to try? Could you repair table with REPAIR TABLE .. USE_FRM ? Thanks for the the suggestion. What does USE_FRM mean? That gives a syntax error. If I do a plain REPAIR TABLE then it has the same effect as myisamchk, just giving me 1030 out of 27000+ rows! Does it also deletes records? Not sure what you mean? Regards, -Rolf -- Rolf Howarth, Square Box Systems Ltd, Stratford-upon-Avon UK. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Trying to get openssl working with MySQL 4.0.3-beta
According to the documentation under section 4.3.9 to get openssl working with mysql you need to configure mysql with the --with-vio --with-openssl. When I add the as arguments to ./configure and then compile it I get a mysqld that will run but try to do anything with it and the client freezes it seems. Is there any way to enable these options with the rpm binary packages. I would like to use the ones that are built by mysql.com. If not how can I compile this so it works right. Thanks for any help. Matthew Scarrow ComIT Solutions Inc. [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: mysock.sql problem
At 9:09 +1200 9/3/02, Defryn, Guy wrote: I have installed mysql from the ports collection on FreeBSD and it was working fine. I would like to move the /tmp/mysql.sock file ( or is it safe to leave it there?) so I Created a my.cnf file with the following options [mysqld] port=3306 socket=/usr/local/mysql/mysql.sock I take down the mysql server and restart but it refuses to work. It is still looking in the /tmp directory 1) *where* did you create the my.cnf file? 2) Do you mean that the server still creates the file in /tmp, or that it creates it where you specified, but that *clients* still look in /tmp? If the latter, remember that you need to tell the clients where to find the file as well: [client] socket=/usr/local/mysql/mysql.sock What am I doing wrong? Could this be a permission thing on the sock file? What permissions does this file need? Cheers Guy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
primary/foreign key contraints
Sorry for the MySQL newbie question ... but are there not primary/foreign key constraints in MySQL 3? I can't imagine that this is right. Perhaps I'm just overlooking something Thanks. Neal - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
secure mySQL connection
Hi. I'm connecting to a remote mySQL server via myODBC from a VB application. Is this connection secure? If not, how can I make it so? Would I have to encrypt the data myself somehow or is there some sort of secure connex like SSL for port 80? Any help appreciated. Cheers, .ben -- ben joyce // [EMAIL PROTECTED] // +44 (0)7958 933718 // http://www.babelfish.co.uk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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! Recovering corrupt table
At 23:57 +0100 9/2/02, Rolf Howarth wrote: RH I'm using MySQL 3.23.51. I have a table which started giving 127 errors. [skip] RH It recovers my table but I end up with only 1030 out of 27497 rows, RH so that's not a log of help! RH Running myisamchk -r -e gives a similar result (only 1030 rows are RH recovered), as does truncating the table first then restored the MYD RH file and running myiasmchk. RH Any other suggestions as to what to try? Could you repair table with REPAIR TABLE .. USE_FRM ? Thanks for the the suggestion. What does USE_FRM mean? That gives a syntax error. That's because USE_FRM isn't supported until MySQL 4.0.2. It means that the repair operation uses the table's .frm (description) file in order to determine what the structure of the indexes should be. It can be useful if the index file has been corrupted beyond recognition. If I do a plain REPAIR TABLE then it has the same effect as myisamchk, just giving me 1030 out of 27000+ rows! Does it also deletes records? Not sure what you mean? Regards, -Rolf -- Rolf Howarth, Square Box Systems Ltd, Stratford-upon-Avon UK. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: stored procedures and triggers
I would like to see the triggers/stored procedures/views in MySQL also. And the only estimate I saw somewhere was around version 5.0. But think about this this way: in the complex enterprise-level system you would probably need some kind of application server instead of direct client-db access. And if this is the case the need of triggers/sp is not that urgent. 3-teer system w/app server is actually the best scalable architecture. So you can do stuff that triggers/sp do in the app server where this stuff really belong. Lots of client-server projects convinced me that this approach is the best on the long run although somewhat more laborious. Yuri. Hello list, Here in my company people are concerned about which database to choose to start implementing a new application client-server. As the only person here with large experience in this field of activity is me, I am not very much inclined to our mysql due to its lack of resources like triggers and stored procedures, which are the kernel of my development. I would like to know from you if someone is in touch with the develolpment of these resources and know something about when they will be ready. And as second question I would like to know if some of you have had experience with interbase/firebird and know if it will always be a free database as well. hope you from the list are all well and healthy, yf marcello miorelli - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 daemon after reboot (after initial install)
Help?, I installed 3.23.52 on a RedHat 7.3 machine. Everything was just fine until I rebooted later for another reason. Now I can't start the daemon. I tried deleting /var/lib/mysql/mysql.sock as root. It deleted, but to no avail. Any idea what I have done wrong? I don't understand sockets. They're magic to me. ps shows no daemon running. mysqladmin also show no daemon and won't ping ...Bill -- [username $] /usr/sbin/mysqld 020902 20:58:00 Can't start server : Bind on unix socket: Permission denied 020902 20:58:00 Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ? 020902 20:58:00 Aborting 020902 20:58:00 /usr/sbin/mysqld: Shutdown Complete [username $] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 i must use mysql_free_result()?
hi all:) int main(void) { . rs=mysql_store_result(connection);//get result to rs .. mysql_free_result(rs);// it is necessary ??? rs=mysql_store_result(connection);// get result to rs again. } i write some codes with c++mysql like above, and i want to know between the same mysql_res used twice , it is necessary to use mysql_free_result() or not. 3KS. asap. Dizzy Myope [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: sysdate or curdate as default date in mysql
Thankx for the reply Egorov,Hillyer and Neil. Timestamp has solved my purpose. Actually we are porting an application from oracle to mysql. In Oracle there were some tables which were using sysdate as default date, therefore we wanted something similar functionality, as it was very difficult to make changes in code of such a large application According to Neil my question was little ambiguous, but inspite of that the answers replied by all of you had helped me in solving my query. -Original Message- From: Egor Egorov [SMTP:[EMAIL PROTECTED]] Sent: Monday, September 02, 2002 9:31 PM To: [EMAIL PROTECTED] Subject:Re: sysdate or curdate as default date in mysql Chugh, Monday, September 02, 2002, 3:41:27 PM, you wrote: CS Can we define sysdate or curdate as default date for a column of CS datatype 'date' while creating a table? You can't define result of function as a default value. Take a look at TIMESTAMP column type: http://www.mysql.com/doc/en/DATETIME.html -Original Message- From: Mike Hillyer [SMTP:[EMAIL PROTECTED]] Sent: Monday, September 02, 2002 6:54 PM To: Chugh Shalini; [EMAIL PROTECTED] Subject: RE: sysdate or curdate as default date in mysql If what you are looking for is the current date to be used as date of creation, then remain unchanged, you will have to specify sysdate as a value during an insert. You may benefit from the timestamp datatype, which sets itself to the current date when any DML statements (insert, update) are performed. Mike -Original Message- From: DL Neil [SMTP:[EMAIL PROTECTED]] Sent: Monday, September 02, 2002 7:15 PM To: Chugh Shalini; [EMAIL PROTECTED] Subject:Re: sysdate or curdate as default date in mysql Dear Chugh, Can we define sysdate or curdate as default date for a column of datatype 'date' while creating a table? The question is ambiguous: - if a table is created with a column defined to be a TIMESTAMP data type, then every time a row is INSERTed or UPDATEd, the current date will be entered into the field (a two-edged sword!). - if you want to define the date/time under which MySQL is running, eg run it as if the server was in London instead of India, then the way to do that is to run the whole serverPC with such a system clock setting. - if you want the table's creation date/time to be the default value for a particular column, then I think you will have to hard-code that as a literal value into the column definition within CREATE TABLE (I don't think it is possible to ask MySQL to evaluate and plug in the time value for you) Have you studied the manual? Regards, =dn -Original Message- From: Chugh Shalini [mailto:[EMAIL PROTECTED]] Sent: Monday, September 02, 2002 6:41 AM To: [EMAIL PROTECTED] Subject: sysdate or curdate as default date in mysql Dear All! Can we define sysdate or curdate as default date for a column of datatype 'date' while creating a table? Regards Sql, mysql, 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Remove David.French@homebs.com.au from your mailing list as he is no longer with the company
Niki Crook Technical Consultant For Home Building Society (08) 9323-5583 [EMAIL PROTECTED] ASG Limited and ASG (Asia Pacific) Pty Ltd -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello, MySQL 4.0.3-beta, the world's most popular Open Source Database, has been released and is now available in source and binary form for a number of platforms from our download pages at http://www.mysql.com/downloads/ and mirror sites. This is the first release of the current 4.0 development tree which has been labelled beta. This means, that we will not add any new features to this code base, but rather focus on stabilizing this release. All new development efforts are now focused on the upcoming 4.1 version. Also please see http://www.mysql.com/doc/en/Which_version.html for more info about our versioning scheme. Version 4.0 of the MySQL server includes many enhancements and new features in comparison to the previous version 3.23: o The InnoDB table type is now included in the standard binaries, adding transactions, row-level locking, and foreign keys. http://www.mysql.com/doc/en/InnoDB.html o A query qache, offering vastly increased performance for many applications. By caching complete result sets, later identical queries can return instantly. http://www.mysql.com/doc/en/Query_Cache.html o Improved full-text indexing with boolean mode, truncation, and phrase searching. http://www.mysql.com/doc/en/Fulltext_Search.html o Enhanced MERGE tables, now supporting INSERTs and AUTO_INCREMENT. http://www.mysql.com/doc/en/MERGE.html o UNION syntax in SELECT. http://www.mysql.com/doc/en/UNION.html o Multi-table DELETE statements. http://www.mysql.com/doc/en/DELETE.html o libmysqld, the embedded server library. http://www.mysql.com/doc/en/libmysqld.html o Additional GRANT privilege options for even tighter control and security. http://www.mysql.com/doc/en/GRANT.html o Management of user resources in the GRANT system, particularly useful for ISPs and other hosting providers. http://www.mysql.com/doc/en/User_resources.html o Dynamic server variables, allowing configuration changes without having to take down the server. http://www.mysql.com/doc/en/SET_OPTION.html o Improved replication code and features. http://www.mysql.com/doc/en/Replication.html o SHOW INNODB STATUS returns the output of the InnoDB Monitor to the MySQL client. This is very useful in performance tuning and finding out the reasons of transaction deadlocks. o SET UNIQUE_CHECKS = 0 speeds up disk-bound table imports. o SET FOREIGN KEY CHECKS = 0 allows one to import table dumps in any order regardless of foreign key constraints. o HANDLER commands now work also for InnoDB type tables. In some cases HANDLER can be used as a substitute of server-side cursors. See the MySQL manual about the details of HANDLER. o Numerous new functions and options. o Changes to existing code for enhanced performance and reliability. There have been many changes between the last version (4.0.2-alpha, released in July 2002) and 4.0.3-beta. Some still missing features have been added and numerous bugs have been squished. - From the Changelog: o Fixed problem with configure ... --localstatedir= o Cleaned up mysql.server script. o Fixed a bug in mysqladmin shutdown when pid file was modified while mysqladmin was still waiting for the previous one to disappear. This could happen during a very quick restart and caused mysqladmin to hang until shutdown_timeout seconds had passed. o Don't increment warnings when setting AUTO_INCREMENT columns to NULL in LOAD DATA INFILE. o Fixed all boolean type variables/options to work with the old syntax, e.g. all of these work: --lower-case-table-names, --lower-case-table-names=1, -O lower-case-table-names=1, --set-variable=lower-case-table-names=1 o Fixed shutdown problem (SIGTERM signal handling) on Solaris. (Bug from 4.0.2). o SHOW MASTER STATUS now returns an empty set if binary log is not enabled. o SHOW SLAVE STATUS now returns an empty set if slave is not initialised. o Don't update MyISAM index file on update if not strictly necessary. o Fixed bug in SELECT DISTINCT ... FROM many_tables ORDER BY not-used-column. o Fixed a bug with BIGINTs and quoted strings. o Added QUOTE() function that performs SQL quoting to produce values that can be used as data values in queries. o Changed variable DELAY_KEY_WRITE to an enum to allow one set DELAY_KEY_WRITE for all tables without taking down the server. o Changed behavior of IF(condition,column,NULL) so that it returns the value of the column type. o Made safe_mysqld a symlink to mysqld_safe in binary distribution. o Fixed security bug when having an empty database name in the user.db table. o Fixed some problems with CREATE TABLE ... SELECT function(). o mysqld now has the option --temp-pool enabled by default as this gives better performance with some
Error Solution Request
Sir, We used the following code for connecting Visual Basic 6.0 with MySql = 3.23.41 . Mysql was running in Linux Red Hat server 7.2 The VB application was in Window NT node The provider used was MySQLProv The code is Option explicit Public gCn As New ADODB.Connection Dim SConnect As String Dim DataBaseName1 as String Dim ServerName1 as String Dim UserName1 as String Dim Password1 as String Public Sub pConnOpen() ServerName1 = MainServer DataBaseName1 = checkMySql UserName1 = abcd Password1 = abcd gCn.Provider = MySQLProv strCon = Data Source= ServerName1 ;Initial Catalog= DataBaseName1 ;User Id= UserName1 ;Password= Password1 ; gCn.Open strCon End sub ___ We got the following error message Multiple step operation generated errors. Please check OLEDB staus value if available.No work was done We request your suggestion for solving this problem. Waiting in Anticipation for your reply R.jayakumar __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.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
SELECT DISTINCT w/LEFT JOIN segfault in 4.0.3
Description: A specific query in the format of: SELECT DISTINCT a.*, b.* FROM privatemessage LEFT JOIN b ON (b.x = a.y); Is causing a segfault. This worked fine in the 3.23 series. How-To-Repeat: DROP TABLE IF EXISTS privatemessage; CREATE TABLE privatemessage ( privatemessageid int(10) unsigned NOT NULL auto_increment, folderid smallint(6) NOT NULL default '0', userid int(10) unsigned NOT NULL default '0', touserid int(10) unsigned NOT NULL default '0', fromuserid int(10) unsigned NOT NULL default '0', title varchar(250) NOT NULL default '', message mediumtext NOT NULL, dateline int(10) unsigned NOT NULL default '0', showsignature smallint(6) NOT NULL default '0', iconid smallint(5) unsigned NOT NULL default '0', messageread smallint(6) NOT NULL default '0', readtime int(10) unsigned NOT NULL default '0', receipt smallint(6) unsigned NOT NULL default '0', deleteprompt smallint(6) unsigned NOT NULL default '0', multiplerecipients smallint(6) unsigned NOT NULL default '0', PRIMARY KEY (privatemessageid), KEY userid (userid) ) TYPE=MyISAM; INSERT INTO privatemessage VALUES (128,0,33,33,8,':D','',996121863,1,0,2,996122850,2,0,0); DROP TABLE IF EXISTS user; CREATE TABLE user ( userid int(10) unsigned NOT NULL auto_increment, usergroupid smallint(5) unsigned NOT NULL default '0', username varchar(50) NOT NULL default '', password varchar(50) NOT NULL default '', email varchar(50) NOT NULL default '', styleid smallint(5) unsigned NOT NULL default '0', parentemail varchar(50) NOT NULL default '', coppauser smallint(6) NOT NULL default '0', homepage varchar(100) NOT NULL default '', icq varchar(20) NOT NULL default '', aim varchar(20) NOT NULL default '', yahoo varchar(20) NOT NULL default '', signature mediumtext NOT NULL, adminemail smallint(6) NOT NULL default '0', showemail smallint(6) NOT NULL default '0', invisible smallint(6) NOT NULL default '0', usertitle varchar(250) NOT NULL default '', customtitle smallint(6) NOT NULL default '0', joindate int(10) unsigned NOT NULL default '0', cookieuser smallint(6) NOT NULL default '0', daysprune smallint(6) NOT NULL default '0', lastvisit int(10) unsigned NOT NULL default '0', lastactivity int(10) unsigned NOT NULL default '0', lastpost int(10) unsigned NOT NULL default '0', posts smallint(5) unsigned NOT NULL default '0', timezoneoffset varchar(4) NOT NULL default '', emailnotification smallint(6) NOT NULL default '0', buddylist mediumtext NOT NULL, ignorelist mediumtext NOT NULL, pmfolders mediumtext NOT NULL, receivepm smallint(6) NOT NULL default '0', emailonpm smallint(6) NOT NULL default '0', pmpopup smallint(6) NOT NULL default '0', avatarid smallint(6) NOT NULL default '0', avatarrevision int(6) unsigned NOT NULL default '0', options smallint(6) NOT NULL default '15', birthday date NOT NULL default '-00-00', maxposts smallint(6) NOT NULL default '-1', startofweek smallint(6) NOT NULL default '1', ipaddress varchar(20) NOT NULL default '', referrerid int(10) unsigned NOT NULL default '0', nosessionhash smallint(6) NOT NULL default '0', autorefresh smallint(6) NOT NULL default '-1', messagepopup tinyint(2) NOT NULL default '0', inforum smallint(5) unsigned NOT NULL default '0', ratenum smallint(5) unsigned NOT NULL default '0', ratetotal smallint(5) unsigned NOT NULL default '0', allowrate smallint(5) unsigned NOT NULL default '1', PRIMARY KEY (userid), KEY usergroupid (usergroupid), KEY username (username), KEY inforum (inforum) ) TYPE=MyISAM; INSERT INTO user VALUES (33,6,'Kevin','0','[EMAIL PROTECTED]',1,'',0,'http://www.stileproject.com','','','','',1,1,0,'Administrator',0,996120694,1,-1,1030996168,1031027028,1030599436,36,'-6',0,'','','',1,0,1,0,0,15,'-00-00',-1,1,'64.0.0.0',0,1,-1,0,0,4,19,1); SELECT DISTINCT privatemessage.*, user.* FROM privatemessage LEFT JOIN user ON (user.userid = privatemessage.touserid); Fix: Unknown I'm happy to try any patches or poke around in GDB if needed though. Submitter-Id: Kevin Day Originator:Kevin Day Organization: Stile Project, Inc. MySQL support: none Synopsis: SELECT DISTINCT w/LEFT JOIN segfault in 4.0.3 Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql-4.0.3-beta (Source distribution) Server: /usr/local/bin/mysqladmin Ver 8.37 Distrib 4.0.3-beta, for unknown-freebsdelf4.6 on i386 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 4.0.3-beta Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 6 sec Threads: 1 Questions: 1 Slow queries: 0 Opens: 0 Flush tables: 1 Open tables: 0 Queries per second avg: 0.167
MySQL Query
Hi, My intention is to get the datedifference(in no of days) between the current date and a previously entered date which is in a table(of course this date is lower in value than the current date).When I used this query: select FROM_DAYS(TO_DAYS(CURDATE()) - TO_DAYS('2001-08-30')); Here the problem comes is that it is checks first the year,then the month and then the days;and if anywhere it finds that the difference is a negative value,it prints as follows: -+ FROM_DAYS(TO_DAYS(CURDATE()) - TO_DAYS('2001-08-30')) -+ -00-00 | -+ So how can I rectify this problem? Abhilash - This message was sent using Endymion MailMan. http://www.endymion.com/products/mailman/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Query
Hello, Abhilash, If you just want the number of days between two dates, you don't need FROM_DAYS. FROM_DAYS gives you a date. This should be all you need: Select TO_DAYS(CURDATE()) - TO_DAYS('2001-08-30'); HTH, Jed On the threshold of genius, [EMAIL PROTECTED] wrote: Hi, My intention is to get the datedifference(in no of days) between the current date and a previously entered date which is in a table(of course this date is lower in value than the current date).When I used this query: select FROM_DAYS(TO_DAYS(CURDATE()) - TO_DAYS('2001-08-30')); Here the problem comes is that it is checks first the year,then the month and then the days;and if anywhere it finds that the difference is a negative value,it prints as follows: -+ FROM_DAYS(TO_DAYS(CURDATE()) - TO_DAYS('2001-08-30')) -+ -00-00 | -+ So how can I rectify this problem? Abhilash - This message was sent using Endymion MailMan. http://www.endymion.com/products/mailman/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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