Delete with join in mysql 4.0.2
I have just upgraded to mysql 4 to be able to perform delete queries with join statement. I have a simple query where I would like to delete a number of rows in tabel t1 depending on id's found in table t2. This doesn't seem to work and I just don't understand why!? mysql delete icl from ca_x_ind_com_lvl as icl, ca_individual as ind where icl.ind_id = ind.ind_id and ind.acc_id_id = @acc_id; ERROR 1066: Not unique table/alias: 'icl' Where @acc_id is set by: set @acc_id = 2; What am I doing wrong? BR Christian === Christian Longberg | Tel: +46 8 730 16 74 Råsundavägen 150 | Mob: +46 70 547 53 67 169 36 Solna | Fax: +46 8 660 96 08 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Permissions
H... ( mysql, query ) What permissions does a user need to issue: LOCK TABLES blah WRITE ??? I have a user which I have: GRANT ALL ON * TO user (blah blah) ...but that user can't lock any tables. Only the mysql root user can... Version 4.0.2, built from source on RH 7.1. DSL -- Say you'll share with me one love, one lifetime Lead me, save me from my solitude. Say you'll want me with you, here beside you Anywhere you go let me go too... (Webber/Hart/Black) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 replication protocol
Paul, (mysql, query) It *can* use TCP, but that's just the transport protocol through which the replication information is processed. Replication can also be done between two servers on the same host, using a UNIX socket or (on a Windows box) a named pipe. The replication protocol itself is MySQL-specific. I would assume, then, that if it were done over TCP/IP that one could setup ipsec to secure it. Just out of interest (and hit me if it's in the manual somewhere ;-P), does the replication protocol offer any cryptographically secure method of replication if one wants it? DSL - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
»ª±±ÆóÒµÃû¼
»ª±±ÆóÒµÃû¼http://www.rqhh.com µÇ¼»ª±±ÆóÒµÍø£¬Äú¿ÉÒÔ 1.Ãâ·Ñ¼ÓÈëÆóÒµÃû¼ 1.Ãâ·Ñ·¢²¼ÆóÒµÐÅÏ¢ 2.Ãâ·Ñ·¢²¼¹©ÇóÐÅÏ¢ 3.Ãâ·Ñ·¢²¼ÆóÒµÐÂÎÅ ´ËÍ⣬»ª±±ÆóÒµÍø»¹°üÀ¨£ºÊ±Ê±¨µÀ¡¢ÆóÒµ¶¯Ì¬¡¢Õþ²ß·¨¹æ¡¢ÐÅÏ¢²éѯµÈÀ¸Ä¿£¬ÊÇÄú¼°Ê±»ñÈ¡ÐÅÏ¢µÄ×î¼Ñ;¾¶¡£ ÓʼþÄÚÈÝÓëÒÔÏÂÎÄ×ÖÎÞ¹Ø= ÖÐ×ÊÔ´¹«Ë¾http://www.net001.net ÌṩÓòÃûÏÈ×¢²áºó¸¶¿î;Ö÷»úÏÈ¿ªÍ¨ºóÊÕ·Ñ·þÎñ, ÖÐ;¿ÉÍË¿î¡£ÌØ»ÝÍƼö£ºÓòÃû+100MÖ÷»ú²¢¸½ËÍ5¸ö10MÆóÒµÓÊÏ䣬ÿÄêÖ»Ðè350Ôª£¡£¡ ÓÅÁªÍøÂç http://www.chinamysql.com רҵÌṩ¸÷ÀàÐéÄâÖ÷»ú£¬²»ÂúÒâ¿É»ñÍË¿î¡£ Ç¿ÊÆÌײͣº100MÖ÷»úËͶ¥¼¶ÓòÃû£¬ËÍ10¸ö10MÆóÒµÓÍÏ䣬¼ÓËÍ20¸ö¶þ¼¶ÓòÃû£¬½öÐè318Ôª/Ä꣡ ʹÓü«ÐÇÓʼþȺ·¢£¬ÎÞÐëͨ¹ýÓʼþ·þÎñÆ÷£¬Ö±´ï¶Ô·½ÓÊÏ䣬ËٶȾø¶ÔÒ»Á÷£¡ ÏÂÔØÍøÖ·£ºhttp://www.lovexin.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
3.23.52 hitting system loads of 25+?
Hi there, Haven't been watching the list lately so forgive me if this has already been discussed here recently. Have any of you seen an issue with MySQL 3.23.52 spiralling out of control after a minute or so of operation? We run a fairly high-volume db, previously running 3.23.49a and upgrading today to 3.23.52. The system comes up and runs fine for a minute or so, reaching a binlog file size of almost exactly 78k each time, and then something weird happens... top suddenly shows a hundred mysqld processes, load jumps from around 0.5 to 4, to 9, to 15, 23, and then sits there, fluctuating between 20 and 25, while processlist shows a dozen or more connections trying to authenticate and all client machines report a cannot connect error message. We went to 3.23.51 instead a little while ago and it seems to be working normally. Any ideas about what might be causing this? Is this a known issue? Thanks, =john - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Delete with join in mysql 4.0.2
Christian, Saturday, August 31, 2002, 11:09:47 AM, you wrote: CL I have just upgraded to mysql 4 to be able to perform delete queries CL with join statement. I have a simple query where I would like to delete CL a number of rows in tabel t1 depending on id's found in table t2. This CL doesn't seem to work and I just don't understand why!? CL mysql delete icl from ca_x_ind_com_lvl as icl, ca_individual as ind CL where icl.ind_id = ind.ind_id and ind.acc_id_id = @acc_id; CL ERROR 1066: Not unique table/alias: 'icl' CL Where @acc_id is set by: set @acc_id = 2; CL What am I doing wrong? Use real table name after DELETE, i.e. DELETE ca_x_ind_com_lvl FROM ca_x_ind_com_lvl AS icl, ca_individual AS ind WHERE icl.ind_id = ind.ind_id AND ind.acc_id_id = @acc_id; -- 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: RE: performance tunning 4.x
mos,
Friday, August 30, 2002, 7:04:25 PM, you wrote:
m At 07:58 AM 8/30/2002, you wrote:
mos,
Thursday, August 29, 2002, 5:45:05 PM, you wrote:
Start by looking at the MySQL documentation:
http://www.mysql.com/doc/en/Query_Cache.html
Read the entire 6.9 section.
It offers quite a bit of information on how the cache operates, how
you should configure it and so on.
m I read it too but I have a question about the cache, this sentence
m in particular.
m NOTE: The query cache does not return stale data. When data is modified,
m any relevant entries in the query cache are flushed.
m If I have a select statement like:
m select col1, col2 from table1 where col1='A'
[skip]
m c) Or will any update to the table automatically flush the cache?
m Victoria,
Yes, relevant entries in the query cache are flushed when any changes were
made on the
table.
m Can you define relevant? Do you mean all caches for that table?
m Are you saying any change at all to the table, say I add a row, delete a
m row, or modify a row even if it is not in the scope of the cached query,
m will cause all caches for that table to be discarded? Argghhh! :-O
Yes.
And it's described in the manual:
http://www.mysql.com/doc/en/Query_Cache_How.html
m Example:
m select customer_name from customers where state = 'NY' //-Adds query to cache
m insert into customers (customer_name, state) values('jones',
m 'CA') //-Flushes the cache for customers table?
m select customer_name from customers where state = 'NY' //-No longer in cache?
m If you are correct, then I feel caching is useful primarily for readonly
m access to a table. As soon as a row is modified in any way, the caches for
m that table are flushed. Would you agree?
Yes.
--
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: Delete with join in mysql 4.0.2
Christian Longberg wrote: I have just upgraded to mysql 4 to be able to perform delete queries with join statement. I have a simple query where I would like to delete a number of rows in tabel t1 depending on id's found in table t2. This doesn't seem to work and I just don't understand why!? mysql delete icl from ca_x_ind_com_lvl as icl, ca_individual as ind where icl.ind_id = ind.ind_id and ind.acc_id_id = @acc_id; ERROR 1066: Not unique table/alias: 'icl' Where @acc_id is set by: set @acc_id = 2; What am I doing wrong? BR Christian You have a column named icl and have aliased a table as icl. MySQL can't figure out which icl to use. You should use a different alias for ca_x_ind_com_lvl, or fully-specify the icl column as tablename.columnname. -Mark -- 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
Problem with ALTER query
Hi, I have two connections open to a mysql-nt server. I am using one connection to add a field field to a table using the command ALTER TABLE testtable ADD testfield int; Now if I issue any query from the second connection, the mysql-nt daemon crashes with a Dr.Watson error. The but if I open a new connection it works fine. Only connections open at the time of table alteration have problem Can anyone help me to overcome this problem Raman - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 replication protocol
At 10:55 +0200 8/31/02, David Lloyd wrote: Paul, (mysql, query) It *can* use TCP, but that's just the transport protocol through which the replication information is processed. Replication can also be done between two servers on the same host, using a UNIX socket or (on a Windows box) a named pipe. The replication protocol itself is MySQL-specific. I would assume, then, that if it were done over TCP/IP that one could setup ipsec to secure it. Presumably, yes. Just out of interest (and hit me if it's in the manual somewhere ;-P), does the replication protocol offer any cryptographically secure method of replication if one wants it? DSL MySQL 4 supports SSL. The server supports master-ssl, master-ssl-key, and master-ssl-cert options, which are analogous to the non-master options...the server's help message does warn that this is relatively new. As is SSL in MySQL in general. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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+?
We experienced a similar problem with 3.23.51 which went away once we compiled from source. Assume this is Linux 2.4? -M On Sat, Aug 31, 2002 at 03:08:10AM -0700, John Stanforth wrote: Haven't been watching the list lately so forgive me if this has already been discussed here recently. Have any of you seen an issue with MySQL 3.23.52 spiralling out of control after a minute or so of operation? We run a fairly high-volume db, previously running 3.23.49a and upgrading today to 3.23.52. The system comes up and runs fine for a minute or so, reaching a binlog file size of almost exactly 78k each time, and then something weird happens... top suddenly shows a hundred mysqld processes, load jumps from around 0.5 to 4, to 9, to 15, 23, and then sits there, fluctuating between 20 and 25, while processlist shows a dozen or more connections trying to authenticate and all client machines report a cannot connect error message. We went to 3.23.51 instead a little while ago and it seems to be working normally. Any ideas about what might be causing this? Is this a known issue? -- Michael Bacarella | Netgraft Corp | 545 Eighth Ave #401 Systems Analysis | New York, NY 10018 Technical Support | 212 946-1038 | 917 670-6982 Managed Services | http://netgraft.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
convert ms access mdb file to file that can be imported in mysql
Hi, I've looked through the archives of this list but all methods of porting a ms access db to mysql seem to require installing additional software under Windows. Is there a tool available that converts an existing ms access db-file (*.mdb) into something that can be imported into mysql? I don't care about synchronising the two databases, running queries from different platforms, converting forms and/or queries. All I would like to extract the data from the .mdb file and store it in a mysql table. Preferably without having to install MS Access first. Thanks in advance, -- # Mertens Bram M8ram [EMAIL PROTECTED] Linux User #249103 # # Red Hat Linux 7.3 KDE 3.0.0-10 kernel 2.4.18-3 i686 128MB RAM # - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: convert ms access mdb file to file that can be imported in mysql
you could install MyODBC to write the tables directly from MS A. to MySQL via ODBC. Works ok and did a good job for me. Andy - Original Message - From: Mertens Bram [EMAIL PROTECTED] To: mysql mailing list [EMAIL PROTECTED] Sent: Saturday, August 31, 2002 4:17 PM Subject: convert ms access mdb file to file that can be imported in mysql Hi, I've looked through the archives of this list but all methods of porting a ms access db to mysql seem to require installing additional software under Windows. Is there a tool available that converts an existing ms access db-file (*.mdb) into something that can be imported into mysql? I don't care about synchronising the two databases, running queries from different platforms, converting forms and/or queries. All I would like to extract the data from the .mdb file and store it in a mysql table. Preferably without having to install MS Access first. Thanks in advance, -- # Mertens Bram M8ram [EMAIL PROTECTED] Linux User #249103 # # Red Hat Linux 7.3 KDE 3.0.0-10 kernel 2.4.18-3 i686 128MB RAM # - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: convert ms access mdb file to file that can be imported inmysql
At 16:17 +0200 8/31/02, Mertens Bram wrote: Hi, I've looked through the archives of this list but all methods of porting a ms access db to mysql seem to require installing additional software under Windows. Is there a tool available that converts an existing ms access db-file (*.mdb) into something that can be imported into mysql? I don't care about synchronising the two databases, running queries from different platforms, converting forms and/or queries. All I would like to extract the data from the .mdb file and store it in a mysql table. Preferably without having to install MS Access first. If you don't want to install *any* software, you're probably out of luck, because any such extraction is going to require you to use *some* program. :-) But you don't need to install Access itself. Other tools can read Access files. DBTools and MySQLFront are a couple that work pretty well. Thanks in advance, -- # Mertens Bram M8ram [EMAIL PROTECTED] Linux User #249103 # # Red Hat Linux 7.3 KDE 3.0.0-10 kernel 2.4.18-3 i686 128MB RAM # - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: convert ms access mdb file to file that can be imported in mysql
Andy, ( mysql, query ) you could install MyODBC to write the tables directly from MS A. to MySQL via ODBC. Works ok and did a good job for me. I've looked through the archives of this list but all methods of porting a ms access db to mysql seem to require installing additional software under Windows. You have missed his point. He's asking Microsoft to support MySQL as a native backend. YEAH RIGHT I'd suggest the original asker rephrase his question into something a little more useful... DSL -- Say you'll share with me one love, one lifetime Lead me, save me from my solitude. Say you'll want me with you, here beside you Anywhere you go let me go too... (Webber/Hart/Black) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: convert ms access mdb file to file that can be imported in mysql
On Sat, 2002-08-31 at 17:59, David Lloyd wrote: ( mysql, query ) You have missed his point. He's asking Microsoft to support MySQL as a native backend. I'm sorry if I was unclear, I'll try to clarify. I created a db under Windows using Access, I backed the .mdb files up. I have upgraded my OS to Linux. :) And my dbm to mysql, I do have Win98 installed on a separate partition but I haven't reinstalled Access or any other Office program and would like to know if it is possible to use a LINUX tool or program (I don't mind installing software, I just would prefer not to install any software under Windows) to convert the .mdb file into something I can use under Linux as input for my mysql db. I'd suggest the original asker rephrase his question into something a little more useful... Is this more useful? And an additional question: if the files can only be read/altered under Windows wouldn't it be easier to install Access and export the data to a text-file? I do believe Access offered that possibility,or doesn't it? BTW the Office version I could install is 2000. rant And finally: I wouldn't want Microsoft to support mysql in any way, they have a bad habit of 'improving' other software. In the process rendering it useless for everybody not willing to upgrade to the last version of their OS. /rant so again, thanks in advance for suggestions! Regards, -- # Mertens Bram M8ram [EMAIL PROTECTED] Linux User #249103 # # Red Hat Linux 7.3 KDE 3.0.0-10 kernel 2.4.18-3 i686 128MB RAM # - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Wrong Sorting in arabic alphabets
Wrong Sorting in arabic alphabets Hi, This bug is for Arabic alphabets. I am using mysql 32.23.52 The error is : When sorting a table ASC it puts the letter (mem ãíã) in the top. The letter (mem ãíã) is the 24 alphabets Example 1 ÌÑíÑ (first letter is jeem Ìíã - number 5 in the alphabets ) 2 ÚáÞãÉ (first letter is aeen Úíä - number 19 in the alphabets) 3 ÝÑÒÏÞ (first letter is faa ÝÇÁ number 21 in the alphabets) 4 - ãÞäÚ (first letter is mem ãíã number 24 is the 24 alphabets) this is the correct sort, but mysql sort it : 4 - ãÞäÚ (first letter is mem ãíã number 24 is the 24 alphabets) 1 ÌÑíÑ (first letter is jeem Ìíã - number 5 in the alphabets ) 2 ÚáÞãÉ (first letter is aeen Úíä - number 19 in the alphabets) 3 ÝÑÒÏÞ (first letter is faa ÝÇÁ number 21 in the alphabets) Is there a solution? __ 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
Re: 3.23.52 hitting system loads of 25+?
Michael, what compiler/version did you use? Thanks, --jeff - Original Message - From: Michael Bacarella [EMAIL PROTECTED] To: John Stanforth [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, August 31, 2002 6:58 AM Subject: Re: 3.23.52 hitting system loads of 25+? We experienced a similar problem with 3.23.51 which went away once we compiled from source. Assume this is Linux 2.4? -M On Sat, Aug 31, 2002 at 03:08:10AM -0700, John Stanforth wrote: Haven't been watching the list lately so forgive me if this has already been discussed here recently. Have any of you seen an issue with MySQL 3.23.52 spiralling out of control after a minute or so of operation? We run a fairly high-volume db, previously running 3.23.49a and upgrading today to 3.23.52. The system comes up and runs fine for a minute or so, reaching a binlog file size of almost exactly 78k each time, and then something weird happens... top suddenly shows a hundred mysqld processes, load jumps from around 0.5 to 4, to 9, to 15, 23, and then sits there, fluctuating between 20 and 25, while processlist shows a dozen or more connections trying to authenticate and all client machines report a cannot connect error message. We went to 3.23.51 instead a little while ago and it seems to be working normally. Any ideas about what might be causing this? Is this a known issue? -- Michael Bacarella | Netgraft Corp | 545 Eighth Ave #401 Systems Analysis | New York, NY 10018 Technical Support | 212 946-1038 | 917 670-6982 Managed Services | http://netgraft.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: convert ms access mdb file to file that can be imported in mysql
I can supply a converter that will do this without having Access installed. Contact my Sales Manager Joy Johnson at [EMAIL PROTECTED] who will let you have a copy for £30.00 plus VAT (If in the EU) Michael Johnson Director BPEnet Humphrey Consulting Limited 13 Austin Friars London EC2N 2JX Tel +44(0)1323 438975 Fax +44(0)1323 738355 email [EMAIL PROTECTED] URL www.bpenet.net Also in Dublin Luxembourg -Original Message- From: Mertens Bram [mailto:[EMAIL PROTECTED]] Sent: 31 August 2002 17:20 To: mysql mailing list Subject: Re: convert ms access mdb file to file that can be imported in mysql On Sat, 2002-08-31 at 17:59, David Lloyd wrote: ( mysql, query ) You have missed his point. He's asking Microsoft to support MySQL as a native backend. I'm sorry if I was unclear, I'll try to clarify. I created a db under Windows using Access, I backed the .mdb files up. I have upgraded my OS to Linux. :) And my dbm to mysql, I do have Win98 installed on a separate partition but I haven't reinstalled Access or any other Office program and would like to know if it is possible to use a LINUX tool or program (I don't mind installing software, I just would prefer not to install any software under Windows) to convert the .mdb file into something I can use under Linux as input for my mysql db. I'd suggest the original asker rephrase his question into something a little more useful... Is this more useful? And an additional question: if the files can only be read/altered under Windows wouldn't it be easier to install Access and export the data to a text-file? I do believe Access offered that possibility,or doesn't it? BTW the Office version I could install is 2000. rant And finally: I wouldn't want Microsoft to support mysql in any way, they have a bad habit of 'improving' other software. In the process rendering it useless for everybody not willing to upgrade to the last version of their OS. /rant so again, thanks in advance for suggestions! Regards, -- # Mertens Bram M8ram [EMAIL PROTECTED] Linux User #249103 # # Red Hat Linux 7.3 KDE 3.0.0-10 kernel 2.4.18-3 i686 128MB RAM # - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Lock Permissions
At 18:16 +0930 8/31/02, David Lloyd wrote: H... ( mysql, query ) What permissions does a user need to issue: LOCK TABLES blah WRITE ??? I have a user which I have: GRANT ALL ON * TO user (blah blah) ...but that user can't lock any tables. Only the mysql root user can... Version 4.0.2, built from source on RH 7.1. The privilege tables have changed in 4.0.2. Two of the new privileges are CREATE TEMPORARY TABLES and LOCK TABLES. However, these are not granted at the database level, but only at the global level, so they are not granted with GRANT ALL ON db_name.* TO ... You must grant them explicitly with: GRANT CREATE TEMPORARY TABLES,LOCK TABLES ON *.* to ... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Query problem in Perl
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
Query problem in Perl
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
query crashes 4.03 every time
Here is the evil query: 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 Here's a structure dump of the table it's trying to select from: CREATE TABLE b2comments ( comment_ID int(11) unsigned NOT NULL auto_increment, comment_post_ID int(11) NOT NULL default '0', comment_author tinytext NOT NULL, comment_author_email varchar(100) NOT NULL default '', comment_author_url varchar(100) NOT NULL default '', comment_author_IP varchar(100) NOT NULL default '', comment_date datetime NOT NULL default '-00-00 00:00:00', comment_content text NOT NULL, comment_karma int(11) NOT NULL default '0', PRIMARY KEY (comment_ID) ) TYPE=MyISAM; This is my first time posting to the list, so do you need any more information? I'll be happy to provide any other information needed, PHP or SQL code, etcetera. --Matt - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Remote admin app?
Just found a new one I really like. Does everything, create tables, queries, etc. The best part is that you can create really nice formated reports. http://www.mysqlstudio.com/feature.php3 Jayne - Original Message - From: neal [EMAIL PROTECTED] To: mySQL [EMAIL PROTECTED] Sent: Friday, August 30, 2002 4:07 PM Subject: Remote admin app? What do you guys use for remote admin of mySQL? mySQL-front? MySQLGUI? Other? What's most popular and why? 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Binary Update Logs
On Fri, Aug 30, 2002 at 10:24:13PM -0700, Jefferson Cowart wrote: I just downloaded 3.23.52 from the mysql servers and the version of mysqlbinlog in there doesn't have the -d option you are talking about. Yeah, looks like it's in 4.0.2 and later. I may have the patch still floating around if you'd like it. It was only about 15 lines of code, IIRC. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 25 days, processed 528,106,946 queries (239/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: mysqldump variables
At 13:37 -0700 8/31/02, [EMAIL PROTECTED] wrote: The 4.0.2 manual's mysqldump section says the mysqldump variables that can be set are listed below, but I can't find them. Anybody know where they are, or what they are? Just run mysqldump --help and it will show a list. Thanks Peter [filter fodder: 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
Re: 3.23.52 hitting system loads of 25+?
Yes, Redhat's 2.4.18 kernel running on a Redhat 7.2 install. I was going to try compiling from source, except that MySQL AB seems to warn against that sort of thing on the releases page (people experiencing data corruption, etc.) and we also have a support contract with them which seems to work best when we're running their pre-compiled binaries. :-) Has anyone here from MySQL seen similar issues in .51 or .52? And is compiling from source the recommended fix for this for now? BTW, thanks Michael for the info... Very helpful, since I was just plain stumped at this bizarre behavior... =john 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? -M On Sat, Aug 31, 2002 at 03:08:10AM -0700, John Stanforth wrote: Haven't been watching the list lately so forgive me if this has already been discussed here recently. Have any of you seen an issue with MySQL 3.23.52 spiralling out of control after a minute or so of operation? We run a fairly high-volume db, previously running 3.23.49a and upgrading today to 3.23.52. The system comes up and runs fine for a minute or so, reaching a binlog file size of almost exactly 78k each time, and then something weird happens... top suddenly shows a hundred mysqld processes, load jumps from around 0.5 to 4, to 9, to 15, 23, and then sits there, fluctuating between 20 and 25, while processlist shows a dozen or more connections trying to authenticate and all client machines report a cannot connect error message. We went to 3.23.51 instead a little while ago and it seems to be working normally. Any ideas about what might be causing this? Is this a known issue? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Wrong Sorting in arabic alphabets
Wrong Sorting in arabic alphabets Hi, This bug is for Arabic alphabets. I am using mysql 32.23.52 under winxp The error is : When sorting a table ASC it puts the letter (mem ãíã) in the top. The letter (mem ãíã) is the 24 alphabets Example 1 ÌÑíÑ (first letter is jeem Ìíã - number 5 in the alphabets ) 2 ÚáÞãÉ (first letter is aeen Úíä - number 19 in the alphabets) 3 ÝÑÒÏÞ (first letter is faa ÝÇÁ number 21 in the alphabets) 4- ãÞäÚ (first letter is mem ãíã number 24 is the 24 alphabets) this is the correct sort, but mysql sort it : 4 - ãÞäÚ (first letter is mem ãíã number 24 is the 24 alphabets) 1 ÌÑíÑ (first letter is jeem Ìíã - number 5 in the alphabets ) 2 ÚáÞãÉ (first letter is aeen Úíä - number 19 in the alphabets) 3 ÝÑÒÏÞ (first letter is faa ÝÇÁ number 21 in the alphabets) Is there a solution? __ 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
file size limit
here a file size limit in my sql
Re: file size limit
At 18:59 -0400 8/31/02, qlarry wrote: here a file size limit in my sql What? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
limiting the user
Hi everyone, I am running a FreeBSD server with MySQL 3.23 I want to let my virtual users create/drop tables and limit the size of each table, and also the number of tables they can create. Can someone please tell me how I can do this? Is it possible wit applications such as webmin, or phpMyAdmin? Thanks so much - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 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 -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 25 days, processed 528,502,681 queries (238/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: limiting the user
Hey, You can limit the size of the database by specifying a quota on the directory created by MySQL for that database. When you create a database, all MySQL does is create a directory under the data directory for that database. You can then set a quota on that directory using whatever tools your OS supplies. This won't limit the number of tables, or the specific size of any one table, but it might be all you need... Dean. -Original Message- From: Soheil Shaghaghi [mailto:[EMAIL PROTECTED]] Sent: Sunday, 1 September 2002 9:35 am To: [EMAIL PROTECTED] Subject: limiting the user Hi everyone, I am running a FreeBSD server with MySQL 3.23 I want to let my virtual users create/drop tables and limit the size of each table, and also the number of tables they can create. Can someone please tell me how I can do this? Is it possible wit applications such as webmin, or phpMyAdmin? Thanks so much - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL - ODBC - CF - performance?
Hi all, does anyone have any experience with running MySQL on Red Hat Linux as a back end to a web application written in Cold Fusion under VERY heavy load? We're talking hundreds of thousands of hits per day. I'm curious about how well the Merant MySQL ODBC driver performs under such extreme conditions. In my experience ODBC can be very buggy and unreliable and equally hard to troubleshoot. Any ideas? Does anyone have any performance data on comparing such a setup to, say, PHP connected to MySQL through native drivers instead of ODBC? (CF doesn't give you the option of using native drivers with MySQL) Any pointers, thoughts, comments, ideas would be very much appreciated. Thanks in advance, Balazs Wellisch Neu Solutions Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Request for help - Table Crashing
Hello,
This is my 2nd post, not to sound pushy, just raising the urgency of my
dilemna. My table is crashing way to often (I'd like it to not crash at
all).
I'm not sure what to do, how to trouble shoot, and how to fix my problem. I
will post the structure of the table here, as well as the pertinent
hardware/software supporting my DB.
I'm wondering if the problem might be with the FullText indexes?
Please Advise.
Karl
TABLE STRUCTURE:
# MySQL dump 8.16
#
# Host:Database: submitsearch
#
# Server version4.0.0-alpha
#
# Table structure for table 'submit'
#
CREATE TABLE submit (
submitid int(11) NOT NULL auto_increment,
name varchar(50) default '',
title varchar(80) NOT NULL default '',
url varchar(100) NOT NULL default '',
email varchar(50) default '',
keywords varchar(255) NOT NULL default '',
subject varchar(50) default '',
phone varchar(50) default '',
company varchar(50) default '',
address1 varchar(50) default '',
address2 varchar(50) default '',
city varchar(50) default '',
state varchar(25) default '',
zipcode varchar(25) default '',
country varchar(50) default '',
description varchar(255) default NULL,
service varchar(30) NOT NULL default '',
dbedit timestamp(14) NOT NULL,
amount varchar(16) NOT NULL default '0',
submitdate datetime default NULL,
phone2 varchar(30) NOT NULL default '',
callstatus char(2) NOT NULL default 'NC',
notes varchar(255) NOT NULL default 'Add your comments here (max 255
char.)',
caller varchar(10) NOT NULL default '',
followupdate varchar(15) NOT NULL default '',
pending enum('Y','N') default 'Y',
famappvd enum('Y','N') default 'N',
optkeywords varchar(255) NOT NULL default '',
opturl varchar(255) NOT NULL default '',
srvcOptCode varchar(16) NOT NULL default '',
srvcAuthCode varchar(16) NOT NULL default '',
srvcExpDate date NOT NULL default '-00-00',
srvcStatus varchar(10) NOT NULL default '',
preferred int(11) NOT NULL default '0',
submittedby varchar(15) NOT NULL default '',
PRIMARY KEY (submitid),
UNIQUE KEY url_unique (url),
KEY service (service),
KEY name_index (name),
KEY opturl_index (opturl),
KEY optkeywords_index (optkeywords),
KEY submitdate_index (submitdate),
FULLTEXT KEY full_4_index (title,keywords,description,url)
) TYPE=MyISAM PACK_KEYS=1;
SERVER OPERATING SYSTEM / SOFTWARE:
---
ASP Script IIS 5.0
Windows 2000 Server Running MySQL ODBC
Makes ODBC connection with MySQL server
FreeBSD Box with MySQL 4.0.0-alpha
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Request for help - Table Crashing
Hi,
Perhaps try to upgrade first from 4.0.0 to 4.0.3 to see if the problem still
happens ? (many fixes have been introduced, especially on FT search)
Regards,
Jocelyn
- Original Message -
From: Karl J. Stubsjoen [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, September 01, 2002 3:35 AM
Subject: Request for help - Table Crashing
Hello,
This is my 2nd post, not to sound pushy, just raising the urgency of my
dilemna. My table is crashing way to often (I'd like it to not crash at
all).
I'm not sure what to do, how to trouble shoot, and how to fix my problem.
I
will post the structure of the table here, as well as the pertinent
hardware/software supporting my DB.
I'm wondering if the problem might be with the FullText indexes?
Please Advise.
Karl
TABLE STRUCTURE:
# MySQL dump 8.16
#
# Host:Database: submitsearch
#
# Server version 4.0.0-alpha
#
# Table structure for table 'submit'
#
CREATE TABLE submit (
submitid int(11) NOT NULL auto_increment,
name varchar(50) default '',
title varchar(80) NOT NULL default '',
url varchar(100) NOT NULL default '',
email varchar(50) default '',
keywords varchar(255) NOT NULL default '',
subject varchar(50) default '',
phone varchar(50) default '',
company varchar(50) default '',
address1 varchar(50) default '',
address2 varchar(50) default '',
city varchar(50) default '',
state varchar(25) default '',
zipcode varchar(25) default '',
country varchar(50) default '',
description varchar(255) default NULL,
service varchar(30) NOT NULL default '',
dbedit timestamp(14) NOT NULL,
amount varchar(16) NOT NULL default '0',
submitdate datetime default NULL,
phone2 varchar(30) NOT NULL default '',
callstatus char(2) NOT NULL default 'NC',
notes varchar(255) NOT NULL default 'Add your comments here (max 255
char.)',
caller varchar(10) NOT NULL default '',
followupdate varchar(15) NOT NULL default '',
pending enum('Y','N') default 'Y',
famappvd enum('Y','N') default 'N',
optkeywords varchar(255) NOT NULL default '',
opturl varchar(255) NOT NULL default '',
srvcOptCode varchar(16) NOT NULL default '',
srvcAuthCode varchar(16) NOT NULL default '',
srvcExpDate date NOT NULL default '-00-00',
srvcStatus varchar(10) NOT NULL default '',
preferred int(11) NOT NULL default '0',
submittedby varchar(15) NOT NULL default '',
PRIMARY KEY (submitid),
UNIQUE KEY url_unique (url),
KEY service (service),
KEY name_index (name),
KEY opturl_index (opturl),
KEY optkeywords_index (optkeywords),
KEY submitdate_index (submitdate),
FULLTEXT KEY full_4_index (title,keywords,description,url)
) TYPE=MyISAM PACK_KEYS=1;
SERVER OPERATING SYSTEM / SOFTWARE:
---
ASP Script IIS 5.0
Windows 2000 Server Running MySQL ODBC
Makes ODBC connection with MySQL server
FreeBSD Box with MySQL 4.0.0-alpha
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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
possibly off topic: any VB programmers out there?
I've got a strange problem using VB to connect to a mysql database via ODBC. The problem isn't with connecting, but rather with one particular control -- the datalist/combo control. In fact, the problem doesn't seem to have anything to do with databases directly, BUT I figured that there is sufficient VB talent on this list that someone has seen this and knows how to fix it. (indirectly, I'm not able to reliably detect if a row exists or not using this control) Background: the datacombo control will automatically load itself with values taken from a dataset -- this is really cool for lookup fields where you want to make it easy for the end user to select related data. Being a combo type item, it ALSO allows the user to type in a completely NEW value, and that's where things seem to go downhill. In particular, the control has a property/field called macthedwithlist which returns true if the user selects or types in a value actually in the list, and another property called selecteditem which returns a bookmark [record number] of the selected value. This bookmark can then be applied to the related dataset to retrieve the full record for display or editing. The problem I'm running into is that if you TYPE IN the value directly (i.e., without using the mouse to point-n-click or the arrow keys to scroll through the list), the bookmark contains a null value EVEN IF THE USER TYPES IN A MATCHING ENTRY. (and here, a null bookmark would imply that the entered value doesn't match anything) What I'm trying to accomplish is to combine two activities into one logical activity -- for example, inventory item maintenance. I want to build a form that allows editing of all the particulars for an inventory item (item code, description, qty, etc.) There are two (well, three) activities that can occur: a new item can be added, or an existing item can be modified (or deleted). The traditional way to do this would be to place an add button on the form to clear the form and allow an item to be defined, generating an annoying error if the user enters an existing code number. Likewise, you would place a find button that generates an equally annoying error if you DON'T type in the proper item code. What I want to do is combine these activities via the combo box -- if you select a existing item the form displays the data and allows for modifications. Likewise, if you type in a new value, the program implicitly adds a new (blank) record -- note that since I've determined from the key value entered whether to add or modify an entry, there is no need to display an annoying error. The part my program falls over on is that if you TYPE in an EXISTING item code, the two tests that you can perform to see if this is a new entry generate conflicting values: matchedwithlist will return TRUE (meaning we should MODIFY the entry), and selecteditem=null also returns TRUE (which would indicate we need to ADD a new entry...) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: file size limit
Paul et al, At 18:59 -0400 8/31/02, qlarry wrote: here a file size limit in my sql What? I think that loosely should translate as Where is a file size limit in MySQL which I would then interpret as Is there a file size limit in MySQL. All MyISAM tables are stored on the local file system so it is dependant on the file system and operating system you are running. Or to put it another way, your MyISAM table (MySQL's default type) are stored as files, and it is your operating system that limits the file size and not MySQL. As for other types such as BDB and InnoDB I don't know the answer. I hope this helps. DSL -- Say you'll share with me one love, one lifetime Lead me, save me from my solitude. Say you'll want me with you, here beside you Anywhere you go let me go too... (Webber/Hart/Black) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
InnoDB: wild memory allocation size = server restarted
I am running version 3.23.51-log (built with -O3) on FreeBSD-5.0-CURRENT on Alpha. InnoDB is on raw disk. After a week of uptime it restarted by itself and the message below was logged. Looks like it was trying to allocate 4GB+0x1E bytes. Machine has 2GB of physical memory + 1GB swap. Database is small: around 1MB. And mysql memory usage was reasonable (150M). 100M was allocated for key_buffer. Could it be related to 64-bits pointer size on this architecture? Any ideas what could have caused the problem? Yuri. my.cnf: snip 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 snip -errorlog /usr/local/libexec/mysqld: ready for connections week passed 020831 11:57:41 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. InnoDB: Fatal error: cannot allocate 4294967528 bytes of InnoDB: memory with malloc! Total allocated memory InnoDB: by InnoDB 33699660 bytes. Operating system errno: 12 InnoDB: Cannot continue operation! InnoDB: Check if you should increase the swap file or InnoDB: ulimits of your operating system. InnoDB: On FreeBSD check you have compiled the OS with InnoDB: a big enough maximum process size. 020831 11:57:41 mysqld restarted 020831 11:57:43 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 2705349 InnoDB: Doing recovery: scanned up to log sequence number 0 2705349 InnoDB: Last MySQL binlog file position 0 535499, file name ./s2-bin.101 020831 11:57:43 InnoDB: Flushing modified pages from the buffer pool... 020831 11:57:43 InnoDB: Started - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: file size limit
At 5:19 +0200 9/1/02, David Lloyd wrote: Paul et al, At 18:59 -0400 8/31/02, qlarry wrote: here a file size limit in my sql What? I think that loosely should translate as Where is a file size limit in MySQL which I would then interpret as Is there a file size limit in MySQL. All MyISAM tables are stored on the local file system so it is dependant on the file system and operating system you are running. Or to put it another way, your MyISAM table (MySQL's default type) are stored as files, and it is your operating system that limits the file size and not MySQL. As for other types such as BDB and InnoDB I don't know the answer. ISAM: minimum of 4GB per file (MyISAM internal limit) or OS file size limit. MyISAM: same, except that by using AVE_ROW_LENGTH and MAX_ROWS you can bump the MyISAM internal limit to approx 8 terabytes. BDB: minimum of at least 2 TB (MyISAM internal limit) or OS file size limit. InnoDB: depends on size of InnoDB tablespace. By default, max tablespace size is 4 billion pages x 16KB per page. But all InnoDB tables compete for space inside this tablespace. I hope this helps. DSL -- Say you'll share with me one love, one lifetime Lead me, save me from my solitude. Say you'll want me with you, here beside you Anywhere you go let me go too... (Webber/Hart/Black) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: possibly off topic: any VB programmers out there?
Well I guess the first point to make is that you would not be so off topic in the MyODBC list. I personally stay away from the data set of controls. I stick to manually loading recordsets into boxes, and thus avoid problems such as the one you point out. To do what you are doing, I would manually compare the entry to the recordset and take action accordingly. Something else to consider is that the add button will likely be what the users will be looking for, and may not think to type in something manually when they do not find what they are looking for in the combo box (I have gone against the grain, and in an enterprise environment you can always train to make sure the user knows what to expect, but what about when you cannot train the user?) Ultimately, my advice would be to switch to a regular combo box and handle the checks against the record set yourself, but that is just me. If you choose that course, feel free to e-mail me and I will see if I can help you work it out. Mike Hillyer Dynamergy Software -Original Message- From: Tom Emerson [mailto:[EMAIL PROTECTED]] Sent: Saturday, August 31, 2002 7:47 PM To: mySQL (E-mail) (E-mail) Subject: possibly off topic: any VB programmers out there? I've got a strange problem using VB to connect to a mysql database via ODBC. The problem isn't with connecting, but rather with one particular control -- the datalist/combo control. In fact, the problem doesn't seem to have anything to do with databases directly, BUT I figured that there is sufficient VB talent on this list that someone has seen this and knows how to fix it. (indirectly, I'm not able to reliably detect if a row exists or not using this control) Background: the datacombo control will automatically load itself with values taken from a dataset -- this is really cool for lookup fields where you want to make it easy for the end user to select related data. Being a combo type item, it ALSO allows the user to type in a completely NEW value, and that's where things seem to go downhill. In particular, the control has a property/field called macthedwithlist which returns true if the user selects or types in a value actually in the list, and another property called selecteditem which returns a bookmark [record number] of the selected value. This bookmark can then be applied to the related dataset to retrieve the full record for display or editing. The problem I'm running into is that if you TYPE IN the value directly (i.e., without using the mouse to point-n-click or the arrow keys to scroll through the list), the bookmark contains a null value EVEN IF THE USER TYPES IN A MATCHING ENTRY. (and here, a null bookmark would imply that the entered value doesn't match anything) What I'm trying to accomplish is to combine two activities into one logical activity -- for example, inventory item maintenance. I want to build a form that allows editing of all the particulars for an inventory item (item code, description, qty, etc.) There are two (well, three) activities that can occur: a new item can be added, or an existing item can be modified (or deleted). The traditional way to do this would be to place an add button on the form to clear the form and allow an item to be defined, generating an annoying error if the user enters an existing code number. Likewise, you would place a find button that generates an equally annoying error if you DON'T type in the proper item code. What I want to do is combine these activities via the combo box -- if you select a existing item the form displays the data and allows for modifications. Likewise, if you type in a new value, the program implicitly adds a new (blank) record -- note that since I've determined from the key value entered whether to add or modify an entry, there is no need to display an annoying error. The part my program falls over on is that if you TYPE in an EXISTING item code, the two tests that you can perform to see if this is a new entry generate conflicting values: matchedwithlist will return TRUE (meaning we should MODIFY the entry), and selecteditem=null also returns TRUE (which would indicate we need to ADD a new entry...) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
FW: Mysql 3.23.52 fails compile on OS X 10.2
-- Forwarded Message From: John J. Rushford [EMAIL PROTECTED] Date: Sun, 01 Sep 2002 00:04:08 -0600 To: [EMAIL PROTECTED] Subject: Mysql 3.23.52 fails compile on OS X 10.2 Greetings, Downloaded mysql 3.23.52 from the mysql web site and ran into compile failures in the mysql client, the linker couldn't locate various curses functions. After troubleshooting this and adding -lncurses to the list of LIBS in the client/Makefile, the compile and installation completed sucessfully. I configured using: ./configure --prefix=/usr/local/mysql Following the configure, I changed line 186 from 'LIBS = -lz -lm' to 'LIBS = -lz -lm -lncurses' so that the compile would pass. Installation was sucessful and make test passed. I have it up and running now and can connect with a java jdbc client ok. Regards John J. Rushford [EMAIL PROTECTED] -- End of Forwarded Message - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
