InnoDB crash repeated under 3.23.51...
Heikki, After a good 6-8 hours of runnning, the server just restarted itself (running the most recent build from the 3.23.xx tree, as you suggested). I got this message: InnoDB: Assertion failure in thread 42527756 in file ha_innobase.cc line 316 InnoDB: We intentionally generate a memory trap. InnoDB: Send a detailed bug report to [EMAIL PROTECTED] mysqld got signal 11; And then the stack trace, which resolved as: 0x807d764 handle_segfault__Fi + 428 0x824cc98 pthread_sighandler + 176 0x80cc16a innobase_commit__FP3THDPv + 174 0x80ceba6 innobase_report_binlog_offset_and_commit__FP3THDPvPcUx + 42 0x80c774c ha_report_binlog_offset_and_commit__FP3THDPcUx + 44 0x80b11d2 write__9MYSQL_LOGP15Query_log_event + 1346 0x8051a90 item_user_lock_release__FP3ULL + 548 0x807502d _._3THD + 277 0x807d444 end_thread__FP3THDb + 64 0x80830c1 handle_one_connection__FPv + 1109 I hope that's meaningful to you... The machine was doig about 800 - 1,000 queries per second when this happened. Most of them were *not* InnoDB, but some were. Let me know if there's any other data I can send you to help track this down. I'll probably convert my tables back to MyISAM soon. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.51: up 0 days, processed 318,464 queries (1061/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
synopsis of the problem (one line)
Description: How-To-Repeat: Fix: Submitter-Id: submitter ID Originator:MySQL server Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release: mysql-3.22.32 (Source distribution) Environment: System: Linux mhn.kansai.nttcom.co.jp 2.2.18-1 #1 Wed Jan 17 20:25:02 JST 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/i586-pc-linux/2.95.2/specs gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS='-O6 -fomit-frame-pointer' CXX='g++' CXXFLAGS='-O6 -fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' Configure command: ./configure --host=i686-pc-linux-gnu --enable-assembler --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/share/info --includedir=/usr/include --mandir=/usr/share/man Perl: This is perl, version 5.005_03 built for i386-linux - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Error 1114 when import mysqldump in InnoDB table
Thanks Luciano. It works. Iago. -Mensaje original- De: Luciano Barcaro [mailto:[EMAIL PROTECTED]] Enviado el: martes 28 de mayo de 2002 19:21 Para: Iago Sineiro CC: MySql Mail List Asunto: Re: Error 1114 when import mysqldump in InnoDB table Hi, the internal space for innodb is full... create new extends (add another ibdata file and restart the mysql) to see how much space is free, execute the command: show table status like 'yourtableinnodb' Iago Sineiro wrote: Hi all. I import a mysqldump from MyISAM database in a new innodb database. It gives me an error saying that the table is full ERROR 1114 at line 3035: The table 'LALBARANPR' is full These are the values for the innodb variables in the my.cnf file: innodb_data_file_path = ibdata1:2000M;ibdata2:2000M innodb_data_home_dir = /mysql/ innodb_log_group_home_dir = /mysql/ innodb_log_arch_dir = /mysql/ set-variable = innodb_mirrored_log_groups=1 set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=5M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 innodb_log_archive=0 set-variable = innodb_buffer_pool_size=16M set-variable = innodb_additional_mem_pool_size=2M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 What could I do? Thanks in advance. Iago. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- -- \|/ __\|/ `@ / o . \ @' Microsoft? Por acaso é alguma nova /___| \/ |___\ marca de papel higiênico? \___U__/ .^. Luciano Barcaro - Linux User # 99517 /v\ Registre-se gratuitamente em // \\http://counter.li.org //(.)\\ ICQ # 17266954 ^`~'^ -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
does my mysql/os version affects stability of my DBFiles?
MySQL Version: 3.23.48-log OS/RedHat 7.2 / gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-98) Hi, this are the versions of my mysql and OS, i compiled them thru source. I am aware of the problem that exists on mysql ver 3.23.49 and w/ gcc version 2.96. So i de-graded by only 1 version of mysql, Is this advisable?. Your help is very much appreciated. ty, louie... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Powerbuilder and Mysql
Hi to all, I am new in MYSQL.I use powerbuilder 6.5.1 with Mysql (v.4.01 with Innodb tables) and I am not sure if the compatiblility is good enough. No rows are returned during retrieve of a datawindow with retrieval arguments. Can anyone help me? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 is released mysql 3.23.50?
Hi all. When is released mysql 3.23.50? I received in the announce mail list an announce of a pre-release of mysql 3.23.50 one month ago. This release has some enhancements on InnoDB table type (specially the autoexten capability). The announcement mail says than this prerelease it will moved to standard download page in a week. Iago. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Weird optimization problem when using same table multiple times in query
Hi all, I'm developing financial analysis app in MySQL. Since I want it to be portable and purely client-server I'm coding (nearly) all calculations in SQL, and came across weird optimization issue. The following query calculates one of my ratios using financial data from TQRPE table (some 5K records), and RPDTE tables (contain date codes, 2-3 records): select r1.rpco,min(r2.coeff)*(sum(t1.ams)-sum(t4.ams))/((sum(t2.ams)+sum(t3.ams))/2 ) from rpdte_full r1,rpdte_ann r2,tqrpe t1,tqrpe t2,tqrpe t3,tqrpe t4 where r1.rpco=r2.rpco and r1.rpco=t1.rpco and t1.rpco=t2.rpco and r1.prev_rpco=t3.rpco and t1.rpco=t4.rpco and t1.prcode like I% and (t2.prcode like E% or t2.prcode like N%) and (t3.prcode like E% or t3.prcode like N%) and t4.prcode like XF% group by r1.rpco Explain produces following results: table,type,possible_keys,key,key_len,ref,rows,Extra t4,range,PRIMARY,prcode,prcode,5,NULL,28,where used; Using temporary t1,ref,PRIMARY,prcode,PRIMARY,4,t4.rpco,6,where used t2,ref,PRIMARY,prcode,PRIMARY,4,t1.rpco,6,where used r1,eq_ref,PRIMARY,PRIMARY,4,t1.rpco,1, t3,ref,PRIMARY,prcode,PRIMARY,4,r1.prev_rpco,6,where used r2,eq_ref,PRIMARY,PRIMARY,4,r1.rpco,1, Weird thing is that t1...t3 tables are scanned using primary key while for t4 MySQL uses non-unique PRCODE index. As a result the query takes some 30sec to complete (which is unacceptable). Similar queries with just 3 tables (t1...t3) are used to calculate simpler ratios and complete in a wink. Any help appreciated! Table structures below Peter CREATE TABLE `tqrpe` ( `rpco` varchar(4) NOT NULL default '', `prcode` varchar(5) NOT NULL default '', `ams` double default NULL, PRIMARY KEY (`rpco`,`prcode`), KEY `prcode` (`prcode`) ) TYPE=MyISAM; CREATE TABLE `rpdte_ann` ( `rpco` varchar(4) NOT NULL default '', `coeff` double default NULL, PRIMARY KEY (`rpco`) ) TYPE=MyISAM; CREATE TABLE `rpdte_full` ( `rpco` varchar(4) NOT NULL default '', `rpdte` date default NULL, `prev_rpco` varchar(4) default NULL, PRIMARY KEY (`rpco`) ) TYPE=MyISAM; - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InnoDB crash repeated under 3.23.51...
On Wed, May 29, 2002 at 12:13:49AM -0700, Jeremy Zawodny wrote: Heikki, After a good 6-8 hours of runnning, the server just restarted itself (running the most recent build from the 3.23.xx tree, as you suggested). Just for the record, it happened again. So it's reproducable to a dregree. Again, it died on: ut_a(trx-magic_n == TRX_MAGIC_N); in the code. Same stack trace. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.51: up 0 days, processed 63,534 queries (547/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
Tab delimited dump?
Does anyone have a way to export data from a table into a tab delimited text file? Can't seem to see the option in mysqldump. For bonus points - how could I achieve this via PHP?(!) TIA, ollie or-media.com | design | online | interactive | 3d | animation | video +44 (0) 207 394 1072 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Tab delimited dump?
http://phpmyadmin.sourceforge.net/ /Peter - Original Message - From: ollie [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED] Sent: Wednesday, May 29, 2002 11:57 AM Subject: Tab delimited dump? Does anyone have a way to export data from a table into a tab delimited text file? Can't seem to see the option in mysqldump. For bonus points - how could I achieve this via PHP?(!) TIA, ollie -- -- or-media.com | design | online | interactive | 3d | animation | video +44 (0) 207 394 1072 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
SubQueries
Hi All i am running MySql 3.23.49 Max on Win 2K Does this version of MySQL supports subqueries. Also does this support transaction.. Where can i get the details reg this.. Regards, Arul - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InnoDB crash repeated under 3.23.51...
Jeremy, I think this happens because the InnoDB transaction handle has already been freed in end_thread when MySQL still writes one log item for the connection. Please test the following patch. Replace the function innobase_close_connection with the one below. I forgot to set innobase_tid to NULL when the handle is freed. Best regards, Heikki /* Frees a possible InnoDB trx object associated with the current THD. */ int innobase_close_connection( /*==*/ /* out: 0 or error number */ THD* thd) /* in: handle to the MySQL thread of the user whose transaction should be rolled back */ { if (NULL != thd-transaction.all.innobase_tid) { trx_rollback_for_mysql((trx_t*) (thd-transaction.all.innobase_tid)); trx_free_for_mysql((trx_t*) (thd-transaction.all.innobase_tid)); thd-transaction.all.innobase_tid = NULL; } return(0); } - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, May 29, 2002 10:13 AM Subject: InnoDB crash repeated under 3.23.51... Heikki, After a good 6-8 hours of runnning, the server just restarted itself (running the most recent build from the 3.23.xx tree, as you suggested). I got this message: InnoDB: Assertion failure in thread 42527756 in file ha_innobase.cc line 316 InnoDB: We intentionally generate a memory trap. InnoDB: Send a detailed bug report to [EMAIL PROTECTED] mysqld got signal 11; And then the stack trace, which resolved as: 0x807d764 handle_segfault__Fi + 428 0x824cc98 pthread_sighandler + 176 0x80cc16a innobase_commit__FP3THDPv + 174 0x80ceba6 innobase_report_binlog_offset_and_commit__FP3THDPvPcUx + 42 0x80c774c ha_report_binlog_offset_and_commit__FP3THDPcUx + 44 0x80b11d2 write__9MYSQL_LOGP15Query_log_event + 1346 0x8051a90 item_user_lock_release__FP3ULL + 548 0x807502d _._3THD + 277 0x807d444 end_thread__FP3THDb + 64 0x80830c1 handle_one_connection__FPv + 1109 I hope that's meaningful to you... The machine was doig about 800 - 1,000 queries per second when this happened. Most of them were *not* InnoDB, but some were. Let me know if there's any other data I can send you to help track this down. I'll probably convert my tables back to MyISAM soon. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.51: up 0 days, processed 318,464 queries (1061/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
How see InnoDB messages at startup mysql server?
Hi all. Anybody knows how to see innodb messages at startup or shutdown of mysql server? Is there any log of messages? Thanks in advance. Iago. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Index on unique/primary key
Hello! specifying a column as unique or primary in MySQL creates indices automatically or do we need to do it explicitly using INDEX(unique/primary_colname) in CREATE TABLE command of MySQL?? Thanx in advance.. Ritu Singla Everything you always wanted to know about cars and bikes,now at: http://in.autos.yahoo.com/cricket/tracker.html Everything you always wanted to know about cars and bikes,now at: http://in.autos.yahoo.com/cricket/tracker.html - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How see InnoDB messages at startup mysql server?
u can see the InnoDB messages in 'hostname.err' file in the data dir. On Wed, 29 May 2002, Iago Sineiro wrote: Hi all. Anybody knows how to see innodb messages at startup or shutdown of mysql server? Is there any log of messages? Thanks in advance. Iago. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Log Files in InnoDB
Hello, i could not understand what is the content of log files in InnoDB in MySQL...is it the log of the database,i mean, the data, or the transaction log?? Thanx in advance.. Ritu Singla Everything you always wanted to know about cars and bikes,now at: http://in.autos.yahoo.com/cricket/tracker.html Everything you always wanted to know about cars and bikes,now at: http://in.autos.yahoo.com/cricket/tracker.html - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Index on unique/primary key
On Wed, 29 May 2002 11:24:36 +0100 (BST) ritu singla [EMAIL PROTECTED] wrote: Hello! specifying a column as unique or primary in MySQL creates indices automatically or do we need to do it explicitly using INDEX(unique/primary_colname) in CREATE TABLE command of MySQL?? yes, you have to explicitly define the primary key/uniq in table creation query ... :D -- Avoid the Gates of Hell. Use Linux -- unknown source - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Fw: InnoDB crash repeated under 3.23.51...
Jeremy, it looks like this crash can happen if you use MySQL 'user level locks' which are kind of semaphores. In that case MySQL will write a binlog entry even after THD::cleanup where the transaction handle is freed. From the manual: You can also solve some cases by using the user-level lock functions GET_LOCK() and RELEASE_LOCK(). I believe the patch below to ha_innobase.cc fixes the problem. Regards, Heikki - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, May 29, 2002 1:16 PM Subject: Re: InnoDB crash repeated under 3.23.51... Jeremy, I think this happens because the InnoDB transaction handle has already been freed in end_thread when MySQL still writes one log item for the connection. Please test the following patch. Replace the function innobase_close_connection with the one below. I forgot to set innobase_tid to NULL when the handle is freed. Best regards, Heikki /* Frees a possible InnoDB trx object associated with the current THD. */ int innobase_close_connection( /*==*/ /* out: 0 or error number */ THD* thd) /* in: handle to the MySQL thread of the user whose transaction should be rolled back */ { if (NULL != thd-transaction.all.innobase_tid) { trx_rollback_for_mysql((trx_t*) (thd-transaction.all.innobase_tid)); trx_free_for_mysql((trx_t*) (thd-transaction.all.innobase_tid)); thd-transaction.all.innobase_tid = NULL; } return(0); } - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, May 29, 2002 10:13 AM Subject: InnoDB crash repeated under 3.23.51... Heikki, After a good 6-8 hours of runnning, the server just restarted itself (running the most recent build from the 3.23.xx tree, as you suggested). I got this message: InnoDB: Assertion failure in thread 42527756 in file ha_innobase.cc line 316 InnoDB: We intentionally generate a memory trap. InnoDB: Send a detailed bug report to [EMAIL PROTECTED] mysqld got signal 11; And then the stack trace, which resolved as: 0x807d764 handle_segfault__Fi + 428 0x824cc98 pthread_sighandler + 176 0x80cc16a innobase_commit__FP3THDPv + 174 0x80ceba6 innobase_report_binlog_offset_and_commit__FP3THDPvPcUx + 42 0x80c774c ha_report_binlog_offset_and_commit__FP3THDPcUx + 44 0x80b11d2 write__9MYSQL_LOGP15Query_log_event + 1346 0x8051a90 item_user_lock_release__FP3ULL + 548 0x807502d _._3THD + 277 0x807d444 end_thread__FP3THDb + 64 0x80830c1 handle_one_connection__FPv + 1109 I hope that's meaningful to you... The machine was doig about 800 - 1,000 queries per second when this happened. Most of them were *not* InnoDB, but some were. Let me know if there's any other data I can send you to help track this down. I'll probably convert my tables back to MyISAM soon. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.51: up 0 days, processed 318,464 queries (1061/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: Date Question
Ed, Wednesday, May 29, 2002, 2:24:40 AM, you wrote: EL I'm not sure how to phrase this. Please excuse the crudeness of my description. EL I'm storing calendar data in a MySQL database and I'm wondering, is there a EL way to specify a day, such as the 28th, and fourth Tuesday as search EL criteria when selecting rows from a table with a field of type date? EL Or... EL Another approach, is there a way to tell what week and day a given date EL falls on? For example, is there a way to find out that today, the 28th, is EL the 4th Tuesday and select all rows that meet this criteria? Take a look at date and time functions: http://www.mysql.com/doc/D/a/Date_and_time_functions.html It may help you. F.e. if you want to retrieve rows where day is 'Tuesday' you can do: SELECT * FROM table_name WHERE DAYNAME(mydate)='Tuesday'; -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Date Format
Trevor, Wednesday, May 29, 2002, 3:29:43 AM, you wrote: TF Running MYSQL 3.23 can the date mmdd be reversed when using Access or VB TF frontend so that users can enter it as they are used to eg. ddmm. MySQL stores data in mmdd format, but you can use DATE_FORMAT() function to display data in different format: http://www.mysql.com/doc/D/a/Date_and_time_functions.html TF Also I TF tried creating a new field for date using DATE(8) BUT the sql statement came TF back with an error. I tried changing the format of the date field to 8 TF characters but the change did not work I still get mmddhhmmss. Any TF ideas? It's not a recognized format for DATE column type, look at: http://www.mysql.com/doc/D/a/Date_and_time_types.html TF regards TF Trevor -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: SubQueries
Arul, Wednesday, May 29, 2002, 1:05:02 PM, you wrote: A i am running MySql 3.23.49 Max on Win 2K A Does this version of MySQL supports subqueries. Nope. How to re-write queries read in our manual: http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html A Also does this support transaction.. MySQL has transaction-unsafe table types(ISAM, MyISAM, HEAP) and transaction-safe tables (InnoDB, BDB). So, if you want to use transactions you should install MySQL server with InnoDB or BDB support. http://www.mysql.com/doc/T/a/Table_types.html If you install MySQL from the source distribution you should configure MySQL with --with-innodb option or --with-berkeley-db option. If you use binary distribution, you should install MySQL-Max: http://www.mysql.com/doc/m/y/mysqld-max.html A Where can i get the details reg this.. In the MySQL manual: http://www.mysql.com/documentation/index.html A Regards, A Arul -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Installation
weng, Wednesday, May 29, 2002, 2:15:11 AM, you wrote: wc Thanks for your prompt reply! wc Egor Egorov wc actually i alrdy followed the manual..the error is wc whenever i type in the command prompt - mysqld-nt wc -install FAILURE TO START SERVICE is the error i wc encounter.. but if i run type net start mysql its wc alrdy started. wc This is the only problem that ive encountered and i wc think this is the reason why i cant view my PHP file wc in IE properly.. If you start MySQL server from MS DOS prompt as: C:\mysql\binmysqld-nt --standalone --debug mysqld shows you warning message. wc Ma., wc Tuesday, May 28, 2002, 7:09:37 AM, you wrote: MRC hi! im a newbie.. ive installed both mysql and wc php MRC under windows 2000.. and ive tried the command MRC mysqld-nt -install.. and it didnt work, only the wc net MRC start mysql worked.. and i cant run php or browse wc in MRC IE .. wc Can you provide more info about what exactly doesn't wc work? MRC pls help.. MRC Thanks.. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Index on unique/primary key
ritu, Wednesday, May 29, 2002, 1:24:36 PM, you wrote: rs specifying a column as unique or primary in MySQL rs creates indices automatically or do we need to do it rs explicitly using INDEX(unique/primary_colname) in rs CREATE TABLE command of MySQL?? PRIMARY and UNIQUE are indexes. Look at: http://www.mysql.com/doc/M/y/MySQL_indexes.html You can also find info in the Paul's book at page 152. rs Thanx in advance.. rs Ritu Singla -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Log Files in InnoDB (MySQL)
- Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: ritu singla [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, May 29, 2002 2:31 PM Subject: Re: Log Files in InnoDB (MySQL) Ritu, the ib log files contain records of every change to database pages in the ibdata files. Thus all changes to data, and also all changes to disk-based transaction structures like undo logs in the ibdata files. Regards, Heikki Innobase Oy - Original Message - From: ritu singla [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, May 29, 2002 1:49 PM Subject: Log Files in InnoDB (MySQL) Hello, i could not understand what is the content of log files in InnoDB...is it the log of the database,i mean, the data, or the transaction log?? Thanx in advance.. Ritu Singla Everything you always wanted to know about cars and bikes,now at: http://in.autos.yahoo.com/cricket/tracker.html - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Loading BLOB into a MySQL-DB
Hello Outthere! Maybe this is a very simple question, but I'm a Rookie so lets see. I've tried to load BLOBs into my MySQL-DB, but I could not find a documentation how to do this. How can I load a BLOB, for example a PDF-File from my local filesystem into the database (which SQL-commands do I have to use or how can I do it via a JDBC-Connection)? Thanks, for help. Christian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Loading BLOB into a MySQL-DB
Christian, It's pretty easy, you can do it with a normal INSERT statement, all you've got to remember is that NUL (ascii 0) needs to be escaped as \0, and that double quotes and single quotes should also be escaped (i.e. \ and \'). Getting the data back again is even easier, because it'll unescape all the data for you. You just need to get the length of the field using mysql_fetch_field_direct() (since you can't assume it's just a NUL terminated string due to the fact that it may have NULs embedded in it). This is what I use to store Unicode characters in the database. You just can't sort on them, that's all :) Dean Harding. -Original Message- From: Christian Nebenfuehr [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 29 May 2002 9:32 pm To: [EMAIL PROTECTED] Subject: Loading BLOB into a MySQL-DB Hello Outthere! Maybe this is a very simple question, but I'm a Rookie so lets see. I've tried to load BLOBs into my MySQL-DB, but I could not find a documentation how to do this. How can I load a BLOB, for example a PDF-File from my local filesystem into the database (which SQL-commands do I have to use or how can I do it via a JDBC-Connection)? Thanks, for help. Christian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
fulltext - exact phrase
Hello I have a question, is possible to search on mysql 4.0 in fulltext index the exact phrase ? thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: fulltext - exact phrase
On Wed, May 29, 2002 at 02:10:07PM -0700, ddd wrote: I have a question, is possible to search on mysql 4.0 in fulltext index the exact phrase ? http://www.mysql.com/doc/F/u/Fulltext_Search.html suggests that it is possible. Here is the relevant excerpt: The boolean full-text search capability supports the following operators: ... The phrase, that is enclosed in double quotes , matches only rows that contain this phrase literally, as it was typed. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: fulltext - exact phrase
ddd, Thursday, May 30, 2002, 12:10:07 AM, you wrote: d I have a question, d is possible to search on mysql 4.0 in fulltext index d the exact phrase ? Phrase search will come in 4.0.2... d thanks -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Starting the Server at Boot Time ??
Peter, Wednesday, May 29, 2002, 4:39:52 AM, you wrote: PM I have just installed mysql 3.23.49 onto my Mandrake installation using the RPMs. PM How can I get the mysql server to start as the PC is booting ?? If you installed MySQL server from RPMs mysqld should automatically run at the boot time. In other cases you should put mysql.server.sh (found in the distrib directory support-files) into /etc/rc.d/init.d/ dir and create in the /etc/rc.d/rc3.d softlink on /etc/rc.d/init.d/mysql like cd /etc/rc.d/rc3.d ln -s ../init.d/mysql ./S99mysql PM Pete -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Select data that has no related categories...
Victor, Wednesday, May 29, 2002, 12:01:31 AM, you wrote: VSA Tells a great deal about how confused I am... VSA I've a database with three tables, one with image data, one with VSA categories and one table which helps me to have several categories per VSA image... VSA The following SQL gives me _all_ the images that has at least one VSA category associated: VSA SELECT images.filename, images.path, images.desc, categories.name FROM VSA images, relate, categories WHERE public = 1 AND relate.fromid = VSA images.id AND relate.toid = categories.id VSA But what I need help with is getting all the images that has no VSA categorie associated with them in the table relate... Something like that: SELECT images.filename, images.path, images.desc FROM images LEFT JOIN relate ON images.id=relate.fromid WHERE relate.fromid IS NULL; VSA Someone, please... VSA Sincerely, VSA Victor -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
database restore - please help
I deleted my database today by mistake and I have a backup from yesterday made as follows: mysqldump -A backup.txt How can I restore this database? Thanks for your help in advance. Scott - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Loading BLOB into a MySQL-DB
Hi Chris, See the code how load BLOB into a MySQl String saveSql = INSERT INTO Table (DataCol) VALUES (?) try { bos = new ByteArrayOutputStream(); oos = new ObjectOutputStream(new BufferedOutputStream(bos)); fileObj.writeObjectData(oos); oos.close(); byte[] obs = bos.toByteArray(); int size = obs.length; bis = new ByteArrayInputStream(obs, 0, size); in = new BufferedInputStream(bis, size); if(preparedSaveSql == null) preparedSaveSql = _conn.prepareStatement(saveSql); preparedSaveSql.setBinaryStream(1, in, size); preparedSaveSql.execute(); } catch(SQLException e) { } Regards Daya Krishan Dubey Core Solucomm Ltd 423 B, Hamilton court, DLF phase IV Gurgaon, India Ph No :- 6392896/7 (O) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: database restore - please help
You should be able to do this: mysql backup.txt -Original Message- From: Hathaway, Scott L [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 8:49 AM To: Mysql (E-mail) Subject: database restore - please help I deleted my database today by mistake and I have a backup from yesterday made as follows: mysqldump -A backup.txt How can I restore this database? Thanks for your help in advance. Scott - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: database restore - please help
You wrote:: deleted my database today by mistake and I have a backup from yesterday made as follows: mysqldump -A backup.txt How can I restore this database? Thanks for your help in advance. Scott Do get the backup write the command mysql databasename backup.txt Regards Daya Krishan Dubey Core Solucomm Ltd 423 B, Hamilton court, DLF phase IV Gurgaon, India Ph No :- 6392896/7 (O) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL not connecting over 110
Hallo I cant use phpMyAdmin, or any of my other (php) pages as I get the error cannot connect to MySQL via 110 (111) I had this in the past and what I did then was to check if mysql.sock was in the temp directory (or a link to it) I do see it there now but I cant seem to get any connection to MySQL, I have my.cnf file in /etc and all the settings there point to the correct locations, I have also checked my php.ini file and that also seems fine. It all worked fine before but now it does not - I have even rebooted the machine. I know this is not a lot to work from so if you need any more info to assist me let me know what to supply. Anton - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
multi site replication - thoughts and advice please
Hi, I am about to set up a network which has a central main server, and several (up to 30) shop servers (it is for a retail chain). I'm intending to link install mysql on all of them and link them up using the method described below. What I'd like to know is (a.) Can anyone see a fatal flaw in my plan, (b.) Can anyone suggest a better way), and (c.)Is there anything i should watch out for ? Requirement: Certain tables in the database must be replicated round all of the shops, so that changes e.g. in prices made on a central server can cascade out the shop servers, and also changes to stock levels, messages etc made in one shop are copied to the other shops and the main server. The main server will always be online, and the shops will connect to the Internet via DSL or Dialup/ISDN. Here's the plan: I will configure each of the servers to be both a master and a slave (same as for normal two way replication betweem to machines) In the slave settings on the shop servers, the master will always be set to the main central server. I will have a script running on the main server that executes a CHANGE MASTER TO each of the shop servers periodically. This way, in theory, the changes will propagate round whenever the cycle is completed. I'd appreciate your thoughts! Thanks in advance, Iain Gray - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
installing mysqladmin and mysql bins missing
ok. my admin guy installed the linux rpm of mysql. however, i can't locate the mysqladmin and mysql bins. do i have to install an additional rpm that include those? Luke - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Fulltext search - several tables
Peter, Tuesday, May 28, 2002, 7:10:28 PM, you wrote: PE How can I do a fulltext search on several tables PE with just one SQL query? You can use full-text search in boolean mode on several tables without full-text index. SELECT * FROM table1, table2 WHERE MATCH(table1.column1, table2.column2) AGAINST('searchword' IN BOOLEAN MODE); PE Best regards PE /Peter -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: installing
Christopher, Wednesday, May 29, 2002, 5:18:25 PM, you wrote: CLW ok. my admin guy installed the linux rpm of mysql. however, i can't locate CLW the mysqladmin and mysql bins. do i have to install an additional rpm that CLW include those? Yes, you should install MySQL-client package. You can find it on the MySQL website: http://www.mysql.com/downloads/index.html CLW Luke -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Automatic Primary Key for circular table
Hi,, I'm looking for a way to create a table with a ID columns (PRIMARY KEY) generated automatically... The only probleme is that i cannot use a AUTO_INCREMENT field because I have thousand of lines added each day (and all lines older than a week are deleted)With AUTO_INCREMENT, one day or another I'll reach the size limit of the ID field ;-) I could also use a timestamp as a primary key, but i have over 15 process running at the same time that could make an INSERT query during the same second, so a timestamp in second is not enough ;-( I'm simply looking for a way to tell Mysql to use the first free value in the valid range of the field to use as a Primary Key (Ex: specify a INT as the ID and make MySQL take the first available integer in the INT range as the ID) Any Idea ??? / Jonathan Pelletier \ \ B.ing Informatique / / Matrox Electronic Systems Ltd. \ \ MIS / Département des systèmes -- Groupe Unix / / \ \ 1055 Blv. St-Regis Tel: (514) 822-6000 x.7589/ / Dorval (Quebec) Fax: (514) 822-6262 \ \ H9P 2T4 Email: [EMAIL PROTECTED]/ / http://www.matrox.com \ \ / /Home: [EMAIL PROTECTED] \ \/ _ ASCII ribbon campaign ( ) - against HTML email X vcards / \ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: database restore - please help
Since I did the backup with a |, it appended. I had to go through the file and remove the older instances of the backups and then it worked ok. Thanks for the help! You all saved me. Scott -Original Message- From: D.K.Dubey [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 9:14 AM To: Hathaway, Scott L Subject: Re: database restore - please help Hi Scott, One more simple way..u should have the mysql back ..copy the dir from \mysql\data (Old dir ) having name of the database. Copy to the new \mysql\data (current). Or delete the dir having name as database name cut that dir and place somewhere else for safe. Now run the script using given command. If still problem then open the backup.txt and delete that code having name of table for which showing error then run the query. Regards Daya Krishan Dubey Core Solucomm Ltd 423 B, Hamilton court, DLF phase IV Gurgaon, India Ph No :- 6392896/7 (O) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL not connecting over 110
- Original Message - From: Anton [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, May 29, 2002 3:51 PM Subject: MySQL not connecting over 110 Hallo I cant use phpMyAdmin, or any of my other (php) pages as I get the error cannot connect to MySQL via 110 (111) Well, that 110 better be an error-code; cuz if it is a port, then you can wait a long, long time for any MySQL server to appear there. :) Port 110 is used for POP. Try a more common approach, and connect to port 3306. - 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
LOAD DATA LOCAL INFILE problem with MySQL 4.0.1-alpha on RH7.3
Hi list! I have a problem when trying to read data into tables with LOAD DATA LOCAL INFILE. I get this error: ERROR 2013: Lost connection to MySQL server during query When looking at the MySQL site it says that I should increase the max_allowed_packet=# option (default 1M). However, my file is not that big, since it is only 226 byte. It also suggests that I should check the uptime of the mysqld, so I can verify that it hasn't crashed. issuing the 'mysqladmin version' command gives this: Server version 4.0.1-alpha Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 22 hours 22 min 52 sec so, the server hasn't crashed... I am not 100% sure if I am starting mysqld in the correct manner however. The my.cnf for the server is in /var/lib/mysql/my.cnf, which looks like this: [client] port= 3306 host= localhost [safe_mysqld] open-files-limit=8192 socket=/var/lib/mysql/mysql.sock max_allowed_packet=2M Probably this .cnf file is not sufficient, but I hope that somebody might help me in the right direction :) Thnx, Patrik Birgersson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Query question
This query seems to be quite easy, but I still cannot figure out how to do it. I have a randomly ordered table. And I want to SELECT that table by ORDERing it in specific row, and when I'm done I want to find out numeric position of a raw where the first raw is 1, second is 2 etc. Of course I could iterate over each row. But I want to do it for a specific raw only. Any ideas? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 with binary data in row
Michael Flora wrote: Hello all, I posted this question yesterday but received no feedback so I decided to ask again. I am new to MySQL and I am trying to access binary data stored in a MySQL table using a C program. The table looks like this: date date double firstfield double secondfield double thirdfield My C code looks like this: double first; double second; . . . row = mysql_fetch_row(result); first = *row[1]; . . . Since a row is supposed to be returned as an array of pointers I should be able to dereference to get the field value, right? However I get nothing but junk. What am I doing wrong? Thanks for any suggestions, Michael Flora Please see http://www.mysql.com/doc/C/_/C_API_datatypes.html mysql_fetch_row() returns type MYSQL_ROW, which is an array of byte-strings. You will need to use the C library function atod() to change it into a double. -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: Automatic Primary Key for circular table
I'm looking for a way to create a table with a ID columns (PRIMARY KEY) generated automatically... The only probleme is that i cannot use a AUTO_INCREMENT field because I have thousand of lines added each day (and all lines older than a week are deleted)With AUTO_INCREMENT, one day or another I'll reach the size limit of the ID field ;-) If you are adding one line per second (which is significantly more than your thousands per day) and you make the ID BIGINT UNSIGNED, you will run out of IDs after something over 500 billion years. May I suggest firstly that if the system goes wrong after this time, it will be Someone Else's Problem, and secondly, that in the intervening millennia, it is highly likely that the MySQL team will have implemented 128 bit INTS, which will allow a simple ALTER TABLE to postpone your problem until after the universe has ended (if it hasn't already). At one new line per second, even a 32-bit INT UNSIGNED will last over a century. If I take your thousands of lines per day at face value and assume 10,000 lines per day, you get over a thousand years before 32 bits run out. When you do run out, ALTER TABLE will add a few more billions of years. Alec Cawley - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 with binary data in row
Hi, mysql_fetch_row returns a MYSQL_ROW, that is an array of byte strings. look at http://www.mysql.com/doc/C/_/C_API_datatypes.html Frederic - Original Message - From: Michael Flora [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, May 29, 2002 5:32 PM Subject: Problem with binary data in row Hello all, I posted this question yesterday but received no feedback so I decided to ask again. I am new to MySQL and I am trying to access binary data stored in a MySQL table using a C program. The table looks like this: date date double firstfield double secondfield double thirdfield My C code looks like this: double first; double second; . . . row = mysql_fetch_row(result); first = *row[1]; . . . Since a row is supposed to be returned as an array of pointers I should be able to dereference to get the field value, right? However I get nothing but junk. What am I doing wrong? Thanks for any suggestions, Michael Flora - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Compiling On Tru64
I am trying to compile MySQL 3.23.49 on the following system: Compaq Tru64 Version 5.1 1885 alpha gnu gcc 3.1 make 3.79 I keep getting the error shown below. Any trouble shooting insight will be greatly appreciated. Thanks Dean mv -f .libs/mf_cache.lo mf_cache.o (cd . ln -s mf_cache.o mf_cache.lo) /bin/sh ../libtool --mode=compile gcc -DDEFAULT_CHARSET_HOME=\/usr/local\ -DDATADIR=\/usr/local/var\ -DSHAREDIR=\/usr/local/share/mysql\ -DUNDEF_THREADS_HACK -DDONT_USE_RAID -I./../include -I../include -I./.. -I.. -I..-O3 -DDBUG_OFF -c getopt.c rm -f .libs/getopt.lo gcc -DDEFAULT_CHARSET_HOME=\/usr/local\ -DDATADIR=\/usr/local/var\ -DSHAREDIR=\/usr/local/share/mysql\ -DUNDEF_THREADS_HACK -DDONT_USE_RAID -I./../include -I../include -I./.. -I.. -I.. -O3 -DDBUG_OFF -c getopt.c -DPIC -o .libs/getopt.lo In file included from /usr/include/sys/socket.h:64, from ../include/global.h:370, from getopt.c:49: /usr/include/sys/uio.h:177:22: macro readv requires 3 arguments, but only 1 given /usr/include/sys/uio.h:178:23: macro writev requires 3 arguments, but only 1 given make[2]: *** [getopt.lo] Error 1 make[2]: Leaving directory `/user01/dgrimes/cdev/mysql-3.23.49/libmysql' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/user01/dgrimes/cdev/mysql-3.23.49' make: *** [all-recursive-am] Error 2 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Basic index questions
Hi, I am trying to learn about indexing and have a few questions. 1. Does index only apply to query that use = operator in the where clause? 2. Does operators such as , like and between will result to full table scan? 3. For example, In the following table: tbl_A id int primary key, flag1 char(1), amount float, signup_date date In a query has multiple condition in the where clause such as, select * from tbl_A where flag1 = 'y' and amount 10 and signup_date between '2002-02-01' and '2002-03-31'. If only the flag and signup_date field has index, will the index be use? 4. Where could I learn more about indexing? Thanks for helping. _ 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
Building a Shopping Cart with MySQL
Hi, I am new to this list and new to mySQL and PHP so please excuse the simplicty of my questions. Is it possible to create your own shopping cart program with just mySQL and PHP? Right now I am building a database for my companies new web page. I am looking to build an e-commerce site, but I prefer to build it myself as much as possible as opposed to buying a shopping cart program and what not. However, we are not hosting the site ourselves, so I do not have complete control over the back-end. I have two questions on this... 1) I am trying to build my own shopping cart. When building an orders database, is it possible to make room for an infinite number of items in the order? Right now I have a Field for Item, a Field for Quantity, and a field for Item Total. This constitutes one item line in the order. Do I need a seperate field for each item in one table? Would it be better to have a second table just for items in an order? If I did that what what would be a good way to link the two (ie. how would you pass the primary key from the Order table to individual lines of the Items table)? 2) The items we sell require a many to many relationship. I have not been able to find any information about many-many relationships in mySQL. Even when I was using access, I knew how to relate the tables using a junction table, but damned if I could figure out how to enter information easily like that. We sell Ink, Toner, and Ribbon. So, there are multiple inks that work in one machine, and multiple machines that use one ink. Do you link these in mySQL the same as you would in Acess? Is there a way to create a form using PHP that would be able to pass information to all three tables (Product, Machine, and Junction)? Any suggestions on this would be greatly appreciated as I have been going in circles with this for a while now. Thank you in advance for any help you can offer, Erin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Unable to drop database
I have an application database that I'm unable to drop after a period of running several applications against that are using the MySQL++ api. Wondering if anyone has seen this, if it's a known bug and/or if there is a fix. mysqladmin -uroot -p drop db and rm -rf /var/lib/mysql/dbname do succesfully remove the database it's just the mysql client has the problem. drop database returns ok but the database is still there (both show databases and ls -al /var/lib/mysql/dbname say so). Logging in to mysql with mysql -uroot -p to do the drop so it shouldn't be a user permission issue. The directory permissions and file permissions within seem fine too -rw---1 mysqlmysql dirname The database is largely unpopulated (10Mb) with about 50 tables (most of which are MyISAM with 2 or 3 HEAP tables). Linux redhat 7.2 rpms MySQL-Max-4.0.1-2 MySQL-4.0.1-2 MySQL-shared-4.0.1-2 MySQL-devel-4.0.1-2 MySQL-client-4.0.1-2 -- Scott Olson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Building a Shopping Cart with MySQL
[snip] Is it possible to create your own shopping cart program with just mySQL and PHP? [/snip] Yep. [snip] 1) I am trying to build my own shopping cart. When building an orders database, is it possible to make room for an infinite number of items in the order? [/snip] Ideally you should have tables for customer, order, products. Any basic SQL book uses this example to demonstrate examples. [snip] 2) The items we sell require a many to many relationship. I have not been able to find any information about many-many relationships in mySQL. Even when I was using access, I knew how to relate the tables using a junction table, but damned if I could figure out how to enter information easily like that. [/snip] While MySQL has some limitations dependent upon the version you are using most SQL related queries will work just as they did in Access. HTH! Jay - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Can I remove innobd binarie files?
Hi all. In the innodb directory I have these files (prototipo is the name of the computer): -rw-rw 1 mysql mysql 86 May 28 09:56 prototipo-bin.001 -rw-rw 1 mysql mysql 86 May 28 10:00 prototipo-bin.002 -rw-rw 1 mysql mysql 86 May 28 10:13 prototipo-bin.003 -rw-rw 1 mysql mysql 149 May 28 11:00 prototipo-bin.004 -rw-rw 1 mysql mysql 116 May 28 11:12 prototipo-bin.005 -rw-rw 1 mysql mysql 86 May 28 13:33 prototipo-bin.006 -rw-rw 1 mysql mysql 1074262897 May 28 16:11 prototipo-bin.007 -rw-rw 1 mysql mysql 260966772 May 28 17:58 prototipo-bin.008 -rw-rw 1 mysql mysql 1074322953 May 28 19:12 prototipo-bin.009 -rw-rw 1 mysql mysql 1074101557 May 28 20:43 prototipo-bin.010 -rw-rw 1 mysql mysql15064075 May 29 08:24 prototipo-bin.011 -rw-rw 1 mysql mysql 86 May 29 08:27 prototipo-bin.012 -rw-rw 1 mysql mysql 239076993 May 29 09:47 prototipo-bin.013 -rw-rw 1 mysql mysql 178 May 29 10:48 prototipo-bin.014 -rw-rw 1 mysql mysql 1074320875 May 29 11:49 prototipo-bin.015 -rw-rw 1 mysql mysql 1074100037 May 29 12:52 prototipo-bin.016 -rw-rw 1 mysql mysql15063821 May 29 13:08 prototipo-bin.017 -rw-rw 1 mysql mysql 86 May 29 13:22 prototipo-bin.018 -rw-rw 1 mysql mysql 86 May 29 17:15 prototipo-bin.019 -rw-rw 1 mysql mysql 177 May 29 17:23 prototipo-bin.020 -rw-rw 1 mysql mysql 73 May 29 17:23 prototipo-bin.021 -rw-rw 1 mysql mysql 420 May 29 17:23 prototipo-bin.index I suppose they are binarie files that contains updates of innodb tables. Some of them are very large. Can I remove innobd binarie files after shutdown mysql server? Is necessary prototipo-bin.index or I can remove it? Also which files is ib_arch_log_00? Thanks in advance. Iago. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MyODBC vs. iODBC
Hello, Can someone tell me what is the difference between MyODBC and iODBC? My understanding is that in order for an application to be able to talk to a database it needs a protocol, and that protocol would be ODBC. What I'm trying to do is have the Tango2000 application server (www.witango.com) communicate with MySQL server. -Hoa _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Does anyone know
when MySQL 4.0.2 will be out? We'd like to play around with InnoDB's autoextend feature on v.4. Thanks, --Walt Weaver Bozeman, Montana - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SQL query help
I've been trying to solve this problem for a couple of days now. I've only started with DB's a month ago so I am no expert in SQL. So, I present this problem to you guys in hopes of getting a solution. Thanks in advance, Mike = Question: = Using the query below I get the result set as shown below. Everything is correct except the Last Src and Last Dst fields. I'm getting the same values in Last Src and Last Dst that I have in First Src and First Dst. What I want shown is the First Time an event occurs along with the source and destination ips for that first time and the Last Time an event occurs along with the source and destination ips for that last time. The event and iphdr tables are related by the primary keys sid and cid which are present in both tables. The event and signature tables are related by event.signature and signature.sig_id. The timestamps for First and Last time are located in the event table whereas the ips that I want to correspond to the First and Last time are in the iphdr table. The query is grouped by signature.sig_name. I've tried using min and max (inet_ntoa(iphdr.ip_src)) etc. However, this gives me the largest ip address numerically (not a big surprise [:)] ). This is not what I want. == Query: == select count(*) as Count, min(event.timestamp) as First Time, inet_ntoa(iphdr.ip_src) as First Src, inet_ntoa(iphdr.ip_dst) as First Dst, max(event.timestamp) as Last Time, inet_ntoa(iphdr.ip_src) as Last Src, inet_ntoa(iphdr.ip_dst) as Last Dst from event, signature, iphdr where event.signature = signature.sig_id and event.sid = iphdr.sid and event.cid = iphdr.cid and signature.sig_name not like spp_portscan% group by signature.sig_name order by count desc; === Tables: === event - Field Type Null Key Default Extra sid int(10) unsignedPRI0 cid int(10) unsignedPRI0 signature int(10) unsignedMUL0 timestamp datetime MUL-00-00 00:00:00 signature - Field Type Null Key Default Extra sig_id int(10) unsignedPRINULLauto_increment sig_name varchar(255) MUL sig_class_id int(10) unsignedMUL0 sig_priority int(10) unsignedYESNULL sig_rev int(10) unsignedYESNULL sig_sid int(10) unsignedYESNULL iphdr - Field Type Null Key Default Extra sid int(10) unsignedPRI0 cid int(10) unsignedPRI0 ip_src int(10) unsignedMUL0 ip_dst int(10) unsignedMUL0 ip_ver tinyint(3) unsignedYESNULL ip_hlen tinyint(3) unsignedYESNULL ip_tos tinyint(3) unsignedYESNULL ip_len smallint(5) unsignedYESNULL ip_id smallint(5) unsignedYESNULL ip_flags tinyint(3) unsignedYESNULL ip_off smallint(5) unsignedYESNULL ip_ttl tinyint(3) unsignedYESNULL ip_proto tinyint(3) unsigned0 ip_csum smallint(5) unsignedYESNULL Result: Count First TimeFirst SrcFirst Dst 4621 2002-03-15 09:40:44192.168.1.21063.105.25.187 2798 2002-03-12 15:59:0524.60.17.13192.168.1.210 2275 2002-03-12 15:48:1312.125.139.54192.168.1.210 2103 2002-03-12 16:06:25195.30.18.4192.168.1.210 1507 2002-03-15 09:50:37199.230.29.74192.168.1.210 1118 2002-03-12 15:54:14208.185.54.14192.168.1.119 1109 2002-03-12 16:34:35192.168.1.21066.77.73.155 Last Time Last Src Last Dst 2002-03-20 09:20:23 192.168.1.21063.105.25.187 2002-03-20 10:50:38 24.60.17.13192.168.1.210 2002-03-20 11:06:09 12.125.139.54192.168.1.210 2002-03-20 11:16:09 195.30.18.4192.168.1.210 2002-03-20 10:31:08 199.230.29.74192.168.1.210 2002-03-20 10:46:29 208.185.54.14192.168.1.119 2002-03-20 11:02:12 192.168.1.21066.77.73.155 ... (snip) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MS Access 2000 and MySQL
Hello, I created a blank table in MS Access 2000 for recieving data from mysql and tried to compile importsql.txt in Access module but I still got the error saying user defined-type not defined. I copy pasted exportsql.txt to the module and got the same error. I have a coworker who told me she never had the problem with Access 97. Is this a problem related to Access 2000? If so, how can I work around it? Thank you in advance. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: MS Access 2000 and MySQL
Hi, This error make reference to a variable which is not correctly defined.I suppose that you have in routine which make import a variable like : Dim myvar as lon insted Dim myvar as long Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, May 29, 2002 9:29 PM Subject: MS Access 2000 and MySQL Hello, I created a blank table in MS Access 2000 for recieving data from mysql and tried to compile importsql.txt in Access module but I still got the error saying user defined-type not defined. I copy pasted exportsql.txt to the module and got the same error. I have a coworker who told me she never had the problem with Access 97. Is this a problem related to Access 2000? If so, how can I work around it? Thank you in advance. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Tab delimited dump?
SELECT cols FROM tbl INTO OUTFILE '/someflie'; ollie wrote: Does anyone have a way to export data from a table into a tab delimited text file? Can't seem to see the option in mysqldump. For bonus points - how could I achieve this via PHP?(!) TIA, ollie or-media.com | design | online | interactive | 3d | animation | video +44 (0) 207 394 1072 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 736-5160 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Discovering which foreign key constraint failed
Hello, I'm using InnoDB tables, is there a way to know which foreign key constraint was violated? Oracle gives me the constraint name in the error message, so that I can seek in the data dictionary. I'm porting an web application developed for Oracle to MySQL, so I need a solution with the smallest impact possible. Thank you a lot for the attention. Cesar - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mulitple uses of a foreign key
I was hoping for some help with this -- I'm not sure if I can use just one SQL statement to pull this data out, I think I need to use two separate statements. Can someone clarify for me? My tables: +-+ +---+ | people | | projects | +-+ +---+ | people_id |-| project_id| | people_name | | project_name | +-+ | canceler_id | | canceled_date | | finisher_id | | finished_date | +---+ In the projects table, a project will have a project_id, a project_name, and either a canceler_id and canceled_date or a finisher_id and finished_date. I would like to use a query to get the project name and the people name from the database WHERE projects.project_id = 8 AND projects.canceler_id = people.people_id, or projects.finisher_id = people.people_id, depending on whether the project was finished or canceled. But I also need to be able to determine from the query whether the project was finished or canceled. Thanks! Erik Erik Price Web Developer Temp Media Lab, H.H. Brown [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
Exceptions do not work .
Hi All, I am new to MySQL ( using on Solaris ) I wrote my first program to do the insertions in a table. If a row is already there then the program crashes instead of just throwing an exception. I have a catch (... ) handler also so I am sure that the Query.Execute (Insert.. ) is not throwing an exception, whereas it should. Anybody faced this problem before ?? Thanks in advance. Hitesh This message is for the named person's use only. It is not intended as an offer or solicitation for the purchase or sale of any financial instrument or as an official confirmation of any transaction. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SQL Complex Query problem
I have the following table; ++--+++ | id | wtn | dueDate| ageAmt | ++--+++ | 1 | 210-212-3871 | 2001-12-01 | 0.51 | | 2 | 210-212-3871 | 2001-12-01 | 0.49 | | 3 | 210-212-3871 | 2001-12-01 | 0.50 | | 4 | 210-212-3871 | 2002-01-01 | 1.32 | | 5 | 210-212-3871 | 2002-01-01 | 0.02 | | 6 | 210-212-3871 | 2002-01-01 | 3.54 | | 7 | 210-212-3871 | 2002-02-01 | 39.95 | | 8 | 210-212-3871 | 2002-02-01 | 0.03 | | 9 | 210-212-3871 | 2002-03-01 | 2.72 | | 10 | 210-212-3871 | 2002-03-01 | 0.51 | ++--+++ where I would like to query like this; select wtn, sum(if(dueDate between 2001-12-01 and 2001-12-30, ageAmt, 0)) AS +150, sum(if(dueDate between 2002-01-01 and 2001-01-30, ageAmt, 0)) AS +120, sum(if(dueDate between 2002-02-01 and 2001-02-28, ageAmt, 0)) AS +90, sum(if(dueDate between 2002-03-01 and 2001-03-30, ageAmt, 0)) AS +60, sum(if(dueDate between 2002-04-01 and 2001-04-30, ageAmt, 0)) AS +30 from tblAcctRec group by wtn; it returns; +--+--+--+--+--+--+ | wtn | +150 | +120 | +90 | +60 | +30 | +--+--+--+--+--+--+ | 210-212-3871 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | +--+--+--+--+--+--+ which is not right. Can anyone see what I'm doing wrong here? Thanks! Jay - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
TCP/IP Host setup
Hello, We currently have two MySQL server/clients running on a RH/Linux 6.2 box, 3.23.40(production) and 3.23.49(development) We would like to setup the .49 with a TCP/IP host instead of a socket. The .49 is using the port 3307, the default server hostname is justlightening.justlightening.net(216.118.81.2), but we would like to setup a hostname something like mysql.justlightening.net My question is, what is the best way to setup a hostname without using the default server hostname for a TCP/IP connection, and do we need to enable skip-networking(ON), right now it's OFF thanks, sql,mysql Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-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
Exceptions do not work .
Hi All, I am new to MySQL ( using on Solaris ) I wrote my first program to do the insertions in a table. If a row is already there then the program crashes instead of just throwing an exception. I have a catch (... ) handler also so I am sure that the Query.Execute (Insert.. ) is not throwing an exception, whereas it should. Anybody faced this problem before ?? Thanks in advance. Hitesh This message is for the named person's use only. It is not intended as an offer or solicitation for the purchase or sale of any financial instrument or as an official confirmation of any transaction. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Exceptions do not work .
hitesh_mittal@itginc.com wrote: Hi All, I am new to MySQL ( using on Solaris ) I wrote my first program to do the insertions in a table. If a row is already there then the program crashes instead of just throwing an exception. I have a catch (... ) handler also so I am sure that the Query.Execute (Insert.. ) is not throwing an exception, whereas it should. Anybody faced this problem before ?? Thanks in advance. Hitesh This message is for the named person's use only. It is not intended as an offer or solicitation for the purchase or sale of any financial instrument or as an official confirmation of any transaction. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php What language? What drivers/connectinvity options/versions? What MySQL version? What happens when you do the insert from the command-line client? Do you have primary keys or unique constraints? You need to answer all of these questions if you expect help. -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: Can I remove innobd binarie files?
sql reset master; Ric - Original Message - From: Iago Sineiro [EMAIL PROTECTED] To: MySql Mail List [EMAIL PROTECTED] Sent: Wednesday, May 29, 2002 6:14 PM Subject: Can I remove innobd binarie files? Hi all. In the innodb directory I have these files (prototipo is the name of the computer): -rw-rw 1 mysql mysql 86 May 28 09:56 prototipo-bin.001 -rw-rw 1 mysql mysql 86 May 28 10:00 prototipo-bin.002 -rw-rw 1 mysql mysql 86 May 28 10:13 prototipo-bin.003 -rw-rw 1 mysql mysql 149 May 28 11:00 prototipo-bin.004 -rw-rw 1 mysql mysql 116 May 28 11:12 prototipo-bin.005 -rw-rw 1 mysql mysql 86 May 28 13:33 prototipo-bin.006 -rw-rw 1 mysql mysql 1074262897 May 28 16:11 prototipo-bin.007 -rw-rw 1 mysql mysql 260966772 May 28 17:58 prototipo-bin.008 -rw-rw 1 mysql mysql 1074322953 May 28 19:12 prototipo-bin.009 -rw-rw 1 mysql mysql 1074101557 May 28 20:43 prototipo-bin.010 -rw-rw 1 mysql mysql15064075 May 29 08:24 prototipo-bin.011 -rw-rw 1 mysql mysql 86 May 29 08:27 prototipo-bin.012 -rw-rw 1 mysql mysql 239076993 May 29 09:47 prototipo-bin.013 -rw-rw 1 mysql mysql 178 May 29 10:48 prototipo-bin.014 -rw-rw 1 mysql mysql 1074320875 May 29 11:49 prototipo-bin.015 -rw-rw 1 mysql mysql 1074100037 May 29 12:52 prototipo-bin.016 -rw-rw 1 mysql mysql15063821 May 29 13:08 prototipo-bin.017 -rw-rw 1 mysql mysql 86 May 29 13:22 prototipo-bin.018 -rw-rw 1 mysql mysql 86 May 29 17:15 prototipo-bin.019 -rw-rw 1 mysql mysql 177 May 29 17:23 prototipo-bin.020 -rw-rw 1 mysql mysql 73 May 29 17:23 prototipo-bin.021 -rw-rw 1 mysql mysql 420 May 29 17:23 prototipo-bin.index I suppose they are binarie files that contains updates of innodb tables. Some of them are very large. Can I remove innobd binarie files after shutdown mysql server? Is necessary prototipo-bin.index or I can remove it? Also which files is ib_arch_log_00? Thanks in advance. Iago. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Auto increment (Newbie)
Hey there, I know this might sound like a stupid question to a lot of you guys out there but please keep in mind I come from an oracle background and am new to this: I am accessing MySql from PHP, I have two questions regarding Auto_Increment 1) how to create an auto_increment? create table MyTestTable(cno int, name varchar(20)); works fine, but I want cno as an auto_increment, what statement to use? 2)to insert int into my example I will use insert into MyTestTable(555,'Ryan'); How would I do it if I was entering data and the cno was an auto increment? I have glossed through the manual, but frankly after 6 hours of PHP programming i'm feeling braindead so PLEASE dont ask me to RTFM, if you have links to the specific topic in the manual no problem, just tired of searching. Cheers all, -Ryan. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Exceptions do not work .
Hi I am using -mysql 3.23.59, - Solaris 2.6 the program is in C++, using gnu C 2.95.3 . The table does have primary key constraint and the program should throw an exception when I try to insert and the the row aready exists, But instead It crashes. Any suggestions ?? Thanks Hitesh This message is for the named person's use only. It is not intended as an offer or solicitation for the purchase or sale of any financial instrument or as an official confirmation of any transaction. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
data warehousing
Hi guys, Does anyone have any thoughts on using MySQL for a datawarehousing application? Problems I've run in to are with mining data from a data warehouse because of the lack of sub-selects, stored procs, and views. Should I be looking more at InnoDB or MyISAM table types? any thoughts are appreciated, Don -- Don Vu Database Guy Madstone Films 85 fifth avenue, 12th floor new york new york 10003 p 212.989.4500 f 212.989.7744 www.madstonefilms.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
example connecting to database via socket instead of networking
Hi list, can someone here give me a quick and dirty example of how there connecting to a database via sockets? I see the data in the man page but I'm uncertain as to implementation. Thanks, justin Sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Time-out Error
Hi I am using mysql 3.2133b, Sun Solaris 2.6, JHTML and Apache. I have been getting Time-out requesting db connectionUnable to connect to database server where url was jdbc:z1MySQL://localhost:3306 error whenever the JHTML is initialized for the first time. It works fine when i click on the refresh button again. Any suggesstions? Thanks Ravi. _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Auto increment (Newbie)
manual_Reference.html#CREATE_TABLE create_definition: col_name type [NOT NULL | NULL] [DEFAULT default_value] [AUTO_INCREMENT] [PRIMARY KEY] [reference_definition] create table MyTestTable(cno int AUTO_INCREMENT, name varchar(20)); can't seem to find the ref right now, but insert into MyTestTable(555,'Ryan'); insert into MyTestTable (name) values ('Ryan'); or insert into MyTestTable values (null, 'Ryan'); On Thursday 30 May 2002 3:43, you wrote: Hey there, I know this might sound like a stupid question to a lot of you guys out there but please keep in mind I come from an oracle background and am new to this: I am accessing MySql from PHP, I have two questions regarding Auto_Increment 1) how to create an auto_increment? create table MyTestTable(cno int, name varchar(20)); works fine, but I want cno as an auto_increment, what statement to use? 2)to insert int into my example I will use insert into MyTestTable(555,'Ryan'); How would I do it if I was entering data and the cno was an auto increment? I have glossed through the manual, but frankly after 6 hours of PHP programming i'm feeling braindead so PLEASE dont ask me to RTFM, if you have links to the specific topic in the manual no problem, just tired of searching. Cheers all, -Ryan. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
FYI: @@IDENTITY
I don't know if this is just weirdness on my system but I thought I would pass this on in case anyone runs into this problem. I'm converting some Java/JDBC code from a commercial DBMS to MySQL. The existing code executed the SQL statement Select @@identity after an INSERT to retrieve the autoincrement value. But, MySQL would never return from this query -- just hang until I stopped and restarted the service. After some trial-and-error-and-error, I found that @@IDENTITY worked as expected but @@identity would cause this hang symptom. Moral of the story: don't use lower case letters in SELECT @@IDENTITY. Rick - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Eliminating downtime
Has anyone architected an oltp database using mysql where downtime is virtually eliminated? I understand it's fairly simple to set up a readonly system using mysql replication or another type of replication to maintain the uptime, but I have yet to see how to do this with a heavy transaction system. Basically what I want is a guaranteed insert or update. Has anyone had any luck setting up an environment where upgrades, regular maintenance, and other activities do not interupt service? Any pointers to products or documents that will help me with this are appreciated. Dave Turner - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Exceptions do not work .
hitesh_mittal@itginc.com wrote: Hi I am using -mysql 3.23.59, - Solaris 2.6 the program is in C++, using gnu C 2.95.3 . The table does have primary key constraint and the program should throw an exception when I try to insert and the the row aready exists, But instead It crashes. Any suggestions ?? Thanks Hitesh What are you using to connect to MySQL? libmysql or MySQL++? -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
timestamp
Greetings guys, Special greetings to all of you who helped me in the last question, one last one in a timestamp field, do I have to provide the values? eg create table ryan(t_imestamp timestamp(8), name varchar(30)); how do I insert? do I have to specify the value? if so how do I get the value to specify it? The manual has just confused me more. Cheers, -Ryan mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: @@IDENTITY
-Original Message- From: Richard Davidson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 1:31 PM To: MySql List; [EMAIL PROTECTED] Subject: FYI: @@IDENTITY I don't know if this is just weirdness on my system but I thought I would pass this on in case anyone runs into this problem. I'm converting some Java/JDBC code from a commercial DBMS to MySQL. The existing code executed the SQL statement Select @@identity after an INSERT to retrieve the autoincrement value. But, MySQL would never return from this query -- just hang until I stopped and restarted the service. After some trial-and-error-and-error, I found that @@IDENTITY worked as expected but @@identity would cause this hang symptom. Moral of the story: don't use lower case letters in SELECT @@IDENTITY. This is fixed from MySQL 3.23.50 and 4.0.2 versions, so you can give a try with the 3.23.50 from: http://www.mysql.com/downloads/mysql-3.23-pre.html Make a note that, the Windows binaries are not pre-releases, and they are official and can be used in production. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: data warehousing
I dont think the types of tables will really help you, because as I understand it mySQL doesnt yet have stored procs, views, and sub-selects, regardless of table type... I may be wrong though... Taylor Lewick Unix System Administrator Fortis Benefits 816 881 6073 Help Wanted. Seeking Telepath... You Know where to apply. Don Vu [EMAIL PROTECTED] 05/29/02 03:02PM Hi guys, Does anyone have any thoughts on using MySQL for a datawarehousing application? Problems I've run in to are with mining data from a data warehouse because of the lack of sub-selects, stored procs, and views. Should I be looking more at InnoDB or MyISAM table types? any thoughts are appreciated, Don -- Don Vu Database Guy Madstone Films 85 fifth avenue, 12th floor new york new york 10003 p 212.989.4500 f 212.989.7744 www.madstonefilms.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 Note The information in this E-mail message is legally privileged and confidential information intended only for the use of the individual(s) named above. If you, the reader of this message, are not the intended recipient, you are hereby notified that you should not further disseminate, distribute, or forward this E-mail message. If you have received this E-mail in error, please notify the sender. 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
Alias WHERE
It seems I cannot use an alias in WHERE clause, but I can use it in ORDER BY. An examples: this doesn't work SELECT field1 AS ABC, field2 AS XXX, field3 AS QQQ FROM mytable WHERE ABC = 'abc' ORDER BY ABC this works SELECT field1 AS ABC, field2 AS XXX, field3 AS QQQ FROM mytable WHERE field1 = 'abc' ORDER BY ABC Why I cannot use the alias 'ABC' in WHERE clause and I can use it in ORDER BY clause? I'm using mySQL 3.23.47 on W98 with ODBC (myODBC 3.51.02). TIA, Massimo. ___ Massimo Colurcio mailto:[EMAIL PROTECTED] http://www.softhor.com/developmentarea ICQ #96413649 ATIC #1219 SONORK 100.10862 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Exceptions do not work .
hitesh_mittal@itginc.com wrote: I am using MYSQL ++. Hitesh Then, I would suggest posting your question over on the plusplus list (see http://www.mysql.com/documentation/lists.html), as the developers for MySQL++ hang out over there. -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: Eliminating downtime
The thing is I'm looking for a solution with guaranteed transaction success. I have thought about building a layer that would guarantee transaction success. Say I had two duplicate databases and if a transaction failed on one it would still succeed on the other. Once the transaction failed it should take the failed database out of service. I believe this could be fairly straightforward but thought I would check the list to see if someone had already built a product or setup some system that would allow for this. Dave Turner On Wed, May 29, 2002 at 05:21:39PM -0400, Moyer, Andy wrote: I don't think this is specific for MySQL - I believe you can have it monitor any processes you want it to. It also gets feedback from the system (core temperature, power fluxuations, etc). We would have it monitor Apache, MySQL, and any other core system components. The heartbeat cable is also designed so that if one system dies (and stops sending the heartbeat), the other system comes online. Also not sure about this, but I believe the systems share an IP address on the network port, but the slave doesn't enable its network port until the heartbeat dies or tells it to. If this isn't the case, they might include something to update a NAT firewall configuration on the local network, but I think it's actually the former. If it is the former, the slave is still accessible through the heartbeat cable [probably]. You can get systems like this for under $10,000, but going with IBM and super high redundancy, you're more likely to maintain the goal of 100%(99.9%) uptime. - Andy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: example connecting to database via socket instead of networking
Hi, It's more comfortable(and sure) if you use C API of MySQL.Order of (few of the main) functions to be executed is : mysql_init-initialise MYSQL struct mysql_options-set options for connection mysql_real_connect-this function make all for you, from connection point of view(create socket,setting socket,open socket for read/write) ...and after this, mysql_real_query -send query to server mysql_store(or use)_result-store the result of query in to ,let's say, recordset mysql_fetch_field -retrieve data about fields mysql_fetch_row -retrieve data from row mysql_free-release memory by recordset mysql_close -close connection now(i think), you can look in documentation to read carefully, all about C API function. If you really interested to make your own connection and channel for communication with RDBMS, you must use a data structure(protocol) which must be understandable by the server...and all become very sophisticated. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: justin cunningham [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, May 29, 2002 11:08 PM Subject: example connecting to database via socket instead of networking Hi list, can someone here give me a quick and dirty example of how there connecting to a database via sockets? I see the data in the man page but I'm uncertain as to implementation. Thanks, justin Sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Fw: InnoDB crash repeated under 3.23.51...
On Wed, May 29, 2002 at 02:06:19PM +0300, Heikki Tuuri wrote: Jeremy, it looks like this crash can happen if you use MySQL 'user level locks' which are kind of semaphores. In that case MySQL will write a binlog entry even after THD::cleanup where the transaction handle is freed. From the manual: You can also solve some cases by using the user-level lock functions GET_LOCK() and RELEASE_LOCK(). I believe the patch below to ha_innobase.cc fixes the problem. Ah-ha! That explains it! We use GET_LOCK() and RELEASE_LOCK() all over the place.! I'll build a new binary in a few hours with your modified function and test that out. Thanks a bunch. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.51: up 0 days, processed 20,341,584 queries (462/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: Alias WHERE
See: http://www.mysql.com/doc/P/r/Problems_with_alias.html Gurhan -Original Message- From: Massimo Colurcio [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 5:09 PM To: mySQL List Subject: Alias WHERE It seems I cannot use an alias in WHERE clause, but I can use it in ORDER BY. An examples: this doesn't work SELECT field1 AS ABC, field2 AS XXX, field3 AS QQQ FROM mytable WHERE ABC = 'abc' ORDER BY ABC this works SELECT field1 AS ABC, field2 AS XXX, field3 AS QQQ FROM mytable WHERE field1 = 'abc' ORDER BY ABC Why I cannot use the alias 'ABC' in WHERE clause and I can use it in ORDER BY clause? I'm using mySQL 3.23.47 on W98 with ODBC (myODBC 3.51.02). TIA, Massimo. ___ Massimo Colurcio mailto:[EMAIL PROTECTED] http://www.softhor.com/developmentarea ICQ #96413649 ATIC #1219 SONORK 100.10862 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Foreign Keys and NULL
Hi, I am evaluating InnoDB's Foreign Keys and am stuck. Using the sample tables I want to add records in the Child table with a NULL parent_id (this being referenced to the Parent table) as follows: CREATE TABLE parent(id INT NOT NULL, PRIMARY KEY (id)) TYPE=INNODB; CREATE TABLE child(id INT, parent_id INT, INDEX par_ind (parent_id), FOREIGN KEY (parent_id) REFERENCES parent(id) ON DELETE CASCADE) TYPE=INNODB; mysql insert into parent values(1); Query OK, 1 row affected (0.00 sec) mysql insert into child (id, parent_id) values(4, 1); Query OK, 1 row affected (0.00 sec) mysql insert into child (id, parent_id) values(5, null); ERROR 1216: Cannot add a child row: a foreign key constraint fails mysql insert into child (id) values(5); ERROR 1216: Cannot add a child row: a foreign key constraint fails Is this possible in InnoDB ? Is there a setting that I have missed ? I am using:mysqld-max.exe Ver 4.0.1-alpha-max for Win95/Win98 on i32 Any help will be highly appreciated. Thanks in advance. Ashok Kumar Parmar ISL NZ Limited. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Foreign Keys and NULL
CREATE TABLE parent(id INT NOT NULL, PRIMARY KEY (id)) TYPE=INNODB; CREATE TABLE child(id INT, parent_id INT, INDEX par_ind (parent_id), FOREIGN KEY (parent_id) REFERENCES parent(id) ON DELETE CASCADE) TYPE=INNODB; OI!!! I'm going to sound like a complete ass now (I know) But since when does MySQL support FOREIGN keys?? *gasp* MAN this is going to make my life S much easier *curses at phpMyAdmin for not having the option* *lick* *bounce* *all happy now* *goes to redo all his DBs* Now, I like MySQL 10 times more - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Filemaker Pro and Dates
Hi all, I apologise if this question has been asked recently; I have checked the list archives and could not see anything. This is my problem: I am trying to convert and import a fairly convoluted Filemaker Pro 5 database to MySQL. I have exported the filemaker records as tab delimited files and have managed to load them in to MySQL without too much problem. However I have one issue: Dates. Of course MySQL stores dates in -MM-DD whilst filemaker uses DD-MM- and so when I import my delimited text file MySQL interprets the dates incorrectly. I can't seem to find a way of changing the date format in Filemaker, nor can I figure out how to get MySQL to convert the dates into it's format. Any help would be greatly appreciated and I apologise if this is something simple but this is my first entanglement with databases. I am using MySQL 3.23.49 running on FreeBSD 4-STABLE. MySQL was compiled from the FreeBSD port. Thanks for your help, Cameron - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Time-out Error
Hi I am using mysql 3.2133b, Sun Solaris 2.6, JHTML and Apache. I have been getting Time-out requesting db connectionUnable to connect to database server where url was jdbc:z1MySQL://localhost:3306 error whenever the JHTML is initialized for the first time. It works fine when i click on the refresh button again. Any suggesstions greatly appreciated. Thanks Ravi. _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Send and receive Hotmail on your mobile device: http://mobile.msn.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: Foreign Keys and NULL
snip tables OI!!! I'm going to sound like a complete ass now (I know) But since when does MySQL support FOREIGN keys?? *gasp* MAN this is going to make my life S much easier *curses at phpMyAdmin for not having the option* Do remember that this is only valid for mysql 3.23.50+ and 4.0.2+. Now, I like MySQL 10 times more Cool. :) -- Gabriel Cain Unix Systems Administrator [EMAIL PROTECTED] Dialup USA, Inc. 888-460-2286 ext 208 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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:Installing
If you start MySQL server from MS DOS prompt as: C:\mysql\binmysqld-nt --standalone --debug mysqld shows you warning message. hi! i tried this already.. but whenever i type mysqld-nt -install to install mysql as a service.. an error messge Failed to install service occurs.. using Windows 2000 but if i type net start mysql, it says that The requested service has alrdy been started. and i really dont know if this is the reason why i cant view php files in IE correctly.. pls help.. thanks.. __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[50 character or so descriptive subject here (for reference)] ./configure --with-mit-threads fails to compile vio/ and innodb/
Description: `./configure --with-mit-threads` fails to compile vio/ and innodb/ due to missing -I directives for pthread.h. How-To-Repeat: in my particular case: ./configure --prefix=/usr/local/mysql/ --with-named-z-libs=z --without-libwrap --with-mit-threads gcc -DHAVE_CONFIG_H -I. -I. -I.. -I./../include -I../include -O3 -DDBUG_OFF -Dunix -c vio.c In file included from ../include/my_sys.h:32, from vio.c:29: ../include/my_pthread.h:233: pthread.h: No such file or directory Fix: both innodb and vio don't seem to properly add a -I../mit-pthreads/include/ to pick up the pthreads includes. manually adding it to the compile line seems to work. Submitter-Id: submitter ID Originator:Tom Spindler Organization: MySQL support: [none | licence | email support | extended email support ]none Synopsis: ./configure --with-mit-threads fails to compile vio/ and innodb/ Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql-4.0.1-alpha (Source distribution) Environment: System: NetBSD droolbib 1.5.3 NetBSD 1.5.3 (PRATTLE) #2: Wed May 8 14:42:08 PDT 2002 [EMAIL PROTECTED]:/netbsd15/nbsrc153/sys/arch/i386/compile/PRATTLE i386 Some paths: /usr/local/bin/perl /usr/bin/make /usr/pkg/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Using builtin specs. gcc version egcs-2.91.66 19990314 (egcs-1.1.2 release) Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS='' LIBC: -r--r--r-- 1 root wheel 1205162 Mar 13 14:13 /usr/lib/libc.a lrwxr-xr-x 1 root wheel 15 Mar 13 14:32 /usr/lib/libc.so - libc.so.12.62.1 lrwxr-xr-x 1 root wheel 15 Mar 13 14:32 /usr/lib/libc.so.12 - libc.so.12.62.1 -r--r--r-- 1 root wheel 616710 Mar 13 14:13 /usr/lib/libc.so.12.62.1 Configure command: ./configure --with-unix-socket-path=/var/tmp/mysql.sock --with-low-memory --with-mit-threads=yes --without-perl --enable-thread-safe-client --with-berkeley-db --with-innodb --with-vio --without-pstack --with-extra-tools --with-embedded-server - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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_num_rows
Hello - I am running MySQL 3.23.33 with Apache 1.3.19 and PHP 4.0.4PL1 on a DELL Latitude C600 Laptop developing a project. However every time i try to use mysql_num_rows it tells me that this is not a valid mysql result resource. I've tried all kinds of differnt tricks to try to fix the problem but to no avail. If i transfer the project to my desktop it works fine, so i know its not the code. Unfortunately i cant work soley on my desktop as i commute to work and the laptop is my work computer. I had a similar problem with a Dell Inspiron laptop. Im beginning to think it some kind of dell propritory software thats getting in the way. Anyone have a fix. Thanks.. -Eric Computer Science/Music Sigma Alpha Epsilon 6 Humboldt Ave. (401) 527-2249 IM: studioajaz [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:mysql_num_rows
You should try echoing out mysql_error() to see what error is being returned from MySQL or run mysql from the command line on your laptop and run the same query that your script is running. HTH --Sam Masiello On Wed, 29 May 2002 20:35:33 -0400 (EDT) Eric P. McDonough [EMAIL PROTECTED] wrote: Hello - I am running MySQL 3.23.33 with Apache 1.3.19 and PHP 4.0.4PL1 on a DELL Latitude C600 Laptop developing a project. However every time i try to use mysql_num_rows it tells me that this is not a valid mysql result resource. I've tried all kinds of differnt tricks to try to fix the problem but to no avail. If i transfer the project to my desktop it works fine, so i know its not the code. Unfortunately i cant work soley on my desktop as i commute to work and the laptop is my work computer. I had a similar problem with a Dell Inspiron laptop. Im beginning to think it some kind of dell propritory software thats getting in the way. Anyone have a fix. Thanks.. -Eric Computer Science/Music Sigma Alpha Epsilon 6 Humboldt Ave. (401) 527-2249 IM: studioajaz [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: Does anyone know
On Wed, May 29, 2002 at 11:58:06AM -0600, Weaver, Walt wrote: when MySQL 4.0.2 will be out? We'd like to play around with InnoDB's autoextend feature on v.4. On what platform? If you're on FreeBSD or Linux, I can send you one of my daily builds. Sice you're just looking to play around, you probably needn't wait for the official release. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.51: up 0 days, processed 427,127 queries (134/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: Filemaker Pro and Dates
At 23:45 +0100 5/29/02, Cameron Murdoch wrote: Hi all, I apologise if this question has been asked recently; I have checked the list archives and could not see anything. This is my problem: I am trying to convert and import a fairly convoluted Filemaker Pro 5 database to MySQL. I have exported the filemaker records as tab delimited files and have managed to load them in to MySQL without too much problem. However I have one issue: Dates. Of course MySQL stores dates in -MM-DD whilst filemaker uses DD-MM- and so when I import my delimited text file MySQL interprets the dates incorrectly. I can't seem to find a way of changing the date format in Filemaker, nor can I figure out how to get MySQL to convert the dates into it's format. Any help would be greatly appreciated and I apologise if this is something simple but this is my first entanglement with databases. http://www.kitebird.com/mysql-cookbook/ One of the scripts in the early release distribution is cvt_date.pl. Looks for dates in one format, converts them to another. Might help you out. I am using MySQL 3.23.49 running on FreeBSD 4-STABLE. MySQL was compiled from the FreeBSD port. Thanks for your help, Cameron - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Filemaker Pro and Dates
I considered perl but it is quite some time since I used it so I had been wondering if there was a way do what I wanted from within MySQL. Having said that it has taken about an hour for me to relearn some perl tricks and get the problem sorted so perhaps I should have just tried straight off instead of trying to cheat :) Anyway, thanks for your help guys, CM PS Rick, I don't have much experience with AWK, always been one of those things I need to look into. -Original Message- From: Bradley Brown [mailto:[EMAIL PROTECTED]] Sent: 30 May 2002 00:27 To: Cameron Murdoch Cc: [EMAIL PROTECTED] Subject: Re: Filemaker Pro and Dates Do you have any experience with Perl? Perhaps a quick script would convert your tab delimited files to the proper format? Bradley Cameron Murdoch wrote: Hi all, I apologise if this question has been asked recently; I have checked the list archives and could not see anything. This is my problem: I am trying to convert and import a fairly convoluted Filemaker Pro 5 database to MySQL. I have exported the filemaker records as tab delimited files and have managed to load them in to MySQL without too much problem. However I have one issue: Dates. Of course MySQL stores dates in -MM-DD whilst filemaker uses DD-MM- and so when I import my delimited text file MySQL interprets the dates incorrectly. I can't seem to find a way of changing the date format in Filemaker, nor can I figure out how to get MySQL to convert the dates into it's format. Any help would be greatly appreciated and I apologise if this is something simple but this is my first entanglement with databases. I am using MySQL 3.23.49 running on FreeBSD 4-STABLE. MySQL was compiled from the FreeBSD port. Thanks for your help, Cameron - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Questions
Hi, I have been using MySql very successfully on Linux for the past 1.5 years. (a lethal combination) This morning when I tried to login using MySqlFront, it seems that my password has been changed. I was able to login to the server and restore it, using the root password. Upon further inspection i noticed the following files in the mysql directory: -rw-r--r--1 root root0 May 29 15:35 -h=172.16.22.40 -rw-r--r--1 root root0 May 29 15:36 --host=172.16.22.40 I was wondering how they got there, and how to delete them. These ip addresses are not supposed to have anything to do with my server. Then I want to know if mysql keeps a log of users who have logged in? Or is this included in the log variable option? (which I don't currently use) Thanks to anyone who can help. Rgds Terence - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Filemaker Pro and Dates
If you can load the data into MySQL, put the date field into a CHAR(10) field. After the data load, add a date field using ALTER TABLE. You should then be able to run something like UPDATE TABLE tablename SET NewDate = CONCAT( RIGHT(OrigDate,4),-, MID(OrigDate,4,2),-, LEFT(OrigDate,2) ); You can then drop the original date column with alter table. If there are more than 1 date fields just follow the same procedure for each one. If there are several date fields in the converted database, you may want to use an editor to build the multiple Alter/Update/Alter sequencies, save as changedate.sql and then execute using MYSQL database name changedate.sql This lets you use copy paste to generate the multiple SQL statements with minimal typing. - Another process which works if you have Microsoft Access is to Import the tables into an Access Database Create the tables in MySQL Link the MySQL tables into the Access database through an ODBC DSN Build an APPEND query to copy the Access tables into the MySQL tables Delete the Access database after verifying success Moving the dates through the ODBC interface automatically converts the DD-MM- format to the -MM-DD format used by MySQL. Gordon Bruce Interstate Software US MySQL Training Partner -Original Message- From: Cameron Murdoch [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 5:46 PM To: [EMAIL PROTECTED] Subject: Filemaker Pro and Dates Hi all, I apologise if this question has been asked recently; I have checked the list archives and could not see anything. This is my problem: I am trying to convert and import a fairly convoluted Filemaker Pro 5 database to MySQL. I have exported the filemaker records as tab delimited files and have managed to load them in to MySQL without too much problem. However I have one issue: Dates. Of course MySQL stores dates in -MM- DD whilst filemaker uses DD-MM- and so when I import my delimited text file MySQL interprets the dates incorrectly. I can't seem to find a way of changing the date format in Filemaker, nor can I figure out how to get MySQL to convert the dates into it's format. Any help would be greatly appreciated and I apologise if this is something simple but this is my first entanglement with databases. I am using MySQL 3.23.49 running on FreeBSD 4-STABLE. MySQL was compiled from the FreeBSD port. Thanks for your help, Cameron - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php