Re: Federated Engine
Sergei, thanks for the reply, but I coudn´t see any 'useful' info about it . I would like to know the differences (characteristics) between federated and other engines Thanks Sergei Golubchik wrote: Hi! It was added ony a few days ago - documentation is catching up still. For now - take a look at the mysql-test/t/federated.test file. Regards, Sergei -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.296 / Virus Database: 265.6.2 - Release Date: 20/12/2004 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Federated Engine
Hi all, I downloaded the source from bk tree and I saw the federated engine. Taking a look into documentation (http://dev.mysql.com/doc/mysql/en/index.html) I didn´t find anything. So, where I can find some info about it ? Thanks in advance. (sorry my poor english ;) ) -- Luciano Barcaro Depto. Informática - Laboratório Alvaro -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.296 / Virus Database: 265.5.4 - Release Date: 15/12/2004 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Which file to backup
Egor Egorov wrote: Mauricio Pellegrini [EMAIL PROTECTED] wrote: I'm trying to backup the 'binary log' and don't know which file is it. these are the files I see in my datadir -rw-rw 1 mysql users175K Sep 14 14:21 hrrgp01-bin.07 -rw-rw 1 mysql users345K Sep 14 15:03 hrrgp01-bin.08 -rw-rw 1 mysql users1.6M Sep 14 15:18 hrrgp01-bin.09 -rw-rw 1 mysql users3.9M Sep 15 09:06 hrrgp01-bin.10 -rw-rw 1 mysql users 29K Sep 15 09:11 hrrgp01-bin.11 -rw-rw 1 mysql users676K Sep 15 15:58 hrrgp01-bin.12 -rw-rw 1 mysql users4.4M Sep 16 11:10 hrrgp01-bin.16 -rw-rw 1 mysql mysql322M Sep 16 11:10 ibdata1 -rw-rw 1 mysql users 40M Sep 16 11:10 ib_logfile0 The thing is I intend to stop the server at a certain time and then make a backup copy of the actual binary log. But which is the name of the file I should use into my script? Backup *-bin.* and ib_logfile* if you use InnoDB. And don´t forget ibdata1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: InnoDB - Foreign Key - Error 150.
Gabriel, First of all, sorry for my poor english (I´m just a brazilian guy - eu quase não sei falar o portugues, imaginem o ingles então.) Tucker, Gabriel wrote: Luciano I am confused... As far as I can tell, the set foreign_key_checks=0; is used with the load data infile command. I am not using this command to restore the database. The mysqldump command creates a file with the data and schema. I restore it to a new instance that just has the mysql database using: unix$ mysql --port=port --socket=socket -p archive.sql The set foreign_key_checks=0 disables the referential integrity (for just one session only). So, I am not sure where I would insert this line nor if it would work. Should I insert it in the archive.sql from the previous example? Yes, you should insert in the beginning of the file, OR you can do this: mysql --port=port --socket=socket -p set foreign_key_checks=0; - Disables integrity \. archive.sql - Execute the script exit- quits the client Can I use the load data infile to restore the file I generated? As far as I know, no, you can´t. Also, in the mysqldump command I used the --disable-keys command, believing this would correct the problem. Do you know why it does not? No, the foreign key error is generated because mysqldump dumps table in a different order (alphabetical) that it should. I know I asked a bunch of questions, thanks for whatever you can offer! Gabe -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Step on migrating MyISAM to InnoDB
Asep Andria I.W. wrote: I have MySQL Server 3.23.xx running on RedHat Linux 9 with 40GB harddrive and 256 RAM. I'm using MyISAM table type with around 157 tables. I think i decided to change MyISAM table to InnoDB table. But, I don't know how to do that for the first step. I have read a section on MySQL documentation about InnoDB but still not clearly about that. My existing database is still 40 Mb but would be growing fast. This database have been running about 6 month and used for critical production. Thanks in advance and for your help. It´s simple to convert a table to innodb. Just do this: alter table your_table type=innodb; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Automatic conversion from `char` TO `varchar`
No, it´s not strange. Look the manual at http://www.mysql.com/doc/en/Silent_column_changes.html Best Regards --- Luciano Barcaro Depto. Informática - Laboratório Alvaro Hassan Shaikh wrote: Hi, It's really strange but when I execute the following statement, all my char(10) columns turn into varchar(10). My other tables are ok and I've tried create dummy table also. Problem seems to be associated with this table only. CREATE TABLE `offer` ( `SVID` int(11) NOT NULL auto_increment, `CUID` char(10) NOT NULL default '', `OFTXT` text, `OFAMOUNT` decimal(12,2) NOT NULL default '0.00', `OFTYPE` char(1) NOT NULL default 'P', `OFSENTDT` datetime default NULL, `OFREPLYDT` datetime default NULL, `OFREPLYTXT` text, `OFRESULT` char(1) NOT NULL default 'X', `PID` char(10) NOT NULL default '', PRIMARY KEY (`SVID`) ) TYPE=InnoDB ; Would appreciate if someone could provide some insight. Thanks. Hassan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ZeosDBO 5.5 x 6.1.2 Version
Hi Carlos, I tested zeos in my application and 6.1 seems to be faster, and much more simple. Happy new year From Brazil too ;) - Luciano Barcaro Depto. Informática - Laboratório Alvaro Carlos J Souza wrote: Dear friends, What version of zesdbo is more faster, 5.5 or 6.1.2? .NET Plataform is a future you believe in this new plataform? Regards. Carlos J Souza From Brazil -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
replication question
Hi, I'm trying to use replication and the slave stopped with error: Could not parse relay log event entry. The possible reasons are: the master's binary log is corrupted (you can check this by running 'mysqlbinlog' on the binary log), the slave's relay log is corrupted (you can check this by running 'mysqlbinlog' on the relay log), a network problem, or a bug in the master's or slave's MySQL code. If you want to check the master's binary log or slave's relay log, you will be able to know their names by issuing 'SHOW SLAVE STATUS' on this slave. The master version is 4.0.14-standard (official binaries) The slave version is 4.0.15-standard (official binaries too) When I 'mysqlbinlog host-relay-bin.011' it gives me: ERROR: Error in Log_event::read_log_event(): 'read error', data_len: 106, event_type: 2 ERROR: Could not read entry at offset 171971 : Error in log format or read error My question is, how can I recover from this error? TIA --- Luciano Barcaro Depto. Informática - Laboratório Alvaro -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Kylux
Hi Silmara, You can use the dbExpress that comes with kylix. Silmara wrote: need use MySql to Linux ( Connectiva 7 )and Kylux. What version of the MySQL? Do I need MyODBC? -- -- \|/ __\|/ `@ / o . \ @' Microsoft? Por acaso é alguma nova /___| \/ |___\ marca de papel higiênico? \___U__/ .^. Luciano Barcaro - Linux User # 99517 /v\ Registre-se gratuitamente em // \\http://counter.li.org //(.)\\ ICQ # 17266954 ^`~'^ -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Lock Issue
Can anyone help me with monitoring locks? mysql, sql, query ___ Alvaro Online Mail (c) 2001 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Monitoring
Hi all, I'm using InnoDB Tables, and I need to know which user has records locked. I'm trying to use innodb_monitor, but I didn't find some useful info. Can anyone help me? (Sory my poor english) and, to make the filter happy: sql query ___ Alvaro Online Mail (c) 2001 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: is there a whoami for mysql?
Hi Ray, You can see what user you is with: select user(); Ray wrote: is there a show grants self or a whoami type command? i'm trying to setup security, but i'm not show who i'm login in as? root@% or [EMAIL PROTECTED]/255.255.255.0 i am logging in just fine, but i don't really want to delete root@% until i know i'm getting the right login. \s just shows me Current user: [EMAIL PROTECTED] but show grants for [EMAIL PROTECTED]; says there are no grants for this account. also, i could see this coming up for debugging as a big help. note: all ips and usernames have been changed to protect the incredably insecure, and maybe a bit paranoid. 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 -- -- \|/ __\|/ `@ / o . \ @' Microsoft? Por acaso é alguma nova /___| \/ |___\ marca de papel higiênico? \___U__/ .^. Luciano Barcaro - Linux User # 99517 /v\ Registre-se gratuitamente em // \\http://counter.li.org //(.)\\ ICQ # 17266954 ^`~'^ -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql-3.23.50
Try http://www.mysql.com/downloads/mysql-3.23-pre.html Mehalick, Richard RE SITI-ITPSCA wrote: On the MySQL download page, 3.23.50 is not available, only 3.23.49a. Is that the same thing? Rick -- -- \|/ __\|/ `@ / o . \ @' Microsoft? Por acaso é alguma nova /___| \/ |___\ marca de papel higiênico? \___U__/ .^. Luciano Barcaro - Linux User # 99517 /v\ Registre-se gratuitamente em // \\http://counter.li.org //(.)\\ ICQ # 17266954 ^`~'^ -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 1114 when import mysqldump in InnoDB table
Hi, the internal space for innodb is full... create new extends (add another ibdata file and restart the mysql) to see how much space is free, execute the command: show table status like 'yourtableinnodb' Iago Sineiro wrote: Hi all. I import a mysqldump from MyISAM database in a new innodb database. It gives me an error saying that the table is full ERROR 1114 at line 3035: The table 'LALBARANPR' is full These are the values for the innodb variables in the my.cnf file: innodb_data_file_path = ibdata1:2000M;ibdata2:2000M innodb_data_home_dir = /mysql/ innodb_log_group_home_dir = /mysql/ innodb_log_arch_dir = /mysql/ set-variable = innodb_mirrored_log_groups=1 set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=5M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 innodb_log_archive=0 set-variable = innodb_buffer_pool_size=16M set-variable = innodb_additional_mem_pool_size=2M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 What could I do? Thanks in advance. Iago. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- -- \|/ __\|/ `@ / o . \ @' Microsoft? Por acaso é alguma nova /___| \/ |___\ marca de papel higiênico? \___U__/ .^. Luciano Barcaro - Linux User # 99517 /v\ Registre-se gratuitamente em // \\http://counter.li.org //(.)\\ ICQ # 17266954 ^`~'^ -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Forcing case sensitivity via a query?
Hi Richard, Richard Bolen wrote: If I understand correctly, you have to define a char field as binary if you want the database to treat it as a 'case sensitive' field. Is there any way via a SQL query to force case sensitivity to be used for a non-binary char field? i.e.: for comparing strings in a case sensitive way. Or is there some way to force the database to use case sensitive string comparisons all the time (even for non-binary char fields)? Yes, try this: select * from yourtable where binary field1= 'CASEsensitive'; I'm using the mm.mysql jdbc driver to access the database and it returns the data differently if a field is defined as binary. This is causing my string data to be garbled in my application for binary char fields. Rich Rich Bolen Senior Software Developer GretagMacbeth Advanced Technologies Center 79 T. W. Alexander Drive - Bldg. 4401 - Suite 250 PO Box 14026 Research Triangle Park, North Carolina 27709-4026 USA Phone: 919-549-7575 x239, Fax: 919-549-0421 http://www.gretagmacbeth.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 -- -- \|/ __\|/ `@ / o . \ @' Microsoft? Por acaso é alguma nova /___| \/ |___\ marca de papel higiênico? \___U__/ .^. Luciano Barcaro - Linux User # 99517 /v\ Registre-se gratuitamente em // \\http://counter.li.org //(.)\\ ICQ # 17266954 ^`~'^ -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL 3.23.44 not using indexes
Hi Monty, Michael Widenius wrote: Hi! Jeremy commit that affected the key cache yet. Sanja has been trying to do improvements to the key cache code, but we are still not satisfied with this. He just went back to the sub select code, so we can't just now give a definite answer when we have a new key cache. (I am myself totally concentrating on getting 4.0.2-beta out; When this is done I hope to have time to take a look a the key cache problem) 4.0.2 will be labelled beta ? Regards, Monty MySQL, sql, query -- -- \|/ __\|/ `@ / o . \ @' Microsoft? Por acaso é alguma nova /___| \/ |___\ marca de papel higiênico? \___U__/ .^. Luciano Barcaro - Linux User # 99517 /v\ Registre-se gratuitamente em // \\http://counter.li.org //(.)\\ ICQ # 17266954 ^`~'^ -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: --- InnoDB for Win
maxim wrote: Hi? all Can i use InnoDB tables in MySQL Max for Win9x ? Thanks... Hi Maxim, Yes, if you use the -max version, you can. -- -- \|/ __\|/ `@ / o . \ @' Microsoft? Por acaso é alguma nova /___| \/ |___\ marca de papel higiênico? \___U__/ .^. Luciano Barcaro - Linux User # 99517 /v\ Registre-se gratuitamente em // \\http://counter.li.org //(.)\\ ICQ # 17266954 ^`~'^ -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Encrypting with PASSWORD() function
Hi Walter, Walter D. Funk wrote: Hi, I am trying Mysql Password() function, to encrypt password in a a user/password table, it works fine both ways; it is to say, when I submit a login (user/password) combination it fetches the pair ok. My question is, as I read in the documentation, that the process is irreversible, how can I deal with the fact that a user can forget his password, if I will not be able to retrieve the original string, because what i can see is the encrypted data You always (since you have privileges) can change the password of a user. So, forget the password is not a big problem. is there a workaround to deal with this, either than storing in a separeted table the original password string (not encrypted), or shall i simply not use this function ? thanks in advance to any suggestion Walter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- -- \|/ __\|/ `@ / o . \ @' Microsoft? Por acaso é alguma nova /___| \/ |___\ marca de papel higiênico? \___U__/ .^. Luciano Barcaro - Linux User # 99517 /v\ Registre-se gratuitamente em // \\http://counter.li.org //(.)\\ ICQ # 17266954 ^`~'^ -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Is there MySQL version 4.0.2 ?
Viliam Batka clear wrote: Hi, When I have been browsing the mysql documentation on http://www.mysql.com/documentation/mysql/bychapter/ I have recognised that the documentation is referring the 4.0.2 version of MySQL. I would like to compile MySQL from source files. At the moment I am able to download the 4.0.1 version. Will be the 4.0.2 version available soon or shall I go ahead with the 4.0.1 version? Thanks Viliam Batka Hi, You can get the latest source code take a look at http://www.mysql.com/doc/I/n/Installing_source_tree.html to see how to proceed -- \|/ __\|/ `@ / o . \ @' Microsoft? Por acaso é alguma nova /___| \/ |___\ marca de papel higiênico? \___U__/ .^. Luciano Barcaro - Linux User # 99517 /v\ Registre-se gratuitamente em // \\http://counter.li.org //(.)\\ ICQ # 17266954 ^`~'^ -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: AUTO_INCREMENT= ?
Amer Neely wrote: Yes, I understand that, but I'm trying to create the table and initialize UserID by redirecting a .sql file into mysql (batch mode). I don't want to insert a 'dummy' record starting at 1000, I want MySQL to do that, like it says in MySQL by Paul DuBois [p.94, chap.2.]. Again, this works in interactive mode, but NOT in batch mode. Can you or someone explain how this can be done in batch mode? What you can do is the following: After the Create table command, add : Alter table Respondents auto_increment=1000; AN The values I'm inserting for AN UserID are all 'null' (without quotes). How did you inserted values? Manually or from a file? As I indicated above, from a file. -- -- \|/ __\|/ `@ / o . \ @' Microsoft? Por acaso é alguma nova /___| \/ |___\ marca de papel higiênico? \___U__/ .^. Luciano Barcaro - Linux User # 99517 /v\ Registre-se gratuitamente em // \\http://counter.li.org //(.)\\ ICQ # 17266954 ^`~'^ -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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! Error building 4.0.2 under RH Linux 7.2
Hi Vadim, My mistake, sorry. :) I'm with the same problem in conectiva 7.0 (last week 4.0.2 compiles fine, but, after a bk pull, it gives me the same error). CL 7.0 uses gcc 2.95.3 I tested in CL 8 (gcc 2.95.3) and still don't compile. Vadim P. wrote: Hi Luciano, Could you please re-post the your reply to the mysql list as well (right now I'm the only recipient).. Your voice is very important, as MySQL folks probably believe that this is my own, isolated, problem... :( Thanks! Vadim P. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Download of source
Hi, I downloaded the latest source from mysql.com with bk clone bk://work.mysql.com:7001 mysql-4.0 and after compile/install, it installs the 3.23.50 version. Is this correct? Seems very strange to me. so, I tried to download the source of 3.23 with the command bk clone bk://work.mysql.com:7001 mysql And it downloaded exactly the same number of bytes of 4.0: (19877534 bytes) And with du --max-depth=1: 175944 ./mysql 175944 ./mysql-4.0 How can I download the real source of 4.0 ? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Download of Source (Please, ignore the previous message)
Hi, I downloaded the latest source from mysql.com with bk clone bk://work.mysql.com:7001 mysql-4.0 and after compile/install, it installs the 3.23.50 version. Is this correct? Seems very strange to me. so, I tried to download the source of 3.23 with the command bk clone bk://work.mysql.com:7001 mysql And it downloaded exactly the same number of bytes of 4.0: (19877534 bytes) And with du --max-depth=1: 175944 ./mysql 175944 ./mysql-4.0 How can I download the real source of 4.0 ? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Download of source
Paul DuBois wrote: At 13:51 -0300 4/29/02, Luciano Barcaro wrote: Hi, I downloaded the latest source from mysql.com with bk clone bk://work.mysql.com:7001 mysql-4.0 and after compile/install, it installs the 3.23.50 version. Is this correct? Seems very strange to me. That is odd. I just tried it and got 4.0.2-alpha. My error, :) the 3.23 source tree is in port 7000, the 4.0 is 7001. In the first try I used port 7000. It's OK now, thanks. so, I tried to download the source of 3.23 with the command bk clone bk://work.mysql.com:7001 mysql You're cloning the same repository in both cases. The final argument indicates the directory to use on the client machine; it has nothing to do with what you're pulling from the server. And it downloaded exactly the same number of bytes of 4.0: (19877534 bytes) And with du --max-depth=1: 175944 ./mysql 175944 ./mysql-4.0 How can I download the real source of 4.0 ? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Further Question with -- table lock - which connection id own's it
*** REPLY SEPARATOR *** Hi ... just wanted to added another question to this one... you suggested to use LAST_INSERT_ID() , but the question is if there are concurrent access to the database, how will you get the last id without locking the table. Don't worry about concurrent access... the last_insert_id() returns the last id inserted by your process (connection). Because what I've been doing is also: 1. lock the table 2. get the id 3. release lock Could you further explain the LAST_INSERT_ID() a little more and how to complish it without using locks. thank you. Sukhdev. --- Michael Widenius [EMAIL PROTECTED] wrote: Hi! Lopez == Lopez David E-r9374c [EMAIL PROTECTED] writes: Lopez AntiSpam - mysql, sql, query Lopez Version: 3.23.49a, MyISAM, NT, Solaris Lopez My app is 150 daemons writing logs to mysql. The main Lopez table is of fixed size but depends on four other tables Lopez for foreign keys (hash tables). These tables are uploaded Lopez once to the daemon at start-up. Occasionally, a new entry Lopez must be written into these hash tables. The procedure is Lopez to lock the table, insert entry, get the key (auto-increment Lopez field) and release the lock. A better solution is to use LAST_INSERT_ID() and not use any locks at all. Lopez But what if the connection dies during the update process. Lopez If this happens, how can I tell which connection id has the Lopez lock so I can kill it? If a connection dies, the server will automaticly delete all temporary tables and all table locks. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland ___/ 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 __ Do You Yahoo!? Yahoo! Games - play chess, backgammon, pool and more http://games.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 fim do besteirol todo que Sukhdev Sethi escreveu. --- \|/ __ \|/ `@ / o . \ @'Microsoft? Por acaso é alguma /___| \/ |___\marca de papel higiênico? \___U__/ .^. Luciano Barcaro - Linux User #99517 /v\ Seja também um feliz usuário de linux // \\ Registre-se gratuitamente em /( . )\http://counter.li.org ^`~'^ ICQ # --- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Selecting Information Just Inserted
Hi, Andrew, To get the auto_increment value, simply execute select last_insert_id() after insert statement Andrew Kuebler wrote: Maybe someone can help me here.. I'm inserting data with an AUTO_INCREMENT column and immediately after I need to use that new number for a corresponding record in another table. How am I able to extract that new number quickly? I could run a SELECT query after the INSERT using the MAX command, but if at a busy time another record is entered while the first record was being entered, it's possibly I may get the wrong number. If there a way to use the INSERT command and extract the new AUTO_INCREMENT all in one command? Any help is appreciated. Andrew - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Number of records updated
Hi All, First, sorry my poor english I'm testing the pre-version of innodb (with on delete cascade) and when I delete some records, the number returned is only the records matched in the parent table. It erases the records in the child tables, but don't count them. This is because I'm using the 3.23.49 (with new code from innodb.com) ? or it's a bug? Mysql, SQL --- Luciano Barcaro - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
