Re: My dump does not work
When I faced the same problem, I was suggested to use MySQL Front. I have (Bbeen also using phpMyAdmin.Both work fine. (B (BHope this will help u (B (Bregards (B- Original Message - (BFrom: "srinath sundarrajan" [EMAIL PROTECTED] (BTo: [EMAIL PROTECTED] (BSent: Friday, February 14, 2003 4:11 PM (BSubject: My dump does not work (B (B (B Hello, (B (B I face a problem in transfering a mysql db from 1 machine to another. I (Bused (B the mysqldump command to take the dump of a db from machine A running (Blinux. (B I put the same on to a machine B running on linux. Then I used the (Bmysqldump (B command to create the database. In all 15 tables should be there. (B Unfortunately only 3 tabels are there. The dump restoration stops midway (B through the third table without giving any error. I tried opening the (B original .sql file in wordpad. All the tabels records are there. Any (Bidea (B what could be the problem. Is there any way to transfer table by table. (B Machine B is a new one. (B (B Thanks regards, (B Srinivasan. (B (B _ (B Help STOP SPAM with the new MSN 8 and get 2 months FREE* (B http://join.msn.com/?page=features/junkmail (B (B (B - (B Before posting, please check: (Bhttp://www.mysql.com/manual.php (the manual) (Bhttp://lists.mysql.com/ (the list archive) (B (B To request this thread, e-mail [EMAIL PROTECTED] (B To unsubscribe, e-mail (B[EMAIL PROTECTED] (B Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php (B (B (B (B (B- (BBefore posting, please check: (B http://www.mysql.com/manual.php (the manual) (B http://lists.mysql.com/ (the list archive) (B (BTo request this thread, e-mail [EMAIL PROTECTED] (BTo unsubscribe, e-mail [EMAIL PROTECTED] (BTrouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Datentypen
Hallo Liste, als MySql Einsteiger hätte ich gerne eine Liste der Datentypen mit Beschreibung. Leider kann ich diese nicht in der Doku finden. Schon mal vielen Dank im vorraus. Ingo Döring - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Datentypen
Hello Ingo, n etman wrote: als MySql Einsteiger hätte ich gerne eine Liste der Datentypen mit Beschreibung. this is an english list. dies ist eine englischsprachige Liste. -- Manuel Kiessling - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Datentypen
Leider kann ich diese nicht in der Doku finden. how in the world did you manage to miss that one? http://www.mysql.com/doc/en/Column_types.html Regards Roland - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Future outlook: MySql + Linux and 2gig ram limit..
Hi, I am wondering if the MySQL staff have been working on a way to circumvent the current 2G ram usage limit for MySQL under LInux for maybe the 5.0 release? Did a list search but did not find a thread regarding this matter so I want to get this question out of my system. With the rising need of Innodb on ever growing size of databases, (10Gig data + 10million rows+, tons of indices including full-text), one would need to not only give lots of ram to myisam key/buffer cache but also quite a bit if not more to the innodb engine. Factoring the per connection ram usage of record/sort buffer 2gig of ram can be reached fairly easily and more ram need to be allocated to avoid hits to HD as much as possible. Finally, is there a 2G ram limit on MySQL for Mac OS X builds? The 2GIG limit is perfectly fine for my setup now but I can see the need for more hitting critical level in a year and a half and would like to prepare for that point. Thanks for any info... Xing Li - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: Strange sorting in table
Paul, Thanks for the explanation! Best Regards, Viktor Vasiliou - Original Message - From: Paul DuBois To: Viktor Vasiliou ; [EMAIL PROTECTED] Sent: Friday, February 14, 2003 12:05 AM Subject: Re: Re: Strange sorting in table At 0:01 +0100 2/14/03, Viktor Vasiliou wrote: Ok, I guess you're right. It's just that it has never happend to me before. Thanks for your help. In general, when you simply insert rows into a table, that's the order in which they're returned. That's just happy coincidence, and not to be relied on. And when you start deleting rows, you create gaps into which subsequent rows may be inserted. That entirely throws off the retrieve-in-insertion-order property that you were observing. ORDER BY's always the safest course when you need rows in order. (Exception: MySQL's GROUP BY also sorts, so if you have a GROUP BY and it sorts in the order you want, you don't also need an ORDER BY. Regards, Viktor sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Datentypen
http://www.mysql.com/doc/en/Column_types.html - Original Message - From: n etman [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, February 14, 2003 9:13 AM Subject: Datentypen Hallo Liste, als MySql Einsteiger hätte ich gerne eine Liste der Datentypen mit Beschreibung. Leider kann ich diese nicht in der Doku finden. Schon mal vielen Dank im vorraus. Ingo Döring - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Datentypen
Ingo, als MySql Einsteiger hätte ich gerne eine Liste der Datentypen mit Beschreibung. Leider kann ich diese nicht in der Doku finden. The list language is English. Anyway, here's what you're looking for. English manual: http://www.mysql.com/doc/en/Column_types.html German manual: http://mysql.de/documentation/mysql/bychapter/manual.de_Reference.html#Column_types Regards, -- Stefan Hinz [EMAIL PROTECTED] iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 [filter fodder: sql, mysql, query] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Bug with innodb multi-table delete and foreign keys.
Scott Wong writes: Hi sinisa, I tried this patch. It came up with undefined symbol for ER_MULTI_TABLE_UPDATE_DELETE_WITH_INNODB on compile so i went ahead and added to include/mysqld_error.h for testing. i'm not sure if it's the right place or the right error code but it made mysql compile *** 256a257 #define ER_MULTI_TABLE_UPDATE_DELETE_WITH_INNODB 1238 *** then ran the query again. drop table parent; drop table child; CREATE TABLE parent(id INT NOT NULL, PRIMARY KEY (id)) TYPE=INNODB; CREATE TABLE child(id INT PRIMARY KEY, parent_id INT, INDEX par_ind (parent_id), FOREIGN KEY (parent_id) REFERENCES parent(id) ON DELETE CASCADE ) TYPE=INNODB; insert into parent set id=1; insert into child set id=1, parent_id=1; delete parent,child from parent,child where parent.id=child.parent_id; now i get ERROR 2013: Lost connection to MySQL server during query mysql Number of processes running now: 0 030213 15:54:20 mysqld restarted regards, Scott Wong Yes, of course. I have sent just an excerpt. Full patch is rather big and is not appropriate for mail. Plus I am still improving it in order to work under all conditions. Full patch will be in 4.0.11. -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com Join MySQL Users Conference and Expo: http://www.mysql.com/events/uc2003/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 with subs
Hej all, I have a really kinky mysql problem. Well lets start, I have a table that looks like this ++--+-+ | id|title |subid| ++--+-+ | 1| MAIN | 0 | ++--+-+ | 2| MAIN2| 0 | ++--+-+ | 3| sub1 | 2 | ++--+-+ | 4| sub1sub| 3 | ++--+-+ | 5|sub2-1| 3 | ++--+-+ | 6|sub2-2| 3 | ++--+-+ The id is the primary key, the title is just a text field, and subid is the reference to witch id it is sub to. I need these datas to be called in the following order MAIN MAIN2 +- sub1 '-sub1sub '-sub2-1 +- sub2 '-sub2-2 AND SO ON, it's supposed to go to as many subs as possible...(for example down 100 subs) I hope you can make a sql command that can make it for me. THANK YOU! //Regards - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Show record number
Hello Query: SELECT Name, St, PNumber From TABLE WHERE St = FL ORDER BY PNumber Would like output to be: 1 Joe Jones 123-123-1234 2 Mary Adams 123-123-4567 3 Ted Smith 145-456-8974 etc How can I generate a record number SELECT recnu(), Name, St, PNumber ?? thanks jrt - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Show record number
If your're using some other programming language to fetch the results, maybe it should be better to do it with that language. Otherwise, if you really need it to be in SQL you can, for example, use variables like this: SET @c:=0; SELECT @c:=@c+1, Name, St, PNumber FROM TABLE; On Fri, 2003-02-14 at 13:36, John Thorne wrote: Hello Query: SELECT Name, St, PNumber From TABLE WHERE St = FL ORDER BY PNumber Would like output to be: 1 Joe Jones 123-123-1234 2 Mary Adams 123-123-4567 3 Ted Smith 145-456-8974 etc How can I generate a record number SELECT recnu(), Name, St, PNumber ?? thanks jrt -- Diana Soares - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[PATCH]: mysql 4.0.10 - fix for missing include file
Hi, There is problem with include files. include/raid.h is installed as for example /usr/local/include/mysql/raid.h and it includes my_dir.h which is not installed in /usr/local/include/mysql/ and thus is not usable. This patch fixes that: diff -urN mysql-4.0.10-gamma.org/include/Makefile.am mysql-4.0.10-gamma/include/Makefile.am --- mysql-4.0.10-gamma.org/include/Makefile.am Wed Jan 29 12:29:24 2003 +++ mysql-4.0.10-gamma/include/Makefile.am Fri Feb 14 15:19:26 2003 @@ -19,13 +19,13 @@ pkginclude_HEADERS = dbug.h m_string.h my_sys.h my_list.h \ mysql.h mysql_com.h mysqld_error.h mysql_embed.h \ my_semaphore.h my_pthread.h my_no_pthread.h raid.h \ - errmsg.h my_global.h my_net.h my_alloc.h \ + errmsg.h my_global.h my_net.h my_alloc.h my_dir.h \ my_getopt.h sslopt-longopts.h \ sslopt-vars.h sslopt-case.h $(BUILT_SOURCES) noinst_HEADERS = config-win.h config-os2.h config-netware.h \ nisam.h heap.h merge.h my_bitmap.h\ myisam.h myisampack.h myisammrg.h ft_global.h\ - my_dir.h mysys_err.h my_base.h \ + mysys_err.h my_base.h \ my_nosys.h my_alarm.h queues.h rijndael.h sha1.h \ my_aes.h my_tree.h hash.h thr_alarm.h \ thr_lock.h t_ctype.h violite.h md5.h mysql_version.h.in Note that we are building rpms for PLD Linux with latest mysql 4.0: lftp ftp.nest.pld.org.pl:/test ls */mysql* lftt.pld.org.pl:/test ls */mysql*4.0* -rw-r--r-- 1 pldadmin pldadmin 12146406 Feb 13 20:06 SRPMS/mysql-4.0.10-0.1.src.rpm -rw-r--r-- 1 pldadmin pldadmin 2714023 Feb 13 22:30 athlon/mysql-4.0.10-0.1.athlon.rpm -rw-r--r-- 1 pldadmin pldadmin 466269 Feb 13 22:30 athlon/mysql-bench-4.0.10-0.1.athlon.rpm -rw-r--r-- 1 pldadmin pldadmin 115858 Feb 13 22:30 athlon/mysql-client-4.0.10-0.1.athlon.rpm -rw-r--r-- 1 pldadmin pldadmin 1798365 Feb 13 22:30 athlon/mysql-devel-4.0.10-0.1.athlon.rpm -rw-r--r-- 1 pldadmin pldadmin 178342 Feb 13 22:30 athlon/mysql-extras-4.0.10-0.1.athlon.rpm -rw-r--r-- 1 pldadmin pldadmin61627 Feb 13 22:30 athlon/mysql-extras-perl-4.0.10-0.1.athlon.rpm -rw-r--r-- 1 pldadmin pldadmin 209305 Feb 13 22:30 athlon/mysql-libs-4.0.10-0.1.athlon.rpm -rw-r--r-- 1 pldadmin pldadmin 188490 Feb 13 22:30 athlon/mysql-static-4.0.10-0.1.athlon.rpm -rw-r--r-- 1 pldadmin pldadmin 2620274 Feb 13 20:08 i386/mysql-4.0.10-0.1.i386.rpm -rw-r--r-- 1 pldadmin pldadmin 465297 Feb 13 20:08 i386/mysql-bench-4.0.10-0.1.i386.rpm -rw-r--r-- 1 pldadmin pldadmin 114615 Feb 13 20:08 i386/mysql-client-4.0.10-0.1.i386.rpm -rw-r--r-- 1 pldadmin pldadmin 1765964 Feb 13 20:08 i386/mysql-devel-4.0.10-0.1.i386.rpm -rw-r--r-- 1 pldadmin pldadmin 176211 Feb 13 20:08 i386/mysql-extras-4.0.10-0.1.i386.rpm -rw-r--r-- 1 pldadmin pldadmin61447 Feb 13 20:08 i386/mysql-extras-perl-4.0.10-0.1.i386.rpm -rw-r--r-- 1 pldadmin pldadmin 204745 Feb 13 20:08 i386/mysql-libs-4.0.10-0.1.i386.rpm -rw-r--r-- 1 pldadmin pldadmin 186742 Feb 13 20:08 i386/mysql-static-4.0.10-0.1.i386.rpm -rw-r--r-- 1 pldadmin pldadmin 2698674 Feb 13 20:11 i586/mysql-4.0.10-0.1.i586.rpm -rw-r--r-- 1 pldadmin pldadmin 465257 Feb 13 20:11 i586/mysql-bench-4.0.10-0.1.i586.rpm -rw-r--r-- 1 pldadmin pldadmin 116440 Feb 13 20:11 i586/mysql-client-4.0.10-0.1.i586.rpm -rw-r--r-- 1 pldadmin pldadmin 1811782 Feb 13 20:11 i586/mysql-devel-4.0.10-0.1.i586.rpm -rw-r--r-- 1 pldadmin pldadmin 177580 Feb 13 20:11 i586/mysql-extras-4.0.10-0.1.i586.rpm -rw-r--r-- 1 pldadmin pldadmin61520 Feb 13 20:11 i586/mysql-extras-perl-4.0.10-0.1.i586.rpm -rw-r--r-- 1 pldadmin pldadmin 206793 Feb 13 20:11 i586/mysql-libs-4.0.10-0.1.i586.rpm -rw-r--r-- 1 pldadmin pldadmin 189800 Feb 13 20:11 i586/mysql-static-4.0.10-0.1.i586.rpm -rw-r--r-- 1 pldadmin pldadmin 2747202 Feb 13 20:06 i686/mysql-4.0.10-0.1.i686.rpm -rw-r--r-- 1 pldadmin pldadmin 464972 Feb 13 20:06 i686/mysql-bench-4.0.10-0.1.i686.rpm -rw-r--r-- 1 pldadmin pldadmin 116685 Feb 13 20:06 i686/mysql-client-4.0.10-0.1.i686.rpm -rw-r--r-- 1 pldadmin pldadmin 1815609 Feb 13 20:06 i686/mysql-devel-4.0.10-0.1.i686.rpm -rw-r--r-- 1 pldadmin pldadmin 179255 Feb 13 20:06 i686/mysql-extras-4.0.10-0.1.i686.rpm -rw-r--r-- 1 pldadmin pldadmin61540 Feb 13 20:06 i686/mysql-extras-perl-4.0.10-0.1.i686.rpm -rw-r--r-- 1 pldadmin pldadmin 209934 Feb 13 20:06 i686/mysql-libs-4.0.10-0.1.i686.rpm -rw-r--r-- 1 pldadmin pldadmin 189381 Feb 13 20:06 i686/mysql-static-4.0.10-0.1.i686.rpm -rw-r--r-- 1 pldadmin pldadmin 2872687 Feb 13 20:37 ppc/mysql-4.0.10-0.1.ppc.rpm -rw-r--r-- 1 pldadmin pldadmin 465480 Feb 13 20:37 ppc/mysql-bench-4.0.10-0.1.ppc.rpm -rw-r--r-- 1 pldadmin pldadmin 127835 Feb 13 20:37
re: Starting MySQL RPM
On Friday 14 February 2003 01:06, John Oliver wrote: I removed the Red Hat MySQL RPMs (which worked fine, other than not supporting InnoDB) and installed the 3.23.55-1 RPMs from mysql.com When I try to start it: [joliver@joliver-lnx joliver]$ sudo /etc/rc.d/init.d/mysql start [joliver@joliver-lnx joliver]$ Starting mysqld-max daemon with databases from /var/lib/mysql 030213 15:01:06 mysqld ended [joliver@joliver-lnx joliver]$ And that's it. Nothing is logged and, oddly enough, /etc/rc.d/init.d/mysql doesn't contain the strings that are being echoed to the console. So I'm more than a little puzzled here... :-) And Google isn't helping me much, either :-( Check error log file to see why MySQL server doesn't start. -- 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
New Database,
Okay, I have installed, mySQL, ( all is well ) and now looking to build my first database, is there a comprehensive user manual on how to, say in .pdf format out there ? if not, a on-line link maybe ? Thanks- Richard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: New Database,
Yes, there are, many :) Jerry - Original Message - From: Richard Nagle [EMAIL PROTECTED] To: list - MySQL [EMAIL PROTECTED] Sent: Friday, February 14, 2003 3:57 PM Subject: New Database, Okay, I have installed, mySQL, ( all is well ) and now looking to build my first database, is there a comprehensive user manual on how to, say in .pdf format out there ? if not, a on-line link maybe ? Thanks- Richard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: New Database,
- Original Message - From: Richard Nagle [EMAIL PROTECTED] To: list - MySQL [EMAIL PROTECTED] Sent: Friday, February 14, 2003 10:57 AM Subject: New Database, Okay, I have installed, mySQL, ( all is well ) and now looking to build my first database, is there a comprehensive user manual on how to, say in .pdf format out there ? if not, a on-line link maybe ? See http://www.mysql.com/documentation/index.html Peter ^_^ - Peter Grigor Hoobly Classified Ads http://www.hoobly.com Thanks- Richard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: New Database,
Its a lot easier asking people than trying to look for yourself isn't it? Well, that is frowned uppon over here. You should ask us questions when you have attempted to find the solution yourself first. http://www.mysql.com click on the documentation link on the header. See, it wasn't so hard! Maximo. At 10:57 14/2/2003 -0500, you wrote: Okay, I have installed, mySQL, ( all is well ) and now looking to build my first database, is there a comprehensive user manual on how to, say in .pdf format out there ? if not, a on-line link maybe ? Thanks- Richard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: New Database,
Richard, what exactly do you mean? guidelines to good database engineering? which data how an where to store? intelligent table structures? or technical instructions related to mysql? - documentation, see message attachment cherio, henning Richard Nagle wrote, On 2/14/2003 4:57 PM: Okay, I have installed, mySQL, ( all is well ) and now looking to build my first database, is there a comprehensive user manual on how to, say in .pdf format out there ? if not, a on-line link maybe ? Thanks- Richard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: New Database,
On Friday 14 February 2003 17:57, Richard Nagle wrote: I have installed, mySQL, ( all is well ) and now looking to build my first database, is there a comprehensive user manual on how to, say in .pdf format out there ? if not, a on-line link maybe ? Please, check the following link: http://www.mysql.com/documentation/index.html -- 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
FW: how to create database (auto)
Hi Richard, Do you think the following links may help? I got them from the online manual: [1] http://www.mysql.com/doc/en/CREATE_DATABASE.html [2] http://www.mysql.com/doc/en/CREATE_TABLE.html [3] http://www.mysql.com/doc/en/CREATE_FUNCTION.html [4] http://www.mysql.com/doc/en/CREATE_INDEX.html [5] http://www.mysql.com/doc/en/Cannot_create.html [6] http://www.mysql.com/doc/en/SHOW_CREATE_TABLE.html This was an automated reply to your message about 'how to create database'. I used 'create database' as a keyword to query the database. If you no longer want to receive messages from the bot, send email to [EMAIL PROTECTED] with subject unsubscribe. P.S. Feedbacks, suggestions and complaints should be directed to [EMAIL PROTECTED] -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: New Database,
BTW, exactly how did you acquire, install and execute mysql without visiting mysql.com? :) Peter ^_^ - Peter Grigor Hoobly Classified Ads http://www.hoobly.com - Original Message - From: Richard Nagle [EMAIL PROTECTED] To: list - MySQL [EMAIL PROTECTED] Sent: Friday, February 14, 2003 10:57 AM Subject: New Database, Okay, I have installed, mySQL, ( all is well ) and now looking to build my first database, is there a comprehensive user manual on how to, say in .pdf format out there ? if not, a on-line link maybe ? Thanks- Richard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql with subs
This probably isn't best handled by mysql...use associative arrays to store members of members in the hierarchy, then print out the associative array's contents in order. Peter ^_^ - Peter Grigor Hoobly Classified Ads http://www.hoobly.com - Original Message - From: Lars Rasmussen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, February 14, 2003 7:46 AM Subject: mysql with subs Hej all, I have a really kinky mysql problem. Well lets start, I have a table that looks like this ++--+-+ | id|title |subid| ++--+-+ | 1| MAIN | 0 | ++--+-+ | 2| MAIN2| 0 | ++--+-+ | 3| sub1 | 2 | ++--+-+ | 4| sub1sub| 3 | ++--+-+ | 5|sub2-1| 3 | ++--+-+ | 6|sub2-2| 3 | ++--+-+ The id is the primary key, the title is just a text field, and subid is the reference to witch id it is sub to. I need these datas to be called in the following order MAIN MAIN2 +- sub1 '-sub1sub '-sub2-1 +- sub2 '-sub2-2 AND SO ON, it's supposed to go to as many subs as possible...(for example down 100 subs) I hope you can make a sql command that can make it for me. THANK YOU! //Regards - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Views
I wanted to use the Views feature that is available in Oracle which is the counterpart of Queries available in MS Access. mySQL does not support views at the moment. Is there a way I can achieve my goals ? The purpose of having a view/query is that I want to access data from that view/query through jdbc. Having views/queries will make things very simple as I can just do a select * from viewname. Any thoughts would be appreciated. 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: mysql with subs
Hi, I have had this type of problems. Under Oracle, the CONNECT BY statement was done for such queries if I can remember. But I don't know if mysql can handle this statement, or has an equivalent. Erwan - Original Message - From: Peter Grigor [EMAIL PROTECTED] To: Lars Rasmussen [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, February 14, 2003 5:20 PM Subject: Re: mysql with subs This probably isn't best handled by mysql...use associative arrays to store members of members in the hierarchy, then print out the associative array's contents in order. Peter ^_^ - Peter Grigor Hoobly Classified Ads http://www.hoobly.com - Original Message - From: Lars Rasmussen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, February 14, 2003 7:46 AM Subject: mysql with subs Hej all, I have a really kinky mysql problem. Well lets start, I have a table that looks like this ++--+-+ | id|title |subid| ++--+-+ | 1| MAIN | 0 | ++--+-+ | 2| MAIN2| 0 | ++--+-+ | 3| sub1 | 2 | ++--+-+ | 4| sub1sub| 3 | ++--+-+ | 5|sub2-1| 3 | ++--+-+ | 6|sub2-2| 3 | ++--+-+ The id is the primary key, the title is just a text field, and subid is the reference to witch id it is sub to. I need these datas to be called in the following order MAIN MAIN2 +- sub1 '-sub1sub '-sub2-1 +- sub2 '-sub2-2 AND SO ON, it's supposed to go to as many subs as possible...(for example down 100 subs) I hope you can make a sql command that can make it for me. THANK YOU! //Regards - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: New Database,
mmh, in the beginning i had never used any database except access (is one? :-)), i learned rapidly by reading the docs - hope that will be good for you too - because external howtos often come to an end sooner than you want, the docs on the other hand will answer all your questions. if not you can return to the list. good luck, henning p.s.: please keep the discussion on the list Richard Nagle wrote, On 2/14/2003 5:24 PM: in the simplest form, how to create a new database. how to assign users to that database. how to create tables...etc etc was looking for a more a layman approach of documentation. of even a website. Here is my issue. mysql create database Cognigen; ERROR 1044: Access denied for user: '@localhost' to database 'Cognigen' Rick On Friday, February 14, 2003, at 11:05 AM, Henning Heil wrote: Richard, what exactly do you mean? guidelines to good database engineering? which data how an where to store? intelligent table structures? or technical instructions related to mysql? - documentation, see message attachment cherio, henning Richard Nagle wrote, On 2/14/2003 4:57 PM: Okay, I have installed, mySQL, ( all is well ) and now looking to build my first database, is there a comprehensive user manual on how to, say in .pdf format out there ? if not, a on-line link maybe ? Thanks- Richard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Error with libmyclient.a
Using MySQL 4.0.10-0 on Redhat linux 7.3 ./libmysqlclient.a(my_compress.o): In function `my_uncompress': my_compress.o(.text+0xaa): undefined reference to `uncompress' ./libmysqlclient.a(my_compress.o): In function `my_compress_alloc': my_compress.o(.text+0x13c): undefined reference to `compress' collect2: ld returned 1 exit status Any suggestions? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 with libmyclient.a
./libmysqlclient.a(my_compress.o): In function `my_uncompress': my_compress.o(.text+0xaa): undefined reference to `uncompress' ./libmysqlclient.a(my_compress.o): In function `my_compress_alloc': my_compress.o(.text+0x13c): undefined reference to `compress' collect2: ld returned 1 exit status Any suggestions? I believe you need the zlib library. http://www.gzip.org/zlib/ Steve Sapovits GSI Commerce, Inc. http://www.gsicommerce.com Email: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Error with libmyclient.a
You need the zlib library...that's where compress is defined. It can be found at http://www.gzip.org Peter ^_^ - Peter Grigor Hoobly Free Classifieds http://www.hoobly.com - Original Message - From: Ron Sorber [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, February 14, 2003 11:41 AM Subject: Error with libmyclient.a Using MySQL 4.0.10-0 on Redhat linux 7.3 ./libmysqlclient.a(my_compress.o): In function `my_uncompress': my_compress.o(.text+0xaa): undefined reference to `uncompress' ./libmysqlclient.a(my_compress.o): In function `my_compress_alloc': my_compress.o(.text+0x13c): undefined reference to `compress' collect2: ld returned 1 exit status Any suggestions? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
dates in delphi
Hi, I have problems inserting records to a table with a date field. If I do not include the field in the form, the record is inserted succesfully with a default value for the date, but if I enter the date from de form, I get an error from the application. As long as I know, MySQL date format is -mm-dd and delphi is dd-mm-. In spite to change this format in delphi's date control, I get the same error. Does some of you guys knows a delphi date control wich works weel? Thank you. Regards. German Quiroz - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Row numbers
On Thu, Feb 13, 2003 at 03:52:18PM -0800, Steve Edberg wrote: That means no field exists or should exist in the database. I only want to generate at query time. I can't use an autoincrement field since that wont work very well with results that are returned out of order and maybe not with all the data. Using variables is the best response to my question. I just dislike using them cause they are ugly to work with because of the session persistance and because I have to issue multiple queries to do the job. If the value isn't being used to even select a row, why not wrap the lines with OL...results.../OL or perhaps just use PHP/Perl/? to do an $i++ for display? Why put this in the query at all, if it has nothing to do with the data? -- Michael T. Babcock CTO, FibreSpeed Ltd. (Hosting, Security, Consultation, Database, etc) http://www.fibrespeed.net/~mbabcock/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 MySQL RPM
On Fri, Feb 14, 2003 at 05:01:01PM +0200, Egor Egorov wrote: On Friday 14 February 2003 01:06, John Oliver wrote: I removed the Red Hat MySQL RPMs (which worked fine, other than not supporting InnoDB) and installed the 3.23.55-1 RPMs from mysql.com When I try to start it: [joliver@joliver-lnx joliver]$ sudo /etc/rc.d/init.d/mysql start [joliver@joliver-lnx joliver]$ Starting mysqld-max daemon with databases from /var/lib/mysql 030213 15:01:06 mysqld ended [joliver@joliver-lnx joliver]$ And that's it. Nothing is logged and, oddly enough, /etc/rc.d/init.d/mysql doesn't contain the strings that are being echoed to the console. So I'm more than a little puzzled here... :-) And Google isn't helping me much, either :-( Check error log file to see why MySQL server doesn't start. I see you missed the part where I said Nothing is logged... :-) I fixed that by removing the mysql.com RPMs and reinstalling the Red Hat RPMs. Someone else told me how to get InnoDB enabled with them. -- John Oliver, CCNAhttp://www.john-oliver.net/ Linux/UNIX/network consulting http://www.john-oliver.net/resume/ *** sendmail, Apache, ftp, DNS, spam filtering *** Colocation, T1s, web/email/ftp hosting - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Cannot Connect
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I just got a copy of MySql and am trying both SqlGui and MySqlcc. In desperation, I also tried the command line. When I finally got it started, it fails to connect, refuses every password and I find I am unable to set a user and a password. I installed the binary for glibc 2.2 (using 2.2.5), but cannot get anything to connect. The website documentation indicates a procedure that requires certain sub-directories, none of which exist in this implementation. Could someone give me at least a hint as to how I can set this up so I can use it? - -- Robert Black Eagle (DS) Get my key from http://www.keyserver.net/en Trying to copyright bits is like trying to make water dry. But politicians try, anyway. -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQE+TS78tjSYKkYJrmcRAiyFAKCMzo4PZCsVCL4VXgkPwgaf4QLpXwCgkgb2 QJ15fho4kWWvngoUei4VIGw= =5Q6h -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Row numbers
On Thu, Feb 13, 2003 at 03:52:18PM -0800, Steve Edberg wrote: That means no field exists or should exist in the database. I only want to generate at query time. I can't use an autoincrement field since that wont work very well with results that are returned out of order and maybe not with all the data. Using variables is the best response to my question. I just dislike using them cause they are ugly to work with because of the session persistance and because I have to issue multiple queries to do the job. If the value isn't being used to even select a row, why not wrap the lines with OL...results.../OL or perhaps just use PHP/Perl/? to do an $i++ for display? Why put this in the query at all, if it has nothing to do with the data? I didn't say it had nothing to do with the data, I said it had nothing to do with the data in the database. The data in the recordset returned from the database referenced by row is important. As I said, sure I could make external functions to do the job. But why? (I did because I have no choice at the moment) 1. There are a lot of functions that return values that have nothing to do with data contained in the database. Math functions for one, they calculate return values using data that is in the database. And many many other functions. Why not one more. In the 4.x series the developers implemented SQL_CALC_FOUND_ROWS and FOUND_ROWS(), something that could just have easily been handled by external programming... 2. There is a use for it. since... 3. Going through the archives, I have seen many many people ask for it. 4. Those numbers probably already exist, how else does it ORDER BY, it has to put the results in an array of some kind - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Cannot Connect
On Fri, Feb 14, 2003 at 12:01:32PM -0600, RBE wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I just got a copy of MySql and am trying both SqlGui and MySqlcc. In desperation, I also tried the command line. When I finally got it started, it fails to connect, refuses every password and I find I am unable to set a user and a password. I installed the binary for glibc 2.2 (using 2.2.5), but cannot get anything to connect. The website documentation indicates a procedure that requires certain sub-directories, none of which exist in this implementation. Could someone give me at least a hint as to how I can set this up so I can use it? Check if you are actually running the daemon :) It should be listening either or both of UNIX socket and TCP port. eg. netstat -l -p and look to the daemon. - Adam - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: New Database,
Really, for non-administrative tasks, you should look at the two sections in the manual that deal with data definition (create, drop, etc) and data manipulation (insert, select, delete)...you're after the data definition stuff. Peter ^_^ - Peter Grigor Hoobly Free Classifieds http://www.hoobly.com - Original Message - From: RBE [EMAIL PROTECTED] To: Peter Grigor [EMAIL PROTECTED] Sent: Friday, February 14, 2003 1:09 PM Subject: Re: New Database, -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Friday 14 February 2003 10:01 am, Peter Grigor wrote: - Original Message - From: Richard Nagle [EMAIL PROTECTED] Okay, I have installed, mySQL, ( all is well ) and now looking to build my first database, is there a comprehensive user manual on how to, say in .pdf format out there ? if not, a on-line link maybe ? See http://www.mysql.com/documentation/index.html I got the manual. It is well done and looks quite complete. HOWEVER (emphasis, not shouting), for us beginners, it is a bit daunting and the instructions for resolving problems assume a directory tree that is not installed with the latest version of MySql. (There is simply no tree at all -- everything is spread all over the disk). Once upon a time, back when DB2 was new, I wrote my own programs and interface using a relational database, but that was a very long time ago. The new programs are supposedly more efficient, but, for me, baffling. The GUI's are really strange as it seems terminology has changed rather radically. Is there -- anywhere -- a Step-by-Step HOWTO around for beginners, even if we were once anything but? - -- Robert Black Eagle (DS) Get my key from http://www.keyserver.net/en Trying to copyright bits is like trying to make water dry. But politicians try, anyway. -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQE+TTDUtjSYKkYJrmcRAgyxAJ9F47KzecKIa+WMjOETTYNwj/XdxACfd7hz eLdxzv23jMeWn0vJRo5Lp9Q= =Dy6G -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ERROR 1005 , Please help
Hi , I have a problem with the mysql database restore. When I take a backup of a database and try to restore it on a particular server(Production) , I get the following error message. ERROR 1005 at line 12: Can't create table './CloneTracking/HitPickFileMaster.frm' (errno: 150) But the same works on the development server running on the same machine. The backup is also from one of the databases in the development server. This is the output of the mysqladmin -version for the two servers mysqladmin Ver 8.23 Distrib 3.23.52, for sun-solaris2.9 on sparc Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.52-log Protocol version10 Connection genomics via TCP/IP TCP port3307 Uptime: 12 hours 47 min 21 sec Sindhu K. Pillai Database Administrator / Developer Fungal Genomics Concordia University - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql 4.09 query cache bug
Hi! [skip] When running a query like: LOAD DATA CONCURRENT INFILE '...' REPLACE INTO TABLE l_data FIELDS TERMINATED BY ',' ENCLOSED BY '\' LINES TERMINATED BY '\n' (list_id,email,f1,f2,f3) [skip] Thank you for your bugreport. Now bug is fixed, here is patch: diff -Nrc a/sql/sql_load.cc b/sql/sql_load.cc *** a/sql/sql_load.cc Fri Feb 14 22:21:22 2003 --- b/sql/sql_load.cc Fri Feb 14 22:21:22 2003 *** *** 336,341 --- 336,342 } if (transactional_table) error=ha_autocommit_or_rollback(thd,error); + query_cache_invalidate3(thd, table_list, 0); err: if (thd-lock) -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Oleksandr Byelkin [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Lugansk, Ukraine ___/ 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: Replication problem
I've narrowed it down a lot. We have two different PHP interfaces for the database. One is for employees to access the data, and the other is for customers. The UPDATEs and INSERTs on the system that customers use is not being replicated, but the one that employees is working perfectly. The system the employees use is located on localhost, while the other isn't. Do you think this would make a difference, how about different versions of the client libs? Any ideas? Phillip Salzman [EMAIL PROTECTED] said: Hello, I just setup replication on mysql 3.23.55 and seem to be having some problems. The slave machine does not seem to want to copy all the data on start. I have a table with 54,000 rows on the master, and after I load up the slave there are only 54,850 on that machine. I can drop the table and do a 'load table from master', and it will update the changes to each row, but won't add new rows to the slave. Has anyone seen this before? I've been looking online and cannot seem to find anything. Any assistance would be very much appriciated. Thanks, --- Phillip Salzman - Before posting, please check: http://www.mysql.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
Rows
Hi, Any one gone over 1000 million rows ? or any where near ? Pref. in ver 4+ with a MyISAM table. Cheers - Jerry @ MetalCat.Net - SQL - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Invalid Date Bug
Is it just me, or does Mysql allow invalid dates to be entered into columns with date datatype? I found some data that blew up in a perl script when doing some date manipulation, and it turns out I have invalid dates in my database, such as June 31, 2003. Of course June never has 31 days. Is this a known bug? honestly, this seems like a pretty basic thing to validate. Is there a patch/fix for it? here's a transcript of a quick test i did afterwards...june 31 enters successfully but not june 33: mysql create table DateTest ( id integer(11), - startDate date); Query OK, 0 rows affected (0.01 sec) mysql desc DateTest; +---+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | +---+-+--+-+-+---+ | id| int(11) | YES | | NULL| | | startDate | date| YES | | NULL| | +---+-+--+-+-+---+ 2 rows in set (0.00 sec) mysql insert into DateTest values (1, '2002-06-31'); Query OK, 1 row affected (0.00 sec) mysql select * from DateTest; +--++ | id | startDate | +--++ |1 | 2002-06-31 | +--++ 1 row in set (0.00 sec) -- Don Vu Madstone Theaters 85 fifth avenue, 12th floor new york new york 10003 p 212.379.1545 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
Re: Invalid Date Bug
At 16:43 -0500 2/14/03, Don Vu wrote: Is it just me, or does Mysql allow invalid dates to be entered into columns with date datatype? I found some data that blew up in a perl script when doing some date manipulation, and it turns out I have invalid dates in my database, such as June 31, 2003. Of course June never has 31 days. Is this a known bug? honestly, this seems like a pretty basic thing to validate. Is there a patch/fix for it? It's by design. MySQL does only minimal validation of date values for maximum server speed. Validate your dates on the client end. If, as you say, it's a pretty basic thing, it shouldn't be too difficult. :-) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Invalid Date Bug
On 14 Feb 2003, at 16:43, Don Vu wrote: Is it just me, or does Mysql allow invalid dates to be entered into columns with date datatype? See the documentation (http://www.mysql.com/doc/en/DATETIME.html): The MySQL server only performs basic checking on the validity of a date: days 00-31, months 00-12, years 1000-. Any date not within this range will revert to -00-00. Please note that this still allows you to store invalid dates such as 2002-04-31. It allows web applications to store data from a form without further checking. To ensure a date is valid, perform a check in your application. -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org Phone 202-667-6653 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Invalid Date Bug
Yep, you're right. Never noticed that before :) I think that would probably be considered a bug. But possibly for efficiency's sake the check was made ultra simple. Peter ^_^ - Peter Grigor Hoobly Free Classifieds http://www.hoobly.com - Original Message - From: Don Vu [EMAIL PROTECTED] To: MySQL Mailing List (E-mail) [EMAIL PROTECTED] Sent: Friday, February 14, 2003 4:43 PM Subject: Invalid Date Bug Is it just me, or does Mysql allow invalid dates to be entered into columns with date datatype? I found some data that blew up in a perl script when doing some date manipulation, and it turns out I have invalid dates in my database, such as June 31, 2003. Of course June never has 31 days. Is this a known bug? honestly, this seems like a pretty basic thing to validate. Is there a patch/fix for it? here's a transcript of a quick test i did afterwards...june 31 enters successfully but not june 33: mysql create table DateTest ( id integer(11), - startDate date); Query OK, 0 rows affected (0.01 sec) mysql desc DateTest; +---+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | +---+-+--+-+-+---+ | id| int(11) | YES | | NULL| | | startDate | date| YES | | NULL| | +---+-+--+-+-+---+ 2 rows in set (0.00 sec) mysql insert into DateTest values (1, '2002-06-31'); Query OK, 1 row affected (0.00 sec) mysql select * from DateTest; +--++ | id | startDate | +--++ |1 | 2002-06-31 | +--++ 1 row in set (0.00 sec) -- Don Vu Madstone Theaters 85 fifth avenue, 12th floor new york new york 10003 p 212.379.1545 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
matlab interface
hello, does anyone know of a good mysql-matlab release 13 interface? the standard database connection capability within matlab is a really poor implementation based on JDBC. JDBC is fine, but not how the matlab people use it. thanks jeff -- Jeff Mathis, Ph.D. 505-995-1434 The Prediction Company [EMAIL PROTECTED] 525 Camino de los Marquez, Ste 6http://www.predict.com Santa Fe, NM 87505 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Invalid Date Bug
At 16:55 -0500 2/14/03, Peter Grigor wrote: Yep, you're right. Never noticed that before :) I think that would probably be considered a bug. But possibly for efficiency's sake the check was made ultra simple. It can be argued either way. You could just as well consider it a bug that you try to shove garbage into your database. :-) Client-side validation has the disadvantage that you must do it in each client, of course. On the other hand, for things like web apps, you may as well validate the data in the client anyway: Suppose MySQL validated the date and returned an error for a bad data. You'd just have to tell the user that anyway, plus you wasted time sending a bad query to the server. If you check the date in your app, you can tell the user immediately and skip the bad query. Peter ^_^ - Peter Grigor Hoobly Free Classifieds http://www.hoobly.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: Invalid Date Bug
I'm with you for sure...client processing is the way to go...fat servers suck. Peter ^_^ - Peter Grigor Hoobly Free Classifieds http://www.hoobly.com - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: Peter Grigor [EMAIL PROTECTED]; Don Vu [EMAIL PROTECTED]; MySQL Mailing List (E-mail) [EMAIL PROTECTED] Sent: Friday, February 14, 2003 4:59 PM Subject: Re: Invalid Date Bug At 16:55 -0500 2/14/03, Peter Grigor wrote: Yep, you're right. Never noticed that before :) I think that would probably be considered a bug. But possibly for efficiency's sake the check was made ultra simple. It can be argued either way. You could just as well consider it a bug that you try to shove garbage into your database. :-) Client-side validation has the disadvantage that you must do it in each client, of course. On the other hand, for things like web apps, you may as well validate the data in the client anyway: Suppose MySQL validated the date and returned an error for a bad data. You'd just have to tell the user that anyway, plus you wasted time sending a bad query to the server. If you check the date in your app, you can tell the user immediately and skip the bad query. Peter ^_^ - Peter Grigor Hoobly Free Classifieds http://www.hoobly.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: Invalid Date Bug
thanks for the thoughts guys...we've already taken steps to validate on the client side. I just never knew about this aspect of date columns and it struck me as odd that a database would allow invalid data to go in...interesting feature. Personally I place a higher premium on data integrity over speed but that's just me... take care, d -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Friday, February 14, 2003 5:00 PM To: Peter Grigor; Don Vu; MySQL Mailing List (E-mail) Subject: Re: Invalid Date Bug At 16:55 -0500 2/14/03, Peter Grigor wrote: Yep, you're right. Never noticed that before :) I think that would probably be considered a bug. But possibly for efficiency's sake the check was made ultra simple. It can be argued either way. You could just as well consider it a bug that you try to shove garbage into your database. :-) Client-side validation has the disadvantage that you must do it in each client, of course. On the other hand, for things like web apps, you may as well validate the data in the client anyway: Suppose MySQL validated the date and returned an error for a bad data. You'd just have to tell the user that anyway, plus you wasted time sending a bad query to the server. If you check the date in your app, you can tell the user immediately and skip the bad query. Peter ^_^ - Peter Grigor Hoobly Free Classifieds http://www.hoobly.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem building .src.rpm
I grabbed MySQL-3.23.55-1.src.rpm to build on my box, due to all the problems I'm seeing with the RPMs from mysql.com But *that* isn't working, either... + automake configure.in:7: your implementation of AM_INIT_AUTOMAKE comes from an configure.in:7: old Automake version. You should recreate aclocal.m4 configure.in:7: with aclocal and run automake again. automake: strings/Makefile.am: Assembler source seen but `CCAS' not defined in `configure.in' automake: strings/Makefile.am: Assembler source seen but `CCASFLAGS' not defined in `configure.in' error: Bad exit status from /var/tmp/rpm-tmp.26184 (%build) RPM build errors: user mysqldev does not exist - using root user mysqldev does not exist - using root user mysqldev does not exist - using root Bad exit status from /var/tmp/rpm-tmp.26184 (%build) This is under Red Hat 8.0, so I do *not* have an old Automake... [joliver@joliver-lnx joliver]$ rpm -qa | grep automake automake-1.6.3-1 automake14-1.4p6-3 automake15-1.5-4 -- John Oliver, CCNAhttp://www.john-oliver.net/ Linux/UNIX/network consulting http://www.john-oliver.net/resume/ *** sendmail, Apache, ftp, DNS, spam filtering *** Colocation, T1s, web/email/ftp hosting - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Infile problem.
Hi List.
I have been working on a problem that is driving me crazy.
I have to create a process in which I upload some info to a table. Since I
have to add some different information to that table, I decided to do it
like this.
1.I create a temporary table copying the structure of my final table. I.E.
$query_temp_table=CREATE TEMPORARY TABLE tguias SELECT * FROM guias WHERE
1=0;
$temp_table=mysql_query($query_temp_table, $cosmo_logistic) or
die(mysql_error());
I do this in PHP.
It works fine It seems.
2. I populate the temporary table.
$query_populate_tguias=LOAD DATA LOCAL INFILE
'c:/cosmo/www/upload/guias.txt' INTO TABLE tguias FIELDS TERMINATED BY ','
ENCLOSED BY '\'
(cliente,asesora,extra1,peso,albaran,gerente,tipo,imprimir);
$populate_tguias=mysql_query($query_populate_tguias, $cosmo_logistic) or
die(mysql_error());
3. Then I pass the information along with some other variables to the real
table.
mysql_select_db($database_cosmo_logistic, $cosmo_logistic);
$query_poblar = SELECT * FROM tguias;
$poblar = mysql_query($query_poblar, $cosmo_logistic) or die(mysql_error());
$row_poblar= mysql_fetch_assoc($poblar);
$totalRows_poblar= mysql_num_rows($poblar);
do {
mysql_select_db($database_cosmo_logistic, $cosmo_logistic);
$query_poblar_guias=INSERT INTO guias
(cliente,asesora,peso,albaran,gerente,tipo,imprimir,manifiesto,Status)
VALUES
(\.$row_poblar['cliente'].\,\.$row_poblar['asesora'].\,.$row_poblar
['peso'].,\.$row_poblar['albaran'].\,\.$row_poblar['gerente'].\,\
.$row_poblar['tipo'].\,.$row_poblar['imprimir'].,\.$manifiesto.\,\A
\);
$poblar_guias=mysql_query($query_poblar_guias, $cosmo_logistic) or
die(No pude insertar el registro .mysql_error());
} while ($row_poblar=mysql_fetch_assoc($poblar));?
with this source file:
13DAN010,D79406,13DAN010, 1 ,20430002201,75301;753,PAQUETE,1
13DAN010,D55816,13DAN010, 1.32
,20430003101,100201;1002,PAQUETE,1
it Does not work at all. I wonder if it is because it has a . in the number
even as the field receiving it is a decimal(10,2) or if it is because in one
of the field I have ;.
The thing is that it will import one, and skip one full record each time.
But the one it inserts, is correctly inserted with the ; and the decimal
point correct. Any idea why it might be pasing one row and adding one?
This is driving me crazy.
When I do this same procedure on another table with source code like:
D79427,LOPEZ DURAN ELISA,ACUEDUCTO TARRAGONA 59,15,PASEOS DEL
BOSQUE,NAUCALPAN,53297, ,LOPEZ DURAN ELISA,,F,T
it Works correctly even as it has two false or true fields.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: Load Data Infile problem.
The thing is that it will import one, and skip one full record each time. But the one it inserts, is correctly inserted with the ; and the decimal point correct. Any idea why it might be pasing one row and adding one? This is typically a problem of not having the line-ending terminator specified correctly. What's the line-ending sequence that you're using in your file? sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Re: Load Data Infile problem.
At 16:53 -0600 2/14/03, Webmaster MBT wrote: Haven't been able to identify it yet... I'm attaching the file so maybe someone can help me with this. Well, it's your data file. You should know what the line terminators are. BTW, how do I tell the command what is the ending symbol? Add a LINES TERMINATED BY clause at the appropriate spot in the LOAD DATA statement. Common ones are: For newlines (common on Unix): LINES TERMINATED BY '\n' For carriage returns (common on Mac OS): LINES TERMINATED BY '\r' For carriage return/linefeed pairs (common on DOS/Windows): LINES TERMINATED BY '\r\n' Note that you may need to double the \ characters to get them passed through PHP properly to MySQL. Thanks in advance. -Mensaje original- De: Paul DuBois [mailto:[EMAIL PROTECTED]] Enviado el: Viernes, 14 de Febrero de 2003 04:43 p.m. Para: [EMAIL PROTECTED] Asunto: Re: Re: Load Data Infile problem. The thing is that it will import one, and skip one full record each time. But the one it inserts, is correctly inserted with the ; and the decimal point correct. Any idea why it might be pasing one row and adding one? This is typically a problem of not having the line-ending terminator specified correctly. What's the line-ending sequence that you're using in your file? sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Cannot Connect
RBE, I just got a copy of MySql and am trying both SqlGui and MySqlcc. In desperation, I also tried the command line. When I finally got it started, it fails to connect, refuses every password and I find I am unable to set a user and a password. It bit more information could help to track down the problem: 1) Which MySQL version do you use? 2) Which OS? 3) Do you connect via localhost, i.e. are your clients running on the same machine as your MySQL server? 4) How exactly are you tring to connect (mysql -hlocalhost -uuser -psecret)? Regards, -- Stefan Hinz [EMAIL PROTECTED] iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 [filter fodder: sql, mysql, query] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Rows
Jerry, Any one gone over 1000 million rows ? or any where near ? I saw something like 4 terabytes of data in a table on this list. Maybe I was too tired by the time I read this, or even asleep already. As MySQL doesn't impose limits to the table size, you're in for a fight with file size limitations by your OS and stuff like that. I'll leave it to Jeremy (jeremy.zawodny.com) and the other gurus to provide you with impressive figures :) Regards, -- Stefan Hinz [EMAIL PROTECTED] iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 [filter fodder: sql, mysql, query] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Row numbers
On Fri, Feb 14, 2003 at 01:04:00PM -0500, Luc Foisy wrote: I didn't say it had nothing to do with the data, I said it had nothing to do with the data in the database. The data in the recordset returned from the database referenced by row is important. [...] 1. There are a lot of functions that return values that have nothing to do with data contained in the database. Math functions for one, they calculate return values using data that is in the database. And many many other functions. Why not one more. You're not just asking for a function whose input doesn't come from the database, you're asking for one whose input comes from a later pass in data processing. After the row is inserted into the final result set, this value has to be updated. In the 4.x series the developers implemented SQL_CALC_FOUND_ROWS and FOUND_ROWS(), something that could just have easily been handled by external programming... I'm sure they weighed the utility of the change (saves a lot of traffic and time, when you need it) against the complexity of its implementation (probably very little, given what it does) and decided it was worth it. Every addition to a language or library has to be made very carefully because they generally will be there forever. The function you describe requires a row to be updated where currently there is no updating going on, adding complexity where there is none now. 2. There is a use for it. since... 3. Going through the archives, I have seen many many people ask for it. I've seen people ask for a ROWNUM() function or somesuch, which reveals the implementation's ordering of records in the source table; that request shows up once in a while (and usually reveals a misunderstanding of rdbms, imo). But in the result set? We're talking about $resultNum++ as you loop through the results. (Or the @x solutions other people have mentioned.) I've never heard someone ask for the functionality you want before. Even if there were many such requests, assigning serial numbers to sequential output, if that's what you want, is what general purpose languages are for, not what relational databases are for. Imo. Extreme example: Why not add SELECT ... INTO EMAIL [EMAIL PROTECTED] to the language so the server can email you results? (You may find examples where the folks at MySQL have chosen to add non-rdbms features into their server, but that doesn't mean they want to add anything whatsoever and then maintain it forever.) 4. Those numbers probably already exist, how else does it ORDER BY, it has to put the results in an array of some kind I believe those numbers are unknown when generating the row values. -- Pete Harlan, who doesn't speak for the MySQL developers of course. [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
Does MySQL store TimeZone and DayLight Saving Time changes ?
Hello, We are running MySQL server Ver 3.23.8 on a Linux system. We have a table that contains a field whose type is MODIFIED | timestamp(14) We would like to find out if there an easy way in MySQL to convert the date that is on the MODIFIED field (timestamp) to GMT time without an external program. Does MySQL store TimeZone and DayLight Saving Time changes ? Or does it have a way to find it once you have a field whose type is timestamp ? Thanks a lot in advance for your help, Patrick, Mariella - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Slower access from a client some router hops away from mysql server
We have developed an application with Visual Basic 6 managing through myoledb some mysql server tables. Perhaps it´s basic, but we have seen that the client application runs much more slower in a point separated through 2 routers and with 2 Mbps circuits than in the vlan where the mysql server is located. I assume that the bandwith is not the problem (a wan connnection with 2Mbps circuits is enough) and there is some fine tunning (application, myoledb or mysqlserver) we are not configuring in a proper way. I will appreciate a lot any ideas about this. Thanks José Luis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Slower access from a client some router hops away from mysql server
We have developed an application with Visual Basic 6 managing through myoledb some mysql server tables. Perhaps it´s basic, but we have seen that the client application runs much more slower in a point separated through 2 routers and with 2 Mbps circuits than in the vlan where the mysql server is located. I assume that the bandwith is not the problem (a wan connnection with 2Mbps circuits is enough) and there is some fine tunning (application, myoledb or mysqlserver) we are not configuring in a proper way. The first think I WOULD check is if bandwidth is the issue. 2 Mbps is much slower than local LAN. Also there is the possiblity of dropped packets and retransmittals. The more routers the slower this would be. Have you checked how busy the WAN is. Just my $0.02 worth. I will appreciate a lot any ideas about this. Thanks José Luis William R. Mussatto, Senior Systems Engineer Ph. 909-920-9154 ext. 27 FAX. 909-608-7061 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Slower access from a client some router hops away from mysqlserver
At 0:44 +0100 2/15/03, Jose Luis Pérez wrote: We have developed an application with Visual Basic 6 managing through myoledb some mysql server tables. Perhaps it´s basic, but we have seen that the client application runs much more slower in a point separated through 2 routers and with 2 Mbps circuits than in the vlan where the mysql server is located. I assume that the bandwith is not the problem (a wan connnection with 2Mbps circuits is enough) and there is some fine tunning (application, myoledb or mysqlserver) we are not configuring in a proper way. Why assume that? It sounds like the application, myoledb and the MySQL server are the constants, and that the network is the independent variable. Bandwidth may appear to be adequate, but it seem to me like the network is where you want to look to find the latency problems. I will appreciate a lot any ideas about this. Thanks José Luis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Search All Fields ?
Hi Im using MYSQL and ASP Im trying to implement a Search cross ALL 40 Fields in the table I have tried lines like b_search = b_search [AGENOTES] LIKE '% pSearch %' OR b_search = b_search [MARITALSTATUS] LIKE '% pSearch %' OR b_search = b_search [CHILDREN] LIKE '% pSearch %' OR b_search = b_search [PARENTS] LIKE '% pSearch %' OR b_search = b_search [SIBLINGS] LIKE '% pSearch %' OR b_search = b_search [YEARSMARRIED] LIKE '% pSearch %' OR b_search = b_search [JCPUBLICATIONDATE] LIKE '% pSearch %' OR b_search = b_search [POSITION] LIKE '% pSearch %' OR to build the search but I get a Query is to Complex error returned. Am I going the right way about this ? I think I can possibly index the fields and then maybe query the index ? Any pointers would be appreciated Regards John Berman - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
myisamchk vs. mysqlcheck
Hi, I have a question about using myisamchk and mysqlchk. I am running myisamchk -s on a certain table and get this error: /usr/local/mysql/bin/myisamchk: MyISAM file /usr/local/mysql/var/db1/my_table.MYI /usr/local/mysql/bin/myisamchk: warning: 1 clients is using or hasn't closed the table properly MyISAM-table '/usr/local/mysql/var/db1/my_table.MYI' is usable but should be fixed I am running mysql while doing the isamchk - which I know should be avoided. But in the manual it says I can do this as long as nobody uses the table I am checking. I do not have any active connections, all connections are sleeping, but I still get the above error. I do not get the error however when I do mysqlcheck db1 my_table. Is the only reason for this the fact that I have mysql running? Are mysqlcheck and myisamchk doing the exact same thing. Or are there scenarios in which one reports errors and the other doesn't. Does mysqlcheck lock tables while checking? If so, does it do full locks or is read-access possible during the check is performed? Thanks, 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: Rows
I've gone over 60 million (per table and there are 4 of them) , had the indexes sorted and it was a fast machine. 4 reference tables (foreign keys) then a counter which made a massive hash. I'm starting to run into system and hard ware problems, more like open files/inodes/through put, opposed to MySQL limits. Which is nice. :) Cheers - Jerry @ MetalCat.Net - SQL - Original Message - From: MySQL List [EMAIL PROTECTED] To: Jerry [EMAIL PROTECTED] Sent: Friday, February 14, 2003 9:51 PM Subject: Re: Rows Uhm, would that even be possible? that is one billion rows. I think that would take forever to search through! What do you think? I'm building an affiliate program, and I'm worried about the impressions, clicks and sales table getting too big, but shoot, if it could hold a few million with no problem, then I probably don't have to worry :o), or should I? Richard. - Original Message - From: Jerry [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, February 14, 2003 3:23 PM Subject: Rows Hi, Any one gone over 1000 million rows ? or any where near ? Pref. in ver 4+ with a MyISAM table. Cheers - Jerry @ MetalCat.Net - SQL - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Own mysqld per database
Hi, I have an idea to reduce the interdependencies between my various databases as far as one database needing to be down for maintenance is affecting other databases on the same server. If I run one mysqld instance for all the databases on a server (the standard setup), all the databases become unavailable if I take mysqld down, even though I might have to do maintenance for only one of the databases. I have seen section 4.7.3 of the manual on mysqld_multi, however, this means defining different ports in all the connect statements in all my scripts/programs I have. Since I do have many scripts/db-connection configuration files, this means changing many files on many servers and i will definitely overlook one or the other file. It also means having to change firewall settings every time I add/remove databases. Is there any way to come in through the standard port for all the databases and then internally redirecting to the various engines/ports so that my clients don't have to know about this? Either as part of the standard MYSQL distribution or some additional add-on/plugin (hopefully a reliable one :) )... Thanks, 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: encrypted password
I came to the same conclusion today after reading the docs again. I would
prefer the des_encode if I need to get things back out of it, but since I'm
running 3.23.55, the des_encode function is not available to me. I have a
need to encrypt data and then retrieve it later (credit card data). I could
probably pass it through and md5 or des function via openssl I suppose and
then store it. Perl and PHP both have functions to handle that.
Curtis
Tonu Samuel said:
On Tue, 2003-02-11 at 15:39, Curtis Maurand wrote:
The manual suggests that the password function is really for intenal
mysql functions. Ideally you should use the encode or md5_encode
functions.
update user set password=encode('password', 'salt') where user =
'your_user';
Unless manual does not say, what method is used for encode(), I would
prefer MD5() which is known to be good enough.
I remember something about encode from source code. If I remember
properly it was home-made algorithm and home-made algorithms are
always known to be keep-away algorithms.
If you need security, always hire expert to analyze your needs and
suggest exact ways to improve it. Even smaller mistake can void all
efforts to secure something. Most security problems I have seen are
results of doing security without knowing about topic. Often they lead
to headlines as it was in CNN few months ago: hackers stoled credit
reports of 15000 people.
Use MD5() for one-way hashing where result never needs to be decrypted
(usually passwords)
Use DES_ENCRYPT() for encrypting data if you want to decrypt it at some
point.
Surely do not use PASSWORD() anywhere.
Tõnu
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
cygwin strangeness
I posted this to the win32 list and didn't get a response yet. Hopefully someone can help me. Config information: Hardware: P3-500 Software: Windows 98 cygwin / bash 2.05b.0(8)-release (i686-pc-cygwin) g++ using gcc version 3.2 20020927 mysql 3.23.55-max-debug for Win32/Win98 on i32 (executables off the web-site) I've even tried compiling with the libraries specified on the web-site with the same results. This same source-code works fine on Linux. Two problems: 1 - Cannot use load_defaults. I look for it and find it in libmysqlclient.lib, but if I link against it I get alot of errors (see following: NoLoadDefault.txt). I am able to link fine using libmySQL.lib but there is no load_defaults available. 2 - mysql_fetch_row() seems to be returning invalid MYSQL_ROW values. I have a query which returns back 100 rows using mysql_store_results(). I can tell this by looking at mysql_affected_rows() and the SQL is correct when executed in mysql. I am able to print a value for the first row, but it's not correct, then when attempting to access the second row, I get a seg-fault. To add to the strangeness, I have a control variable fldCnt which is assigned to 0; I print the value before I enter a for-loop to display the number of fields and columns. When I get into the for-loop, the value changes. I'm also attaching the file - forgive the obvious spastic debugging. Any suggestions? Thanks in advance. -- Amy and Joseph Kormann NoLoadDefault.txt: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- g++ -c InsertMatrix.C -I/usr/include/mysql -I/cygdrive/c/mysql/include In file included from /usr/include/c++/3.2/backward/iostream.h:31, from InsertMatrix.C:10: /usr/include/c++/3.2/backward/backward_warning.h:32:2: warning: #warning This file includes at least one deprecated or antiquated header. Please consider using one of the 32 headers found in section 17.4.1.2 of the C++ standard. Examples include substituting the X header for the X.h header for C++ includes, or sstream instead of the deprecated header strstream.h. To disable this warning use -Wno-deprecated. g++ -c ConnectionManager.C -I/usr/include/mysql -I/cygdrive/c/mysql/include In file included from /usr/include/c++/3.2/backward/iostream.h:31, from ConnectionManager.C:1: /usr/include/c++/3.2/backward/backward_warning.h:32:2: warning: #warning This file includes at least one deprecated or antiquated header. Please consider using one of the 32 headers found in section 17.4.1.2 of the C++ standard. Examples include substituting the X header for the X.h header for C++ includes, or sstream instead of the deprecated header strstream.h. To disable this warning use -Wno-deprecated. g++ -o InsertMatrix -L/cygdrive/c/mysql/lib/opt -lmysqlclient -mt InsertMatrix.o ConnectionManager.o InsertMatrix.o(.text+0xbe):InsertMatrix.C: multiple definition of `_main' /cygdrive/c/mysql/lib/opt/mysqlclient.lib(./release/select_test.obj)(.text+0x0):D:\mysql-3.23.55\c: first defined here Warning: resolving _mysql_query by linking to _mysql_query@8 Use --enable-stdcall-fixup to disable these warnings Use --disable-stdcall-fixup to disable these fixups Warning: resolving _mysql_error by linking to _mysql_error@4 Warning: resolving _mysql_errno by linking to _mysql_errno@4 Warning: resolving _mysql_close by linking to _mysql_close@4 Warning: resolving _mysql_real_connect by linking to _mysql_real_connect@32 Warning: resolving _mysql_init by linking to _mysql_init@4 /cygdrive/c/mysql/lib/opt/mysqlclient.lib(./release/select_test.obj)(.text+0x18):D:\mysql-3.23.55\c: undefined reference to `__iob' /cygdrive/c/mysql/lib/opt/mysqlclient.lib(./release/select_test.obj)(.text+0x76):D:\mysql-3.23.55\c: undefined reference to `__iob' /cygdrive/c/mysql/lib/opt/mysqlclient.lib(./release/select_test.obj)(.text+0xf7):D:\mysql-3.23.55\c: undefined reference to `__iob' /cygdrive/c/mysql/lib/opt/mysqlclient.lib(./release/select_test.obj)(.text+0x117):D:\mysql-3.23.55\c: undefined reference to `__iob' /cygdrive/c/mysql/lib/opt/mysqlclient.lib(./release/libmysql.obj)(.text+0x3c):D:\mysql-3.23.55\l: undefined reference to `_getservbyname@8' /cygdrive/c/mysql/lib/opt/mysqlclient.lib(./release/libmysql.obj)(.text+0x4a):D:\mysql-3.23.55\l: undefined reference to `_ntohs@4' /cygdrive/c/mysql/lib/opt/mysqlclient.lib(./release/libmysql.obj)(.text+0x234):D:\mysql-3.23.55\l: undefined reference to `_socket@12' /cygdrive/c/mysql/lib/opt/mysqlclient.lib(./release/libmysql.obj)(.text+0x24e):D:\mysql-3.23.55\l: undefined reference to `_WSAGetLastError@0' /cygdrive/c/mysql/lib/opt/mysqlclient.lib(./release/libmysql.obj)(.text+0x341):D:\mysql-3.23.55\l: undefined reference to `_inet_addr@4' /cygdrive/c/mysql/lib/opt/mysqlclient.lib(./release/libmysql.obj)(.text+0x3d3):D:\mysql-3.23.55\l: undefined reference to `_htons@4' /cygdrive/c/mysql/lib/opt/mysqlclient.lib(./release/libmysql.obj)(.text+0x406):D:\mysql-3.23.55\l: undefined reference to
mysql@lists.mysql.com
mysql:ÄúºÃ! ÇëÔÊÐíÎÒÏòÄú½éÉÜ´ó·ͨϵÁÐÍøÂçÓªÏúÈí¼þ¡£ ÉÌÕ½²Ð¿á£¬ËÓ®µÃ¸ü¶à¿Í»§Ë¾ÍÓÐÁËÉú´æµÄȨÀû£¬µ«ÄúµÄ¿Í»§ÔÚÄÄÀïÄØ£¿Ñ°ÕÒÄúµÄ¿Í»§ÊÇÃæÁÙÉú´æµÄµÚÒ»²½¡£ ÏÖÔÚÓµÓдó·ͨϵÁÐÓªÏúÈí¼þÒ»ÇбäµÃ¼òµ¥£¬Ö»ÐèÄúÌîÉÏËùÐèÒª¿Í»§µÄÃû³ÆÈçóÒ×¹«Ë¾»¯¹¤ÆóÒµÂÃÓÎÒµ±±¾© µØÇøÍâó½ø³ö¿Ú¹«Ë¾µÈµÈ..¿É¸ù¾ÝÐèÒªÈÎÒâÌîд£¬Ö»Ð輸ÃëÖÓÄãËùÐèÒª¿Í»§¾ÍÁ¢¼´³ÊÏÖÔÚÄúµÄÃæÇ°£¬Ãæ¶ÔÉÏÍò ¼ÒÉõÖÁÉÏ°ÙÍò¼ÒÄúµÄÄ¿±ê¿Í»§ÈçºÎÁ¢¼´ÍƹãÄú×Ô¼ºÄØ£¿Ö»ÐèʹÓÃÎÒÃǵÄÈí¼þ²¢Ð´ÉÏÒ»·âÓʼþÉÌÒµÐź˲¼äÊýÊ®Íò¼Ò ÆóÒµ¾ù¿ÉÁ¢¼´ÊÕµ½£¬Ê£ÏµÄʾÍÊǽӵ绰£¬´¦Àí¶©µ¥ÁË¡£¶øÓÐÕë¶ÔÐԵķ¢ËÍÄúµÄÉÌÒµÓʼþÔò¿ÉÍêÈ«±Ü¿ªÀ¬»øÓʼþµÄ ÏÓÒÉ¡£ ÎÒÃÇ»¹ÎªÄú×¼±¸ÁË´ó·ͨȫÇòÉÌóÐÅÏ¢·¢²¼Èí¼þ£¬Ëü¿ÉʹÄúµÄÉÌÒµÐÅϢ˲¼ä·¢²¼µ½³ÉǧÉÏÍò¼Ò¹úÄÚ»ò¹úÍâµÄÉÌ Ã³ÐÅÏ¢ÍøÕ¾ÉÏ£¬¶øÕâÒ»ÇÐÖ»Ð輸ÃëÖÓʱ¼ä¡£ Ä¿Ç°¹úÄÚÍâÏÖÔÚ¹úÄÚ´ó¶àÊýÆóÒµÒѾ¿ªÊ¼ÊµÊ©×Ô¼ºµÄÍøÂçÓªÏú¼Æ»®£¬¶ø´ó·ͨϵÁÐÍøÂçÓªÏúÈí¼þÊÇÆóÒµÍøÂçÓª ÏúµÄ±Ø±¸¹¤¾ß¼òµ¥µÄ²Ù×÷¼´¿É×öǧÍòÈ˵Ĺã¸æ£¬È«Ã濪ÍØÊг¡¡¢Ñ°ÇóÈ«ÇòÂò¼Ò¡¢·è¿ñÔö¼ÓÏúÊÛ¶©µ¥¡¢Ê÷Á¢ÆóÒµÐÎ Ïó¡¢½«ÆóÒµ¹ã¸æͶÈëËõ¼õΪÁ㣬ÕâÒ»ÇÐÄú¶¼¿ÉÒÔÔÚ˲¼ä×öµ½£¡ Ïêϸ×ÊÁÏÇë·ÃÎÊÎÒÃǵÄÍøÕ¾http://js.yuefeng2000.com»òÕß·¢Óʼþµ½[EMAIL PROTECTED]½øÐÐ×Éѯ£¬´ËÐÅÇë ÎðÖ±½Ó»Ø¸´¡£ ÐĶ¯²»ÈçÐж¯£¬¸Ï¿ìÏÂÔØÊÔÓÃhttp://js.yuefeng2000.com »ò·¢EMAILÃâ·ÑË÷È¡ÊÔÓãº[EMAIL PROTECTED] Áí:±¾¹«Ë¾ÒòÒµÎñ·¢Õ¹ÐèÒª,³ÏÕ÷´úÀí,´ýÓöÓźñ.¸÷µØÇøÖ»ÓÐÒ»¸öÃû¶î,ÓÐÐËȤÕßÇëÀ´µç»òÀ´ÐŽøÐÐÁªÏµ. ´ó·ÍøÂç ÍøÖ·£ºhttp://js.yuefeng2000.com µç»°£º025-2609854£¬4480931 ´«Õ棺025-4480931 ÁªÏµÈË£ºÏÄС½ã µç×ÓÓÊÏ䣺[EMAIL PROTECTED] Ö Àñ! 2003-02-15 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Error No. 7
Hello When I use the Alter table structure command to alter any field, it comes up with an error stating that Error number 7 - error in renaming of table table name.myi to sql-208... and so on with (Errorcode 13). Thus I am unable to change the structure of any table. I am using MySQL ver 3.23.55 and on a Windows XP professional system. Any help. Insane - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Delete duplicate rows
I need to delete duplicate rows. Each row that is in the table has an exact duplicate of itself. There are four columns. No one column could be defined as a primary key; however, two columns together could. What's going to be the best way to do this? Thanks. Lewis mysql, 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: Formatting SQL in Access
query database On Fri, Feb 14, 2003 at 11:17:22AM +1100, Daniel Kasak wrote: You have to use the visual basic constant: vbCrLf Or vbNewLine. Bob Hall - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Red Hat 8.0 compile problems with 4.0.10
I am having trouble compiling a custom mysqld (version 4.0.10) under Red Hat 8.0 - I did email this list a few weeks ago and I have tried a few things since then but I am asking again in the hope that someone more knowledgeable might be able to help. As far as I can tell this is a compiling or linking problem. System information: The system is a dual AMD Athlon MP 1800+ on a Tyan S2466 mainboard with 1GB ram and 1GB swap. The system is using an Adaptec 2400A ATA RAID card. Operating system: Standard installation of Red Hat Linux 8.0 - kernel is 2.4.18-14smp My configure line: ./configure --prefix=/usr/local/mysql-4.0.10 --localstatedir=/home/database/mysql-4.0.10 --enable-assembler --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --enable-thread-safe-client --with-extra-charsets=complex --with-debug --with-tcp-port=3307 --with-unix-socket-path=/tmp/mysql-4.0.10.sock The problem surfaces when the mysql_install_db script attempts to install the prepared grant tables. Output is as follows: [root@jupiter mysql-4.0.10-gamma]# ./scripts/mysql_install_db --defaults-file=/etc/mysql/mysql-4.0.10.cnf Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=268435456 read_buffer_size=1044480 sort_buffer_size=1048568 max_used_connections=0 max_connections=100 threads_connected=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 466543 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=0x83e3718 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Cannot determine thread, fp=0xbf5fefb8, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x8089d51 0x823f280 0x825dc8d 0x822fe03 0x80ab6de 0x8095113 0x823a6d5 0x827669a ./scripts/mysql_install_db: line 1: 18414 Segmentation fault /usr/local/mysql-4.0.10/libexec/mysqld --defaults-file=/etc/mysql/mysql-4.0.10.cnf --log --debug --bootstrap --skip-grant-tables --basedir=/usr/local/mysql-4.0.10 --datadir=/home/database/mysql-4.0.10 --skip-innodb --skip-bdb Installation of grant tables failed! Examine the logs in /home/database/mysql-4.0.10 for more information. You can also try to start the mysqld daemon with: /usr/local/mysql-4.0.10/libexec/mysqld --skip-grant You can use the command line tool /usr/local/mysql-4.0.10/bin/mysql to connect to the mysql database and look at the grant tables: shell /usr/local/mysql-4.0.10/bin/mysql -u root mysql mysql show tables Try 'mysqld --help' if you have problems with paths. Using --log gives you a log in /home/database/mysql-4.0.10 that may be helpful. The latest information about MySQL is available on the web at http://www.mysql.com Please consult the MySQL manual section: 'Problems running mysql_install_db', and the manual section that describes problems on your OS. Another information source is the MySQL email archive. Please check all of the above before mailing us! And if you do mail us, you MUST use the /usr/local/mysql-4.0.10/bin/mysqlbug script! [root@jupiter mysql-4.0.10-gamma]# The stack trace resolved as follows: 0x8089d51 handle_segfault + 431 0x823f280 __pthread_sighandler + 116 0x825dc8d vfprintf + 8057 0x822fe03 _db_doprnt_ + 189 0x80ab6de _Z19close_thread_tablesP3THDb + 290 0x8095113 handle_bootstrap + 779 0x823a6d5 pthread_start_thread + 177 0x827669a thread_start + 4 If anyone has any ideas, or even better, if anyone has a solution to this problem then please reply to this post. Many thanks, Duncan Maitland [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
