Re: InnoDB create table error 150
Hi! It is a bug in the FOREIGN KEY syntax parser. It is confused by the column name e_foreigncurrency The bug appears if the string 'foreign' is succeeded by a non-space character in a CREATE TABLE statement. Workaround: change the column name to e_currencyforeign, for example. Fixed in 3.23.50. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB Richard R. Harms wrote in message ... The create table command included at the end of this message gives the following error: ERROR 1005: Can't create table './catalogmgr/macitm_vendordfrom.frm' (errno: 150) Creating it with type=myisam, and then doing an alter table and converting it to innodb works okay. It just cannot be initially created as an innodb table. The error occurs on both Red Hat Linux 6.2 and Mac OS X 10.1.2. MySQL was compiled on both systems with the --enable-raid flag. my.cnf settings are included below as well. =rh CREATE TABLE macitm_vendordfrom ( e_vendorno varchar(10) default NULL, e_apvendor varchar(20) default NULL, e_company char(2) default NULL, e_division char(2) default NULL, e_name varchar(30) default NULL, e_lastname varchar(16) default NULL, e_initial char(2) default NULL, e_firstname varchar(16) default NULL, e_title char(2) default NULL, e_ref1 varchar(30) default NULL, e_ref2 varchar(30) default NULL, e_street varchar(30) default NULL, e_city varchar(30) default NULL, e_state char(2) default NULL, e_zip varchar(10) default NULL, e_countrycode varchar(4) default NULL, e_dayphone varchar(16) default NULL, e_freightppcode char(2) default NULL, e_freightppbasis bigint(10) default NULL, e_freightpct int(5) default NULL, e_fobcity varchar(30) default NULL, e_foreigncurrency char(2) default NULL, e_termscode varchar(4) default NULL, e_termspct int(4) default NULL, e_termsdays int(5) default NULL, e_standarddays int(5) default NULL, e_faxno varchar(16) default NULL, e_miscdata40 varchar(40) default NULL, e_vendorcomments001 varchar(60) default NULL, e_vendorcomments002 varchar(60) default NULL, e_vendorcomments003 varchar(60) default NULL, e_vendorcomments004 varchar(60) default NULL, e_vendorcomments005 varchar(60) default NULL, e_vendorcomments006 varchar(60) default NULL, e_vendorcomments007 varchar(60) default NULL, e_vendorcomments008 varchar(60) default NULL, e_addldata varchar(20) default NULL, e_email varchar(48) default NULL ) TYPE=InnoDB; [mysqld] set-variable = delayed_queue_size=10 set-variable = sort_buffer=8M set-variable = join_buffer=4M set-variable = tmp_table_size=4M set-variable = max_sort_length=16384 set-variable = max_allowed_packet=1M set-variable = query_cache_size=2M set-variable = query_cache_startup_type=1 # innodb_data_home_dir = /usr/local/var/.ibdata #Data files must be able to #hold your data and indexes innodb_data_file_path = ibdata1:500M;ibdata2:500M;ibdata3:500M #Set buffer pool size to 50 - 80 % #of your computer's memory set-variable = innodb_buffer_pool_size=32M set-variable = innodb_additional_mem_pool_size=8M # innodb_log_group_home_dir = /usr/local/var/.iblogs #.._log_arch_dir must be the same #as .._log_group_home_dir innodb_log_arch_dir = /usr/local/var/.iblogs innodb_log_archive=0 set-variable = innodb_log_files_in_group=3 #Set the log file size to about #15 % of the buffer pool size set-variable = innodb_log_file_size=50M set-variable = innodb_log_buffer_size=8M #Set ..flush_log_at_trx_commit to #0 if you can afford losing #a few last transactions innodb_flush_log_at_trx_commit=1 set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
AND connected Selects on a n-to-m table.
Hi, I have 2 Tables one with the data (lets call the Table Data) and one with Category information (let's call it Category). I have a third Table (dat2cat) with FK_Data and FK_Category that i use to assign up to n categorys to each Dataset in Data. I now want to get a list of datasets with just on datafield with a Unique index on it (lets call it name) from Data that have a certain combination of Categorys (And connected). Normaly i would use Subquerys but since mySql dont support them i have tried following Query: select data.name from data, dat2cat where data.pk_data = dat2cat.fk_data and (dat2cat.fk_category=44 or dat2cat.fk_category = 18) having count(data.name) 1; ( In this example i used just two categorys (Key 44 and 18) when i use more i would put mor 'or' statements in and adjust the having clause) This works fine when there are Results but when there shouldn't be Results i get bacj the first dataset of the Query without the having clause. (That seems rather strange to me ;-) ) Do anyone know what is my error ord knows someone a better way to solve this task (i would like to avoid the usage of temporary tables) Thanks in Advance Simon mail2web - Check your email from the web at http://mail2web.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: AND connected Selects on a n-to-m table.
Oh sorry, in my posted version of the Query i forgot a Group by clause. the Query that i have used is: select data.name from data, dat2cat where data.pk_data = dat2cat.fk_data and (dat2cat.fk_category=44 or dat2cat.fk_category = 18) group by data.name having count(data.name) 1; Simon Klaiber mail2web - Check your email from the web at http://mail2web.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
Change column names
Hi there. Just recently I have started to investigate a possible future use of mySql at my company. As part of this investigation I have come across one seemingly trivial obstacle, but an obstacle very important for me. What I wonder is if there is no means of renaming a column in a sql select phrase in mySql? In, par example, Oracle this i simply done with SELECT group_id g, time t FROM tbl_Groupsn if the desired outcome is that the group_id column is presented as g. Thankful for any possible answer. ___ Mikaela Holmberg M Sc Systems Developer OSIX AB Lumavägen 6, SE-120 31 Stockholm Direkt: +46 8 50 600 667 Mobil: +46 70 597 06 67 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Strange install problem
Hi, after ./configure, make, make install of Version 4.0.1-alpha I executed the mysql_install_db script to finish the installation of mysql. The script says I should execute the commands $/mysql/bin/mysqladmin -u root password 'mypass' $/mysql/bin/mysqladmin -u root -h admin08-1 password 'mypass' The first command worked but when I try the second I get the message: #error: 'HOST 'XXX.XXX.XXX.XXX' is not allowed to connect to this MySQL server' Are there already set rights or what might be the problem? Thanks. Kind regards Jan Albrecht -- Jan AlbrechtSystem Consultant Bertelsmann mediaSystems NMI-DC UNIX/NT/Windows 2000 An der Autobahn 33311 Gütersloh Germany Phone: +49-5241-80-88404 mobile: +49-172-2978914 Fax:+49-5241-80-688404 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
update data from other table
Hi, How to update data in table with data from other table in single SQL command (without using loop)? Sommai, -- Please be informed that all e-mail which are addressing to thaithanakit.co.th will need to be changed to BTsecurities.com by March 1, 2002 Thank you. :-) -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 database question
Jason, Friday, February 15, 2002, 9:33:14 PM, you wrote: JGE what affects the rows in the host table of database mysql? is it when a JGE particular host logs in the server's mysql console? or is it when a user JGE browses a web file that launches a script to access a database? or both? Table 'host' in mysql db is used with table 'db' when you want to set several host for 'db' entry. You can also use table 'host' to indicate hosts that are not secure. Look at: http://www.mysql.com/doc/P/r/Privileges.html http://www.mysql.com/doc/R/e/Request_access.html JGE thanks JGE jembo -- For technical support contracts, goto https://order.mysql.com/ 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: update data from other table
Soory its not possible. Here a User Comment from the Commented MySqlDoc (Chapter UPDATE Systax) -- Comments: Michael Holopainen: I was looking for info on how-to UPDATE with data retrived from another table. aka. UPDATE with JOIN. I noticed many other people were asking the same question so I desided to write this comment. The answer is : You can't. Not until MySQL 4.1 that supports sub-selects. Then and only then you can use something like this: UPDATE t1 SET t1.col = (SELECT t2.col FROM t2 WHERE where clause) WHERE where clause; As far as I can tell not even in MySQL 4.1 can you use JOIN with UPDATE. - Original Message: - From: Sommai Fongnamthip [EMAIL PROTECTED] Date: Fri, 15 Feb 2002 16:37:51 +0700 To: [EMAIL PROTECTED] Subject: update data from other table Hi, How to update data in table with data from other table in single SQL command (without using loop)? Sommai, -- Please be informed that all e-mail which are addressing to thaithanakit.co.th will need to be changed to BTsecurities.com by March 1, 2002 Thank you. :-) -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php mail2web - Check your email from the web at http://mail2web.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: update data from other table
Sorry its not possible. Here a User Comment from the commented MySql Doc (Chapter UPDATE Systax) -- Comments: Michael Holopainen: I was looking for info on how-to UPDATE with data retrived from another table. aka. UPDATE with JOIN. I noticed many other people were asking the same question so I desided to write this comment. The answer is : You can't. Not until MySQL 4.1 that supports sub-selects. Then and only then you can use something like this: UPDATE t1 SET t1.col = (SELECT t2.col FROM t2 WHERE where clause) WHERE where clause; As far as I can tell not even in MySQL 4.1 can you use JOIN with UPDATE. - Original Message: - From: Sommai Fongnamthip [EMAIL PROTECTED] Date: Fri, 15 Feb 2002 16:37:51 +0700 To: [EMAIL PROTECTED] Subject: update data from other table Hi, How to update data in table with data from other table in single SQL command (without using loop)? Sommai, -- Please be informed that all e-mail which are addressing to thaithanakit.co.th will need to be changed to BTsecurities.com by March 1, 2002 Thank you. :-) -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php mail2web - Check your email from the web at http://mail2web.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: update data from other table
HI Hi, How to update data in table with data from other table in single SQL command (without using loop)? Sommai, insert into table1 select * from table2 Kittiphum Worachat,MT. www.hatyailab.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: Change column names
Mikaela Holmberg a écrit : Hi there. Just recently I have started to investigate a possible future use of mySql at my company. As part of this investigation I have come across one seemingly trivial obstacle, but an obstacle very important for me. What I wonder is if there is no means of renaming a column in a sql select phrase in mySql? In, par example, Oracle this i simply done with SELECT group_id g, time t FROM tbl_Groupsn if the desired outcome is that the group_id column is presented as g. Thankful for any possible answer. ___ Mikaela Holmberg M Sc Systems Developer OSIX AB Lumavägen 6, SE-120 31 Stockholm Direkt: +46 8 50 600 667 Mobil: +46 70 597 06 67 Hi, Have you looked at the manual ? (http://www.mysql.com/doc/S/E/SELECT.html) I think that you can do it with AS keyword: SELECT group_id AS g, time AS t FROM Or am I missing something ? Regards -- Joseph Bueno NetClub/Trader.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
Changing the darn names
Thanks for all the answers, you all seemed very surprised by the seemingly easy answer SELECT old_name as new_name FROM ... which made me feel rather at ease. I realized the problem wasn't with mySQL - for it certainly did work as it should. even my way - without the as. Problem was with darn darn Excel, which I have to get to work with mySQL. So - problem solved. Thanks guys and girls! Mikaela Holmberg RD Systems Developer OSIX AB, Lumaparksvägen 9, SE-120 31 Stockholm, Sweden Tel +46 (0)8 50 600 667, Fax +46 (0)8 50 600 601 Mob +46 (0)70 537 06 67, [EMAIL PROTECTED] http://www.osix.se The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: update data from other table
I want to update existing data not insert new data. sommai At 16:52 15/2/2002 +0700, Kittiphum Worachat wrote: HI Hi, How to update data in table with data from other table in single SQL command (without using loop)? Sommai, insert into table1 select * from table2 Kittiphum Worachat,MT. www.hatyailab.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 -- Please be informed that all e-mail which are addressing to thaithanakit.co.th will need to be changed to BTsecurities.com by March 1, 2002 Thank you. :-) -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: update data from other table
thank you very much. I have to used loop for this solution, did I? sommai At 04:53 15/2/2002 -0500, [EMAIL PROTECTED] wrote: Sorry its not possible. Here a User Comment from the commented MySql Doc (Chapter UPDATE Systax) -- Comments: Michael Holopainen: I was looking for info on how-to UPDATE with data retrived from another table. aka. UPDATE with JOIN. I noticed many other people were asking the same question so I desided to write this comment. The answer is : You can't. Not until MySQL 4.1 that supports sub-selects. Then and only then you can use something like this: UPDATE t1 SET t1.col = (SELECT t2.col FROM t2 WHERE where clause) WHERE where clause; As far as I can tell not even in MySQL 4.1 can you use JOIN with UPDATE. - Original Message: - From: Sommai Fongnamthip [EMAIL PROTECTED] Date: Fri, 15 Feb 2002 16:37:51 +0700 To: [EMAIL PROTECTED] Subject: update data from other table Hi, How to update data in table with data from other table in single SQL command (without using loop)? Sommai, -- Please be informed that all e-mail which are addressing to thaithanakit.co.th will need to be changed to BTsecurities.com by March 1, 2002 Thank you. :-) -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php mail2web - Check your email from the web at http://mail2web.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 -- Please be informed that all e-mail which are addressing to thaithanakit.co.th will need to be changed to BTsecurities.com by March 1, 2002 Thank you. :-) -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: admin privilege problems
System, Friday, February 15, 2002, 5:38:51 AM, you wrote: jr i made the mistake of changing my root password manually in the mysql jr database. after doing so, i 'flushed privileges'. jr now i'm unable to log on using the root. i've tried to log on using the new jr password a number of times, but i'm always denied access. strangely enough, jr other users (that have passwords) can log on successfully without providing jr a password. does anybody have any recommendations for logging on as the root jr user ... and fixing this privileges problem? Look at: http://www.mysql.com/doc/R/e/Resetting_permissions.html It will help you. SAakaTRotP What if you run into: SAakaTRotP Script started on Thu Feb 14 20:35:44 2002 SAakaTRotP doctor.nl2k.ab.ca//var$ mysqladmin -h localhost -u root password 'Nathan84' SAakaTRotP mysqladmin: unable to change password; error: 'You must have privileges to update tables in the mysql database to be able to change passwords for others' SAakaTRotP doctor.nl2k.ab.ca//var$ exuit it SAakaTRotP exit Did you run mysql at first time? The recomended way to change password and privileges is to use GRANT statement. SAakaTRotP Script done on Thu Feb 14 20:35:56 2002 -- For technical support contracts, goto https://order.mysql.com/ 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: Suspected Bug
Yeah, for me also find error. -- mysql create table X1(name varchar(10)); Query OK, 0 rows affected (0.00 sec) mysql insert into X1 values(5); Query OK, 1 row affected (0.01 sec) mysql RENAME TABLE X1 TO X2; ERROR 1064: You have an error in your SQL syntax near 'RENAME TABLE X1 TO X2' at line 1 mysql Regards, ~ SubbaReddy .M Sr. Programmer, Frontlinesoft, Hyderabad http://www.frontlinesoft.com ICQ: 56093095 - Original Message - From: Fred Lovine [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, February 15, 2002 12:23 PM Subject: Suspected Bug MySQL is awesome, but I think I found a bug. The following script: CREATE TABLE X1 (x smallint); insert into X1 values(5); RENAME TABLE X1 TO X2; is producing the following error: 7 - Error on rename '.\db\X1.MY1' to '.\db\X2.MYI' (Errcode: 13) The problem seems to be caused by using uppercase table names. The problem does not happen when the table names are all lowercase. MySQL version: 3.23.47-nt Running on Windows 2000 Pro Feel free to contact me if there are any questions. Server Variables Variable CLW Laptop back_log 50 basedir C:\CLW\MySQL\ binlog_cache_size 32768 character_set latin1 character_sets latin1 big5 czech euc_kr gb2312 gbk sjis tis620 ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5 concurrent_insert ON connect_timeout 5 datadir C:\CLW\MySQL\data\ delay_key_write ON delayed_insert_limit 100 delayed_insert_timeout 300 delayed_queue_size 1000 flush OFF flush_time 1800 have_bdb NO have_gemini NO have_innodb NO have_isam YES have_raid NO have_openssl NO init_file interactive_timeout 28800 join_buffer_size 131072 key_buffer_size 8384512 language C:\CLW\MySQL\share\english\ large_files_support ON log OFF log_update OFF log_bin OFF log_slave_updates OFF log_long_queries OFF long_query_time 10 low_priority_updates OFF lower_case_table_names 1 max_allowed_packet 130048 max_binlog_cache_size 4294967295 max_binlog_size 1073741824 max_connections 100 max_connect_errors 10 max_delayed_threads 20 max_heap_table_size 16777216 max_join_size 4294967295 max_sort_length 1024 max_user_connections 0 max_tmp_tables 32 max_write_lock_count 4294967295 myisam_max_extra_sort_file_size 256 myisam_max_sort_file_size 2047 myisam_recover_options 0 myisam_sort_buffer_size 8388608 net_buffer_length 16384 net_read_timeout 30 net_retry_count 10 net_write_timeout 60 open_files_limit 0 pid_file C:\CLW\MySQL\data\laptop.pid port 3306 protocol_version 10 record_buffer 131072 record_rnd_buffer 131072 query_buffer_size 0 safe_show_database OFF server_id 0 slave_net_timeout 3600 skip_locking ON skip_networking OFF skip_show_database OFF slow_launch_time 2 socket MySQL sort_buffer 2097144 sql_mode 0 table_cache 64 table_type MYISAM thread_cache_size 0 thread_stack 65536 transaction_isolation READ-COMMITTED timezone Eastern Standard Time tmp_table_size 33554432 tmpdir C:\WINNT\TEMP\ version 3.23.47-nt wait_timeout 28800 Fred Lovine [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: Suspected Bug
I am afraid it's not a bug, rather a syntax error. please follow the syntax to rename the table: mysql alter table X1 rename as X2; Regards, ~ SubbaReddy .M - Original Message - From: SubbaReddy M [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, February 15, 2002 3:46 PM Subject: Re: Suspected Bug Yeah, for me also find error. -- -- -- mysql create table X1(name varchar(10)); Query OK, 0 rows affected (0.00 sec) mysql insert into X1 values(5); Query OK, 1 row affected (0.01 sec) mysql RENAME TABLE X1 TO X2; ERROR 1064: You have an error in your SQL syntax near 'RENAME TABLE X1 TO X2' at line 1 mysql -- -- Regards, ~ SubbaReddy .M Sr. Programmer, Frontlinesoft, Hyderabad http://www.frontlinesoft.com ICQ: 56093095 - Original Message - From: Fred Lovine [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, February 15, 2002 12:23 PM Subject: Suspected Bug MySQL is awesome, but I think I found a bug. The following script: CREATE TABLE X1 (x smallint); insert into X1 values(5); RENAME TABLE X1 TO X2; is producing the following error: 7 - Error on rename '.\db\X1.MY1' to '.\db\X2.MYI' (Errcode: 13) The problem seems to be caused by using uppercase table names. The problem does not happen when the table names are all lowercase. MySQL version: 3.23.47-nt Running on Windows 2000 Pro Feel free to contact me if there are any questions. Server Variables Variable CLW Laptop back_log 50 basedir C:\CLW\MySQL\ binlog_cache_size 32768 character_set latin1 character_sets latin1 big5 czech euc_kr gb2312 gbk sjis tis620 ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5 concurrent_insert ON connect_timeout 5 datadir C:\CLW\MySQL\data\ delay_key_write ON delayed_insert_limit 100 delayed_insert_timeout 300 delayed_queue_size 1000 flush OFF flush_time 1800 have_bdb NO have_gemini NO have_innodb NO have_isam YES have_raid NO have_openssl NO init_file interactive_timeout 28800 join_buffer_size 131072 key_buffer_size 8384512 language C:\CLW\MySQL\share\english\ large_files_support ON log OFF log_update OFF log_bin OFF log_slave_updates OFF log_long_queries OFF long_query_time 10 low_priority_updates OFF lower_case_table_names 1 max_allowed_packet 130048 max_binlog_cache_size 4294967295 max_binlog_size 1073741824 max_connections 100 max_connect_errors 10 max_delayed_threads 20 max_heap_table_size 16777216 max_join_size 4294967295 max_sort_length 1024 max_user_connections 0 max_tmp_tables 32 max_write_lock_count 4294967295 myisam_max_extra_sort_file_size 256 myisam_max_sort_file_size 2047 myisam_recover_options 0 myisam_sort_buffer_size 8388608 net_buffer_length 16384 net_read_timeout 30 net_retry_count 10 net_write_timeout 60 open_files_limit 0 pid_file C:\CLW\MySQL\data\laptop.pid port 3306 protocol_version 10 record_buffer 131072 record_rnd_buffer 131072 query_buffer_size 0 safe_show_database OFF server_id 0 slave_net_timeout 3600 skip_locking ON skip_networking OFF skip_show_database OFF slow_launch_time 2 socket MySQL sort_buffer 2097144 sql_mode 0 table_cache 64 table_type MYISAM thread_cache_size 0 thread_stack 65536 transaction_isolation READ-COMMITTED timezone Eastern Standard Time tmp_table_size 33554432 tmpdir C:\WINNT\TEMP\ version 3.23.47-nt wait_timeout 28800 Fred Lovine [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
Replication question
Hi Currently, I maintain two mysql server, hosted by separate ISPs, and keep them synchronised using standard MySQL replication. Server A is master+slave to server B, and likewise server B is master +slave to server A. This allows both servers to receive inserts/updates/deletes and replicate them accordingly. This has, and continues to work well. The problem I have is simple, it has been decided to have a third web site, with an associated database. The replication model I have implemented only works with TWO servers. The only solution to this is to add to one servers my.cnf the option LOG-SLAVE-UPDATES and enable read-only replication to this new server. If I do add this option, and one server logs all its 'native' transactions + 'replicated' transactions, will this confuse the second server ? Will the second server try and apply the remote native transaactions only, or will I get into a loop of a machine applying its own transactions back on to itself ? Thanx Simon -- NameSimon WindsorTel 0(44) 454 617 689 Email [EMAIL PROTECTED] Fax 0(44) 454 610 709 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 skips a match
Hi! On a site I'm developing I need to conduct boolean searches. I use a piece of code I found on: http://www.evolt.org/article/comment/18/15665/http://www.evolt.org/art icle/comment/18/15665/ and I've got to say it works really well. The problem is I cannot search for one specific word because, even though the word exists on several records, MySQL never returns any rows. The word I can't look for is portaria. Any other word works just fine. I have tried every word I could think of and it works... except for that one: portaria. Here is the syntax for the query: SELECT *, match (titulo,estado,sumario,categoria,tipo,pachave) against (' portaria ') as relevance FROM dgf_net.dgf_lex WHERE= match (titulo,estado,sumario,categoria,tipo,pachave) against= ('portaria')0 HAVING relevance0 ORDER BY relevance DESC And here is a view of the table: Field Type Attributes Null Default Extra id int(11) Noauto_increment estado varchar(255) Yes NULL titulo varchar(255) Yes NULL sumario text Yes NULL url text Yes NULL autor varchar(255) Yes NULL insdata datetime Yes NULL dipdata date Yes NULL categoria varchar(255) Yes NULL tipo varchar(255) Yes NULL pachave varchar(255) Yes NULL Indexes : Keyname Type Cardinality Field PRIMARY PRIMARY 81 id id UNIQUE 81 id titulo FULLTEXT None titulo estado sumario 1 categoria tipo pachave I'm puzzled! Why is MySQL picky about this specific word? MySQL is 3.23.36 and PHP 4.0.4pl1 Any help is appreciated! :-) -- Joao Verde, [EMAIL PROTECTED] on 02/15/2002 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: ....from ms access to mysql
Someone in the list posted the following links. I went with the second one and it worked. NOBBY http://www.convert-in.com/acc2sqlp.htm http://ultradev.buzzinet.co.uk/mysql/tutorials/converting_data/index.asp http://www.winmysql.com/ - Original Message - From: Fabio Amura [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, February 14, 2002 1:33 PM Subject: from ms access to mysql Hi, i have to migrate from ms access to my sql, and i dont know how can i do... do your know at easy metod for this migration, and can you give me indication or link i'm not an espert... thanks fabio -Messaggio originale- Da: Jochen Kaechelin [mailto:[EMAIL PROTECTED]] Inviato: giovedì 14 febbraio 2002 7.52 A: [EMAIL PROTECTED] Oggetto: Updating SuSE 7.3 Can I use the RedHat-rpms on mysql.com to update a SuSE 7.3 prof or do I need to compile it from source with some parameters? I run 3.23.44 max and I want to update to 3.23.48 max -- Jochen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Need help about mysql order and index....
Okay is not a reply for myself :) is only for add a question... :) I read that mysql 4 will fix this, but mysql 4 is stable? I mean i'm on production, i'm not selling mysql :) I mean I have a big projet in test using mysql.. so if it crash it will be very bad for me... someone had test mysql 4? stable or not? :) Jean-Francois Dionne - Original Message - From: Jean-Francois Dionne [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, February 14, 2002 7:25 PM Subject: Need help about mysql order and index Hi there, I hope someone will can help me... First, sorry for bad english :) i'm french First all I have those index in my table +---+---+-++ --+-++--++ -- + | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Comment | +---+---+-++ --+-++--++ -- + | Stats | 0 | PRIMARY |1| ID | A | 4568748 | NULL | NULL| | | Stats | 1 | Port_ID |1| Port_ID | A | 1 | NULL | NULL| | | Stats | 1 | Timestamp |1| Timestamp | A | 49126 | NULL | NULL| | +---+---+-++ --+-++--++ -- + You have to know I have 4 500 000 in my db Okay I have this query: select Timestamp from Stats use index (Timestamp) where Timestamp = '2002-01-01' and Timestamp '2002-02-01' order by Timestamp limit 1; this one is jsut doing fine.. it take 0.00 sec to do it... but select Timestamp from Stats use index (Timestamp) where Timestamp = '2002-01-01' and Timestamp '2002-02-01' order by Timestamp desc limit 1; this one take sometime 10 sec to do I understand is the desc the prob.. because my index is in asc (collation=A) my question is... is there a way for maiking a index in desc? or maybe something else? Jean-Francois Dionne Yard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Suspected Bug
* Egor Egorov FL = Fred Lovine FL CREATE TABLE X1 (x smallint); FL insert into X1 values(5); FL RENAME TABLE X1 TO X2; FL is producing the following error: FL 7 - Error on rename '.\db\X1.MY1' to '.\db\X2.MYI' (Errcode: 13) FL The problem seems to be caused by using uppercase table FL names. The problem does not happen when the table names FL are all lowercase. $ perror 13 Error code 13: Permission denied When you rename table, you also rename files that are appropriate to this table. You don't have file permission to rename files in mysql data dir. Do you mean this is the desired behaviour? Also, this does not explain why it only happens when the name is uppercase. -- Roger 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: re-ordering rows
Brent, What Rick said is absolutely correct and you probably are obsessing about something that doesn't matter. But I would venture you are using an auto-number field as the primary key when you could easily change it to a function something similar to: set ID = MAX(ID) + 1. Keith, I agree with what everyone is saying. But for display purposes, it would be nice if MySQL could display a row# for the result set. This could be used to display a line# at the start of each row, like Select count, col1, col2 from table1 where ... and the running count would show Count Col1 Col2 1 ABC DEF 2GHI KLM It would act as sort of a line item# for display purposes only. As everyone mentioned, it doesn't make any sense to store this number in the table. But it might come in handy for display purposes. Few people use native-MySQL to present production/user results. Most interface to MySQL from some other tool/programming language. Storing the data and retrieving it according to use is the job of MySQL. Isn't using the output in some way and/or making it look 'pretty' is a job for that tool? 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
Re: Suspected Bug
Once tables are CREATEd, the name is listed in SHOW tables using lower case characters, regardless of the case used in the CREATE command. Using upper case table names in RENAME results in the error. Workaround: Using lower case equivalent table names works, regardless of the case used in the CREATE command. Windows does not differentiate between X1 and x1 as table/filenames. *nix does. Perhaps CREATE has been Window-ised but RENAME has not (yet). Regards, =dn WinNT 4.0 SP6a, MySQL vn 3.23.40-nt - Original Message - From: SubbaReddy M [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: 15 February 2002 10:16 Subject: Re: Suspected Bug Yeah, for me also find error. -- mysql create table X1(name varchar(10)); Query OK, 0 rows affected (0.00 sec) mysql insert into X1 values(5); Query OK, 1 row affected (0.01 sec) mysql RENAME TABLE X1 TO X2; ERROR 1064: You have an error in your SQL syntax near 'RENAME TABLE X1 TO X2' at line 1 mysql Regards, ~ SubbaReddy .M Sr. Programmer, Frontlinesoft, Hyderabad http://www.frontlinesoft.com ICQ: 56093095 - Original Message - From: Fred Lovine [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, February 15, 2002 12:23 PM Subject: Suspected Bug MySQL is awesome, but I think I found a bug. The following script: CREATE TABLE X1 (x smallint); insert into X1 values(5); RENAME TABLE X1 TO X2; is producing the following error: 7 - Error on rename '.\db\X1.MY1' to '.\db\X2.MYI' (Errcode: 13) The problem seems to be caused by using uppercase table names. The problem does not happen when the table names are all lowercase. MySQL version: 3.23.47-nt Running on Windows 2000 Pro Feel free to contact me if there are any questions. Server Variables Variable CLW Laptop back_log 50 basedir C:\CLW\MySQL\ binlog_cache_size 32768 character_set latin1 character_sets latin1 big5 czech euc_kr gb2312 gbk sjis tis620 ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5 concurrent_insert ON connect_timeout 5 datadir C:\CLW\MySQL\data\ delay_key_write ON delayed_insert_limit 100 delayed_insert_timeout 300 delayed_queue_size 1000 flush OFF flush_time 1800 have_bdb NO have_gemini NO have_innodb NO have_isam YES have_raid NO have_openssl NO init_file interactive_timeout 28800 join_buffer_size 131072 key_buffer_size 8384512 language C:\CLW\MySQL\share\english\ large_files_support ON log OFF log_update OFF log_bin OFF log_slave_updates OFF log_long_queries OFF long_query_time 10 low_priority_updates OFF lower_case_table_names 1 max_allowed_packet 130048 max_binlog_cache_size 4294967295 max_binlog_size 1073741824 max_connections 100 max_connect_errors 10 max_delayed_threads 20 max_heap_table_size 16777216 max_join_size 4294967295 max_sort_length 1024 max_user_connections 0 max_tmp_tables 32 max_write_lock_count 4294967295 myisam_max_extra_sort_file_size 256 myisam_max_sort_file_size 2047 myisam_recover_options 0 myisam_sort_buffer_size 8388608 net_buffer_length 16384 net_read_timeout 30 net_retry_count 10 net_write_timeout 60 open_files_limit 0 pid_file C:\CLW\MySQL\data\laptop.pid port 3306 protocol_version 10 record_buffer 131072 record_rnd_buffer 131072 query_buffer_size 0 safe_show_database OFF server_id 0 slave_net_timeout 3600 skip_locking ON skip_networking OFF skip_show_database OFF slow_launch_time 2 socket MySQL sort_buffer 2097144 sql_mode 0 table_cache 64 table_type MYISAM thread_cache_size 0 thread_stack 65536 transaction_isolation READ-COMMITTED timezone Eastern Standard Time tmp_table_size 33554432 tmpdir C:\WINNT\TEMP\ version 3.23.47-nt wait_timeout 28800 Fred Lovine [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: Suspected Bug
SubbaReddy M I am afraid it's not a bug, rather a syntax error. please follow the syntax to rename the table: mysql alter table X1 rename as X2; Why do you say this? Manual entry: 6.5.5 RENAME TABLE Syntax RENAME TABLE tbl_name TO new_table_name[, tbl_name2 TO new_table_name2,...] ... RENAME TABLE was added in MySQL 3.23.23. 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
Re: Suspected Bug
Egor, Yours/this arrived in my InBox whilst I was addressing the original msg - please see my other reply/ies. Error still occurs when running as Administrator on WinNT and root under MySQL - definitely no access/permission issues. Lower case works (please see earlier reply). If I/my NT PC can be of assistance, please don't hesitate to request further clarification/experimentation. Regards, =dn WinNT 4.0 SP6a, PHP vn 4.0.6, Apache vn 1.3.20WinNT, MySQL vn 3.23.40-nt - Original Message - From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: 15 February 2002 11:00 Subject: Suspected Bug Fred, Friday, February 15, 2002, 8:53:17 AM, you wrote: FL MySQL is awesome, but I think I found a bug. FL The following script: FL CREATE TABLE X1 (x smallint); FL insert into X1 values(5); FL RENAME TABLE X1 TO X2; FL is producing the following error: FL 7 - Error on rename '.\db\X1.MY1' to '.\db\X2.MYI' (Errcode: 13) FL The problem seems to be caused by using uppercase table names. The problem FL does not happen when the table names are all lowercase. $ perror 13 Error code 13: Permission denied When you rename table, you also rename files that are appropriate to this table. You don't have file permission to rename files in mysql data dir. FL MySQL version: 3.23.47-nt FL Running on Windows 2000 Pro FL Feel free to contact me if there are any questions. -- For technical support contracts, goto https://order.mysql.com/ 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: small little 'bug' in newest source version
Kedryna, Bartosz writes: In mysqldump.c there is // in 2 places, older compilers don't like it, changing to /* */ fixes the problem. Bart Kedryna Software Engineer Online Support [EMAIL PROTECTED] (215) 386 0100 x1470 ISI 3501 Market Street Philadelphia, PA 19104 Thank you, this has been duly noted and already fixed for the future version. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Suspected Bug
Hi, this has to be a bug. It seems on windows RENAME TABLE old TO new only works for uppercase table names _after_ an ALTER TABLE old RENAME AS new _or_ if you first rename the table using lower case letters: mysql create table U1 (id int); Query OK, 0 rows affected (0.04 sec) mysql insert into U1 values (1); Query OK, 1 row affected (0.01 sec) mysql rename table U1 to U2; ERROR 7: Error on rename of '.\test\u1.MYI' to '.\test\u2.MYI' (Errcode: 13) mysql alter table U1 rename as U2; Query OK, 0 rows affected (0.01 sec) mysql rename table U2 to U1; Query OK, 0 rows affected (0.00 sec) mysql rename table U1 to U2; Query OK, 0 rows affected (0.01 sec) I think there is some confusion within the mysql server because windows has case insensitive file names. The table is created with lowercase letters on the OS level: mysql create table W1 (id int); Query OK, 0 rows affected (0.05 sec) mysql insert into W1 values (1); Query OK, 1 row affected (0.00 sec) mysql show tables like W%; Empty set (0.01 sec) mysql show tables like w%; +-+ | Tables_in_test (w%) | +-+ | w1 | +-+ 1 rows in set (0.00 sec) C:\mysql\data\testdir w1* Volume in drive C has no label. Volume Serial Number is 28E6-EF3E Directory of C:\mysql\data\test 15.02.2002 13:028 550 w1.frm 15.02.2002 13:035 w1.MYD 15.02.2002 13:021 024 w1.MYI 3 File(s) 9 579 bytes 0 Dir(s) 573 779 968 bytes free mysql rename table W1 to W2; ERROR 7: Error on rename of '.\test\w1.MYI' to '.\test\w2.MYI' (Errcode: 13) mysql rename table w1 to W2; Query OK, 0 rows affected (0.01 sec) mysql rename table W2 to W1; Query OK, 0 rows affected (0.00 sec) mysql rename table W1 to W2; Query OK, 0 rows affected (0.01 sec) Note that the error message has the table name in lower case, so it seems mysql 'knows' about the OS case insensitivity, but for some reason it fails on the rename if the user used upper case letters on the RENAME _and_ on the CREATE, _and_ this is done within the same session. Creating the table, exiting the mysql console, re-entering the console and then do the rename works just fine. -- Roger 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: Suspected Bug
Roger, Friday, February 15, 2002, 1:32:13 PM, you wrote: RB * Egor Egorov FL = Fred Lovine FL CREATE TABLE X1 (x smallint); FL insert into X1 values(5); FL RENAME TABLE X1 TO X2; FL is producing the following error: FL 7 - Error on rename '.\db\X1.MY1' to '.\db\X2.MYI' (Errcode: 13) FL The problem seems to be caused by using uppercase table FL names. The problem does not happen when the table names FL are all lowercase. $ perror 13 Error code 13: Permission denied When you rename table, you also rename files that are appropriate to this table. You don't have file permission to rename files in mysql data dir. RB Do you mean this is the desired behaviour? RB Also, this does not explain why it only happens when the name is uppercase. I have tested RENAME TABLE on RedHat with uppercase table name and it works fine. On Windows 2000 it works when i rename table from lowercase table name to uppercase table name but not otherwise. -- For technical support contracts, goto https://order.mysql.com/ 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: MySQL skips a match
* Joao Verde The problem is I cannot search for one specific word because, even though the word exists on several records, MySQL never returns any rows. The word I can't look for is portaria. Any other word works just fine. I have tried every word I could think of and it works... except for that one: portaria. Is this word very common in the table? Are you using IN BOOLEAN MODE? If more than 50% of the rows contains this word, it is ignored in a fulltext search unless IN BOOLEAN MODE is used. You can also disable the 50% treshold by recompiling the server: URL: http://www.mysql.com/doc/F/u/Fulltext_Fine-tuning.html -- Roger 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: mySQL and Firewall
Hi Brumpton, From the webserver, try to connect to port 3306 with telnet Example: telnet 10.0.0.2 3306 You should see someting like: 3.23.47♥hAJ3\Y+e☻ This means that the right ports are open on the firewall to connect to Mysql. -Original Message- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]] Sent: February 14, 2002 9:36 AM To: [EMAIL PROTECTED] Subject: mySQL and Firewall Brumpton, Thursday, February 14, 2002, 10:47:14 AM, you wrote: BR I am having a problem accessing my SQL from our webserver. Between the BR two is firewall. All the ports between the SQL server and firewall are BR currently blocked. BR except port 3306 which is open. BR However, my I can't connect to the mySQL server. Is there anything I BR can do to test or what other ports do I need open? Are you sure that port 3306 is not blocked? Is it really the 3306 port that MySQL is listening to? Please, check your permissions to connect to the MySQL server. BR Richard -- For technical support contracts, goto https://order.mysql.com/ 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Dropped database
Hello mysql, I dropped an entire database but I have the frm, myd and myi files in a backup. What are the complete steps to restoring this database? Thank you for the help. -- Best regards, Paul 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
A sum of a few columns in where clause?
Hi, I've got query like this: select count(ID) from TABLE where (TABLE.A + TABLE.B + TABLE.C + TABLE.D) 0 A,B,C,D are decimal values. There are over 1 records where A is greater than 0, about 1000 where B is greater than 0, about 500 where C is greater than 0, and about 300 where D is greater 0. I want to get a value of at least 1 of course. But I get a very small value, near 50. The problem is, I think, with NULL columns. Often B,C and D don't have decimal value, but NULL. I thought, that this should be counted like zero. Am I wrong ? -- ./ premax ./ [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: A sum of a few columns in where clause?
* Przemyslaw Popielarski I've got query like this: select count(ID) from TABLE where (TABLE.A + TABLE.B + TABLE.C + TABLE.D) 0 A,B,C,D are decimal values. There are over 1 records where A is greater than 0, about 1000 where B is greater than 0, about 500 where C is greater than 0, and about 300 where D is greater 0. I want to get a value of at least 1 of course. But I get a very small value, near 50. The problem is, I think, with NULL columns. Often B,C and D don't have decimal value, but NULL. I thought, that this should be counted like zero. Am I wrong ? NULL is not the same as zero. If any of the field values are NULL, the result of the expression is NULL. -- Roger 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: Dropped database
Just copy the backup files into the database dir and the database should be back. Lars At 08:22 AM 2/15/2002 -0500, Paul wrote: Hello mysql, I dropped an entire database but I have the frm, myd and myi files in a backup. What are the complete steps to restoring this database? Thank you for the help. -- Best regards, Paul 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 from localhost vs. remote
Hi mysql list members, We use the following statements to setup users and rigts for a mysql server which is accessible locally and via internet: INSERT INTO mysql.user VALUES ('%','xyz00',PASSWORD('...'), 'N','N','N','N','N','N','N','N','N','N','N','N','N','N'); INSERT INTO mysql.db VALUES ('%','xyz00_%','xyz00','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y'); The server runs on 66.70.34.150:3307. We can connect via socket locally and via Host:Port remote: remote-system mysql -h 66.70.34.150 -P 3307 -u xyz00 -p = works local-system mysql -S /var/run/mysql-ext/mysql.sock -u yxz00 -p = works But we can NOT connect locally by host:port: local-system mysql -h 66.70.34.150 -O 3307 -u xyz00 -p = ERROR 1045: Access denied for user: 'xyz00@localhost' (Using password: YES) On a mysqld which is accessible only locally the both INSERT statements above would have localhost instead of %. Why does localhost not qualify for %? Do we have to double the entries, having separate ones for localhost? It does not make sense, does it? Thanks Michael -- Hostsharing eG / c/o Michael Hönnig / Boytinstr. 10 / D-22143 Hamburg phone:+49/40/67581419 / mobile:+49/177/3787491 / fax:++49/40/67581426 http://www.hostsharing.net --- Webhosting Spielregeln selbst gemacht - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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[2]: Dropped database
Friday, February 15, 2002, 2:23:52 AM, Lars Heidieker wrote: Just copy the backup files into the database dir and the database should be back. Are you sure that it's not need to CREATE it first ? At 08:22 AM 2/15/2002 -0500, Paul wrote: Hello mysql, I dropped an entire database but I have the frm, myd and myi files in a backup. What are the complete steps to restoring this database? Thank you for the help. -- Best regards, Paul 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: A sum of a few columns in where clause?
I've got query like this: select count(ID) from TABLE where (TABLE.A + TABLE.B + TABLE.C + TABLE.D) 0 A,B,C,D are decimal values. The problem is, I think, with NULL columns. Often B,C and D don't have decimal value, but NULL. I thought, that this should be counted like zero. Am I wrong ? RB NULL is not the same as zero. RB If any of the field values are NULL, the result of the expression is RB NULL. Hey guys Is this so hard to help people instead of killing them ? Use IFNULL(null_field, 0) And your query will be like: select count(ID) from TABLE where (IFNULL(TABLE.A, 0) + IFNULL(TABLE.B, 0) + IFNULL(TABLE.C, 0) + IFNULL(TABLE.D,0)) 0 And I advice you - RTFM. --- Yours sincerely, Ivan Latysh. [EMAIL PROTECTED] http://ivan.yourmail.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 from localhost vs. remote
Michael Hoennig [EMAIL PROTECTED] wrote: Hi mysql list members, We use the following statements to setup users and rigts for a mysql server which is accessible locally and via internet: INSERT INTO mysql.user VALUES ('%','xyz00',PASSWORD('...'), 'N','N','N','N','N','N','N','N','N','N','N','N','N','N'); INSERT INTO mysql.db VALUES ('%','xyz00_%','xyz00','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y'); The server runs on 66.70.34.150:3307. We can connect via socket locally and via Host:Port remote: remote-system mysql -h 66.70.34.150 -P 3307 -u xyz00 -p = works local-system mysql -S /var/run/mysql-ext/mysql.sock -u yxz00 -p = works But we can NOT connect locally by host:port: local-system mysql -h 66.70.34.150 -O 3307 -u xyz00 -p = ERROR 1045: Access denied for user: 'xyz00@localhost' (Using password: YES) On a mysqld which is accessible only locally the both INSERT statements above would have localhost instead of %. Why does localhost not qualify for %? Probably because you already have entry for 'localhost','%' or something to that effect. -- Dimitry - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 from localhost vs. remote
Hi Dimitry, But we can NOT connect locally by host:port: local-system mysql -h 66.70.34.150 -O 3307 -u xyz00 -p = ERROR 1045: Access denied for user: 'xyz00@localhost' (Using password: YES) On a mysqld which is accessible only locally the both INSERT statements above would have localhost instead of %. Why does localhost not qualify for %? Probably because you already have entry for 'localhost','%' or something to that effect. nope, there is not such an entry. But IF we add it, we can login. This just means that we have to insert two entries (% and localhost) each. It looks clumsy to me. Michael -- Hostsharing eG / c/o Michael Hönnig / Boytinstr. 10 / D-22143 Hamburg phone:+49/40/67581419 / mobile:+49/177/3787491 / fax:++49/40/67581426 http://www.hostsharing.net --- Webhosting Spielregeln selbst gemacht - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 installing MySQL on FreeBSD 4.5
Description: When trying to install MySQLi 3.23.47 and 3.23.48 on FreeBSD 4.5, We get the following errors during the mysql_install_db. /usr/local/bin/mysql_install_db Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables Fatal error 'Can't create gc thread' at line ? in file /usr/src/lib/libc_r/uthread/uthread_create.c (errno = ?) Abort trap - core dumped Installation of grant tables failed! We've tried this on multiple hosts running 4.5, and received the same problem. On a machine running 4.4, installation works fine. How-To-Repeat: Get a machine with a new install (or cvsup'd install) of FreeBSD 4.5. Try installing from ports. Submitter-Id: submitter ID Originator:Darrin Walton MySQL support: [none] Synopsis: Problems installing MySQL on FreeBSD 4.5 Severity: Priority: Category: mysql Class: Release: mysql-3.23.47 (FreeBSD port: mysql-server-3.23.47) Environment: System: FreeBSD distrust.routing.org 4.5-RC FreeBSD 4.5-RC #3: Fri Jan 18 16:37:48 EST 2002 [EMAIL PROTECTED]:/usr/src/sys/compile/DISTRUST 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='cc' CFLAGS='-O2 -pipe -march=pentiumpro' CXX='cc' CXXFLAGS='-O2 -pipe -march=pentiumpro -felide-constructors -fno-rtti -fno-exceptions' LDFLAGS='' LIBC: -r--r--r-- 1 root wheel 1223438 Jan 16 02:12 /usr/lib/libc.a lrwxr-xr-x 1 root wheel 9 Jan 16 02:12 /usr/lib/libc.so - libc.so.4 -r--r--r-- 1 root wheel 595712 Jan 16 02:12 /usr/lib/libc.so.4 Configure command: ./configure --localstatedir=/var/db/mysql --without-perl --without-debug --without-readline --without-bench --with-mit-threads=no --with-libwrap --with-low-memory '--with-comment=FreeBSD port: mysql-server-3.23.47' --enable-assembler --with-berkeley-db --with-innodb --prefix=/usr/local i386--freebsd4.5 Perl: This is perl, version 5.005_03 built for i386-freebsd - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Suspected Bug
The RENAME syntax is correct, please see the following documentation: http://www.mysql.com/doc/R/E/RENAME_TABLE.html -Original Message- From: SubbaReddy M [mailto:[EMAIL PROTECTED]] Sent: Friday, February 15, 2002 5:23 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Suspected Bug I am afraid it's not a bug, rather a syntax error. please follow the syntax to rename the table: mysql alter table X1 rename as X2; Regards, ~ SubbaReddy .M - Original Message - From: SubbaReddy M [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, February 15, 2002 3:46 PM Subject: Re: Suspected Bug Yeah, for me also find error. -- -- -- mysql create table X1(name varchar(10)); Query OK, 0 rows affected (0.00 sec) mysql insert into X1 values(5); Query OK, 1 row affected (0.01 sec) mysql RENAME TABLE X1 TO X2; ERROR 1064: You have an error in your SQL syntax near 'RENAME TABLE X1 TO X2' at line 1 mysql -- -- Regards, ~ SubbaReddy .M Sr. Programmer, Frontlinesoft, Hyderabad http://www.frontlinesoft.com ICQ: 56093095 - Original Message - From: Fred Lovine [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, February 15, 2002 12:23 PM Subject: Suspected Bug MySQL is awesome, but I think I found a bug. The following script: CREATE TABLE X1 (x smallint); insert into X1 values(5); RENAME TABLE X1 TO X2; is producing the following error: 7 - Error on rename '.\db\X1.MY1' to '.\db\X2.MYI' (Errcode: 13) The problem seems to be caused by using uppercase table names. The problem does not happen when the table names are all lowercase. MySQL version: 3.23.47-nt Running on Windows 2000 Pro Feel free to contact me if there are any questions. Server Variables Variable CLW Laptop back_log 50 basedir C:\CLW\MySQL\ binlog_cache_size 32768 character_set latin1 character_sets latin1 big5 czech euc_kr gb2312 gbk sjis tis620 ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5 concurrent_insert ON connect_timeout 5 datadir C:\CLW\MySQL\data\ delay_key_write ON delayed_insert_limit 100 delayed_insert_timeout 300 delayed_queue_size 1000 flush OFF flush_time 1800 have_bdb NO have_gemini NO have_innodb NO have_isam YES have_raid NO have_openssl NO init_file interactive_timeout 28800 join_buffer_size 131072 key_buffer_size 8384512 language C:\CLW\MySQL\share\english\ large_files_support ON log OFF log_update OFF log_bin OFF log_slave_updates OFF log_long_queries OFF long_query_time 10 low_priority_updates OFF lower_case_table_names 1 max_allowed_packet 130048 max_binlog_cache_size 4294967295 max_binlog_size 1073741824 max_connections 100 max_connect_errors 10 max_delayed_threads 20 max_heap_table_size 16777216 max_join_size 4294967295 max_sort_length 1024 max_user_connections 0 max_tmp_tables 32 max_write_lock_count 4294967295 myisam_max_extra_sort_file_size 256 myisam_max_sort_file_size 2047 myisam_recover_options 0 myisam_sort_buffer_size 8388608 net_buffer_length 16384 net_read_timeout 30 net_retry_count 10 net_write_timeout 60 open_files_limit 0 pid_file C:\CLW\MySQL\data\laptop.pid port 3306 protocol_version 10 record_buffer 131072 record_rnd_buffer 131072 query_buffer_size 0 safe_show_database OFF server_id 0 slave_net_timeout 3600 skip_locking ON skip_networking OFF skip_show_database OFF slow_launch_time 2 socket MySQL sort_buffer 2097144 sql_mode 0 table_cache 64 table_type MYISAM thread_cache_size 0 thread_stack 65536 transaction_isolation READ-COMMITTED timezone Eastern Standard Time tmp_table_size 33554432 tmpdir C:\WINNT\TEMP\ version 3.23.47-nt wait_timeout 28800 Fred Lovine [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: mysql from localhost vs. remote
Hi I see: local-system mysql -h 66.70.34.150 -O 3307 -u xyz00 -p hmm. I always use: mysql -u xyz -p -h ... -P 3306 Is the -O option in the right place. Maybe it sould be -P like PORT. Isn't ?? Regards. I. Piasecki - webmaster www.b-c.pl - Original Message - From: Michael Hoennig [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, February 15, 2002 3:37 PM Subject: Re: mysql from localhost vs. remote Hi Dimitry, But we can NOT connect locally by host:port: local-system mysql -h 66.70.34.150 -O 3307 -u xyz00 -p = ERROR 1045: Access denied for user: 'xyz00@localhost' (Using password: YES) On a mysqld which is accessible only locally the both INSERT statements above would have localhost instead of %. Why does localhost not qualify for %? Probably because you already have entry for 'localhost','%' or something to that effect. nope, there is not such an entry. But IF we add it, we can login. This just means that we have to insert two entries (% and localhost) each. It looks clumsy to me. Michael -- Hostsharing eG / c/o Michael Hönnig / Boytinstr. 10 / D-22143 Hamburg phone:+49/40/67581419 / mobile:+49/177/3787491 / fax:++49/40/67581426 http://www.hostsharing.net --- Webhosting Spielregeln selbst gemacht - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Okresl Swoje potrzeby - my znajdziemy oferte za Ciebie! [ http://oferty.onet.pl ] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: A sum of a few columns in where clause?
* IvanLatysh I've got query like this: select count(ID) from TABLE where (TABLE.A + TABLE.B + TABLE.C + TABLE.D) 0 A,B,C,D are decimal values. The problem is, I think, with NULL columns. Often B,C and D don't have decimal value, but NULL. I thought, that this should be counted like zero. Am I wrong ? RB NULL is not the same as zero. RB If any of the field values are NULL, the result of the expression is RB NULL. Hey guys Is this so hard to help people instead of killing them ? I'm sorry, it was not my intention to kill anyone! Use IFNULL(null_field, 0) And your query will be like: select count(ID) from TABLE where (IFNULL(TABLE.A, 0) + IFNULL(TABLE.B, 0) + IFNULL(TABLE.C, 0) + IFNULL(TABLE.D,0)) 0 In general, I agree that it is better to provide an example of how to do it, as you do here, but in this case I thought it may be a better solution to avoid having NULL's in the table in the first place. But I don't know if there are other reasons he have the NULL's... instead of trying to guess what he wanted, I just gave him the facts on something he was obviously confused about... -- Roger 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: mysql from localhost vs. remote
Hi Ireneusz, Hi I see: local-system mysql -h 66.70.34.150 -O 3307 -u xyz00 -p hmm. I always use: mysql -u xyz -p -h ... -P 3306 Is the -O option in the right place. Maybe it sould be -P like PORT. Isn't?? sorry, typo in my mail. -P of course. Alles Gute wünscht Michael -- Hostsharing eG / c/o Michael Hönnig / Boytinstr. 10 / D-22143 Hamburg phone:+49/40/67581419 / mobile:+49/177/3787491 / fax:++49/40/67581426 http://www.hostsharing.net --- Webhosting Spielregeln selbst gemacht - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Suspected Bug
I think there are a couple of bugs here: First, per the documentation, 6.1.3 Case Sensitivity in Names (http://www.mysql.com/doc/N/a/Name_case_sensitivity.html), the Windows mysqld is starting with -O lower_case_table_names=1 by default, so all filenames should be converted to lowercase automatically. The create and insert statements are performing as they should. But the RENAME is not, RENAME will create a table in upper case. I believe the first bug is that the RENAME is not respecting the lower_case_table_names option. Second, the error, 7 - Error on rename '.\db\X1.MY1' to '.\db\X2.MYI' (Errcode: 13) is with the index file. After playing around a bit, the following SQL does work: CREATE TABLE X1 (x smallint); insert into X1 values(5); FLUSH TABLES; RENAME TABLE X1 TO X2; My guess is that RENAME is not closing the index file, but FLUSH takes care of that. And the workaround as stated before is to just use lowercase table names. BTW, the following works fine: CREATE TABLE X1 (x smallint); insert into X1 values(5); RENAME TABLE x1 TO x2; -- note names are lowercase --Fred -Original Message- From: DL Neil [mailto:[EMAIL PROTECTED]] Sent: Friday, February 15, 2002 7:20 AM To: SubbaReddy M; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Suspected Bug Once tables are CREATEd, the name is listed in SHOW tables using lower case characters, regardless of the case used in the CREATE command. Using upper case table names in RENAME results in the error. Workaround: Using lower case equivalent table names works, regardless of the case used in the CREATE command. Windows does not differentiate between X1 and x1 as table/filenames. *nix does. Perhaps CREATE has been Window-ised but RENAME has not (yet). Regards, =dn WinNT 4.0 SP6a, MySQL vn 3.23.40-nt - Original Message - From: SubbaReddy M [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: 15 February 2002 10:16 Subject: Re: Suspected Bug Yeah, for me also find error. -- -- -- mysql create table X1(name varchar(10)); Query OK, 0 rows affected (0.00 sec) mysql insert into X1 values(5); Query OK, 1 row affected (0.01 sec) mysql RENAME TABLE X1 TO X2; ERROR 1064: You have an error in your SQL syntax near 'RENAME TABLE X1 TO X2' at line 1 mysql -- -- Regards, ~ SubbaReddy .M Sr. Programmer, Frontlinesoft, Hyderabad http://www.frontlinesoft.com ICQ: 56093095 - Original Message - From: Fred Lovine [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, February 15, 2002 12:23 PM Subject: Suspected Bug MySQL is awesome, but I think I found a bug. The following script: CREATE TABLE X1 (x smallint); insert into X1 values(5); RENAME TABLE X1 TO X2; is producing the following error: 7 - Error on rename '.\db\X1.MY1' to '.\db\X2.MYI' (Errcode: 13) The problem seems to be caused by using uppercase table names. The problem does not happen when the table names are all lowercase. MySQL version: 3.23.47-nt Running on Windows 2000 Pro Feel free to contact me if there are any questions. Server Variables Variable CLW Laptop back_log 50 basedir C:\CLW\MySQL\ binlog_cache_size 32768 character_set latin1 character_sets latin1 big5 czech euc_kr gb2312 gbk sjis tis620 ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5 concurrent_insert ON connect_timeout 5 datadir C:\CLW\MySQL\data\ delay_key_write ON delayed_insert_limit 100 delayed_insert_timeout 300 delayed_queue_size 1000 flush OFF flush_time 1800 have_bdb NO have_gemini NO have_innodb NO have_isam YES have_raid NO have_openssl NO init_file interactive_timeout 28800 join_buffer_size 131072 key_buffer_size 8384512 language C:\CLW\MySQL\share\english\ large_files_support ON log OFF log_update OFF log_bin OFF log_slave_updates OFF log_long_queries OFF long_query_time 10 low_priority_updates OFF lower_case_table_names 1 max_allowed_packet 130048 max_binlog_cache_size 4294967295 max_binlog_size 1073741824 max_connections 100 max_connect_errors 10 max_delayed_threads 20 max_heap_table_size 16777216 max_join_size 4294967295 max_sort_length 1024 max_user_connections 0 max_tmp_tables 32 max_write_lock_count 4294967295 myisam_max_extra_sort_file_size 256 myisam_max_sort_file_size 2047 myisam_recover_options 0 myisam_sort_buffer_size 8388608 net_buffer_length 16384 net_read_timeout 30 net_retry_count 10 net_write_timeout 60 open_files_limit 0 pid_file C:\CLW\MySQL\data\laptop.pid port 3306 protocol_version 10 record_buffer 131072 record_rnd_buffer 131072
table type comparison (poor SELECT performance with HEAP tables ?)
Hello, Well, for my project at work, I've done some small benchmarking of different table types for relatively small sizes (some tens or hundreds of thousands rows - small enough so that key buffer size and other memory factors should not limit performance) and lots of very simple operations. I have the following observation from it : - INSERTs : HEAP tables are incredibly faster than everything else. Then come MYISAM tables (10 to 50 times slower than HEAP), and then the transactional tables (BDB and InnoDB). However the INSERTs were not contained in a single transaction, so this may improve performance. - SELECTs using indexes : HEAP are the best again, but with quite erratic performance. On some occasions they were extremely fast (100 times faster than other tables), and with other record sets they were only twice faster than other tables (which had, on their side, very stable results) - which means even SELECT COUNT(*) FROM my_table is slower than an INSERT ! I find this quite disturbing, and wonder about the reliability of HEAP tables. I wonder if anyone has had performance problems with HEAP tables (erratic performance given that at some time they can be really light-speed, and at others just *a bit* faster than disk-based tables) ? Another problem for HEAP tables is the slowness of DELETE and even TRUNCATE TABLE (you'd better DROP then re-CREATE them). Also, for disk-based tables, setting the 'noatime' flag was a real benefit for lots of very small queries (some tens of percent faster). Endly, it seems that restarting MySQL has some positive impact on SELECTs (strangely enough, because one could think that it would have to reload the indexes and thus spend some more time), expect on HEAP tables (!) ; INSERTs weren't affected though. Are there explanations for some of these facts ?. For HEAP tables, I was wondering if the client side was the bottleneck, but 'top' showed me that MySQL really took most CPU time. This was done with MySQL 3.23.43 source distribution, on a bi-processor Intel Redhat box. The machine is at the same time a production machine but with small loads, and each test was run several times. I can send the test files (4 small PHP scripts ;-)) to the MySQL developpers if they find it interesting. Regards Antoine. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 from localhost vs. remote
Michael Hoennig [EMAIL PROTECTED] wrote: But we can NOT connect locally by host:port: local-system mysql -h 66.70.34.150 -O 3307 -u xyz00 -p = ERROR 1045: Access denied for user: 'xyz00@localhost' (Using password: YES) On a mysqld which is accessible only locally the both INSERT statements above would have localhost instead of %. Why does localhost not qualify for %? Probably because you already have entry for 'localhost','%' or something to that effect. nope, there is not such an entry. But IF we add it, we can login. This just means that we have to insert two entries (% and localhost) each. It looks clumsy to me. One question - are sure that you have wrote -O instead -P as listed ? local-system mysql -h 66.70.34.150 -O 3307 -u xyz00 -p -- Dimitry - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Regex man page
According to the online manual the regex man page contributed by Henry Spencer is included in the source distribution of MySQL. I'm hesitant to download and install a source distribution just to get a man page. Is it found anywhere else? thanks, Joseph Polanik - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 4.0 released
Hello, I'm encountering a serious program fault at using MySQL Win32 client library LIBMYSQL.DLL. I found LIBMYSQL.DLL not thread-safe. When 10 threads are launched to run the following two blocks of C statements, very quickly a program fault window pops up to LIBMYSQL.DLL. block #1 - EnterCriticalSection(dcs); mysql_real_query(db,stmt,strlen(stmt)); res=mysql_store_result(db); LeaveCriticalSection(dcs); block #1 - (in another C function) EnterCriticalSection(dcs); row=mysql_fetch_row(res); nfld=mysql_num_fields(res); flds=mysql_fetch_fields(res); LeaveCriticalSection(dcs); But, if I merged the two blocks into one as: EnterCriticalSection(dcs); mysql_real_query(db,stmt,strlen(stmt)); res=mysql_store_result(db); row=mysql_fetch_row(res); nfld=mysql_num_fields(res); flds=mysql_fetch_fields(res); LeaveCriticalSection(dcs); then, the threads run fine for hours without any program fault pop up. HOWEVER, the second scenario is irrelevant to my (and most multithreaded) application where there are many nested queries of rows. Is there any thread-safe LIBMYSQL.DLL downloadable on mysql.com?? or is there any other solution to make SQL queries by simultaneous threads safe? Thank You! Best Regards, Peter - Original Message - From: Michael Widenius [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, October 16, 2001 6:29 AM Subject: MySQL 4.0 released Hi! MySQL 4.0.0-alpha is now available at: http://www.mysql.com/downloads/mysql-4.0.html You can find information about upgrading from MySQL 3.23 to 4.0 at: http://www.mysql.com/doc/U/p/Upgrading-from-3.23.html The MySQL 4.0 release includes a lot of new exciting features, like MySQL as an embedded library, InnoDB (transactions) as standard table type, UNION, multi table delete and much more. MySQL 4.0 is basically a 'reconstruction release' that will enable us to easier add new features to MySQL in the future. The intention is to quickly add features list at: http://www.mysql.com/doc/T/O/TODO_MySQL_4.0.html and then start to work on the 4.1 branch while 4.0 stabilizes. Changes in release 4.0.0 * Added documentation for `libmysqld', the embedded MySQL server library. Also added example programs (a `mysql' client and `mysqltest' test program) which use `libmysqld'. * Removed all Gemini hooks from MySQL. * Removed `my_thread_init()' and `my_thread_end()' from mysql_com.h, and added `mysql_thread_init()' and `mysql_thread_end()' to mysql.h. * Secure connections (with SSL). * Unsigned `BIGINT' constants now work. `MIN()' and `MAX()' now handles signed and unsigned `BIGINT' numbers correctly. * New character set `latin_de' which provides correct German sorting. * `TRUNCATE TABLE' and `DELETE FROM table_name' are now separate functions. One bonus is that `DELETE FROM table_name' now returns the number of deleted rows. * `DROP DATABASE' now executes a `DROP TABLE' on all tables in the database, which fixes a problem with InnoDB tables. * Added support for `UNION'. * A new `HANDLER' interface to `MyISAM' tables. * Added support for `INSERT' on `MERGE' tables. Patch from Benjamin Pflugmann. * Changed `WEEK(#,0)' to match the calender in the USA. * `COUNT(DISTINCT)' is about 30% faster. * Speed up all internal list handling. * Speed up `IS NULL()' and some other internal primitives. * Creating full text indexes are now much faster. * Tree-like cache to speed up bulk inserts and `myisam_bulk_insert_tree_size' variable. * Searching on packed (`CHAR'/`VARCHAR') keys are now much faster. * Optimized queries of type: `SELECT DISTINCT * from table_name ORDER by key_part1 LIMIT #' * `SHOW CREATE TABLE' now shows all table attributes. * `ORDER BY ... DESC' can now use keys. * `LOAD DATA FROM MASTER' auto-magically sets up a slave. * Renamed `safe_mysqld' to `mysqld_safe'. * Added support for symbolic links to `MyISAM' tables. Symlink handling is now enabled by default for Windows. * `LOAD DATA FROM MASTER' auto-magically sets up a slave. * Added `SQL_CALC_FOUND_ROWS' and `FOUND_ROWS()'. This makes it possible to know how many rows a query would have returned without a `LIMIT' clause. * Changed output format of `SHOW OPEN TABLES'. * Allow `SELECT expression LIMIT ...'. * Added `IDENTITY' as a synonym for `AUTO_INCREMENT' (like Sybase). * Added `ORDER BY' syntax to `UPDATE' and `DELETE'. * `SHOW INDEXES' is now a synonym for `SHOW INDEX'. * Added `ALTER TABLE table_name DISABLE KEYS' and `ALTER TABLE table_name ENABLE KEYS' commands. * Allow one to use `IN' instead of `FROM' in `SHOW' commands. * Allow ANSI SQL syntax `X'hexadecimal-number'' *
Re: Regex man page
Joe, you can find it here: http://arglist.com/regex/ Peter On Fri, 15 Feb 2002, Joe Polanik wrote: According to the online manual the regex man page contributed by Henry Spencer is included in the source distribution of MySQL. I'm hesitant to download and install a source distribution just to get a man page. Is it found anywhere else? thanks, Joseph Polanik -- GPG ID D40940EC FPR 89CC E331 FFD0 3138 9CB2 FE0D 122E 9EC9 D409 40EC - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 in MySql while inserting '\'
Hi everybody, This seems to be a definite defect in MySql. While inserting a String into a MySql attribute defined as VARCHAR or VARCHAR BINARY, etc., if a '\' is present in the String, it is simply disregarded, and the remaining part of the String gets inserted. For inserting a '\', we have to use '\\'. However, the question remains that why should I give a special treatment to a String containing '\' ? Normally I am not bothered by the values I insert, as long as it is a String. I think I should be able to insert any String, irrespective of its value, into an attribute specified as VARCHAR, without any special treatment. What do you say about this, and is there any justification for this kind of behaviour ? Thanks and regards, Jit Roy Chowdhury Hughes Software Systems Gurgaon, India DISCLAIMER: This message is proprietary to Hughes Software Systems Limited (HSS) and is intended solely for the use of the individual to whom it is addressed. It may contain privileged or confidential information and should not be circulated or used for any purpose other than for what it is intended. If you have received this message in error, please notify the originator immediately. If you are not the intended recipient, you are notified that you are strictly prohibited from using, copying, altering, or disclosing the contents of this message. HSS accepts no responsibility for loss or damage arising from the use of the information transmitted by this email including damage from virus. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Regex man page
http://www.google.com/search?q=regex+man+page -Original Message- From: Joe Polanik [mailto:[EMAIL PROTECTED]] Sent: Friday, 15 February 2002 3 12 To: [EMAIL PROTECTED] Subject: Regex man page According to the online manual the regex man page contributed by Henry Spencer is included in the source distribution of MySQL. I'm hesitant to download and install a source distribution just to get a man page. Is it found anywhere else? thanks, Joseph Polanik - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: re-ordering rows
Bryan, I apologise, did I mistakenly call you Brent earlier!? Indeed. I have a relatively large (few dozen) number of tables that are accessed via PHP and a web interface. The script pulls information from these tables to generate pull-down menus. It would be nice if these pull-down menus were in some inherent logical order--alphabetical, say--as they were when I initially populated the tables. =presentation sequence should be logical: no question about it. =initial table population sequence has little to do with 'real life' - if things changed and a load more rows were added to the table, you would still want to achieve the first objective. Which brings us to... However deleting and adding rows have caused the order to become jumbled--althought the ID numbers are still associated with the name fields in alphabetical order, they are no longer returned in order automatically with a simple SELECT statement. I had hoped there would be some simple command I could run to shuffle the rows back around to inherently be in logical order, so that I wouldn't have to go through scores of SQL statements in my scripts adding ORDER BY statements. Perhaps this is not possible, though. Perhaps MySQL does not care in what order rows are stored internally, and an ORDER BY clause is the only way to impose an outside order on them. This is NOT a MySQL issue, it is rooted in relational theory. In a RDBMS there is no concept of storing data in any particular sequence. Concepts of sequence come into such things as indexing that data, and retrieving the data. BTW this is a common question from people who have 'started' with serial file systems and even certain 'personal' database systems, and are now moving into the SQL/relational world. Let's think about adding data to an existing tbl (as a 'for instance'): it would be fastest if the RDBMS INSERTed the data at the end of the existing file - in file system terminology: open file for write-append, write the row, close the file. If the data was to be inserted somewhere mid-file in order to preserve a 'sequence', what would be involved? Boy do I remember struggling with all this different file formats, and their pros and cons, back at Uni! I mentioned indexing. If the index (let's say a single column for 'purity of thought') is 'small' when compared to the size of the row as a whole, an entire file of indexes/indices is going to be significantly smaller (read: easier to manipulate) than the data-table itself. Consequently when rows are added to indexed tbls, the 'data' can be 'thrown in' (he says most unscientifically) and the indexed data can be inserted (using some suitably smart algorithm) into the correct place in the sequence (of the index file). So data is kept as a 'hodge-podge' (with absolutely no predictable/reliable sequence), but indexes/indices are properly maintained. However, if you are a thinking-reader, when I described INSERTing a para back, you may have thought, 'yes slow storing, but faster retrieval - it's a tradeoff' - and you'd be right (in the trade-off notion)! Trouble is, when you stored the data, yesterday, ready for its retrieval today, did you know the sequence that would be demanded, in advance? Another aspect of relational theory is that the way you build the table, with the access methods/relationships you have in mind today, should not 'fix' things so that you can't react/cope with unanticipated requests/demands tomorrow! In order words, just because you want to pull data out of a table in x-sequence today, doesn't limit you to only that (as some older file systems used to do), if you want to use another sequence, even on another column, tomorrow! That's the good news! The bad news is, yes, you either accept SELECTed data back in some random order; or you add an ORDER BY clause. At least it is not as bad as herding cats! =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
replication and transaction problem
Hello everyone I've read about replication mechanism in MySQL, but I've still got some reservations regarding transactions. In the manual thay say that in case of a transaction, all update instructions are hold in a cache, and on commit they are written to the binary transaction log. After the update instructions are written in binary update log, the slave starts reading them and executint. But what happends if a client executes a query on the slave machine in this period of time? Wouldn't he see an inconsistent database state (a state in the middle of the transaction)? So, actually, on the slave machine it's like there are no transactions at all. Am I wrong somewhere? Please give me some advice, Thank you -- Sincerely Catalin Grigoroscuta Junior Programmer One5 Development SRL Str Intrarea Glucozei No 37-39, sector 2, Bucharest, Romania Phone: +40 1-234-5080, Fax: +40 1-243-0579 E-Mail: [EMAIL PROTECTED] Visit us on the Internet: http://www.one5.com/ One5 Corporation - Wireless Infrastructure for 3rd Generation * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
synopsis of the problem (one line)
Description: How-To-Repeat: Fix: Submitter-Id: submitter ID Originator:root Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release: mysql-3.23.48-max (Official MySQL-max binary) Environment: System: Linux localhost.localdomain 2.4.2-2wl #1 ±Ý 6¿ù 8 05:21:58 KST 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-81) Compilation info: CC='gcc' CFLAGS='-O3 -fno-omit-frame-pointer' CXX='gcc' CXXFLAGS='-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 1¿ù 1 1999 /lib/libc.so.6 - libc-2.2.2.so -rwxr-xr-x1 root root 1236396 4¿ù 7 2001 /lib/libc-2.2.2.so -rw-r--r--1 root root 26350254 4¿ù 7 2001 /usr/lib/libc.a -rw-r--r--1 root root 178 4¿ù 7 2001 /usr/lib/libc.so lrwxrwxrwx1 root root 10 1¿ù 1 1999 /usr/lib/libc-client.a - c-client.a Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL-max binary' --with-extra-charsets=complex --with-server-suffix=-max --enable-thread-safe-client --enable-assembler --disable-shared --with-innodb - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Replication + Tmp tables + Flush master/slave = crash
Hei I think we have found a bug in mysql replication. We have some programs that are working against a master DB and that use temporary tables. The hole system works without problems until we run a flush master/slave. Then the replication in the slave DB stops working because of this. How to produce the crash: - We need a system with replication working master-slave. Run f.ex: MASTER: create temporary table testtmp(id text); MASTER: insert into testtmp values (testing); Until here everything works fine. You can continue working with this tmp table without problems. But if we run: MASTER: flush tables with read lock; MASTER: flush master; SLAVE: flush slave; MASTER: unlock tables; MASTER; insert into testtmp values(testing2); The replication in slave will stop working with a error message saying that table testtmp does not exist. This is a huge problem for us. We have many programs working against the master DB, they run for weeks and the process of stopping/starting all of them is not trivial, so we can not stop all of them to run a flush master/slave when the binary update log file gets to big. Is this a bug?, is it another way of doing what we want to do without crashing replication? Do you need more information? Thanks for your help Sincerely Rafael Martinez - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 in MySql while inserting '\'
How would you do: set field='Jim said, that's crazy.' you would have to escape the quote somehow. The '\' is the escaper character. set field='Jim said, that\'s crazy.' That means hat the escape character must also be escaped. Check the manual for the section on special characters. Most languages that support MySQL also have a function that can [ should] be used to escape all strings before they are inserted or matched in a query. [EMAIL PROTECTED] wrote: Hi everybody, This seems to be a definite defect in MySql. While inserting a String into a MySql attribute defined as VARCHAR or VARCHAR BINARY, etc., if a '\' is present in the String, it is simply disregarded, and the remaining part of the String gets inserted. For inserting a '\', we have to use '\\'. However, the question remains that why should I give a special treatment to a String containing '\' ? Normally I am not bothered by the values I insert, as long as it is a String. I think I should be able to insert any String, irrespective of its value, into an attribute specified as VARCHAR, without any special treatment. What do you say about this, and is there any justification for this kind of behaviour ? Thanks and regards, Jit Roy Chowdhury Hughes Software Systems Gurgaon, India DISCLAIMER: This message is proprietary to Hughes Software Systems Limited (HSS) and is intended solely for the use of the individual to whom it is addressed. It may contain privileged or confidential information and should not be circulated or used for any purpose other than for what it is intended. If you have received this message in error, please notify the originator immediately. If you are not the intended recipient, you are notified that you are strictly prohibited from using, copying, altering, or disclosing the contents of this message. HSS accepts no responsibility for loss or damage arising from the use of the information transmitted by this email including damage from virus. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: admin privilege problems
On Fri, Feb 15, 2002 at 12:16:01PM +0200, Egor Egorov wrote: System, Friday, February 15, 2002, 5:38:51 AM, you wrote: jr i made the mistake of changing my root password manually in the mysql jr database. after doing so, i 'flushed privileges'. jr now i'm unable to log on using the root. i've tried to log on using the new jr password a number of times, but i'm always denied access. strangely enough, jr other users (that have passwords) can log on successfully without providing jr a password. does anybody have any recommendations for logging on as the root jr user ... and fixing this privileges problem? Look at: http://www.mysql.com/doc/R/e/Resetting_permissions.html It will help you. SAakaTRotP What if you run into: SAakaTRotP Script started on Thu Feb 14 20:35:44 2002 SAakaTRotP doctor.nl2k.ab.ca//var$ mysqladmin -h localhost -u root password 'Nathan84' SAakaTRotP mysqladmin: unable to change password; error: 'You must have privileges to update tables in the mysql database to be able to change passwords for others' SAakaTRotP doctor.nl2k.ab.ca//var$ exuit it SAakaTRotP exit Did you run mysql at first time? The recomended way to change password and privileges is to use GRANT statement. SAakaTRotP Script done on Thu Feb 14 20:35:56 2002 Further I try: Script started on Fri Feb 15 08:48:41 2002 doctor.nl2k.ab.ca//var$ exitmysql -u root mysql Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Didn't find any fields in table 'columns_priv' Didn't find any fields in table 'db' Didn't find any fields in table 'func' Didn't find any fields in table 'host' Didn't find any fields in table 'tables_priv' Didn't find any fields in table 'user' Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 18 to server version: 3.23.48-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql exit Bye doctor.nl2k.ab.ca//var$ quit sh: quit: command not found doctor.nl2k.ab.ca//var$ exit exit Script done on Fri Feb 15 08:48:49 2002 -- contact: Dave Yadallee NetKnow The Internet Knowledge Company [EMAIL PROTECTED] http://www.nl2k.ab.ca 990-3244 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: date comes out as '0000-00-00'
Hi, Could you tell me about your TABLE-definition and version number of your JDBC Driver? I will check that problem. "Stancescu, Catalina" wrote: I have a servlet in which I connect through a mysql driver to the database. The servlet has a string that represents the date in the format 'MM/DD/YY'. When I am trying to insert this date, I get sometimes the correct date, sometimes I get the '-00-00'. Here is the code: String sql_1 = "INSERT INTO bookmgr.copy (bookid, emp_purchaser, date_expensed, emp_holder) VALUES (?,?,?,?)"; ps = myConnection.prepareStatement(sql_1); // inserting records ps.setInt(1, bookid); ps.setInt(2, userId); ps.setString(3, expensed_date); ps.setInt(4, userId); ps.executeUpdate(); -- TAKAHASHI, Tomohiro - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Aborted connection using myodbc
Hi, we're using myodbc2.50.36 with W2k and W98 to connect to our mysql-server (Linux Kernel 2.2.18 - MySQL Version 3.23.38) in the internet. When we send or receive larger amounts of data (we're using Visual Foxpro 7.0 as frontend) we get the aborted connections-Message in the mysql errorlog very often. In my.cnf the wait_timeout is set to 1800 seconds but the connection is aborted much earlier. Here's a piece of the most recent logfile: 020215 16:22:22 Aborted connection 22987 to db: 'dummy' user: 'dummyusr' host: `my.server.com' (Got an error reading communication packets) 020215 16:25:27 Aborted connection 22991 to db: 'dummy' user: 'dummyusr' host: `my.server.com' (Got an error reading communication packets) 020215 16:26:02 Aborted connection 22999 to db: 'dummy' user: 'dummyusr' host: `my.server.com' (Got an error writing communication packets) 020215 16:28:58 Aborted connection 23574 to db: 'dummy' user: 'dummyusr' host: `my.server.com' (Got an error reading communication packets) 020215 16:32:38 Aborted connection 24381 to db: 'dummy' user: 'dummyusr' host: `my.server.com' (Got an error reading communication packets) 020215 16:34:41 Aborted connection 24877 to db: 'dummy' user: 'dummyusr' host: `my.server.com' (Got an error reading communication packets) 020215 16:34:53 Aborted connection 24970 to db: 'dummy' user: 'dummyusr' host: `my.server.com' (Got an error reading communication packets) 020215 16:43:23 Aborted connection 25296 to db: 'dummy' user: 'dummyusr' host: `my.server.com' (Got an error writing communication packets) 020215 16:48:47 Aborted connection 22968 to db: 'dummy' user: 'dummyusr' host: `my.server.com' (Got timeout reading communication packets) Does anybody know what to do to stop this aborted connections? It's nearly impossible to send or receive larger amounts of data when manipulating tables using ODBC. Greetings from Germany Lutz Maibach - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 + Access + MyODBC + LARGE Tables
Spoiler: Venu's Suggestion about Dynamic Cursor is the answer On Thu, 2002-02-14 at 20:34, Venu wrote: MyODBC, as compiled today, uses mysql_store_result to get records. This is fine for reasonably sized tables. However, if the table has millions of records, writing the results to a temporary table has many detrimental effects, e.g.: Access seems to hang from the user's perspectiv, Access crashes because there are too many records for it to handle at once (data requirements to great); MySQL creates HUGE temporary tables or bombs if SQL_BIG_RESULT was not set. Probably we can add extra DSN options, to make use of either mysql_store_result() or mysql_use_result(). In the second case, lot of code change is needed in all result set dependency APIs too. That would be nice but perhaps unneeded (see below about your suggestion). So in the case of a very long table, it is important to use mysql_use_result instead. This makes it so that results are returned right away and eases the load on all programs involved. The astute reader will realize that if one uses mysql_use_result and does not fetch all of the records, the next query will return the remaining records from the previous query first. It follows that Access bombs because in statement #2 it is getting results from statement #1. (This is seen from the myodbc.log line: | error: message: Commands out of sync; You can't run this command now in the myodbc3.dll changed to use the said function.) Can you be more specific on this ? And a MS ODBC DM trace will be better to analyze. Sorry, I should have been clearer about this. Yesterday (Thursday) I downloaded the bk source. Aside from many other hacks, I changed execute.c:do_query to use mysql_use_result() instead of mysql_store_result(). In THIS version, I got the Commands out of sync error. To better show what is happening, I just got the souce again, made the said modification and a couple of more verbose debugging output modifications. In the setup, I had checked off Return Matching Records and Trace Here is the sequence of what is happening: [bill@badams myodbc-3.51]$ grep -E 'SQLFree|SQLPre|sync' myodbc.log SQLFreeHandle | info: SQLFreeHandle: 157150 | SQLFreeConnect | SQLFreeConnect SQLFreeHandle SQLFreeHandle | info: SQLFreeHandle: 154988 SQLFreeHandle | SQLPrepare | | info: SQLPrepare: 15bd68 SELECT Config, nValue FROM MSysConf | SQLPrepare | SQLFreeStmt | | enter: SQLFreeStmt: 15bd68 option: 1000 | SQLFreeStmt SQLFreeHandle | info: SQLFreeHandle: 15bd68 | SQLFreeStmt | | enter: SQLFreeStmt: 15bd68 option: 1 | SQLFreeStmt SQLFreeHandle | SQLPrepare | | info: SQLPrepare: 15bd68 SELECT `pcm_test_header_200202`.`serial_hi`,`pcm_test_header_200202`.`ymd_ts` FROM `pcm_test_header_200202` | SQLPrepare | SQLFreeStmt | | enter: SQLFreeStmt: 15bd68 option: 1000 | SQLFreeStmt SQLPrepare | info: SQLPrepare: 15c780 SELECT [column names removed --bill] FROM `pcm_test_header_200202` WHERE `serial_hi` = ? AND `ymd_ts` = ? OR `serial_hi` = ? AND `ymd_ts` = ? OR `serial_hi` = ? AND `ymd_ts` = ? OR `serial_hi` = ? AND `ymd_ts` = ? OR `serial_hi` = ? AND `ymd_ts` = ? OR `serial_hi` = ? AND `ymd_ts` = ? OR `serial_hi` = ? AND `ymd_ts` = ? OR `serial_hi` = ? AND `ymd_ts` = ? OR `serial_hi` = ? AND `ymd_ts` = ? OR `serial_hi` = ? AND `ymd_ts` = ? SQLPrepare | SQLFreeStmt | | enter: SQLFreeStmt: 15c780 option: 1000 | SQLFreeStmt | | error: message: Commands out of sync; You can't run this command now SQLFreeStmt | enter: SQLFreeStmt: 15c780 option: 0 SQLFreeStmt SQLFreeHandle | info: SQLFreeHandle: 15c780 | SQLFreeStmt | | enter: SQLFreeStmt: 15c780 option: 1 | SQLFreeStmt SQLFreeHandle SQLFreeHandle | info: SQLFreeHandle: 15bd68 | SQLFreeStmt | | enter: SQLFreeStmt: 15bd68 option: 1 | SQLFreeStmt SQLFreeHandle The bottom line is that in order for MySQL + Access + MyODBC to be usable as a datawarehouse MySQL/MyODBC (a) must be able to return uncached results; and (b) be able to have multiple statements open, active, and with pending data to be fetched at the same time. Try to use Dynamic Cursor Type (OPTION=32) in MyODBC 3.51. YES! The stock 3.51.01.01 myodbc3.dll with Dynamic Cursor Type, Allow BIG Results, and Return Matching rows is the ticket. AFAIK, this satisfies my needs. I will get back later next week after I do some more testing. b. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
API and IPC@CHIP
Dear Sir/Madam I'm fifth year student from Poland. I'm studying at Academy of Minnig and Metalurgy in Cracow (major Electrical Engineering). At the present I'm writing my master thesis. I consider how processors with embedded interface TCP/IP can be used in distributed system data collecting. I use processor German firm Beck (IPC@CHIP; processor family 80186 ). I have access to this processor by web browser and cgi interface (BIOS's this processor include server www ). I must write application which will collect data from outputs this processor. So, I have to (it's one of parts my thesis) write client program for this processor which will connecting with database server. There is atypical operating system similar to DOS. I must write new API to databse. I would like to choose MySQL. In this connection I have a few questions about MySQL. 1. I have open source MySQL but I can't find body of some functions (on base existing API for Windows or Linux I want to write my own API). For example, I can't find body of my_init() function. Where can I find it? Is it possible to see body of this function? (MySQL server will be working in Windows operating system). 2. Do you think that it's possible to write API (at least tiny) for this processor if I have more or less 150k free space on flashdisc whether I should look for another way to solve this problem. 3. I would like to write also another solutions. I wrote application for QNX (because it's hard real time operating system) which uses sockets to communication between Personal Computer and IPC@CHIP by TCP protocol. But now I'm looking for SQL database sytem for QNX. Is it possible to find MySQL for QNX? Where can I find it? If it's impossible, may you recommended me another sql database (shareware or freeware which I can download)? I will be very grateful for any suggestions and advices. I'm not fluent with database at the moment but I think that with your help I will change it pretty soon. If you are interested my work I will describe it for you in details. Yours sincerly Robert Eliasz -- Okrel Swoje potrzeby - my znajdziemy ofert za Ciebie! [ http://oferty.onet.pl ] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 using IN BOOLEAN MODE
Hello all, I searched the archives and found no similar problems, so here goes... Using an almost straight out of the manual example, I am unable to do a fulltext search using IN BOOLEAN MODE using the following SQL statement: SELECT * FROM parts WHERE MATCH (description) AGAINST (+brake +pad IN BOOLEAN MODE); I receive the error: ERROR 1064: You have an error in your SQL syntax near 'BOOLEAN MODE)' at line 1 I get this error on both servers listed below: server version: 3.23.39-max-nt (running on windows 2000) server version: 3.23.40 (running on redhat 7.1) I have no problems without the IN BOOLEAN MODE keywords in the statement. Anything I should know? Bob Price Information Services - Programmer Analyst ATTORNEYS' TITLE GUARANTY FUND, INC. 217.359.2042 § 800.252.5206, ext. 142 email: [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
connections to MySQL
Hello All, I am new to this list and hope that someone could answer this question for me. I am running on a fresh install of Redhat 7.2 and am trying to connect to MySQL from a program that I have to test the connections, but am getting error messages saying that the host in not allowed to connect to this MySQL server. This is strange because I ran my test app on the same machine that the MySQL server is running. Is there some file that I must modify to tell MySQL to accept connections from various machines including localhost? Also, does some one have a simple test program that they know works that I might be able to use to try and connect to a simple database? I need to validate my app is working correctly. Thanks in advance, Lonnie -- Lonnie Cumberland OutStep Technologies Incorporated (313) 832-7366 URL: http://www.outstep.com EMAIL: [EMAIL PROTECTED] : [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
MySql Installation/Configuration
Hi Gurus, I downloaded and installed MySql successfully, on a Windows 2000 O/S. I want to locate the my-example.cnf file, copy it to my root directory and rename it my.cnf. However, the my-example.cnf file I locate is a shortcut, pointing to no physical target. As a result, after going through this process, I cannot open the file to uncomment and edit the basedir line to point to MySql installation directory. Somebody please help. Thanks Juwon _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.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
Left Join problem - Please Help
Whenever I try to issue a query which has a left join for two tables and a where clause for a column in the second table that is a varchar the query runs indefinitely. If I change the where clause to search on a numeric type column the query runs and returns expected values. Does anyone know what I am doing wrong? This is my first time using Mysql, so if this isn't the right list to post on, please tell me where I can post beginner mysql questions. Thanks for your help in advance. Anya Miretsky Computer Technology Dept. Brooklyn Botanic Garden 1000 Washington Avenue Brooklyn, NY 11225 (718)623-7265 [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: connections to MySQL
does your test app connect with root as the user? -Original Message- From: Lonnie Cumberland [mailto:[EMAIL PROTECTED]] Sent: Friday, February 15, 2002 12:12 PM To: [EMAIL PROTECTED] Subject: connections to MySQL Hello All, I am new to this list and hope that someone could answer this question for me. I am running on a fresh install of Redhat 7.2 and am trying to connect to MySQL from a program that I have to test the connections, but am getting error messages saying that the host in not allowed to connect to this MySQL server. This is strange because I ran my test app on the same machine that the MySQL server is running. Is there some file that I must modify to tell MySQL to accept connections from various machines including localhost? Also, does some one have a simple test program that they know works that I might be able to use to try and connect to a simple database? I need to validate my app is working correctly. Thanks in advance, Lonnie -- Lonnie Cumberland OutStep Technologies Incorporated (313) 832-7366 URL: http://www.outstep.com EMAIL: [EMAIL PROTECTED] : [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: Left Join problem - Please Help
Show us your table structure, some table values and the SELECT statement that works and the one that doesn't -Original Message- From: Miretsky, Anya [mailto:[EMAIL PROTECTED]] Sent: Friday, February 15, 2002 12:13 PM To: '[EMAIL PROTECTED]' Subject: Left Join problem - Please Help Whenever I try to issue a query which has a left join for two tables and a where clause for a column in the second table that is a varchar the query runs indefinitely. If I change the where clause to search on a numeric type column the query runs and returns expected values. Does anyone know what I am doing wrong? This is my first time using Mysql, so if this isn't the right list to post on, please tell me where I can post beginner mysql questions. Thanks for your help in advance. Anya Miretsky Computer Technology Dept. Brooklyn Botanic Garden 1000 Washington Avenue Brooklyn, NY 11225 (718)623-7265 [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
When does the timestamp field gets updated?
Hi all, If one uses the timestamp data type for a column inside a table, when executing an update query on said table on a spesific record, will the timestamp column be updated as well or will it retain its first value? Thanks for any info in advance, George mysql, query, 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
RE: When does the timestamp field gets updated?
timestamp is automatically updated -Original Message- From: George Labuschagne [mailto:[EMAIL PROTECTED]] Sent: Friday, February 15, 2002 1:20 PM To: [EMAIL PROTECTED] Subject: When does the timestamp field gets updated? Hi all, If one uses the timestamp data type for a column inside a table, when executing an update query on said table on a spesific record, will the timestamp column be updated as well or will it retain its first value? Thanks for any info in advance, George mysql, query, 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: When does the timestamp field gets updated?
Only the first TIMESTAMP field gets updated when an updat to a record is made, so if you want to maintain the time a record was created, and when it was updated, use two timestamp fields, the first field will be the time updated, but to do this you must initialize the second timestamp field with NOW() when the record is created. John On Friday 15 February 2002 14:20, George Labuschagne wrote: Hi all, If one uses the timestamp data type for a column inside a table, when executing an update query on said table on a spesific record, will the timestamp column be updated as well or will it retain its first value? Thanks for any info in advance, George mysql, query, 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 installing MySQL on FreeBSD 4.5
Hi Darrin, This is very starnge as I just installed two FreeBSD 4.5 machines this week and had no problems! I installed on SMP based machines, with very few changes from the GENERIC kernel. Is this a fresh install of FreeBSD 4.5? If not can you run a 'make world' and 'make kernel' again? Did you run mergemaster after the upgrade (if it was an upgrade)? Is there anything unusla about you install? Ken - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, February 15, 2002 9:43 AM Subject: Problems installing MySQL on FreeBSD 4.5 Description: When trying to install MySQLi 3.23.47 and 3.23.48 on FreeBSD 4.5, We get the following errors during the mysql_install_db. /usr/local/bin/mysql_install_db Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables Fatal error 'Can't create gc thread' at line ? in file /usr/src/lib/libc_r/uthread/uthread_create.c (errno = ?) Abort trap - core dumped Installation of grant tables failed! We've tried this on multiple hosts running 4.5, and received the same problem. On a machine running 4.4, installation works fine. How-To-Repeat: Get a machine with a new install (or cvsup'd install) of FreeBSD 4.5. Try installing from ports. Submitter-Id: submitter ID Originator: Darrin Walton MySQL support: [none] Synopsis: Problems installing MySQL on FreeBSD 4.5 Severity: Priority: Category: mysql Class: Release: mysql-3.23.47 (FreeBSD port: mysql-server-3.23.47) Environment: System: FreeBSD distrust.routing.org 4.5-RC FreeBSD 4.5-RC #3: Fri Jan 18 16:37:48 EST 2002 [EMAIL PROTECTED]:/usr/src/sys/compile/DISTRUST 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='cc' CFLAGS='-O2 -pipe -march=pentiumpro' CXX='cc' CXXFLAGS='-O2 -pipe -march=pentiumpro -felide-constructors -fno-rtti - fno-exceptions' LDFLAGS='' LIBC: -r--r--r-- 1 root wheel 1223438 Jan 16 02:12 /usr/lib/libc.a lrwxr-xr-x 1 root wheel 9 Jan 16 02:12 /usr/lib/libc.so - libc.so.4 -r--r--r-- 1 root wheel 595712 Jan 16 02:12 /usr/lib/libc.so.4 Configure command: ./configure --localstatedir=/var/db/mysql --without-perl --without-de bug --without-readline --without-bench --with-mit-threads=no --with-li bwrap --with-low-memory '--with-comment=FreeBSD port: mysql-server-3.23.47' --enable-assembler --with-berkeley-db --with-inn odb --prefix=/usr/local i386--freebsd4.5 Perl: This is perl, version 5.005_03 built for i386-freebsd - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: ADO to MySQL interface?
ADO supports ODBC drivers and all ODBC functionality as well as the newer ADO/OLEDB interfaces. You should be fine with the ODBC. Michele Harlass DBA AbcEd.com, Inc -Original Message- From: Guy Davis [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 13, 2002 1:29 PM To: [EMAIL PROTECTED] Subject: ADO to MySQL interface? Hi all, The company I work for is a Linux shop using MySQL almost exclusively, however we're partnering with Windows-only shop to tie their application into our overall product offering. Their app uses ADO as it's database interface and they say it will work with Oracle, MS SQL Server, and MS Access. I'm wondering if there is an ADO adapter out there that will work with MySQL. I know of the ODBC connector, but I'm told ADO replaces ODBC(?). If possible we'd like to stick with MySQL, rather than paying large licensing fees for either Oracle or SQL Server. -- Guy Davis Phone: (403) 301-3426 Pason Systems Fax: (403) 301-3499 PGP: 65BA 484B 0B96 5F3B 4D40 DCA2 B2AE 6B5A F52B 1445 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Need help about mysql order and index....
Bonjour Jean-françois, Le DESC qui utilise l'INDEX est un fonction de MySQL 4.0. Il y a un bug en la version 4.0.1 (Quelque fois il n'utilise pas l'index descendre ) mais pour la plus part ça marche bien. En autre il y a un forum de MySQL en français à: Liens utils : Poster un message: [EMAIL PROTECTED] S'abonner: [EMAIL PROTECTED] Se désabonner : [EMAIL PROTECTED] Ecrire au proprio : [EMAIL PROTECTED] URL sur Onelist : http://www.onelist.com/community/mysql-france Bonne chance, Amicalement, Ken - Original Message - From: Jean-Francois Dionne [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, February 14, 2002 7:25 PM Subject: Need help about mysql order and index Hi there, I hope someone will can help me... First, sorry for bad english :) i'm french First all I have those index in my table +---+---+-++-- -- --+-++--+--- -+-- + | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Comment | +---+---+-++-- -- --+-++--+--- -+-- + | Stats | 0 | PRIMARY |1| ID | A | 4568748 | NULL | NULL| | | Stats | 1 | Port_ID |1| Port_ID | A | 1 | NULL | NULL| | | Stats | 1 | Timestamp |1| Timestamp | A | 49126 | NULL | NULL| | +---+---+-++-- -- --+-++--+--- -+-- + You have to know I have 4 500 000 in my db Okay I have this query: select Timestamp from Stats use index (Timestamp) where Timestamp = '2002-01-01' and Timestamp '2002-02-01' order by Timestamp limit 1; this one is jsut doing fine.. it take 0.00 sec to do it... but select Timestamp from Stats use index (Timestamp) where Timestamp = '2002-01-01' and Timestamp '2002-02-01' order by Timestamp desc limit 1; this one take sometime 10 sec to do I understand is the desc the prob.. because my index is in asc (collation=A) my question is... is there a way for maiking a index in desc? or maybe something else? Jean-Francois Dionne Yard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Left Join problem - Please Help
I don't think it's hanging. I think it's going through the process of determining joint criteria for 11,900 table entries multiplied by 88,000 other table entries, then doing a text search on the result, which is much slower than an integer search. I'm posting this back to the mysql list to see what the experts think. -Original Message- From: Miretsky, Anya [mailto:[EMAIL PROTECTED]] Sent: Friday, February 15, 2002 2:17 PM To: 'Rick Emery' Subject: RE: Left Join problem - Please Help Biblio has 11,901 and keyword has 87,971, also I indexed the keyword column in the keyword table. Is the fact that I have the same name for a column as for the table possibly a problem? -Original Message- From: Rick Emery [mailto:[EMAIL PROTECTED]] Sent: Friday, February 15, 2002 3:17 PM To: 'Miretsky, Anya' Subject: RE: Left Join problem - Please Help How many records are in these tables? -Original Message- From: Miretsky, Anya [mailto:[EMAIL PROTECTED]] Sent: Friday, February 15, 2002 1:51 PM To: 'Rick Emery' Subject: RE: Left Join problem - Please Help Table structure would be: Biblio table with the following columns: p_biblio int unsigned not null primary key, authors varchar(255), title varchar(255) , citation varchar(255) Keyword table with the following columns: p_keyword int unsigned not null primary key, fk_biblio int unsigned not null, Keyword varchar(255) Sql statement that works: Select distinct biblio.* from biblio left join keyword on biblio.p_biblio=keyword.fk_biblio where fk_biblio3; Sql statement that doesn't work - msql hangs executing this: Select distinct biblio.* from biblio left join keyword on biblio.p_biblio=keyword.fk_biblio where keyword=SOMESTRING; -Original Message- From: Rick Emery [mailto:[EMAIL PROTECTED]] Sent: Friday, February 15, 2002 2:10 PM To: 'Miretsky, Anya'; '[EMAIL PROTECTED]' Subject: RE: Left Join problem - Please Help Show us your table structure, some table values and the SELECT statement that works and the one that doesn't -Original Message- From: Miretsky, Anya [mailto:[EMAIL PROTECTED]] Sent: Friday, February 15, 2002 12:13 PM To: '[EMAIL PROTECTED]' Subject: Left Join problem - Please Help Whenever I try to issue a query which has a left join for two tables and a where clause for a column in the second table that is a varchar the query runs indefinitely. If I change the where clause to search on a numeric type column the query runs and returns expected values. Does anyone know what I am doing wrong? This is my first time using Mysql, so if this isn't the right list to post on, please tell me where I can post beginner mysql questions. Thanks for your help in advance. Anya Miretsky Computer Technology Dept. Brooklyn Botanic Garden 1000 Washington Avenue Brooklyn, NY 11225 (718)623-7265 [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: Left Join problem - Please Help
possibly -Original Message- From: Miretsky, Anya [mailto:[EMAIL PROTECTED]] Sent: Friday, February 15, 2002 2:32 PM To: 'Rick Emery' Subject: RE: Left Join problem - Please Help When I do this without specifying a left join with just :select biblio.* from biblio,keyword where p_biblio=fk_biblio and keyword=somestring; it works fairly fast, is it the left join that's making it so slow? -Original Message- From: Rick Emery [mailto:[EMAIL PROTECTED]] Sent: Friday, February 15, 2002 3:29 PM To: 'Miretsky, Anya' Cc: '[EMAIL PROTECTED]' Subject: RE: Left Join problem - Please Help I don't think it's hanging. I think it's going through the process of determining joint criteria for 11,900 table entries multiplied by 88,000 other table entries, then doing a text search on the result, which is much slower than an integer search. I'm posting this back to the mysql list to see what the experts think. -Original Message- From: Miretsky, Anya [mailto:[EMAIL PROTECTED]] Sent: Friday, February 15, 2002 2:17 PM To: 'Rick Emery' Subject: RE: Left Join problem - Please Help Biblio has 11,901 and keyword has 87,971, also I indexed the keyword column in the keyword table. Is the fact that I have the same name for a column as for the table possibly a problem? -Original Message- From: Rick Emery [mailto:[EMAIL PROTECTED]] Sent: Friday, February 15, 2002 3:17 PM To: 'Miretsky, Anya' Subject: RE: Left Join problem - Please Help How many records are in these tables? -Original Message- From: Miretsky, Anya [mailto:[EMAIL PROTECTED]] Sent: Friday, February 15, 2002 1:51 PM To: 'Rick Emery' Subject: RE: Left Join problem - Please Help Table structure would be: Biblio table with the following columns: p_biblio int unsigned not null primary key, authors varchar(255), title varchar(255) , citation varchar(255) Keyword table with the following columns: p_keyword int unsigned not null primary key, fk_biblio int unsigned not null, Keyword varchar(255) Sql statement that works: Select distinct biblio.* from biblio left join keyword on biblio.p_biblio=keyword.fk_biblio where fk_biblio3; Sql statement that doesn't work - msql hangs executing this: Select distinct biblio.* from biblio left join keyword on biblio.p_biblio=keyword.fk_biblio where keyword=SOMESTRING; -Original Message- From: Rick Emery [mailto:[EMAIL PROTECTED]] Sent: Friday, February 15, 2002 2:10 PM To: 'Miretsky, Anya'; '[EMAIL PROTECTED]' Subject: RE: Left Join problem - Please Help Show us your table structure, some table values and the SELECT statement that works and the one that doesn't -Original Message- From: Miretsky, Anya [mailto:[EMAIL PROTECTED]] Sent: Friday, February 15, 2002 12:13 PM To: '[EMAIL PROTECTED]' Subject: Left Join problem - Please Help Whenever I try to issue a query which has a left join for two tables and a where clause for a column in the second table that is a varchar the query runs indefinitely. If I change the where clause to search on a numeric type column the query runs and returns expected values. Does anyone know what I am doing wrong? This is my first time using Mysql, so if this isn't the right list to post on, please tell me where I can post beginner mysql questions. Thanks for your help in advance. Anya Miretsky Computer Technology Dept. Brooklyn Botanic Garden 1000 Washington Avenue Brooklyn, NY 11225 (718)623-7265 [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
mysqld unexpectedly crashes
Hello, I am having trouble with Mysqld unexpectedly crashing. I am running mysqld in a situation where there is a nearly constant load on 6 databases, each with about 20 open connections (mostly inserts and selects, occasionally a delete). Once every 3-4 days, at seemingly random points (i.e. in several crashes, it has yet to crash on the same SQL query), one of the mysqld processes crashes and posts to the mysqld.log, complaining of receiving either a signal 11 or a signal 4. One of the running mysqld processes becomes listed as defunct, and the rest just seem to hang there. Stopping the mysqld (/etc/rc.d/init.d/mysqld stop) does not kill the mysql processes. The reset procedure is to kill all of the running clients, re-stop the server, and then start the server. The only thought I have is that I am running Red Hat Linux 7.2, and thus as a result, /usr/bin/safe_mysqld by default forces mysqld to run with --skip-locking (apparently due to locking issues in some Linux systems). -- maybe the combination of a heavy load on the database and running without locking is causing some serious problems. Has anyone out there exerienced a similar problem, or have a better explanation for what's going on? Many thanks, john Siirola [EMAIL PROTECTED] Attached below are excerpts from mysqld.log (with stack traces), as well as other information generated by mysqlbug: -- -- mysqld got signal 11; [.] key_buffer_size=8388600 record_buffer=131072 sort_buffer=2097144 max_used_connections=110 max_connections=255 threads_connected=94 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 563070 K bytes of memory [Note: the server is running with 1024 MB RAM, so this should not be a problem.] [.] Stack range sanity check OK, backtrace follows: 0x80cf68d 0x400287fc 0x400232c4 0x829ae29 0x8283f61 0x82834ab 0x8278df3 0x8116fc8 0x80f4b8e 0x80f42f6 0x80f43a4 0x80f3fa9 0x80eca3d 0x80d5a9f 0x80d8dd3 0x80d4cb0 0x80d4210 Stack trace seems successful - bottom reached [.] Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x87368c0 = SELECT COUNT(ID) FROM data INNER JOIN request ON data.ReqID = request.ReqID WHERE request.AgentID 7 thd-thread_id=214476 Successfully dumped variables, if you ran with --log, take a look at the details of what thread 214476 did to cause the crash. In some cases of really bad corruption, the values shown above may be invalid -- Other crashes reported slightly different stack traces: -- mysqld got signal 11; [.] Stack range sanity check OK, backtrace follows: 0x80cf68d 0x400287fc 0x400232d0 0x829aef9 0x81298dd 0x827edd8 0x827e398 0x811725c 0x811150d 0x80f43c9 0x80f3fa9 0x80eca3d 0x80d5a9f 0x80d8dd3 0x80d4cb0 0x80d4210 Stack trace seems successful - bottom reached [.] Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x83eda20 = SELECT COUNT(ID) FROM data WHERE (C1+CLen)=-3.79606 AND (C1-CLen)=-3.79604 AND (C2+CLen)=-7.91645 AND (C2-CLen)=-7.91643 AND (C3+CLen)=0.921768 AND (C3-CLen)=0.921788 AND (C4+CLen)=-12.31881 AND (C4-CLen)=-12.31879 AND (C5+CLen)=17.04139 AND (C5-CLen)=17.04141 AND (C6+CLen)=13.84509 AND (C6-CLen)=13.84511 AND (C7+CLen)=-2.66293 AND (C7-CLen)=-2.66291 AND (C8+CLen)=-9.66253 AND (C8-CLen)=-9.66251 AND (C9+CLen)=-16.68791 AND (C9-CLen)=-16.68789 AND (C10+CLen)=17.53459 AND (C10-CLen)=17.53461 thd-thread_id=267084 Successfully dumped variables[.] -- mysqld got signal 4; [.] Stack range sanity check OK, backtrace follows: 0x80cf68d 0x40026a85 0x400279ec 0x40024cfe 0x829b67f 0x827caf7 0x8279503 0x8279924 0x8278d44 0x8116fc8 0x80f4b8e 0x80f42f6 0x80f43a4 0x80f3fa9 0x80eca3d 0x80d5a9f 0x80d8dd3 0x80d4cb0 0x80d4210 Stack trace seems successful - bottom reached [.] Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x8678428 = SELECT data.ID, F1 , X1, X2, X3, X4, X5, X6, X7, X8, X9, X10 FROM data INNER JOIN request AS R ON data.ReqID = R.ReqID WHERE R.AgentID 4 thd-thread_id=469679 Successfully dumped variables[.] -- mysqld got signal 4; [.] Stack range sanity check OK, backtrace follows: 0x80cf68d 0x40026a85 0x80ca915 0x80cabef 0x80d4892 0x80d4210 Stack trace seems successful - bottom reached [.] Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at (nil) is invalid pointer thd-thread_id=8319 Successfully dumped variables[.]
remote file processing with MySQL C API
I have a written a Windows client that accesses a MySQL server (Linux) via the MySQL C API. Stored in the MySQL database are large files (larger than a Mbyte). The C API makes it very easy for the client to query and alter the database. However, I have some special needs that don't appear to be addressed by the C API. The windows client needs the ability to download files from the database. But, before the files can be downloaded to the client, the server needs to insert (into the file) some custom information and then encrypt the entire file. Here are my questions: 1. Is there any way I can get MySQL (by means of the C API) to execute a custom process on certain entries in the database? 2. Once the custom processing has been accomplished, how can I transfer the customized file from the server to the client? 3. Apache is not part of the equation, but I would love to use PHP to solve the above problems. Is there any way that this could be accomplished? Thanks in advance for any advice that you might have. Ron - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Selecting records with the highest value no greater than x
I need some help here. Let's see if I can clearly describe it. I have a database containing news stories. Each story is assigned a rating (1 thru 5) indicating its importance. (A story with a rating of 5 is more important than a story with rating of 1.) Now, lets say that there are ten stories in the DB with a rating of 4 and I want to randomly pick one of those stories. I am doing something like this: SELECT * FROM NEWS WHERE RATING=4 ORDER BY RAND() LIMIT 1 That gives me the results I want, but there is a problem. There is no guarantee that there will be any stories in the DB with a rating of 4. If that happens, I want to randomly select a story with the next rating (three in this case) and if there are no stories with a rating of 3 as well, I want to select a story with a rating of 2, and so on and so forth. I would really like to be able to do this with one SELECT statement as opposed to running the above query over and over again, each time decrementing the value of the rating until a record is returned. Any Suggestions? Thanks. Brent Macnaughton - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Unknown crashes after queries.
Description: The errors and crashes herein are related to the use of a software package called Phorums... version 3.2.11... The query that was crashed on here, is made against the phorums3211 database. Log errors as follows: -- 020209 13:52:17 Aborted connection 1107 to db: 'unconnected' user: 'KidsWB' host: `talk-backdow.thewb.com' (Got an error writing communication packets) 020209 13:52:29 Aborted connection 4735 to db: 'phorums3211' user: 'phorums' host: `talk-backdow.thewb.com' (Got timeout reading communication packets) 020209 13:52:39 Aborted connection 6502 to db: 'phorums3211' user: 'phorums' host: `talk-backdow.thewb.com' (Got timeout reading communication packets) 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 agaist 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=402649088 record_buffer=1044480 sort_buffer=1048568 max_used_connections=463 max_connections=600 threads_connected=463 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 1619607 K bytes of memory Hope that's ok, if not, decrease some variables in the equation You seem to be running 32-bit Linux and have 463 concurrent connections. If you have not changed STACK_SIZE in LinuxThreads and build the binary yourself, LinuxThreads is quite likely to steal a part of global heap for the thread stack. Please read http://www.mysql.com/doc/L/i/Linux.html 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... Stack range sanity check OK, backtrace follows: 0x80bbbd8 0x2aad1552 0x2abe76d9 0x2abe759e 0x81cecb8 0x80e1460 0x80d907d 0x80c2279 0x80c605d 0x80c1689 0x80c0bb6 Stack trace seems successful - bottom reached 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 0x8794518 = SELECT p.*, pt.post_text FROM posts p, posts_text pt WHERE topic_id = '575' AND p.post_id = pt.post_id ORDER BY post_id LIMIT 6920, 40 thd-thread_id=6881 Successfully dumped variables, if you ran with --log, take a look at the details of what thread 6881 did to cause the crash. In some cases of really bad corruption, the above values 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: 0 020209 13:52:43 mysqld restarted /usr/local/libexec/mysqld: ready for connections 020209 13:57:54 Aborted connection 22 to db: 'phorums3211' user: 'phorums' host: `talk-backdow.thewb.com ' (Got timeout reading communication packets) 020209 13:57:56 Aborted connection 32 to db: 'phorums3211' user: 'phorums' host: `talk-backdow.thewb.com ' (Got timeout reading communication packets) -- How-To-Repeat: Just wait. It seems to happen every couple weeks or so.. like clockwork. Fix: Unknown as of yet.. restarting mysql only just gives us more time before it happens again. Submitter-Id: . Originator: Steven Deaton Organization: Apollo Interactive MySQL support: none Synopsis: MySQL crashes after specific query. Severity: serious Priority: medium Category: mysql Class: sw-bug Release:mysql-3.23.39 (yes) Environment:VA Linux release 6.2.4 S04.01.01 System: Linux talk-db.thewb.com 2.4.5-beta4va3.17smp-piii #1 SMP Wed Jun 20 22:10:48 PDT 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Jun 22 2001 /lib/libc.so.6 - libc-2.1.3.so -rwxr-xr-x1 root root 4110037 Apr 2 2001 /lib/libc-2.1.3.so -rw-r--r--1 root root 20366272 Apr 2 2001 /usr/lib/libc.a -rw-r--r--1 root root 178 Apr 2 2001 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local --datadir=/home/mysql --enable-assembler --with-mysql-user=mysql --with-unix-socket-path=/home/mysql/mysql.sock --with-raid --enable-thread-safe-client --with-libwrap --with-comment --with-berkeley-db
Re: Selecting records with the highest value no greater than x
How about SELECT * FROM news WHERE rating = 4 ORDER BY rating DESC, RAND() LIMIT 1; Michael On Fri, 15 Feb 2002, Brent Macnaughton wrote: I need some help here. Let's see if I can clearly describe it. I have a database containing news stories. Each story is assigned a rating (1 thru 5) indicating its importance. (A story with a rating of 5 is more important than a story with rating of 1.) Now, lets say that there are ten stories in the DB with a rating of 4 and I want to randomly pick one of those stories. I am doing something like this: SELECT * FROM NEWS WHERE RATING=4 ORDER BY RAND() LIMIT 1 That gives me the results I want, but there is a problem. There is no guarantee that there will be any stories in the DB with a rating of 4. If that happens, I want to randomly select a story with the next rating (three in this case) and if there are no stories with a rating of 3 as well, I want to select a story with a rating of 2, and so on and so forth. I would really like to be able to do this with one SELECT statement as opposed to running the above query over and over again, each time decrementing the value of the rating until a record is returned. Any Suggestions? Thanks. Brent Macnaughton - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySql Installation/Configuration
At 13:35 15/02/2002 -0500, Juwon Aikulola wrote: Hi! Hi Gurus, I downloaded and installed MySql successfully, on a Windows 2000 O/S. I want to locate the my-example.cnf file, copy it to my root directory and rename it my.cnf. However, the my-example.cnf file I locate is a shortcut, pointing to no physical target. The shortcut was created because in your environment the extension .cnf was applied for an MS application. Open my computer. In the Tool menu, open Folder Options. Click the Tab Files Types. Search for the .cnf extension and remove it (if you don't need this set file option). Create the my.cnf file again. Regards, Miguel As a result, after going through this process, I cannot open the file to uncomment and edit the basedir line to point to MySql installation directory. Somebody please help. Thanks Juwon _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.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 -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - 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
MySQL will not run on Debian Linux version 2.4
Hi, I am trying to install run MySQL version 3.23.43-pc-linux-gnu-i686. When I try to run it to finish installation and set up users, i get the following error: /usr/local/mysql# mysql start su: mysql: command not found I have also tried running MySQL with the mysqld start, mysqld, and mysql commands and all of them result in the same message. If you can help me I will be very grateful. Thank You, Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 will not run on Debian Linux version 2.4
Prefix it with the path: /usr/local/mysql/mysqld start or whatever. On Friday 15 February 2002 3:16 pm, Mark M Jervis Jr. wrote: Hi, I am trying to install run MySQL version 3.23.43-pc-linux-gnu-i686. When I try to run it to finish installation and set up users, i get the following error: /usr/local/mysql# mysql start su: mysql: command not found I have also tried running MySQL with the mysqld start, mysqld, and mysql commands and all of them result in the same message. If you can help me I will be very grateful. Thank You, Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Left Join problem - Please Help
* Miretsky, Anya Select distinct biblio.* from biblio left join keyword on biblio.p_biblio=keyword.fk_biblio where keyword=SOMESTRING; Try swapping the tables: Select distinct biblio.* from keyword left join biblio on biblio.p_biblio=keyword.fk_biblio where keyword=SOMESTRING; The left join is used when there may exist rows in the left table which may not have a related row in the right table, but you still want to include the fields from the left table. The fields from the right table are all NULL in the result row in this case. In this case you probably don't need the left join: Select distinct biblio.* from keyword, biblio where biblio.p_biblio=keyword.fk_biblio and keyword=SOMESTRING; The above statements does not select anything from the keyword table, but the where clause use the keyword table only, not the biblio table... In your case you read all the biblio rows (11,901), and for each of them you do a lookup on the related keywords matching SOMESTRING... this is rarely what you want, the exception beeing when there are very very many keywords and very few biblio rows. It is faster to use the index for all mathing keywords, and then do the lookup to find the related biblio row. By simply swapping the table names, you select FROM the keyword table, and then join with the matching biblio rows. -- Roger 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
Unique index/primary key case-insensitive?
Hi there, I'm having som difficulties trying to figure out MySQL's unique indexes and primary keys. Case: mysql create table flaf (lala varchar(20) not null, unique(lala)); Query OK, 0 rows affected (0.00 sec) mysql insert into flaf VALUES ('hest'); Query OK, 1 row affected (0.00 sec) mysql insert into flaf VALUES ('Hest'); ERROR 1062: Duplicate entry 'Hest' for key 1 Here, the unique index sees Hest as hest, and because of that the second row is not inserted. Why does MySQL have this strange behavoir, treating unique indexes case-insensitive? Same thing happens if I use a primary key for the column 'lala'. Similar test in postgresql seems more logical to me: hroi=# create table flaf(gnyf char(4) unique); NOTICE: CREATE TABLE/UNIQUE will create implicit index 'flaf_gnyf_key' for table 'flaf' CREATE hroi=# insert into flaf values ('hest'); INSERT 2722204 1 hroi=# insert into flaf values ('hest'); ERROR: Cannot insert a duplicate key into unique index flaf_gnyf_key hroi=# insert into flaf values ('Hest'); INSERT 2722206 1 Can anyone explain MySQL's behaviour and how I do a workaround making unique indexes and primary keys case sensitive? I've been over the documentation a couple times now unable to find anything. regards, //andreas http://phpwizard.dk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Msql-Mysql-modules-1.2219 bug?
SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `' and `'). SEND-PR: From: pengzhao To: [EMAIL PROTECTED] Subject: Msql-Mysql-modules-1.2219 fails in the test, on Itanium machine Description: precise description of the problem (multiple lines) I downloaded Msql-Mysql-modules-1.2219 and try to install the DBD for mysql on my Itanium box. When I run make test, there are two tests fail. I don't know whether this is acceptable (or more specifically, if I run the sql-bench stuff, whether the test will crash or not). You can check the error at http://www.cs.ualberta.ca/~pengzhao/1 It is generated by /usr/bin/perl -I../blib/arch -I../blib/lib -I/usr/lib/perl5/5.6.0/ia64-linux -I/usr/lib/perl5/5.6.0 -e 'use Test::Harness qw(runtests $verbose); $verbose=1; runtests @ARGV;' t/*.t 1 Can anybody tell me can I go on with make install and forget about the errors during the test phase? Thanks. How-To-Repeat: code/input/activities to reproduce the problem (multiple lines) Fix: how to correct or work around the problem, if known (multiple lines) Submitter-Id: submitter ID Originator: Organization: Regards Peng -- Peng Zhao [EMAIL PROTECTED] http://www.cs.ualberta.ca/~pengzhao TEL (Lab): (780)492-3725 Lab: CSC251 MySQL support: [none | licence | email support | extended email support ] Synopsis: make test fails in Msql-Mysql-modules-1.2219 Severity: [ non-critical | serious | critical ] (one line) Priority: [ low | medium | high ] (one line) Category: mysql Class: [ sw-bug | doc-bug | change-request | support ] (one line) Release: mysql-3.23.47 (Source distribution) Environment: machine, os, target, libraries (multiple lines) System: Linux innisfail 2.4.17 #14 SMP Sat Jan 19 06:11:14 MST 2002 ia64 unknown Architecture: ia64 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/ia64-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-96) Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Nov 10 20:20 /lib/libc.so.6.1 - libc-2.2.4.so -rwxr-xr-x1 root root 15500240 Aug 10 2001 /lib/libc-2.2.4.so -rw-r--r--1 root root 19629612 Aug 10 2001 /usr/lib/libc.a -rw-r--r--1 root root 180 Aug 10 2001 /usr/lib/libc.so Configure command: configure --prefix=/usr/scratch/pengzhao/mysql.gcc - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Compile error. MySql C++ API
Hi List, I am new to the MySql C++ API and I am compiling one file it gives me error saying Error E2303 ..\..\include\sqlplus\resiter1.hh 56: Type name expected Error E2275 ..\..\include\sqlplus\resiter1.hh 56: { expected Error E2275 ..\..\include\sqlplus\resiter1.hh 56: { expected and many warnings. Can you please tell me what option I have to set in my make file. Thanks, Vipul. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: When does the timestamp field gets updated?
George/Rick, a quick addition. It is not clear from the question: do you want to have the timestamp updated, or do you want to leave it be? RTFM: 6.2.2.2 The DATETIME, DATE, and TIMESTAMP Types ... The TIMESTAMP column type provides a type that you can use to automatically mark INSERT or UPDATE operations with the current date and time. If you have multiple TIMESTAMP columns, only the first one is updated automatically. Automatic updating of the first TIMESTAMP column occurs under any of the following conditions: The column is not specified explicitly in an INSERT or LOAD DATA INFILE statement. The column is not specified explicitly in an UPDATE statement and some other column changes value. (Note that an UPDATE that sets a column to the value it already has will not cause the TIMESTAMP column to be updated, because if you set a column to its current value, MySQL ignores the update for efficiency.) You explicitly set the TIMESTAMP column to NULL. If you want to retain the original value, then you need to use the opposite of clause 2! Regards, =dn timestamp is automatically updated If one uses the timestamp data type for a column inside a table, when executing an update query on said table on a spesific record, will the timestamp column be updated as well or will it retain its first value? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 4.0.2 core file uploaded...
On Tuesday 12 February 2002 09:23 pm, you wrote: Sasha, I compressed it first, 'cause it was nearly 400MB in size. It's on the FTP site as mysqld.core.bz2. Jeremy - in case you are wondering why it is taking me so long to reply - we've made a mess on our Linux build machine before the release of 3.23.48 and it got linked against a problematic library. Because of that, we've decided to redo the Linux build system to make it more fool-proof, and I've been busy with that in the last couple of days. -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
information on mysql 4.0.2
I see people speaking about mysql 4.0.2... but where you get it? they write some thing about it on web page but 4.0.2 is not in the download list... maybe someone can say if mysql 4 is stable? I mean if I can use it without 100 crash in 1 hour :) Sorry for bad english :) Jean-Francois Dionne - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: information on mysql 4.0.2
On Fri, Feb 15, 2002 at 08:03:19PM -0500, Jean-Francois Dionne wrote: I see people speaking about mysql 4.0.2... but where you get it? they write some thing about it on web page but 4.0.2 is not in the download list... It's from the MySQL source tree. See this url: http://www.mysql.com/doc/I/n/Installing_source_tree.html for instructions. maybe someone can say if mysql 4 is stable? I mean if I can use it without 100 crash in 1 hour :) Parts of it are. But parts are not, and that's what we're talking about. In my case, we're testing the new replication code in 4.0.2 to make sure it is stable. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 8 days, processed 278,746,500 queries (381/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: information on mysql 4.0.2
So it's better using 4.0.1 of 4.0.2? Jean-Francois Dionne - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Jean-Francois Dionne [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, February 15, 2002 8:12 PM Subject: Re: information on mysql 4.0.2 On Fri, Feb 15, 2002 at 08:03:19PM -0500, Jean-Francois Dionne wrote: I see people speaking about mysql 4.0.2... but where you get it? they write some thing about it on web page but 4.0.2 is not in the download list... It's from the MySQL source tree. See this url: http://www.mysql.com/doc/I/n/Installing_source_tree.html for instructions. maybe someone can say if mysql 4 is stable? I mean if I can use it without 100 crash in 1 hour :) Parts of it are. But parts are not, and that's what we're talking about. In my case, we're testing the new replication code in 4.0.2 to make sure it is stable. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 8 days, processed 278,746,500 queries (381/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: information on mysql 4.0.2
Hi, No problem so far with mysql 4.0.x, no crash at all on a production server with a really high load. If you want to use mysql 4.0.2, take a look here : http://www.mysql.com/doc/I/n/Installing_source_tree.html Best Regards, Jocelyn Fournier Presence-PC - Original Message - From: Jean-Francois Dionne [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, February 16, 2002 2:03 AM Subject: information on mysql 4.0.2 I see people speaking about mysql 4.0.2... but where you get it? they write some thing about it on web page but 4.0.2 is not in the download list... maybe someone can say if mysql 4 is stable? I mean if I can use it without 100 crash in 1 hour :) Sorry for bad english :) Jean-Francois Dionne - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Unique index/primary key case-insensitive?
Hi Andreas, On Sat, 2002-02-16 at 08:52, Andreas Frøsting wrote: Why does MySQL have this strange behavoir, treating unique indexes case-insensitive? Can anyone explain MySQL's behaviour and how I do a workaround making unique indexes and primary keys case sensitive? I've been over the documentation a couple times now unable to find anything. It's a conceptual issue; what you are looking for is not directly related to indexes. Rather, the case sensitivity of a column (and any key taken from there) is dependent on the type of that column. If the type is char, then any operation on that column will by default be case-insensitive. This is actually noted in the manual too, when you look at the sections on CHAR and CREATE TABLE. If you want the column to be case-sensitive, define the column as BINARY CHAR. In your CREATE/ALTER TABLE statement: lala VARCHAR(20) BINARY NOT NULL. That should solve your problem 100% ! Regards, Arjen. -- Get MySQL Training Worldwide, http://www.mysql.com/training/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer, Trainer /_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia ___/ 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: [PHP] MySQL question...not sure if this is the correct forum to ask.
Wouldn't replace change all the entries in your table row, same effect as update? I believe the question is how to test which entry in a form has a new value and replace/update only that value in the table. If I have a form... __ |Employee Record Update| | | |ID No: 1234 | |Name:_| |Address: _| |Status: Married | | | |Submit| -- If I have this table... _ |idnonameaddressstatus| |-| |1234Peter45 street Single| |_| Which means I only want to replace the status and the name and address remains the same. How do you test w/c entries in the form have new values and change only those entries in the table? Peter, this is basically what your asking, right? I actually need to figure this one out myself so I would appreciate any info. thanks... luie What about REPLACE? http://www.mysql.com/doc/R/E/REPLACE.html 'REPLACE works exactly like INSERT, except that if an old record in the table has the same value as a new record on a unique index, the old record is deleted before the new record is inserted' Hi, Can the UPDATE statement have conditional check embedded in it? I have a page that displays a record (in a FORM format) that the user can change the information on each column. I want to check each column and see which has been changed and update the table for entries that were changed only. for each column data { if column is changed then update; else do nothing; } Maybe I am making this too complicated than it needs and just go ahead and update all of the columns regardless with the new values, regardless they are actually different or not. Thanks in advance, -Peter __ www.edsamail.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 will not run on Debian Linux version 2.4
or you can try... /usr/local/mysql# ./mysql start Christopher Thompson wrote: Prefix it with the path: /usr/local/mysql/mysqld start or whatever. On Friday 15 February 2002 3:16 pm, Mark M Jervis Jr. wrote: Hi, I am trying to install run MySQL version 3.23.43-pc-linux-gnu-i686. When I try to run it to finish installation and set up users, i get the following error: /usr/local/mysql# mysql start su: mysql: command not found I have also tried running MySQL with the mysqld start, mysqld, and mysql commands and all of them result in the same message. If you can help me I will be very grateful. Thank You, Mark __ www.edsamail.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: mysqld unexpectedly crashes
Hi John, On Sat, 2002-02-16 at 06:52, John D Siirola wrote: I am having trouble with Mysqld unexpectedly crashing. How-To-Repeat: Unfortunately, I do not know how to consistently cause the crash to repeat. Yeah, that's always a bit tricky; and can make it very hard for the developers to find the cause. However Release: mysql-3.23.47 (Source distribution) System: Linux fs 2.4.17 #1 SMP Wed Dec 26 11:55:14 EST 2001 i686 unknown Architecture: i686 gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-101) Compilation info: CC='gcc' CFLAGS='-O2 -march=i386 -mcpu=i686 Could you please try a binary distribution (from www.mysql.com) of the same 3.23.47 and let us know how you fare with that? Thanks. Regards, Arjen. -- Get MySQL Training Worldwide, http://www.mysql.com/training/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer, Trainer /_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia ___/ 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: Callbacks or External Procedures?
In Callbacks or External Procedures?, [EMAIL PROTECTED] wrote: Is there _any_ way to do something like Oracle's OCI callback functions? What I need to do: Whenever my MySQL database changes data (inserts, updates, whatever) I need to call some of my own code. Any ideas? You don't specify if you need to know the nature of the change. Simply monitor the database filesize. Need to know what changed? Cause a transaction/replication log to be generated, parse the log. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php