³Ì·sø¹Ï³nÅ餤¤åª©¤W¥«Åo
(7¤ù¸Ë)¡Aµ´¹ï¶WÈ!(Á`ª÷ÃB: 1000¤¸) Windows XP PRO SP-1 ¤¤¤å±M·~¥úºÐ¥¿¦¡ª© Windows XP Service Pack 1¥]§t¤F±qWindows XP¥h¦~10¤ë30¤é¤W¥«¥H¨Óªº©Ò¦³×¥¿¡A ³o¨Ç×¥¿µ{¦¡¥]§t¤F¦b¦w¥þ©Êªº´£°ª¡A©Ê¯àªº¥[±j¤Î¿ù»~ªº×¥¿¡A ·íµM§ó¥[¤J¤F¥þ·sªºµwÅé³W®æ¤ä´©¡A¤×¨ä¬O USB 2.0ªº¤ä´©¡A ¦Ó¥þ·sªºWINDOWS XP°£¤F§ó·s¤F¨t²Îªº°ÝÃD¤§¥~¡A ³o¦¸§ó¬Oº«×´£¨Ñ¥i¥H±Nì¥ý©Ò·L³n©Ò´£¨ÑªºInternet Explorer 6¤ÎOutlook Express ÁÙ¦³MediaPlayer ²¾°£¡A³o¥i¬O±qWindows 98 ¥H«áªº²Ä¤@¦¸®@!! CD-KEY: FCKGW-RHQQ2-YXRKT-8TG6W-2B7Q8 Office XP PRO SP-2 ¤¤¤å±M·~¥úºÐ¥¿¦¡ª© Microsoft Office XP Service Pack 2¥]§t¤F±qMicrosoft Office XP ±q¤W¥«¥H¨Óªº©Ò¦³×¥¿¡A ·íµM¤]¥]§t¤F¤§«eªºMicrosoft Office XP Service Pack 1ªº¿ù»~×¥¿¡A ¦Ó³o¨Ç×¥¿µ{¦¡°£¤F¦bºô¸ôªº¦w¥þ±±ºÞ¤W¦³µÛ¤j´T«×ªº×§ï¤§¥~¡A ³Ì«n¤]¬O³Ì¥Dnªº´N¬O§ó·s¤F³Ì·s¤@¥Nªº.NET ¤ä´©¡A³o¥]§t¤F¨â¤j³¡¥÷¡G CD-KEK:FM9FY-TMF7Q-KCKCT-V9T29-TBBBG 1.Microsoft Office XP Service Pack 2 ¥]§t Office XP ¤¸¥óªº³Ì·s§ó·s¡C ¦¹ Service Pack ©M³Ì·sªº§Þ³N¬Ò¬Û®e¡A¦p MicrosoftR Windows XP ©M Office XP Service Pack 2¡A ¨Ã§ïµ½¼Æ¦ì»öªíªO³]p¤¶±ªº¥i¾a©Ê©M SQL Server ¤u§@¬yµ{³]p¤u¨ãªº©µ®i©Ê 2. MicrosoftR Office XP Web Services Toolkit 2.0 ±N«Â¤O±j¤jªº XML Web Service ±a ¤J Office XP¡AÅý¶}µo¤Hû¥i¥Hª½±µ±q Visual Basic ½s¿è¾¹¤º¨Ï¥Î´¶¤Î´yz±´¯Á»P¾ã¦X (Universal Description Discovery and Integration¡A UDDI) ¥ø·~µn¿ý¸ê°T©Î¬O URL ¦Ü Web ªA°È´yz»y¨¥¤u¨ã (Web Services Description Language¡A WSDL ) Àɮצb Office XP ¤è®×¤º°Ñ¦Ò XML Web Service PhotoImpact8¤£¦ý´«¤W¤F¤Í¥ß³Ì·s³]pªºImage¡AÅý¤H¦Õ¥Ø¤@·s¡F ¥\¯à¤W¤]¦]À³¥þ²y¼Æ¦ì¬Û¾÷»P¼v¹³³B²zªº·¦æ¡A·s¼W¤F«Ü¦h¦b¶Ì¥Ê¤Î¼Æ¦ì¬Û¾÷§@¤£¨ìªº¹ê¥Î¥\¯à¡A Åý¼Æ¦ì¼v¹³³B²z§óEasy¡B§óSmart¡F¦bºô¶¤W¡iPhotoImpact8¤¤¤åª©¡j ÁÙ·s¼W¤Fjava§ë¼v¤ù¨qµ¥³Ð·s¥\¯à¡F¨Ï¥ÎªÌ¥iºÉ±¡µo´§³Ð·N¡A»´ÃP§¹¦¨µL³Ð·N·Q¹³¡F ¦¹¥~PhotoImpact8ÁÙÝÅUºô¶»s§@¡Bø¹Ï³]p¡B°Êµe¯S®Ä¡B¨q¹ÏºÞ²zµ¥§¹¾ã¥\¯à¡A Åý¼v¹³µL¥i¯à¡Bºô¶¶W¯Åºë±m!! s/n:124A3-08000-39318665 Adobe PhotoShop V7.0.1 ¤¤¤å¼Ð·Ç¥úºÐ¥¿¦¡ª© ¼W±j±zªºÄá¼v³N ¡E ±j¤jªº¦â±m®Õ¥¿¤u¨ã ¡E ¦b«O¯d¦â½Õ©M¯¾²zªº¦P®É²¾°£·å²«ªº×¸Éµ§¨ê ¡E ¥Î©ó¥i½s¿è¦¡½Æ¦Xªº¹Ï¼h ¡E ºë½T«×¾B¦â¤ù ¡E §Ö³t¦C¦L¾ãÓ¸ê®Æ§¨¼v¹³ªº²Õ¦Xª©±¤u¨ã ¡E «OÅ@±i¶K¦bºô¶¤W¹Ï®×ªº¯B¤ô¦L ¡E ¦bµô¤Á®É×¥¿³zµø¹Ïªººë±Kµô¤Á¤u¨ã CD-KEY: 1045-1675-8851-3712-6899-6209 ¶W¯Åªº¡ÕCorelDRAW 10¡Ö¡G¥]§t¼v¹³½s¿è³nÅéCore PHOTO-PAINT 10¡A ¥H¤Î·s¼Wªº¦V¶q°ÊºA¯S®Ä³nÅéCorel R.A.V.E.¡C ¥þ·sªº¾Þ§@¤¶±¤W¡ÕCorelDRAW 10¡Ö¤w±N¤u¨ã½c¡B¿ï³æ¡B¤u¨ã¦Cµ¥¥\¯à§¹¥þªº¾ã¦X¦b¤@°_¡A ¦ÓÅý¨Ï¥ÎªÌ¯à¦Û¦æ¥[¥H©w¸q¡A±N±`¥Î¤§¤¬°Ê¤u¨ã¬D¿ï¥X¨Ó¡A¨Ï±o¾ãÓ³]p¤u§@§ó¥[¨³³t¡B¦³®Ä²v¡C ¿Õ¹y¨¾¬r 2003 ¤¤¤åª© Norton AntiVirus 2003 Norton.Ghost.2003 ÁcÅ餤¤åª© ¥þ²y³Ì¨ü«H¿àªº¨¾¬r³nÅé ¤ä´©§@·~¥¥x Windows XP Home/XP Pro/2000 Pro/NT WS/ME/98 ¦Û°Ê²M°£¯f¬r ¨Ï¥Î¹q¸£¤£¨ü¤zÂZ §Y®É¨¾Å@¹q¤l¶l¥ó©M§Y®É°T®§ ³s½u§Y¦Û°Ê§ó·s ©è¿m·s¯f¬r Adobe llustrator V10.0.3 ¤¤¤å¥úºÐ¥¿¦¡ª© AdobeR IllustratorR 10 ³nÅé¥H¬ð¯}©Ê¡B´I¦³³Ð·Nªº¿ï¶µ©M¥\¯à±j¤jªº¤u¨ãÅý±z¦³®Ä¦a¦bºô¶¡B ¦L¨ê«~©M¥ô¦ó¦a¤è¤½§G§@«~¡A¬É©w¤F¦V¶q¹Ï§Îªº¥¼¨Ó¡C ±z¥i¥H¨Ï¥Î²Å¸¹©M³Ð·sªº¤Á³Î¿ï¶µ¨Ó»s§@ºë¬üªººô¶¹Ï§Î¡A ÁÙ¥i¥H¥Î§Y®É§á¦±¤u¨ã¨Óµo´§³Ð·N¡C ¨Ï¥ÎÆF¬¡ªºªº¼Æ¦ì¦¡¹Ï§Î©M¨ä¥¦»s§@¥\¯à¨Ó¤½§G¹Ï§Î¡A¨³³t¬Ù®É¡C CD-KEY: 1034-1003-4400--1115-2040 ~~~¦@p7¤ù¸Ë¡Aµ´¹ï¶WÈ!(Á`ª÷ÃB: 1000¤¸) ±ýª¾¸Ô²Ó»¡©ú Disk 1:·L³n Windows XP SP-1 ¤¤¤å±M·~¥úºÐ¥¿¦¡ª© Disk 2:·L³n Office XP SP-2 ¤¤¤å±M·~¥úºÐ¥¿¦¡ª© Disk 3:¤Í¥ßPHOTOIMPACT 8.0 ÁcÅ餤¤å¥¿¦¡ª© Disk 4:Adobe PhotoShop V7.0.1 ¤¤¤å¼Ð·Ç¥úºÐ¥¿¦¡ª© Disk 5:CorelDraw10 ÁcÅ餤¤å¥¿¦¡ª© Disk 6:NORTON ANTIiVIRUS 2003 ¿Õ¹y2003¨¾¬r³nÅéÁcÅ餤¤å¥¿¦¡ª© Norton.Ghost.2003 ÁcÅ餤¤åª© Disk 7:Adobe Illustrator V10.0.3 ¤¤¤å¥úºÐ¥¿¦¡ª© ±ýqÁʪ̡A½Ð¦^«H ¡I¦pªG¦b24¤p®É¤º¨S¦³¦^À³¡B½Ð¦AqÁʤ@¦¸ q¤ù«H½c: [EMAIL PROTECTED] ±Ä¦v°t³q¥N¦¬³f»ù¤è¦¡¥æ©ö,´N¬O·í¦v°t³q±NªF¦è°e¦Ü®É, ±z¥un±N³f´Ú¥æ¥Iµ¹¦v°t³q¤Hû§Y¥i ª`·N¡G½Ð¯d¹q¸Ü ¡i¶ñ¼g½d¨Ò¡j ©m¦W : ¦¬¥ó¦a§} : ¶l»¼°Ï¸¹ : ¹q¸Ü : e-mail : qÁʤº®e:qÁʤ@®M±M·~®MÀ\(7¤ù¸Ë)µ´¹ï¶WÈ!(Á`ª÷ÃB: 1000¤¸)(¶l¸ê§K) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Create table, wrong datatype
Hello! When I run this script the char-fields is converted to varchar. Row-format is dynamic. I think it is because i have a text-field in the script. When I change the text field to somthing else I got the datatype char in the char-columns. I have tried to alter the colums to char but it doesn't work. How do I get around this problem? I use mysql-3.23.55-win and win2000. Regards Ulla #= # Table: BasAtgard #= create table BasAtgard ( AtgIdint not null, ArbBeskrId int not null, Rubrik char(40) null, Beskrivning text null, VardeTillBakasmallint not null, RegDatum datetime null, RegAvchar(20) null, AndradDatum datetime null, AndradAv char(20) null, Raknare int null, PRIMARY KEY (AtgId) ) TYPE=InnoDB; - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL not logging from my LINUX machine to windows
Hi.. Ok i have snort working and logging on my LINUX machine192.168.0.1. They are alerts in /var/log/snort/alerts and portscan. I have it setup soo it is suppose to log to my windows machine192.168.0.69 running MYSQL. I have been using this as my reference: http://www.sans.org/rr/intrusion/practical_guide.php Im on the last step but the MYSQL on my windows machine is not logging anything. I know that my Linux machine is connected to MYSQL on the windows machine becasue im using KERIO firewall and it shows the MYSQL connected to 192.168.0.1 and it tranferred 2016 bytes but stoped but i cant see anything in the events. I dont have a CLUE why or how to DEBUG this. Can someone help. If you need my /etc/snort.conf file it is posted here: http://sourceforge.net/mailarchive/forum.php?thread_id=1638741forum_id=3972 Any help on how to debug this problem and get MYSQL to start logging. _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Query Help
I think you can't If you want this why is this table structure? Details shold be as columns nos as records in separate table - just to lose time ? On Tue, 11 Feb 2003 13:13:31 +, Jeff Snoxell [EMAIL PROTECTED] wrote: Hi, How can I write a MySQL query to grab single lines of the form: ColumnNames: EnquiryID, Name, Address, Detail1, Detail2, Detail3, Detail4 From two joined tables: Tbl1: Enquiries -- ID Name Address Etc Tb12: Details ID EnquiryID Detail Etc There is an imposed maximum number of details per enquiry (say 4 for this example). Many thanks, Jeff - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL SELECT and INSERT not following (my) logic
I have the follow MySQL queries for pulling out ans then inserting a record from a record set. Unfortunately I think I have missed something (vital) as the record being inserted is the value and not the name, for example 1 instead of blue... can someone kindly have a look and spot where I have gone wrong? records pulled: function showColor($item_id) { $query=select ref_colours.* from item_color ,ref_colours where ref_colours.ColorID=item_color.color_id and item_color.item_id=$item_id; $rs=mysql_query($query); if(!$rs) { echo Error while exeuting the query; } else { while($row=mysql_fetch_array($rs)) { $color_id=$row['ColorID']; $cName=$row['ColorName']; echo option value=\$color_id\$cName/option; } } } records displayed: (and the actual color names displyed!!!) echo SELECT name=\size\ value=\$size\; showSize($II); echo /SELECT ; record selected inserted into a temp table: (but the color value instead of the color name goes in) mysql($DBName,INSERT INTO CartItems VALUES ('$UID','$ItemID','$ItemQuantity','$Date','$CartItemsID','$ColorName',' $size')) ; I have tried inserting color_id and cName too but no joy. This is not making sense. I has previously been said but that just doesn't follow with the logic. If a color name has been pulled why isn't the said color name selected being inserted. If this makes sense to someone I am listening with speakers turned up high. Thank you Andrew --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.449 / Virus Database: 251 - Release Date: 27/01/2003 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
two questions in mysql
Hi All, I have mysql 3.23.41 on windows 2000 I have two questions I need to ask. 1) I want bigger value for the max_connections variable. can I define the value in my.ini file? how can I define this variable? 2) I tried to insert into table a string with the char ' and mysql failed to do this. how can I solved this problem? are there any other chars like this? Thanks and please try to help Inbal - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Recursion
Rob, This is a common problem in document management, where I have a reasonable amount of experience. Unfortunately, the short answer is, that to be completely generic, efficient and elegant, it's a bit of an impossible problem. What we have always done in this situation is to maintain an additional denormalised column called FullPath so, expanding your sample data a bit: ID | Name | ParentID | FullPath 1 | Bob | 0| 1 2 | John | 1| 1/2 3 | Elm | 1| 3/1 4 | Sue | 2| 1/2/4 5 | Dave | 4| 1/2/4/5 6 | Fred | 5| 1/2/4/5/6 etc. This initially seems like a horrible solution, raddled with problems. However it's actually quite efficient. The application has to manage the Full Path on updates (although it's easy to rebuild it and check integrity if you screw it up). It's also easy to find anything at any level under an object using string comparisons. If you move a folder (parent) to [new path], you have to do an update such as UPDATE table set FullPath = [new path] + substring(oldpath, [new Path Length]) WHERE fullpath like '[old path]%' Again this is indexed and pretty efficient. If you like, you can remove the objects own id from the fullpath and make it effectively parent path Hope this helps. All the best, Andy -Original Message- From: Rob [mailto:[EMAIL PROTECTED]] Sent: 12 February 2003 07:18 To: [EMAIL PROTECTED] Subject: Recursion Hi all, I need some help with recursion in mySql. I have the following table: ID | Name | ParentID 1 | Bob | 0 2 | John | 1 3 | Elm | 1 etc. For a given ID, I need to recurse up the tree and get all the parents. I've already read about Joe Celko's nested set approach, but it's not a good solution as apparently updates are a real pain and this table will be modified heavily. Does anyone have any good suggestions?? Maybe store procs (although, by all accounts store proc functionality doesn't come standard with mySql)?? Thanks --- Rob ** Rob Cherry mailto:[EMAIL PROTECTED] +27 21 447 7440 Jam Warehouse RSA Smart Business Innovation http://www.jamwarehouse.com ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: socket error
I really am running it all again ! Obviously though I am going wrong somewhere... I have killed it all and run it again 3 times now and getting the same errors, I think it is because I have done it so many times now... I have copied and pasted everything that i have typed (sorry that it is quite alot) in the hope that someone can see where I am going wrong: here it is after I have killed everything: [root@jt local]# cd sfiles [root@jt sfiles]# ls acid-0.9.6b21.tar.gz mysql/phplot-4.4.6.tar.gz apache_1.3.24-i686-whatever-linux22.tar.gz MySQL-Max-3.23.42-1.i386.rpm snort-1.8.6.tar.gz gd-2.0.11/ mysql.tar.gz snortrules.tar.gz gd-2.0.11.tar.gz openssl-0.9.6c.tar.gz zlib-1.1.4/ libpcap-0.7.1.tar.gz php-4.1.2.tar.gz zlib.tar.gz mod_ssl-2.8.8-1.3.24.tar.gz phplens27-021230.tgz [root@jt sfiles]# cd mysql [root@jt mysql]# ./configure --prefix=/usr/local/mysql --localstatedir=/var/mysql NOTE: This is a MySQL binary distribution. It's ready to run, you don't need to configure it! To help you a bit, I am now going to create the needed MySQL databases and start the MySQL server for you. If you run into any trouble, please consult the MySQL manual, that you can find in the Docs directory. Installing all prepared tables 030212 9:22:48 ./bin/mysqld: Shutdown Complete To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: ./bin/mysqladmin -u root password 'new-password' ./bin/mysqladmin -u root -h jt.redhat password 'new-password' See the manual for more instructions. NOTE: If you are upgrading from a MySQL = 3.22.10 you should run the ./bin/mysql_fix_privilege_tables. Otherwise you will not be able to use the new GRANT command! You can start the MySQL daemon with: cd . ; ./bin/safe_mysqld You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory: cd sql-bench ; run-all-tests Please report any problems with the ./bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at https://order.mysql.com Starting the mysqld server. You can test that it is up and running with the command: ./bin/mysqladmin version [root@jt mysql]# Starting mysqld daemon with databases from /usr/local/sfiles/mysql/data [root@jt mysql]# scripts/mysql_install_db Installing all prepared tables 030212 9:23:13 ./bin/mysqld: Shutdown Complete To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: ./bin/mysqladmin -u root password 'new-password' ./bin/mysqladmin -u root -h jt.redhat password 'new-password' See the manual for more instructions. NOTE: If you are upgrading from a MySQL = 3.22.10 you should run the ./bin/mysql_fix_privilege_tables. Otherwise you will not be able to use the new GRANT command! You can start the MySQL daemon with: cd . ; ./bin/safe_mysqld You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory: cd sql-bench ; run-all-tests Please report any problems with the ./bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at https://order.mysql.com [root@jt mysql]# echo /usr/local/mysql/lib/mysql /etc/ld.so.conf ldconfig [root@jt mysql]# groupadd mysql groupadd: group mysql exists [root@jt mysql]# useradd -g mysql mysql useradd: user mysql exists [root@jt mysql]# chown -R root:mysql /usr/local/mysql [root@jt mysql]# chown -R mysql /usr/local/mysql/bin [root@jt mysql]# chown -R mysql /var/mysql chown: failed to get attributes of `/var/mysql': No such file or directory [root@jt mysql]# chown -R mysql /usr/local/mysql [root@jt mysql]# chown -R mysql.mysql /usr/local/mysql [root@jt mysql]# scripts/mysql_install_db Installing all prepared tables 030212 9:26:45 ./bin/mysqld: Shutdown Complete To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: ./bin/mysqladmin -u root password 'new-password' ./bin/mysqladmin -u root -h jt.redhat password 'new-password' See the manual for more instructions. NOTE: If you are upgrading from a MySQL = 3.22.10 you should run the ./bin/mysql_fix_privilege_tables. Otherwise you will not be able to use the new GRANT command! You can start the MySQL daemon with: cd . ; ./bin/safe_mysqld You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory: cd sql-bench ; run-all-tests Please report any problems with the ./bin/mysqlbug script! The latest information
RE: Recursion
Thanks. Awesome idea. We'll probably use that :-) --- Rob ** Rob Cherry mailto:[EMAIL PROTECTED] +27 21 447 7440 Jam Warehouse RSA Smart Business Innovation http://www.jamwarehouse.com ** -Original Message- From: Andy Eastham [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 12, 2003 11:36 AM To: Mysql@Lists. Mysql. Com Subject: RE: Recursion Rob, This is a common problem in document management, where I have a reasonable amount of experience. Unfortunately, the short answer is, that to be completely generic, efficient and elegant, it's a bit of an impossible problem. What we have always done in this situation is to maintain an additional denormalised column called FullPath so, expanding your sample data a bit: ID | Name | ParentID | FullPath 1 | Bob | 0| 1 2 | John | 1| 1/2 3 | Elm | 1| 3/1 4 | Sue | 2| 1/2/4 5 | Dave | 4| 1/2/4/5 6 | Fred | 5| 1/2/4/5/6 etc. This initially seems like a horrible solution, raddled with problems. However it's actually quite efficient. The application has to manage the Full Path on updates (although it's easy to rebuild it and check integrity if you screw it up). It's also easy to find anything at any level under an object using string comparisons. If you move a folder (parent) to [new path], you have to do an update such as UPDATE table set FullPath = [new path] + substring(oldpath, [new Path Length]) WHERE fullpath like '[old path]%' Again this is indexed and pretty efficient. If you like, you can remove the objects own id from the fullpath and make it effectively parent path Hope this helps. All the best, Andy -Original Message- From: Rob [mailto:[EMAIL PROTECTED]] Sent: 12 February 2003 07:18 To: [EMAIL PROTECTED] Subject: Recursion Hi all, I need some help with recursion in mySql. I have the following table: ID | Name | ParentID 1 | Bob | 0 2 | John | 1 3 | Elm | 1 etc. For a given ID, I need to recurse up the tree and get all the parents. I've already read about Joe Celko's nested set approach, but it's not a good solution as apparently updates are a real pain and this table will be modified heavily. Does anyone have any good suggestions?? Maybe store procs (although, by all accounts store proc functionality doesn't come standard with mySql)?? Thanks --- Rob ** Rob Cherry mailto:[EMAIL PROTECTED] +27 21 447 7440 Jam Warehouse RSA Smart Business Innovation http://www.jamwarehouse.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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
JDBC and LOAD DATA LOCAL INFILE : The used command is not allowed with this MySQL version
Hello, I'm using this command into a Java servlet LOAD DATA LOCAL INFILE \ + FIC_DB + \ REPLACE INTO TABLE news; It runs well with mysql-3.23.45 but not with mysql-3.23.55 The error message is : java.sql.SQLException: General error: The used command is not allowed with this MySQL version at org.gjt.mm.mysql.MysqlIO.sendCommand(MysqlIO.java:497) at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(MysqlIO.java:550) at org.gjt.mm.mysql.MysqlIO.sqlQuery(MysqlIO.java:635) at org.gjt.mm.mysql.Connection.execSQL(Connection.java:882) at org.gjt.mm.mysql.Connection.execSQL(Connection.java:815) at org.gjt.mm.mysql.Statement.executeQuery(Statement.java:169) at org.gjt.mm.mysql.jdbc2.Statement.executeQuery(Statement.java:78) ... I compiled mysql-3.23.55 with the option --enable-local-infile and runs it with the argument! --local-i nfile=1. If I use the mysql client, it runs but not inside my Java servlet. Could you help me to find a solution ? Thank you Cédric. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 MacOS9
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello List, I am realy stucked. My Application (C++,OS9) needs to connect to a MySQL-Database. But I can't find any informations how I can do that. Maybe you can give me a hint? Thats what i tried: 1. I found http://www.openlinksw.com/ (ODBC). But they have no MySQL-Drivers. 2. I found http://www.lilback.com/macsql/ (Last update 1999 :-). He said he wrote an API for OS9. But he don't anwser my emails! 3. I tryed to connect my Server via XMLRPC (Zope as middle-tier). But I can't find any hints about XMLRPC on OS9. Is the last option to write my own Mysql-API? P.S. If you think about to anwser with OSX: I can't use OSX. The application currently works on OSX. We have 250 Macs here with running OS9. And our Main-Application don't work on OSX. Even in Classic-Mode! So we have to use OS9! P.P.S. No! Java don't want to run on our 32-MB machines! ;-) - -- GEEK CODE Version: 3.12 GCS d--- s+:+ a C UL+++ P--- L+++ E++ W+++ N++ o K- w+++ O-- M-- V-- PS++ PE-- Y+ PGP+ t++ 5 X- R+++ tv- b+++ DI+++ D++ G e++ h r++ y+++ -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE+SiVoPYtbdJ+vYfgRArg7AJ9yQqT624oWAxZF5p+IPpRgk5fpewCg4+SE zncErYA7Z974/nT/9gjzeao= =9fCg -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: MySQL MacOS9
Hi, The approach I am suggesting is the one that you might use as a last resort. I do not know much about C/C++ programming in OS9. If you could find some ODBC Driver ( or any other API that can be used from C++ on OS9 ) that could talk to JDBC drivers, then you may connect to MySQL from JDBC, and used that driver for connection. What i have in mind is the use of some ODBC-JDBC Bridge (reverse of JDBC-ODBC bridge present in Java) Hope it helps, Shamit - Original Message - From: Stowasser Harald [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, February 12, 2003 4:13 PM Subject: MySQL MacOS9 -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello List, I am realy stucked. My Application (C++,OS9) needs to connect to a MySQL-Database. But I can't find any informations how I can do that. Maybe you can give me a hint? Thats what i tried: 1. I found http://www.openlinksw.com/ (ODBC). But they have no MySQL-Drivers. 2. I found http://www.lilback.com/macsql/ (Last update 1999 :-). He said he wrote an API for OS9. But he don't anwser my emails! 3. I tryed to connect my Server via XMLRPC (Zope as middle-tier). But I can't find any hints about XMLRPC on OS9. Is the last option to write my own Mysql-API? P.S. If you think about to anwser with OSX: I can't use OSX. The application currently works on OSX. We have 250 Macs here with running OS9. And our Main-Application don't work on OSX. Even in Classic-Mode! So we have to use OS9! P.P.S. No! Java don't want to run on our 32-MB machines! ;-) - -- GEEK CODE Version: 3.12 GCS d--- s+:+ a C UL+++ P--- L+++ E++ W+++ N++ o K- w+++ O-- M-- V-- PS++ PE-- Y+ PGP+ t++ 5 X- R+++ tv- b+++ DI+++ D++ G e++ h r++ y+++ -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE+SiVoPYtbdJ+vYfgRArg7AJ9yQqT624oWAxZF5p+IPpRgk5fpewCg4+SE zncErYA7Z974/nT/9gjzeao= =9fCg -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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Table name 'con' ignored.
MySql, I was trying to create a table named 'con' on version 3.23.52-max-nt and found my request was ignored: mysql create table if not exists con ( code integer unsigned not null auto_increment primary key, ... ... ) type=innodb; Query OK, 0 rows affected (0.00 sec) A 'show tables' would not list this table. Nothing showed up in the error log. Oddly, I had some foreign key's defined to this table 'con' in later tables, which were accepted without problem?? Can anybody explain what's going on, and what I should / should not be doing?? Thanks, Ben - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Table name 'con' ignored.
* Ben Clewett I was trying to create a table named 'con' on version 3.23.52-max-nt and found my request was ignored: mysql create table if not exists con ( code integer unsigned not null auto_increment primary key, ... ... ) type=innodb; Query OK, 0 rows affected (0.00 sec) A 'show tables' would not list this table. Nothing showed up in the error log. Oddly, I had some foreign key's defined to this table 'con' in later tables, which were accepted without problem?? Can anybody explain what's going on, and what I should / should not be doing?? CON is a special device name in DOS (and win), so is NUL, LPT1, LPT2, COM1, COM2 and so on. This should not prevent you from creating a table with these names, but I am guessing this is the reason for the bug. I tried this on my 3.23.30-gamma on w2k: mysql create table CON (id int); ERROR 1050: Table 'con' already exists mysql create table NUL (id int); ERROR 1050: Table 'nul' already exists mysql create table LPT1 (id int); ERROR 1050: Table 'lpt1' already exists mysql create table LPT2 (id int); ERROR 1050: Table 'lpt2' already exists mysql create table LPT3 (id int); ERROR 1050: Table 'lpt3' already exists mysql create table COM1 (id int); ERROR 1050: Table 'com1' already exists mysql create table COM2 (id int); ERROR 1050: Table 'com2' already exists None of the tables really existed. I experience this only on win platform, no problem on linux or solaris. -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Change default CHARACTER SET value
To perform correct ORDER BY I need to use win1251 charset. I know that this can be set from my.cfg or in the my.ini: [mysqld] default-character-set=win1251 The problem is that I cant use this because I have limited account on my hosting provider's server (I can't restart the server and I even don't have write permissions for these files). So I want to change it for session with SET server_variable command. (http://www.mysql.com/doc/en/SET_OPTION.html) - But How ??? show variables like character_set; +---++ | Variable_name | Value | +---++ | character_set | latin1 | +---++ SET character_set=win1251; #Returns error ! Thank You in advance, Mirko P.S. Server: MySQL v3.23.55; Client: mysql client, PHP, Perl-DBI. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: JDBC and LOAD DATA LOCAL INFILE : The used command is notallowed with this MySQL version
Hi all, please let me now if there is a solution to this. I am facing the same problem. Anis [EMAIL PROTECTED] [EMAIL PROTECTED] Wednesday, February 12, 2003 3:48:16 PM Hello, I'm using this command into a Java servlet LOAD DATA LOCAL INFILE \ + FIC_DB + \ REPLACE INTO TABLE news; It runs well with mysql-3.23.45 but not with mysql-3.23.55 The error message is : java.sql.SQLException: General error: The used command is not allowed with this MySQL version at org.gjt.mm.mysql.MysqlIO.sendCommand(MysqlIO.java:497) at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(MysqlIO.java:550) at org.gjt.mm.mysql.MysqlIO.sqlQuery(MysqlIO.java:635) at org.gjt.mm.mysql.Connection.execSQL(Connection.java:882) at org.gjt.mm.mysql.Connection.execSQL(Connection.java:815) at org.gjt.mm.mysql.Statement.executeQuery(Statement.java:169) at org.gjt.mm.mysql.jdbc2.Statement.executeQuery(Statement.java:78) ... I compiled mysql-3.23.55 with the option --enable-local-infile and runs it with the argument! --local-i nfile=1. If I use the mysql client, it runs but not inside my Java servlet. Could you help me to find a solution ? Thank you Cédric. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Managing replication logs
hi all i have established a two way replication setup my problem is that my hard disk gets occupied by the log files; i tried purging the files but after some time again my hard disk gets filled with the log files could any one please tell me how to manage the log files. thanks anirudh mysql, queries - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Very slow select query with IN(...)
Hi! I have posted this message yerstaday, but apperantly did not give enough information for reader to figure out what's going on. So, i am reposting it with more information. I have the following table: create table law_words ( l_id int unsigned not null, w_id int unsigned not null, primary key (w_id, l_id) ); The request is: SELECT DISTINCT w0.l_id FROM law_words as w0 inner join law_words as w1 on w0.l_id=w1.l_id WHERE w0.w_id IN (258,282,287, 615, 1101, 1949, 1968, 3417, 3574, 3578, 3643,4345,4768, 5297, 5976,6133, 7243,7245, 9271, 9348, 11146, 11150, 11172, 11232,11847, 12542, 12859, 14811, 24839, 26653,27662) AND w1.w_id IN (405, 2017,2192, 2592, 2595, 2603, 2981, 4055, 4068, 4346,5755, 6480, 9384,9408, 11513, 11514, 12126, 12134, 12638, 13052, 13643, 13769,13836, 13945, 14154, 14693, 14867, 14980, 15518, 15557, 17830, 19005, 19051, 19247, 20176, 20926, 22364, 22365, 22366, 22732, 24668,24793, 24956, 25286, 26242, 26665, 26847, 27144, 27348, 27815, 28494, 30910, 31878, 32161, 33586, 34396); The basic idea is thart law_words holds index of words (w_id) for each law (l_id), so law can be found by words, which are specified by user and the their ids are looked up in vocabulary table. Now law_words has 228207 records and that request takes about 2 seconds on a pc with 1GB of RAM and dual Pentium III XEON 550Mhz, which is TOO MUCH! Explain shows thart mysql is using ' range' and primary index, and about 500 records for each table. HERE IS EXPLAIN: +---+---+---+-+-+--+--+--- ---+ | table | type | possible_keys | key | key_len | ref | rows | Extra| +---+---+---+-+-+--+--+--- ---+ | w0| range | PRIMARY | PRIMARY | 4 | NULL | 473 | where used; Using index; Using temporary | | w1| range | PRIMARY | PRIMARY | 4 | NULL | 479 | where used; Using index; Distinct| +---+---+---+-+-+--+--+--- ---+ 2 rows in set (0.01 sec) For more than three specified words request takes about forever, so no search is possible. The request is using INNER JOIN to get the words in the 'AND' manner (laws which contain ALL specified words). I mean, that the table is joined with itself, so only law_id which have all the specified words are returned. I don't understand what I am doing wrong, since i thought it is a basic technology behind any word search engine. I really do not want to use fulltext search because it does not do any morphology and some other stuff that I need. Please, help, if you can. Regards, Artem - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 overhead
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Stefan, et al -- ...and then Stefan Hinz said... % % MyISAM tables (the default table type in MySQL) become fragmented ... % % If you don't optimize fragmented MyISAM tables, they will become slow % to scan because the operating system will need more time for disk % operations. % % Details: http://www.mysql.com/doc/en/OPTIMIZE_TABLE.html Very interesting. A) Is this the sort of thing that people do from a cron job to make sure that they don't have too much fragmentation? Does it actually show up more than once in a milennium for most people? B) What about the postscript at that URL describing problems with this command? 1) Are there still problems? 2) Is there yet any concrete data on the problems? a) Is it repeatable and deterministic or still an unknown target? b) Is it better to OPTIMIZE more often, and thereby make little optimizations, to avoid such problems, or is any OPTIMIZE a game of roulette and so one should do it only when absolutely needed? 3) What does one do if one has a fragmented table and yet cannot optimize it because of said problems? TIA HAND mysql query, :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE+SkVeGb7uCXufRwARAmgVAJ44GYFx97PSP1M91WLzM4QVtuhD6wCeIrv4 Fk3EjXnXauthotttSlAA5eA= =ciJb -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: Managing replication logs
I too would be interested in a good way of clearing the binary log files (preferably non disruptive to the server ;-) The only thing thats saving me so far is that the systems capacity is 320Gb. danny Anirudha Kukreti wrote: hi all i have established a two way replication setup my problem is that my hard disk gets occupied by the log files; i tried purging the files but after some time again my hard disk gets filled with the log files mysql, queries - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Very slow select query with IN(...)
On Wed, 12 Feb 2003 15:50:29 +0300 Artem Koutchine [EMAIL PROTECTED] wrote: Hi! I have posted this message yerstaday, but apperantly did not give enough information for reader to figure out what's going on. So, i am reposting it with more information. I have the following table: create table law_words ( l_id int unsigned not null, w_id int unsigned not null, primary key (w_id, l_id) ); The request is: SELECT DISTINCT w0.l_id FROM law_words as w0 inner join law_words as w1 on w0.l_id=w1.l_id WHERE w0.w_id IN (258,282,287, 615, 1101, 1949, 1968, 3417, 3574, 3578, 3643,4345,4768, 5297, 5976,6133, 7243,7245, 9271, 9348, 11146, 11150, 11172, 11232,11847, 12542, 12859, 14811, 24839, 26653,27662) AND w1.w_id IN (405, 2017,2192, 2592, 2595, 2603, 2981, 4055, 4068, 4346,5755, 6480, 9384,9408, 11513, 11514, 12126, 12134, 12638, 13052, 13643, 13769,13836, 13945, 14154, 14693, 14867, 14980, 15518, 15557, 17830, 19005, 19051, 19247, 20176, 20926, 22364, 22365, 22366, 22732, 24668,24793, 24956, 25286, 26242, 26665, 26847, 27144, 27348, 27815, 28494, 30910, 31878, 32161, 33586, 34396); The basic idea is thart law_words holds index of words (w_id) for each law (l_id), so law can be found by words, which are specified by user and the their ids are looked up in vocabulary table. Now law_words has 228207 records and that request takes about 2 seconds on a pc with 1GB of RAM and dual Pentium III XEON 550Mhz, which is TOO MUCH! Explain shows thart mysql is using ' range' and primary index, and about 500 records for each table. Try add index on (l_id,w_id) and see if it helps. And see if it runs faster without distinct. -- _/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] - _/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl _/_/_/_/ _/_/_/ul. Traugutta 115c, 80-237 Gdansk, tel/fax. (58)5215625 _/ _/ _/ ==* http://szukaj.wp.pl *==-- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Create table, wrong datatype
Hello: Because you have a variable length column type (text) in the row, mysql changes char() types to varchar. This behavior is discussed in the manual in Silent Column Change Specifications under CREATE TABLE. If the stored length of these columns is an issue, you can move the variable length fields to another table. However, the varchar() type reduces storage requirements without a performance penalty. If the retrieved/displayed length is the issue, you can use the LPAD or RPAD functions as appropriate. Doug On Wed, 12 Feb 2003 09:21:31 +0100, Ulla Wensman wrote: Hello! When I run this script the char-fields is converted to varchar. Row-format is dynamic. I think it is because i have a text-field in the script. When I change the text field to somthing else I got the datatype char in the char-columns. I have tried to alter the colums to char but it doesn't work. How do I get around this problem? I use mysql-3.23.55-win and win2000. Regards Ulla #= # Table: BasAtgard #= create table BasAtgard ( AtgIdint not null, ArbBeskrId int not null, Rubrik char(40) null, Beskrivning text null, VardeTillBakasmallint not null, RegDatum datetime null, RegAvchar(20) null, AndradDatum datetime null, AndradAv char(20) null, Raknare int null, PRIMARY KEY (AtgId) ) TYPE=InnoDB; - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
error 2013 on rh8.0
this is probably an issue already solved or at least treated on this list - so please forgive. nevertheless I encountered the error 2013 when i tried to connect from another machine to the machine holding the mysqlserver running with the standard mysql package resp. the updated mysql package and the updated kernel ..2.4.18-24.8.0smp I know a workaround by starting mysql with --skip-name-resolve. This works. I know MySQL from www.mysql.com version 3.23.55. This works too. The first apears to me as an ugly approach, the latter means I have to recompile everything for connectivity of apache/php/mysql, because standard rpm's from RH don't go with this. If anyone knows how to fix this issue with RedHat packages - please drop me a line. MReger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: JDBC and LOAD DATA LOCAL INFILE : The used command is not allowedwith this MySQL version
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Ahmed S K Anis wrote: Hi all, please let me now if there is a solution to this. I am facing the same problem. Anis [EMAIL PROTECTED] [EMAIL PROTECTED] Wednesday, February 12, 2003 3:48:16 PM Hello, I'm using this command into a Java servlet LOAD DATA LOCAL INFILE \ + FIC_DB + \ REPLACE INTO TABLE news; It runs well with mysql-3.23.45 but not with mysql-3.23.55 The error message is : java.sql.SQLException: General error: The used command is not allowed with this MySQL version at org.gjt.mm.mysql.MysqlIO.sendCommand(MysqlIO.java:497) at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(MysqlIO.java:550) at org.gjt.mm.mysql.MysqlIO.sqlQuery(MysqlIO.java:635) at org.gjt.mm.mysql.Connection.execSQL(Connection.java:882) at org.gjt.mm.mysql.Connection.execSQL(Connection.java:815) at org.gjt.mm.mysql.Statement.executeQuery(Statement.java:169) at org.gjt.mm.mysql.jdbc2.Statement.executeQuery(Statement.java:78) ... I compiled mysql-3.23.55 with the option --enable-local-infile and runs it with the argument! --local-i nfile=1. If I use the mysql client, it runs but not inside my Java servlet. Could you help me to find a solution ? You have to use the 3.0 Connector/J drivers for 'LOAD DATA LOCAL INFILE'. See http://www.mysql.com/products/connector-j/ The support for 'LOAD DATA LOCAL INFILE' appeared in 3.0, the latest version. It was never in MM.MySQL (which is what you're using, I assume something like 2.0.14), so I don't know how it was _ever_ working for you :) -Mark - -- MySQL 2003 Users Conference - http://www.mysql.com/events/uc2003/ For technical support contracts, visit https://order.mysql.com/?ref=mmma __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mark Matthews [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.1.90 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE+Sk2MtvXNTca6JD8RAkjDAKDHfJR6jCsHRrGq3yxK+LTCPzRbWQCfc0Ld RUnZYHgbelXstPKvO2qOj8U= =IvB1 -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
Cannot drop a table.
MySql, Version 3.23.52-max-nt I cannot drop a table. My syntax is: drop table if exists cust I get: MySql Error: Count not execute command [drop table if exists cust] on server because: Unknown table 'cust' This is true, it does not exist, although I still have a cust.frm file for some reason, without it's counterparts. This only happens with this file, all others work as expected, and the 'if not exists' is respected. Can anybody let me know what's going on? Ben - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Very slow select query with IN(...)
But you're not using the word search engine, which would be the full text index. I'm not sure what you mean by morphology. MySQL 4 full text searches support a lot of things, including using * as the truncation operator. Aside from that, perhaps it's the speed of your processor that bottlenecking you. I know Xeon is a server chip, but in your case Mhz might be the best way to go since you are only doing one thing. On Wednesday, February 12, 2003, at 07:50 AM, Artem Koutchine wrote: I don't understand what I am doing wrong, since i thought it is a basic technology behind any word search engine. I really do not want to use fulltext search because it does not do any morphology and some other stuff that I need. -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: JDBC and LOAD DATA LOCAL INFILE :
Thanks Mark, I tried to work with the latest driver. 3.0.4 Now it gave error shown below . Also see code snippet below at the end Error code is0 estoredata1.txt'for 'LOAD DATA LOCAL INFILE' command.Due to underlying IOExcepti on: ** BEGIN NESTED EXCEPTION ** java.io.FileNotFoundException estoredata1.txt (The system cannot find the file specified) STACKTRACE: estoredata1.txt (The system cannot find the file specified) at java.io.FileInputStream.open(Native Method) at java.io.FileInputStream.init(FileInputStream.java:59) at com.mysql.jdbc.MysqlIO.sendFileToServer(MysqlIO.java:1505) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:964) at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:911) at com.mysql.jdbc.Connection.execSQL(Connection.java:1777) at com.mysql.jdbc.Connection.execSQL(Connection.java:1711) at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1293) at Sanity.Restore(Sanity.java:138) at Sanity.main(Sanity.java:70) CODE SNIPPET String filepath = sys:\\restore\\data1.txt; String query = load data local infile \' + filepath + \' into table trail; stmt.executeUpdate(query); what could be wrong here ? Anis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Migrating Microsoft Access to MySQL
Hi Edward, Use DBTools Manager 2.0.1 (http://www.dbtools.com.br). It imports structure, data, indexes, queries and relationships from MSAccess and it's totally free. []s Crercio - Original Message - From: Edward Kim [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 11, 2003 4:54 PM Subject: Migrating Microsoft Access to MySQL I am with a small business in Southern California that would like to migrate our MS Access databases to MySQL server. Are their any computer service companies who can help me? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: JDBC and LOAD DATA LOCAL INFILE :
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Ahmed S K Anis wrote: Thanks Mark, I tried to work with the latest driver. 3.0.4 Now it gave error shown below . Also see code snippet below at the end Error code is0 estoredata1.txt'for 'LOAD DATA LOCAL INFILE' command.Due to underlying IOExcepti on: ** BEGIN NESTED EXCEPTION ** java.io.FileNotFoundException estoredata1.txt (The system cannot find the file specified) STACKTRACE: estoredata1.txt (The system cannot find the file specified) at java.io.FileInputStream.open(Native Method) at java.io.FileInputStream.init(FileInputStream.java:59) at com.mysql.jdbc.MysqlIO.sendFileToServer(MysqlIO.java:1505) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:964) at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:911) at com.mysql.jdbc.Connection.execSQL(Connection.java:1777) at com.mysql.jdbc.Connection.execSQL(Connection.java:1711) at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1293) at Sanity.Restore(Sanity.java:138) at Sanity.main(Sanity.java:70) CODE SNIPPET String filepath = sys:\\restore\\data1.txt; String query = load data local infile \' + filepath + \' into table trail; stmt.executeUpdate(query); what could be wrong here ? First, you do realize that 'load data local infile' means load the file that is on the client and send it to the server. Second, Java is saying it can't open the file 'estoredata1.txt', which either means it doesn't exist at the path you say it does, or the permissions are wrong. Can you load this same file using the MySQL command-line client using the _exact_ same path? -Mark - -- MySQL 2003 Users Conference - http://www.mysql.com/events/uc2003/ For technical support contracts, visit https://order.mysql.com/?ref=mmma __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mark Matthews [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.1.90 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE+Slf+tvXNTca6JD8RAq+YAJ0bV2N62jOE7UsCOL2aOH4A7Y2MnACgiQRw uLPb/oWgEJubdksxBafP6RU= =uzys -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
,,.
mysql:ÄúºÃ! ÐÂÕ¾¿ªÕÅ,ÐÝÏкÃÈ¥´¦,ÇëÄúµãÆÀÒ»ÏÂ. Ö÷Á¦Õ¾£º¡¡http://fenggwx.126.com Á÷ÐиèÇúÒôÀÖÕ¾£º http://yinyuewx.126.com FlashÕ¾£º http://flashwz.126.com ¼«Æ·Ð´ÕæͼƬվ£º http://jpxzw.126.com ÍøÖ·Õ¾£º http://webwz.126.com Ö Àñ! ·ç¹âÎÞÏÞÍøÕ¾ [EMAIL PROTECTED] 2003-02-12 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: JDBC and LOAD DATA LOCAL INFILE :
Yes Mark it worked from the command line. The Archived resides at the server side. I ran Load data local infile 'sys:\\mail\\dump.txt into table X it worked. The from a different machine i ran this java program. The Archived file still exists at the DB server side. So i guess local option is not necessary. It didnt work though I guess the path it takes is wrong. String filepath = sys:\\restore\\data1.txt; String query = load data local infile \' + filepath + \' into table x it takes as estoredata1.txt as file name not clear why ? Like to add here that Select * into outfile works perfect from JDBC wiht same filepath Mark Matthews [EMAIL PROTECTED] Wednesday, February 12, 2003 7:49:42 PM -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Ahmed S K Anis wrote: Thanks Mark, I tried to work with the latest driver. 3.0.4 Now it gave error shown below . Also see code snippet below at the end Error code is0 estoredata1.txt'for 'LOAD DATA LOCAL INFILE' command.Due to underlying IOExcepti on: ** BEGIN NESTED EXCEPTION ** java.io.FileNotFoundException estoredata1.txt (The system cannot find the file specified) STACKTRACE: estoredata1.txt (The system cannot find the file specified) at java.io.FileInputStream.open(Native Method) at java.io.FileInputStream.init(FileInputStream.java:59) at com.mysql.jdbc.MysqlIO.sendFileToServer(MysqlIO.java:1505) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:964) at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:911) at com.mysql.jdbc.Connection.execSQL(Connection.java:1777) at com.mysql.jdbc.Connection.execSQL(Connection.java:1711) at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1293) at Sanity.Restore(Sanity.java:138) at Sanity.main(Sanity.java:70) CODE SNIPPET String filepath = sys:\\restore\\data1.txt; String query = load data local infile \' + filepath + \' into table trail; stmt.executeUpdate(query); what could be wrong here ? First, you do realize that 'load data local infile' means load the file that is on the client and send it to the server. Second, Java is saying it can't open the file 'estoredata1.txt', which either means it doesn't exist at the path you say it does, or the permissions are wrong. Can you load this same file using the MySQL command-line client using the _exact_ same path? -Mark - -- MySQL 2003 Users Conference - http://www.mysql.com/events/uc2003/ For technical support contracts, visit https://order.mysql.com/?ref=mmma __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mark Matthews [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.1.90 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE+Slf+tvXNTca6JD8RAq+YAJ0bV2N62jOE7UsCOL2aOH4A7Y2MnACgiQRw uLPb/oWgEJubdksxBafP6RU= =uzys -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: Create table, wrong datatype
Ulla, When I run this script the char-fields is converted to varchar. Row-format is dynamic. I think it is because i have a text-field in the script. This MySQL feature (silent column type change) is documented here: http://www.mysql.com/doc/en/Silent_column_changes.html 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Strange sorting in table
Viktor, I have a couple of tables in a MySQL database. In one of the tables, PhpMyAdmin sorts very strange. ID 1002 is places between ID 21 and ID 22. Any idea why? Have a look at the table structure. You will find 'ID' is an AUTO_INCREMENT column. When entries are deleted, they leave gaps. These gaps are filled with records newly entered. So what you see is the physical order. If you want another sort order, you could issue ... ORDER BY ID. Details: http://www.mysql.com/doc/en/CREATE_TABLE.html 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 create table either now...
MySql, magor problems! Ver 3.23.52-max-nt I find I cannot create a table (in my db 'rr'), which probably caused my previous posted problem. Works perfectly with MyISAM, but not with InnoDB. No SQL differnce. When executing I get: MySql Error: Could not execute command [create table if not exists job ( code integer unsigned not null auto_increment primary key, cus varchar(8), index i_cus (cus), foreign key (cus) references cus (code), cust_ref varchar(20), order_no varchar(20), booked_by varchar(16), invoice_type enum ( 'normal', 'separate', 'internal' ) not null, job_date date, notes text ) type=innodb;] on server because: Can't create table '.\rr\job.frm' (errno: 150) The odd thing being that, as you can see, I am using 'type=innodb', yet it's trying to create the .frm file in my current database directory. I don't belive this is normal, as the help files say the .frm is created in the 'test' directory. Where no changes have taken place. The log file only shows a correct startup, followed by: 030212 13:51:33 Innodb: Started To make things more weird, I previously created an MyISAM table 'cus', to which this is linked. After this above statment was run, the cust.MYD and cust.MYI have been deleted, just leaving the cust.frm file Which from pervious experience means a 'cust' database can not not be dropped or created until this file is manually erased. Is it something I am doing wrong? Any help, much needed. PS, sorry for sending email by Outlook Exress. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: JDBC and LOAD DATA LOCAL INFILE :
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Ahmed S K Anis wrote: Yes Mark it worked from the command line. The Archived resides at the server side. I ran Load data local infile 'sys:\\mail\\dump.txt into table X it worked. The from a different machine i ran this java program. The Archived file still exists at the DB server side. So i guess local option is not necessary. It didnt work though I guess the path it takes is wrong. String filepath = sys:\\restore\\data1.txt; String query = load data local infile \' + filepath + \' into table x it takes as estoredata1.txt as file name not clear why ? Because '\\' in Java is the escape code for a _single '\' :) You need to get \\ in String literals. What your String actually ends up being is sys:\restore\data1.txt, and '\' also has special meaning in MySQL. -Mark - -- MySQL 2003 Users Conference - http://www.mysql.com/events/uc2003/ For technical support contracts, visit https://order.mysql.com/?ref=mmma __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mark Matthews [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.1.90 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE+Sl0btvXNTca6JD8RAmptAKCqDXC/l8YnSqemI5YbHVhlaC187wCfVzRG OPROaY07+yKvKHHjuwy7uEU= =V70Y -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: JDBC and LOAD DATA LOCAL INFILE :
* Ahmed S K Anis [...] String filepath = sys:\\restore\\data1.txt; String query = load data local infile \' + filepath + \' into table x it takes as estoredata1.txt as file name not clear why ? A double backslash will in many environments be reduced to a single backslash. Your result indicate that you are in such an environment (VBA?), as mysql only sees single backslashes: mysql select sys:\restore\data1.txt; +--+ estoredata1.txt | +--+ estoredata1.txt | +--+ 1 row in set (0.00 sec) Try to double your backslashes twice: String filepath = sys:restoredata1.txt Your programming environment will remove every other backslash, so that mysql sees this: mysql select sys:\\restore\\data1.txt; ++ | sys:\restore\data1.txt | ++ | sys:\restore\data1.txt | ++ 1 row in set (0.00 sec) -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Is there anything equivalent to Oracle9i's list partitioning?
I've recently learned that Oracle has the ability to partition table data, Oracle9i's list partitioning feature. http://www.oracle.com/oramag/oracle/02-jan/index.html?o12part.html I'm trying to find out if MySQL or any open source database has something equivalent to this. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Very slow select query with IN(...)
No, I do not believe that MHZ is the bottle neck. Basically, we can ignore that this is a dual box, because it is a FREEBSD and only one CPU runs a whole process. 650Mhz is enough for doing a little web search engine and I have seen a lot of applications which use the same technology (vocabulary table - word index table - document table) for seaching GIGABYTES of documents and everything runs very fast (about 5 seconds for 1Gig of documents). FULLTEXT does not do morphology. That is word forms as well as synonims (i am actually working with Russian language where words change in many ways depending if it is plural, male, female, etc). Actually, i cannot belive that it takes mysql 2 seconds to select 120 records from a table with two ints with 23 records with a index. This just sounds unreal. - Original Message - From: Brent Baisley [EMAIL PROTECTED] To: Artem Koutchine [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, February 12, 2003 4:57 PM Subject: Re: Very slow select query with IN(...) But you're not using the word search engine, which would be the full text index. I'm not sure what you mean by morphology. MySQL 4 full text searches support a lot of things, including using * as the truncation operator. Aside from that, perhaps it's the speed of your processor that bottlenecking you. I know Xeon is a server chip, but in your case Mhz might be the best way to go since you are only doing one thing. On Wednesday, February 12, 2003, at 07:50 AM, Artem Koutchine wrote: I don't understand what I am doing wrong, since i thought it is a basic technology behind any word search engine. I really do not want to use fulltext search because it does not do any morphology and some other stuff that I need. -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Is there anything equivalent to Oracle9i's list partitioning?
In the last episode (Feb 12), Jeff Bearer said: I've recently learned that Oracle has the ability to partition table data, Oracle9i's list partitioning feature. http://www.oracle.com/oramag/oracle/02-jan/index.html?o12part.html I'm trying to find out if MySQL or any open source database has something equivalent to this. Mysql has things called MERGE tables, which present multiple little phyisical tables as one table to the user. You would have to manually insert records into the correct table, though, and MySQL's optimizer currently does very badly on MERGE tables, so they're not really a good choice yet. -- Dan Nelson [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: Licence Free Import/Export for Access?
Hi Is there a licence free way to Import (and Export) Access databases (mdb files) into (out from) mySQL? I've read the FAQs and looked at the converters available but it appears to me that all of these require the Access program to work. Is there any way of converting to/from MDB files without using the Access tool. Many thanks Neil Dr Neil Williams Director MetaMedia 103 High Street Dunfermline Fife KY12 7DR United Kingdom t: +44 (0) 1383 729 412 f: +44 (0) 1383 735 912 m: +44 (0) 7976 852 467 e: [EMAIL PROTECTED] w: www.metamedia.uk.com --- - - This message is sent in confidence for the addressee only. It may contain legally privileged information. The contents are not to be disclosed to anyone other than the addressee. Unauthorised recipients are requested to preserve this confidentiality and to advise the sender immediately of any error in transmission. - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 2013 on rh8.0
Heinz great hint - poor success actually installed is 2.2.93 if i force it in maybe mysql functions - other thing will fail in bulk. kr mr Stefan Hinz [EMAIL PROTECTED] 02/12/03 15:41 PM Markus, If you're lucky, you might be able to use this RPM: ftp://ftp.suse.com/pub/suse/i386/update/8.1/rpm/i586/glibc-2.2.5-161.i58 Once again, a broken or not compatible glibc, I guess. 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Very slow select query with IN(...)
On Wed, 12 Feb 2003 15:50:29 +0300 Artem Koutchine [EMAIL PROTECTED] wrote: Hi! I have posted this message yerstaday, but apperantly did not give enough information for reader to figure out what's going on. So, i am reposting it with more information. I have the following table: create table law_words ( l_id int unsigned not null, w_id int unsigned not null, primary key (w_id, l_id) ); The request is: SELECT DISTINCT w0.l_id FROM law_words as w0 inner join law_words as w1 on w0.l_id=w1.l_id WHERE w0.w_id IN (258,282,287, 615, 1101, 1949, 1968, 3417, 3574, 3578, 3643,4345,4768, 5297, 5976,6133, 7243,7245, 9271, 9348, 11146, 11150, 11172, 11232,11847, 12542, 12859, 14811, 24839, 26653,27662) AND w1.w_id IN (405, 2017,2192, 2592, 2595, 2603, 2981, 4055, 4068, 4346,5755, 6480, 9384,9408, 11513, 11514, 12126, 12134, 12638, 13052, 13643, 13769,13836, 13945, 14154, 14693, 14867, 14980, 15518, 15557, 17830, 19005, 19051, 19247, 20176, 20926, 22364, 22365, 22366, 22732, 24668,24793, 24956, 25286, 26242, 26665, 26847, 27144, 27348, 27815, 28494, 30910, 31878, 32161, 33586, 34396); The basic idea is thart law_words holds index of words (w_id) for each law (l_id), so law can be found by words, which are specified by user and the their ids are looked up in vocabulary table. Now law_words has 228207 records and that request takes about 2 seconds on a pc with 1GB of RAM and dual Pentium III XEON 550Mhz, which is TOO MUCH! Explain shows thart mysql is using ' range' and primary index, and about 500 records for each table. Try add index on (l_id,w_id) and see if it helps. And see if it runs faster without distinct. I tried adding that index - it is not used at all as shown by explain. Without DISTINCT it runs just a little faster (hundredth of a second) but i NEED distinct anyhow. Artem - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 4.1 clustering/hign avaliability
Hello, I have two servers each one has mysql 4.1 running with seperate disks Is there a way that the 2 mysqld have exactly the same data (besides replication) ? Is there a way that if one server crashes mysql will be avaliable? Does mysql 4.1 have any extra culstering capabilities? Thank you -- Kissandrakis S. George [[EMAIL PROTECTED]] Network and System Administrator [http://www.phaistosnetworks.gr/] Phaistos Networks S.A. - A DOL Digital Company - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
./support-files/mysql.server bug
Hi All, Downloaded mysql-standard-4mysql-standard-4.0.10-gamma-sun-solaris2.8-sparc.tar.gz. If this is NOT installed in /usr/local/mysql and you try and start it using support-files/mysql.server it fails with error: $ ./support-files/mysql.server start ./support-files/mysql.server: /usr/local/mysql: does not exist Yet in ./support-files/mysql.server on line 30: # If you install MySQL on some other places than /usr/local/mysql, then you # have to do one of the following things for this script to work: # # - Run this script from within the MySQL installation directory Yet this is incorrect as the script will not look in . and tries /usr/local/mysql Section 2.4.3 of the Online Manual Contradicts this: You might need to edit mysql.server if you have a binary distribution that you've installed in a non-standard location. Could someone with bitkeep access update mysql.server accordingly so that it matches what is documented (in binary installs need to edit the file) Many Thanks. Greg Cope GCS Ltd Assign to: CIT, Sandwich - ISG Phone: (44) 01304 642040 Fax: (44) 01304 652118 LEGAL NOTICE Unless expressly stated otherwise, this message is confidential and may be privileged. It is intended for the addresee(s) only. Access to this e-mail by anyone else is unauthorised. If you are not an addressee, any disclosure or copying of the contents of this e-mail or any action taken (or not taken) in reliance on it is unauthorised and may be unlawful. If you are not an addressee, please inform the sender immediately. Pfizer Limited is registered in England under No. 526209 with its registered office at Ramsgate Road, Sandwich, Kent CT13 9NJ This message and any attachment has been virus checked by Pfizer Corporate Information Technology, Sandwich. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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.1 clustering/hign avaliability
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Kissandrakis -- ...and then Kissandrakis Giorgos said... % % Hello, Hi! % ... % Does mysql 4.1 have any extra culstering capabilities? I don't know about mysql directly, but I'm sure it would work just fine as an application under an OS cluster. What platform are you using? % % % Thank you HTH HAND mysql query, :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE+Sm33Gb7uCXufRwARAqgPAJ9WGTSUy7m9ILS1pLq5/xX+E0M1MgCg3oOD t5CFGJPYeqIGdwOfSz9/nBg= =E1OO -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: Licence Free Import/Export for Access?
Is there a licence free way to Import (and Export) Access databases (mdb files) into (out from) mySQL? I've read the FAQs and looked at the converters available but it appears to me that all of these require the Access program to work. Is there any way of converting to/from MDB files without using the Access tool. There are some things you can do with Perl here. I've used DBD::ODBC to pull from/put to Access databases on one side and the appropriate DBD:: module on the other side (in this case DBD::mysql) to pull from/put to the non-Access database. The systems I did this with all has Access installed. Whether that's a DBD::ODBC requirement, I don't know ... Also, if you're doing this on a non-Windows box you need to install an ODBC driver, which may not be free. 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: mysql privs table level security
Any idea at all, anyone? Cheers, Andrew -Original Message- From: Andrew Braithwaite Sent: 11 February 2003 17:52 To: [EMAIL PROTECTED] Subject: mysql privs table level security Hi all, Can anyone help me please? I have a database with hundreds of tables and I want to lock down certain tables for select only. The order of presidence for mysql privs as far as I can tell is that if there are database level privileges, these override the table level privs. I don't want to have to issue a grant for each of the tables in the db - but only wish to specify which tables need to be read only. I could go into the datadir and chmod 440 the files in question, but this would deny write privs to all users wheras I would like certain users to have write access. Any ideas? Cheers, Andrew Sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Is there anything equivalent to Oracle9i's list partitioning?
I've recently learned that Oracle has the ability to partition table data, Oracle9i's list partitioning feature. http://www.oracle.com/oramag/oracle/02-jan/index.html?o12part.html I'm trying to find out if MySQL or any open source database has something equivalent to this. See the MySQL MERGE TABLE type - http://www.mysql.com/doc/en/MERGE.html You have to allocate inserts to different partitions in your application, but you can merge many partition tables into one for the purpose of SELECT, DELETE, and UPDATE. Alec - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Has somebody got an example of Foreign Keys
I am using 4.0.10-gamma-max-nt, with 100% innodb, and cannot get Foreign Keys to create. The help files give this example: CREATE TABLE child(id INT, parent_id INT, INDEX par_ind (parent_id), FOREIGN KEY (parent_id) REFERENCES parent(id) ON DELETE SET NULL ) TYPE=INNODB; My syntax is: create table if not exists sub ( code varchar(8) primary key, name varchar(30) not null, notes text, sup varchar(8) not null, index i_sup (sup), foreign key (sup) references sup(code) on delete set null ) type=innodb; I get: MySql Error: Could not execute command [create table if not exists sub ( code varchar(8) primary key, name varchar(30) not null, notes text, sup varchar(8) not null, index i_sup (sup), foreign key (sup) references sup(code) on delete set null ) type=innodb;] on server because: Can't create table '.\rr\sub.frm' (errno: 150) Which is very annoying, as I can't move on from here... The error message is really no help. It will have no problem creating the listed file (.\rr\sub.frm) if there is no foreign key in the schema. I am sure there is not problem with MySQL or everybody would have complained long ago, so it must be me being stupid... Somewhere... Please, if anybody has any advice, I really need to know :) Ben. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 4.05a slave crashes using load data on the master
I have a configuration under MySQL 4.0.5a using many slaves and one master under Linux 2.4.18. The slaves always crash when using the command load data infile to populate a table on the master (the table exists on the slaves). Maybe this could help: - The master and the slaves are bind on a specific IP. - I did not have the problem when I was not using the bind-address option in the my.cnf file. Here is the log file of one of the slaves after the crash: /MYSQL_BIN/mysqld: ready for connections 030210 14:22:33 Slave I/O thread: connected to master 'repli@provisioning-aut-db01:3305', replication started in log 'bwinf0001-bin.004' at position 31144001 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=10481664 read_buffer_size=131072 sort_buffer_size=1048568 max_used_connections=1 max_connections=2000 threads_connected=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 2314220 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=0x870e360 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=0xbfc3f288, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x808258a 0x828dec8 0x80c4d11 0x80c5bd3 0x81014a1 0x8102551 0x828b9ee 0x82bceca New value of fp=(nil) failed sanity check, terminating stack trace! Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at (nil) is invalid pointer thd-thread_id=15 Successfully dumped variables, if you ran with --log, take a look at the details of what thread 15 did to cause the crash. In some cases of really bad corruption, the values shown above may be invalid. The manual page at http://www.mysql.com/doc/C/r/Crashing.html contains information that should help you find out what is causing the crash. Number of processes running now: 9 030212 15:00:04 mysqld restarted 030212 15:00:07 InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 3 1885444325 InnoDB: Doing recovery: scanned up to log sequence number 3 188570 030212 15:00:07 InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percents: 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 InnoDB: Apply batch completed InnoDB: In a MySQL replication slave the last master binlog file InnoDB: position 0 17894355, file name bwinf0001-bin.005 030212 15:00:08 InnoDB: Flushing modified pages from the buffer pool... 030212 15:00:08 InnoDB: Started /MYSQL_BIN/mysqld: ready for connections Could anyone help me with that problem ? Marc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 privs table level security
Write a script that generates all the GRANT SQL ? Then pipe it into mysql. I'd write a function that would go and get all the table name and a list of the relevant users then generate the sql from there. Jerry - Jeremy Hutchings Apps RD Cable and Wireless - - Original Message - From: Andrew Braithwaite [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, February 12, 2003 4:13 PM Subject: RE: mysql privs table level security Any idea at all, anyone? Cheers, Andrew -Original Message- From: Andrew Braithwaite Sent: 11 February 2003 17:52 To: [EMAIL PROTECTED] Subject: mysql privs table level security Hi all, Can anyone help me please? I have a database with hundreds of tables and I want to lock down certain tables for select only. The order of presidence for mysql privs as far as I can tell is that if there are database level privileges, these override the table level privs. I don't want to have to issue a grant for each of the tables in the db - but only wish to specify which tables need to be read only. I could go into the datadir and chmod 440 the files in question, but this would deny write privs to all users wheras I would like certain users to have write access. Any ideas? Cheers, Andrew Sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Generating an automatic e-mail via MySQL
Does any one have a suggestion on running a daily / weekly e-mail notification based on results from a MySQL query? I have a table with date sensitive rows. The idea that as rows become stale (they were created / updated more than a week or month ago) the owner of the row is sent an e-mail with a summary of the stale items or even just a link back to a web page for updating. The e-mail addresses would come from a related 'user' table. The stale data table would have the 'user' id in a column for a JOIN statement. I have a feeling that I will get a few 'buy a PERL book' suggestions which is fine but I am wondering if there is another method. The same server is running Apache and PHP. Could I run this from the command line using PHP? In the end I would just like a simple CRON script that runs each day to send the notifications. Any first thoughts? Thanks, Dan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 privs table level security
It seems like you are getting privileges systems mixed up. The MySQL server has its own privileges system that is separate (sort of) from the filesystem privileges system. All queries within MySQL will be handled by the MySQL server privilege system. Within that system, you are able to control all sorts of SQL sctivities (selects,inserts,deletes,updates,etc.) based on usernames/passwords to the MySQL server. As far as file system privs, all actions while logged into the MySQL server will be performed on the underlying files as whatever user the MySQL server is running as (not the MySQL user login) which is often mysql. For more info, check out these two parts of the manual: http://www.mysql.com/doc/en/Privilege_system.html http://www.mysql.com/doc/en/User_Account_Management.html Duncan --- Duncan Salada Titan Systems Corporation 301-925-3222 x375 -Original Message- From: Andrew Braithwaite [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 12, 2003 11:13 AM To: [EMAIL PROTECTED] Subject: RE: mysql privs table level security Any idea at all, anyone? Cheers, Andrew -Original Message- From: Andrew Braithwaite Sent: 11 February 2003 17:52 To: [EMAIL PROTECTED] Subject: mysql privs table level security Hi all, Can anyone help me please? I have a database with hundreds of tables and I want to lock down certain tables for select only. The order of presidence for mysql privs as far as I can tell is that if there are database level privileges, these override the table level privs. I don't want to have to issue a grant for each of the tables in the db - but only wish to specify which tables need to be read only. I could go into the datadir and chmod 440 the files in question, but this would deny write privs to all users wheras I would like certain users to have write access. Any ideas? Cheers, Andrew Sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Licence Free Import/Export for Access?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Neil -- ...and then Neil Williams said... % % Hi Hi! % % Is there a licence free way to Import (and Export) Access databases (mdb % files) into (out from) mySQL? I haven't seen one yet. It's quite possible that nobody has written a file converter -- also quite possibly because MS hasn't released the file spec and nobody has reverse-engineered it :-) I did a quick CPAN search and found DBIx::Record::Format::ODBC::MSAccess which looks somewhat hopeful; you might dig into that a bit. HTH HAND mysql query, :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE+SnmlGb7uCXufRwARAk5tAJ9AFHohak4IXrL9jhY3suxhWfExvgCgnZvv X7/gEKohVSZhdAu7N+bTLxo= =oJMt -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: Generating an automatic e-mail via MySQL
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Dan -- ...and then Dan Tappin said... % % Does any one have a suggestion on running a daily / weekly e-mail % notification based on results from a MySQL query? ... % % I have a feeling that I will get a few 'buy a PERL book' suggestions % which is fine but I am wondering if there is another method. The same % server is running Apache and PHP. Could I run this from the command % line using PHP? Sure, if you have the php CLI binary built. If which php tells you something like /usr/bin/php then you're in. Any script you write that would work from a web page would work from the command line. In either cae, all you need to write is a script that connects to the DB server and does a SELECT against your parameters and then generates the list for which you must get email addresses to send messages, and then shoot off some email. Shouldn't be too tough. % % In the end I would just like a simple CRON script that runs each day to % send the notifications. Yep. Sounds good. % % Any first thoughts? Buy a perl book ;-) It would be well worth it anyway. % % Thanks, % % Dan HTH HAND mysql query, :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE+SnqSGb7uCXufRwARAibxAKDpqJ0oL7KyI2/2M0Qm+R53gzKFUACglJQE Z+gri8ggHeMYTsnvkWBwvBc= =H5O0 -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: Generating an automatic e-mail via MySQL
On Wed, 12 Feb 2003, Dan Tappin wrote: Does any one have a suggestion on running a daily / weekly e-mail notification based on results from a MySQL query? I have a table with date sensitive rows. The idea that as rows become stale (they were created / updated more than a week or month ago) the owner of the row is sent an e-mail with a summary of the stale items or even just a link back to a web page for updating. The e-mail addresses would come from a related 'user' table. The stale data table would have the 'user' id in a column for a JOIN statement. I do something similar using a shell script run by cron. This pipes a query into mysql like this: cat mysql_command.list | mysql -u user -ppassword database where the file mysql_command.list is a plain text file containing the query which uses SELECT INTO OUTFILE to dump fields containing membership IDs, names and email addresses of all entries between two dates of a membership database into a CSV file. Then the script continues using sed and cut to create a mail message body and header from the data in this CSV file which can be piped into mail (/bin/mail, /bin/mailx or whatever you have on your system) or even directly into sendmail. It works fine. Andy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Counting null values
It won't work because MySQL doesn't count null values. Teddy, Teddy's Center: http://teddy.fcc.ro/ Email: [EMAIL PROTECTED] - Original Message - From: Daniel Kiss [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 11, 2003 8:18 AM Subject: Re: Counting null values Hi Octavian, Try this: select FieldName, count(*) from TableName group by FieldName Bye, Danny At 16:39 2003.02.08._+0200, you wrote: Hi all, I have a table where I have something like this: | abc | | abc | | xxx | | null | | null | | null | I want to count these lines to give the result 5, meaning a distinct count for values which are not null, and counting all the null values. This means 1 for abc, one for xxx, and 3 for null values. Can you tell me what sql query should I use for counting this? Thank you. Teddy, Teddy's Center: http://teddy.fcc.ro/ 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to modify ft_min_word_len?
Can I create my own my.cnf file if I am not the administrator of MySQL but I just have a database? Teddy, Teddy's Center: http://teddy.fcc.ro/ Email: [EMAIL PROTECTED] - Original Message - From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 11, 2003 9:24 PM Subject: re: How to modify ft_min_word_len? On Monday 10 February 2003 17:55, Octavian Rasnita wrote: Please tell me how to modify the variable ft_min_word_len. I've tried: set ft_min_word_len=2; set @ft_min_word_len=2; The second creates a new variable I think and the first one tells me that there is no such variable. You should define it in my.cnf file and then rebuild FULLTEXT indexes. -- 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 privs table level security
It seems like you are getting privileges systems mixed up. No, I understand and have extensively read the below docs more. Going down to the filesystem level is a nasty work-around to the problem. I want to know if there is any way to set certain tables to have SELECT only privileges without setting table level privileges on all the tables in the database (because tables are being added and dropped all the time this would not be feasible). Help anyone? Andrew -Original Message- From: Salada, Duncan [mailto:[EMAIL PROTECTED]] Sent: 12 February 2003 16:37 To: Andrew Braithwaite; [EMAIL PROTECTED] Subject: RE: mysql privs table level security It seems like you are getting privileges systems mixed up. The MySQL server has its own privileges system that is separate (sort of) from the filesystem privileges system. All queries within MySQL will be handled by the MySQL server privilege system. Within that system, you are able to control all sorts of SQL sctivities (selects,inserts,deletes,updates,etc.) based on usernames/passwords to the MySQL server. As far as file system privs, all actions while logged into the MySQL server will be performed on the underlying files as whatever user the MySQL server is running as (not the MySQL user login) which is often mysql. For more info, check out these two parts of the manual: http://www.mysql.com/doc/en/Privilege_system.html http://www.mysql.com/doc/en/User_Account_Management.html Duncan --- Duncan Salada Titan Systems Corporation 301-925-3222 x375 -Original Message- From: Andrew Braithwaite [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 12, 2003 11:13 AM To: [EMAIL PROTECTED] Subject: RE: mysql privs table level security Any idea at all, anyone? Cheers, Andrew -Original Message- From: Andrew Braithwaite Sent: 11 February 2003 17:52 To: [EMAIL PROTECTED] Subject: mysql privs table level security Hi all, Can anyone help me please? I have a database with hundreds of tables and I want to lock down certain tables for select only. The order of presidence for mysql privs as far as I can tell is that if there are database level privileges, these override the table level privs. I don't want to have to issue a grant for each of the tables in the db - but only wish to specify which tables need to be read only. I could go into the datadir and chmod 440 the files in question, but this would deny write privs to all users wheras I would like certain users to have write access. Any ideas? Cheers, Andrew Sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Counting null values
At 9:41 +0200 2/12/03, Octavian Rasnita wrote: It won't work because MySQL doesn't count null values. It depends. count(FieldName) will not count NULL values count(*) will, because it counts rows, not values. Teddy, Teddy's Center: http://teddy.fcc.ro/ Email: [EMAIL PROTECTED] - Original Message - From: Daniel Kiss [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 11, 2003 8:18 AM Subject: Re: Counting null values Hi Octavian, Try this: select FieldName, count(*) from TableName group by FieldName Bye, Danny At 16:39 2003.02.08._+0200, you wrote: Hi all, I have a table where I have something like this: | abc | | abc | | xxx | | null | | null | | null | I want to count these lines to give the result 5, meaning a distinct count for values which are not null, and counting all the null values. This means 1 for abc, one for xxx, and 3 for null values. Can you tell me what sql query should I use for counting this? Thank you. Teddy, Teddy's Center: http://teddy.fcc.ro/ 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
Size limitation on Text field
Thanks to all that responded to my questions about Full Text Searching. Being caught up in that paradigm I overlooked the simpler answer :) I am now experiencing a problem with pulling data from a Text (longvarchar) field in MySql. The data is entered into a TEXTAREA field on a web page and from there populated into the DB. That works fine and I can see that all the data is entered correctly. On pulling the data out however it seems the maximum length won't go past 4095. I open an ODBC connection, do a simple Select and assign the data to a '$Doc' variable. On querying the length of the $Doc variable it returns 4095 even though the amount of data in the DB is greater. My first thoughts are that communication buffers are set too low but I'm not sure this is correct, or how to set them higher.. any of your gurus know how to deal with this? TIA Gord _ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Generating an automatic e-mail via MySQL
I use perl for this. Something like this: -- #!/usr/bin/perl use MIME::Base64; use Mail::Sendmail 0.77; $email = '[EMAIL PROTECTED]'; $subject = 'some stuff here'; $entire_msg = `/usr/local/mysql/bin/mysql -H -e 'some query here' somedatabase`; $mail_result = mail_out($email, $subject , $entire_msg); sub mail_out { local ($to,$sub,$msg) = @_; local(%mail) = ( SMTP = $smtp_server, from = '[EMAIL PROTECTED]', to = $to, subject = $sub, Message = $msg ); $mail{'Content-type'} = 'text/html'; $mail{'Return-path'} = '[EMAIL PROTECTED]'; return sendmail(%mail); } ## Disclaimer: this code is meant as a guide only. No responsibility will be assumed by author if it fails to compile, breaks, or blows up your server etc.. having said that it should work :) -- A -Original Message- From: Dan Tappin [mailto:[EMAIL PROTECTED]] Sent: 12 February 2003 16:37 To: [EMAIL PROTECTED] Subject: Generating an automatic e-mail via MySQL Does any one have a suggestion on running a daily / weekly e-mail notification based on results from a MySQL query? I have a table with date sensitive rows. The idea that as rows become stale (they were created / updated more than a week or month ago) the owner of the row is sent an e-mail with a summary of the stale items or even just a link back to a web page for updating. The e-mail addresses would come from a related 'user' table. The stale data table would have the 'user' id in a column for a JOIN statement. I have a feeling that I will get a few 'buy a PERL book' suggestions which is fine but I am wondering if there is another method. The same server is running Apache and PHP. Could I run this from the command line using PHP? In the end I would just like a simple CRON script that runs each day to send the notifications. Any first thoughts? Thanks, Dan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Generating an automatic e-mail via MySQL
: Does any one have a suggestion on running a daily / weekly e-mail : notification based on results from a MySQL query? In your cron file do something like: echo select * from table | mysql [options] db | mail [EMAIL PROTECTED] If it's a more complex query: cat ~/query.sql | mysql [options] db | mail [EMAIL PROTECTED] It still doesn't solve your problem perfectly, since you can't set email addresses dynamicly in that manner. I think you need to write a litle more than an SQl query or even a cron task. Go with either Perl or PHP. For sending email you can use either mail or sendmail. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Licence Free Import/Export for Access?
There's a relatively low-cost ODBC utility called DBScripter that does a pretty good job creating scripts for exporting ddl and data from ODBC datasources. It allows you to build dialects for server-based SQL variations. I don't think that there's a current MySQL dialect, but looks pretty simple to put one together. Here's the link to the site: http://www.dkgadvancedsolutions.com/dbscript.htm -Original Message- From: David T-G [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 12, 2003 10:43 AM To: mysql users Cc: Neil Williams Subject: Re: Licence Free Import/Export for Access? -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Neil -- ...and then Neil Williams said... % % Hi Hi! % % Is there a licence free way to Import (and Export) Access databases (mdb % files) into (out from) mySQL? I haven't seen one yet. It's quite possible that nobody has written a file converter -- also quite possibly because MS hasn't released the file spec and nobody has reverse-engineered it :-) I did a quick CPAN search and found DBIx::Record::Format::ODBC::MSAccess which looks somewhat hopeful; you might dig into that a bit. HTH HAND mysql query, :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE+SnmlGb7uCXufRwARAk5tAJ9AFHohak4IXrL9jhY3suxhWfExvgCgnZvv X7/gEKohVSZhdAu7N+bTLxo= =oJMt -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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: Change default CHARACTER SET value
On Wednesday 12 February 2003 13:49, Mirko wrote: To perform correct ORDER BY I need to use win1251 charset. I know that this can be set from my.cfg or in the my.ini: [mysqld] default-character-set=win1251 The problem is that I cant use this because I have limited account on my hosting provider's server (I can't restart the server and I even don't have write permissions for these files). So I want to change it for session with SET server_variable command. (http://www.mysql.com/doc/en/SET_OPTION.html) - But How ??? You can't do it. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: two questions in mysql
On Wednesday 12 February 2003 11:30, Inbal Ovadia wrote: I have mysql 3.23.41 on windows 2000 I have two questions I need to ask. 1) I want bigger value for the max_connections variable. can I define the value in my.ini file? Yes. how can I define this variable? set-variable=max_connections=# 2) I tried to insert into table a string with the char ' and mysql failed to do this. how can I solved this problem? are there any other chars like this? You should escape this character: http://www.mysql.com/doc/en/String_syntax.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
re: Create table, wrong datatype
On Wednesday 12 February 2003 10:21, Ulla Wensman wrote: When I run this script the char-fields is converted to varchar. Row-format is dynamic. I think it is because i have a text-field in the script. When I change the text field to somthing else I got the datatype char in the char-columns. I have tried to alter the colums to char but it doesn't work. How do I get around this problem? It's a known behaviour and described here: http://www.mysql.com/doc/en/Silent_column_changes.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
mysql control centre on freebsd
has anyone managed to compile mysql control centre for freebsd (4.5 or lower)? i am on the verge of giving up: my attempt to compile qt3 is failing since qt seems to require the threads libraries even if i configure with -no-thread, and without qt3 i cannot compile control centre. of course if you have pointers to pre-compiled binaries for qt3 for freebsd = 4.5 that would help also! thank you, --ravi - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Generating an automatic e-mail via MySQL
I am interested as to why no one seems to be using the DBI/DBD-MySQL perl modules? Something like: == #!/usr/bin/perl use strict; use warnings; use diagnostics; use DBI; my $dbname = 'DBI:$driver:database=database;host=dbserver.blah.com'; my $dbuser = 'dbusername'; my $dbpass = 'dbuserpass'; my $dbd = 'mysql'; my @mailbody; my $subject; my $dbh = DBI-connect($dbname,$dbuser,$dbpass,$dbd) || die Unable to connect to database. $DBI::errstr.\n; my $sth = $dbh-prepare(select x,y,z from table where blah order by x) || die cannot prepare select. $DBI::errstr.\n; $sth-execute || die cannot execute select. $DBI::errstr.\n; while(my($x,$y,$z) = $sth-fetchrow_array) { build up a body of a mail with something like push @mailbody,$x is $y of $z; } $sth-finish; other stuff you might want to do open(MAIL,|sendmail $recipients) || die cannot open sendmail\n; print MAIL To: $recipients\n; print MAIL From: My_Script\n; print MAIL Subject: $subject\n; print MAIL \n; print MAIL @mailbody; print MAIL .\n; close MAIL; (obviously you could have used Net::SMTP here, or qmail-inject) $dbh-disconnect; == Cheers, Karl -Original Message- From: Andrew Braithwaite [mailto:[EMAIL PROTECTED]] Sent: 12 February 2003 17:19 To: 'Dan Tappin'; [EMAIL PROTECTED] Subject: RE: Generating an automatic e-mail via MySQL I use perl for this. Something like this: -- #!/usr/bin/perl use MIME::Base64; use Mail::Sendmail 0.77; $email = '[EMAIL PROTECTED]'; $subject = 'some stuff here'; $entire_msg = `/usr/local/mysql/bin/mysql -H -e 'some query here' somedatabase`; $mail_result = mail_out($email, $subject , $entire_msg); sub mail_out { local ($to,$sub,$msg) = @_; local(%mail) = ( SMTP = $smtp_server, from = '[EMAIL PROTECTED]', to = $to, subject = $sub, Message = $msg ); $mail{'Content-type'} = 'text/html'; $mail{'Return-path'} = '[EMAIL PROTECTED]'; return sendmail(%mail); } ## Disclaimer: this code is meant as a guide only. No responsibility will be assumed by author if it fails to compile, breaks, or blows up your server etc.. having said that it should work :) -- A -Original Message- From: Dan Tappin [mailto:[EMAIL PROTECTED]] Sent: 12 February 2003 16:37 To: [EMAIL PROTECTED] Subject: Generating an automatic e-mail via MySQL Does any one have a suggestion on running a daily / weekly e-mail notification based on results from a MySQL query? I have a table with date sensitive rows. The idea that as rows become stale (they were created / updated more than a week or month ago) the owner of the row is sent an e-mail with a summary of the stale items or even just a link back to a web page for updating. The e-mail addresses would come from a related 'user' table. The stale data table would have the 'user' id in a column for a JOIN statement. I have a feeling that I will get a few 'buy a PERL book' suggestions which is fine but I am wondering if there is another method. The same server is running Apache and PHP. Could I run this from the command line using PHP? In the end I would just like a simple CRON script that runs each day to send the notifications. Any first thoughts? Thanks, Dan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php This email has been scanned for all viruses by the MessageLabs SkyScan service. For more information on a proactive anti-virus service working around the clock, around the globe, visit http://www.messagelabs.com This email has been scanned for all viruses by the MessageLabs SkyScan service. For more information on a proactive anti-virus service working around the clock, around the globe, visit http://www.messagelabs.com
RE: Recursion
Subject: RE: Recursion Date: Wed, 12 Feb 2003 09:36:11 - From: Andy Eastham [EMAIL PROTECTED] To: Mysql@Lists. Mysql. Com [EMAIL PROTECTED] Rob, This is a common problem in document management, where I have a reasonable amount of experience. Unfortunately, the short answer is, that to be completely generic, efficient and elegant, it's a bit of an impossible problem. What we have always done in this situation is to maintain an additional denormalised column called FullPath so, expanding your sample data a bit: ID | Name | ParentID | FullPath 1 | Bob | 0| 1 2 | John | 1| 1/2 3 | Elm | 1| 3/1 4 | Sue | 2| 1/2/4 5 | Dave | 4| 1/2/4/5 6 | Fred | 5| 1/2/4/5/6 etc. This initially seems like a horrible solution, raddled with problems. However it's actually quite efficient. The application has to manage the Full Path on updates (although it's easy to rebuild it and check integrity if you screw it up). It's also easy to find anything at any level under an object using string comparisons. If you move a folder (parent) to [new path], you have to do an update such as UPDATE table set FullPath = [new path] + substring(oldpath, [new Path Length]) WHERE fullpath like '[old path]%' Again this is indexed and pretty efficient. If you like, you can remove the objects own id from the fullpath and make it effectively parent path Hope this helps. All the best, Andy -Original Message- From: Rob [mailto:[EMAIL PROTECTED]] Sent: 12 February 2003 07:18 To: [EMAIL PROTECTED] Subject: Recursion Hi all, I need some help with recursion in mySql. I have the following table: ID | Name | ParentID 1 | Bob | 0 2 | John | 1 3 | Elm | 1 etc. For a given ID, I need to recurse up the tree and get all the parents. I've already read about Joe Celko's nested set approach, but it's not a good solution as apparently updates are a real pain and this table will be modified heavily. Does anyone have any good suggestions?? Maybe store procs (although, by all accounts store proc functionality doesn't come standard with mySql)?? Thanks --- Rob ** Rob Cherry mailto:[EMAIL PROTECTED] +27 21 447 7440 Jam Warehouse RSA Smart Business Innovation http://www.jamwarehouse.com ** Yes, excellent idea. It's the classic 'linked list' from my old Pascal days. While playing with it I realized that you only have to save the ID, Name and the FullPath (parents) data. For example, using Andy's data: ID | Name | FullPath 1 | Bob | 0 2 | John | 0/1 3 | Elm | 0/1 4 | Sue | 0/1/2 5 | Dave | 0/1/2/4 6 | Fred | 0/1/2/4/5 The FullPath doesn't need the the 'leaf' or bottom node - it can be derived (it's the ID). Using a 'split' function on the FullPath data you can pull out the individual parents. -- /* All outgoing email scanned by Norton Antivirus 2002 */ Amer Neely, Softouch Information Services W: www.softouch.on.ca E: [EMAIL PROTECTED] V: 519.438.5887 Perl | PHP | MySQL | CGI programming for all data entry forms. We make web sites work! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Licence Free Import/Export for Access?
I've used urSQL (http://www.urbanresearch.com/ursql) to accomplish this for quite some time. You can click on an MS Access table and select Build Script as MySQL to get a MySQL-like CREATE TABLE script... On Wed, 12 Feb 2003, Christensen, Dave wrote: There's a relatively low-cost ODBC utility called DBScripter that does a pretty good job creating scripts for exporting ddl and data from ODBC datasources. It allows you to build dialects for server-based SQL variations. I don't think that there's a current MySQL dialect, but looks pretty simple to put one together. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 command not allowed problem
I access a msyql server (apache/mysql/php) from my w2k workstation using phpMyAdmin. I do not have command line access. When I use the link to load a local data file it responds that it is not allowed. I read the mysql docs and see it is now disabled by default. In 4.2.4 one paragraph says If you don't configure MySQL with --enable-local-infile, then LOAD DATA LOCAL will be disabled by all clients, and just below that in another paragraph it says By default, all MySQL clients and libraries are compiled with --enable-local-infile. Which is it? Default with or without? Evidently it defaults to not enabled. The server is running MySQL-3.23.52. How do I run phpMyAdmin to give me the ability to upload a local data file to a mysql server that doesn't allow this? thanks, -- Chip Wiegand Computer Services Simrad, Inc www.simradusa.com [EMAIL PROTECTED] There is no reason anyone would want a computer in their home. --Ken Olson, president, chairman and founder of Digital Equipment Corporation, 1977 (Then why do I have 8? Somebody help me!) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[ Creating a new user ]
Hello friends! How do I create a new user on MySQL? I want to create the respective password too. Thanks, e. _ MSN Hotmail, o maior webmail do Brasil. http://www.hotmail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Recursion
Amer, It's still worth storing the parentId, because you can easily recreate the fullpath if (when!) your code screws up a set of full paths. You can also write a reliable sanity checker that checks the full path of all the nodes in the table based on the parentids. Also, to locate multiple children of a node, it's a more efficient query to use where parentid = x, rather than where fullpath like '1/2/3/4/%' All the best, Andy Yes, excellent idea. It's the classic 'linked list' from my old Pascal days. While playing with it I realized that you only have to save the ID, Name and the FullPath (parents) data. For example, using Andy's data: ID | Name | FullPath 1 | Bob | 0 2 | John | 0/1 3 | Elm | 0/1 4 | Sue | 0/1/2 5 | Dave | 0/1/2/4 6 | Fred | 0/1/2/4/5 The FullPath doesn't need the the 'leaf' or bottom node - it can be derived (it's the ID). Using a 'split' function on the FullPath data you can pull out the individual parents. -- /* All outgoing email scanned by Norton Antivirus 2002 */ Amer Neely, Softouch Information Services W: www.softouch.on.ca E: [EMAIL PROTECTED] V: 519.438.5887 Perl | PHP | MySQL | CGI programming for all data entry forms. We make web sites work! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql-embedded throws errors during compile/linking
I'm running Redhat 8.0, and can't seem to get mysql-embedded to work. After installing the current 4.0 RPMs, I get a lot of errors when trying to compile the sample program as described here: http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html#libmysqld_example [root@gw nwetters]# rpm -Uvh MySQL-client-4.0.10-0.i386.rpm MySQL-devel-4.0.10-0.i386.rpm MySQL-embedded-4.0.10-0.i386.rpm warning: MySQL-client-4.0.10-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5 Preparing...### [100%] 1:MySQL-client ### [ 33%] 2:MySQL-devel### [ 67%] 3:MySQL-embedded ### [100%] [root@gw nwetters]# cd test_libmysqld/ [root@gw test_libmysqld]# make gcc -g -W -Wall -I/usr/include/mysql -D_THREAD_SAFE -D_REENTRANT -static test_libmysqld.c -L/usr/lib/mysql -lmysqld -lz -lm -lcrypt -lpthread -o test_libmysqld /usr/lib/mysql/libmysqld.a(handler.o)(.gnu.linkonce.d.__vt_7handler+0x38): undefined reference to `__pure_virtual' /usr/lib/mysql/libmysqld.a(handler.o)(.gnu.linkonce.d.__vt_7handler+0x40): undefined reference to `__pure_virtual' /usr/lib/mysql/libmysqld.a(handler.o)(.gnu.linkonce.d.__vt_7handler+0x44): undefined reference to `__pure_virtual' /usr/lib/mysql/libmysqld.a(handler.o)(.gnu.linkonce.d.__vt_7handler+0x48): undefined reference to `__pure_virtual' /usr/lib/mysql/libmysqld.a(handler.o)(.gnu.linkonce.d.__vt_7handler+0x4c): undefined reference to `__pure_virtual' /usr/lib/mysql/libmysqld.a(handler.o)(.gnu.linkonce.d.__vt_7handler+0x50): more undefined references to `__pure_virtual' follow /usr/lib/mysql/libmysqld.a(hostname.o): In function `hostname_cache_init(void)': hostname.o(.text+0x1e): undefined reference to `__builtin_new' /usr/lib/mysql/libmysqld.a(hostname.o): In function `hostname_cache_free(void)': hostname.o(.text+0x594): undefined reference to `__builtin_delete' /usr/lib/mysql/libmysqld.a(item.o)(.gnu.linkonce.d.__vt_9Item_buff+0x8): undefined reference to `__pure_virtual' /usr/lib/mysql/libmysqld.a(item.o)(.gnu.linkonce.d.__vt_17Item_result_field+0x28): undefined reference to `__pure_virtual' /usr/lib/mysql/libmysqld.a(item.o)(.gnu.linkonce.d.__vt_17Item_result_field+0x2c): undefined reference to `__pure_virtual' /usr/lib/mysql/libmysqld.a(item.o)(.gnu.linkonce.d.__vt_17Item_result_field+0x30): undefined reference to `__pure_virtual' /usr/lib/mysql/libmysqld.a(item.o)(.gnu.linkonce.d.__vt_17Item_result_field+0x34): undefined reference to `__pure_virtual' /usr/lib/mysql/libmysqld.a(item.o)(.gnu.linkonce.d.__vt_17Item_result_field+0x38): more undefined references to `__pure_virtual' follow /usr/lib/mysql/libmysqld.a(item_func.o): In function `item_user_lock_release(ULL *)': item_func.o(.text+0x17b1): undefined reference to `__builtin_delete' /usr/lib/mysql/libmysqld.a(item_func.o): In function `Item_func_get_lock::val_int(void)': item_func.o(.text+0x19f4): undefined reference to `__builtin_new' item_func.o(.text+0x1a9b): undefined reference to `__builtin_delete' item_func.o(.text+0x1be5): undefined reference to `__builtin_delete' /usr/lib/mysql/libmysqld.a(item_func.o)(.gnu.linkonce.d.__vt_17Item_func_integer+0x30): undefined reference to `__pure_virtual' /usr/lib/mysql/libmysqld.a(item_func.o)(.gnu.linkonce.d.__vt_13Item_dec_func+0x2c): undefined reference to `__pure_virtual' /usr/lib/mysql/libmysqld.a(item_func.o)(.gnu.linkonce.d.__vt_13Item_int_func+0x30): undefined reference to `__pure_virtual' /usr/lib/mysql/libmysqld.a(item_func.o)(.gnu.linkonce.d.__vt_11Item_num_op+0x2c): undefined reference to `__pure_virtual' /usr/lib/mysql/libmysqld.a(item_func.o)(.gnu.linkonce.d.__vt_11Item_num_op+0x30): undefined reference to `__pure_virtual' /usr/lib/mysql/libmysqld.a(item_func.o)(.gnu.linkonce.d.__vt_13Item_num_func+0x2c): more undefined references to `__pure_virtual' follow /usr/lib/mysql/libmysqld.a(log.o): In function `MYSQL_LOG::~MYSQL_LOG(void)': log.o(.text+0x33ac): undefined reference to `__builtin_delete' /usr/lib/mysql/libmysqld.a(log_event.o)(.gnu.linkonce.d.__vt_9Log_event+0x20): undefined reference to `__pure_virtual' /usr/lib/mysql/libmysqld.a(log_event.o)(.gnu.linkonce.d.__vt_9Log_event+0x24): undefined reference to `__pure_virtual' /usr/lib/mysql/libmysqld.a(sql_acl.o): In function `acl_init(THD *, bool)': sql_acl.o(.text+0x22): undefined reference to `__builtin_new' /usr/lib/mysql/libmysqld.a(sql_acl.o): In function `acl_free(bool)': sql_acl.o(.text+0xbe9): undefined reference to `__builtin_delete' /usr/lib/mysql/libmysqld.a(sql_acl.o): In function `Listst_lex_user::delete_elements(void)': sql_acl.o(.Listst_lex_user::gnu.linkonce.t.delete_elements(void)+0x20): undefined reference to `__builtin_delete' /usr/lib/mysql/libmysqld.a(slave.o): In function `init_slave(void)': slave.o(.text+0x10): undefined reference to `__builtin_new'
RE: [ Creating a new user ]
RTM: http://www.mysql.com/doc/en/GRANT.html Also see http://www.catb.org/~esr/faqs/smart-questions.html -Original Message- From: Elby Vaz [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 12, 2003 10:39 AM To: [EMAIL PROTECTED] Subject: [ Creating a new user ] Hello friends! How do I create a new user on MySQL? I want to create the respective password too. Thanks, e. _ MSN Hotmail, o maior webmail do Brasil. http://www.hotmail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 compile 3.23, 4.0 or Redhat SRPMs
whichever way I try, I'm having no luck compiling on redhat 8.0. I've tried with the latest 3.23 and 4.0 tarballs, the latest pull from bitkeeper, and the redhat SRPMs. some details here: http://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=84137 Has anyone else had similar problems? The reason I'm trying to compile from source is because I need a working libmysqld.a and can't get the mysql.com RPM to work (see previous email). -- Nigel Wetters [EMAIL PROTECTED] Perl Developer, Sun Certified Java Programmer 123 Ravensbury Road, London SW18 4RY Tel. 020 8944 8633 PGP: pgp.mit.edu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Generating an automatic e-mail via MySQL
I am interested as to why no one seems to be using the DBI/DBD-MySQL perl modules? Because it's twice as much code to do the same job. Why format your data when the -H option to mysql can do it too? Cheers, A -Original Message- From: Karl Dyson [mailto:[EMAIL PROTECTED]] Sent: 12 February 2003 17:43 To: Andrew Braithwaite; Dan Tappin; [EMAIL PROTECTED] Subject: RE: Generating an automatic e-mail via MySQL I am interested as to why no one seems to be using the DBI/DBD-MySQL perl modules? Something like: == #!/usr/bin/perl use strict; use warnings; use diagnostics; use DBI; my $dbname = 'DBI:$driver:database=database;host=dbserver.blah.com'; my $dbuser = 'dbusername'; my $dbpass = 'dbuserpass'; my $dbd = 'mysql'; my @mailbody; my $subject; my $dbh = DBI-connect($dbname,$dbuser,$dbpass,$dbd) || die Unable to connect to database. $DBI::errstr.\n; my $sth = $dbh-prepare(select x,y,z from table where blah order by x) || die cannot prepare select. $DBI::errstr.\n; $sth-execute || die cannot execute select. $DBI::errstr.\n; while(my($x,$y,$z) = $sth-fetchrow_array) { build up a body of a mail with something like push @mailbody,$x is $y of $z; } $sth-finish; other stuff you might want to do open(MAIL,|sendmail $recipients) || die cannot open sendmail\n; print MAIL To: $recipients\n; print MAIL From: My_Script\n; print MAIL Subject: $subject\n; print MAIL \n; print MAIL @mailbody; print MAIL .\n; close MAIL; (obviously you could have used Net::SMTP here, or qmail-inject) $dbh-disconnect; == Cheers, Karl -Original Message- From: Andrew Braithwaite [mailto:[EMAIL PROTECTED]] Sent: 12 February 2003 17:19 To: 'Dan Tappin'; [EMAIL PROTECTED] Subject: RE: Generating an automatic e-mail via MySQL I use perl for this. Something like this: -- #!/usr/bin/perl use MIME::Base64; use Mail::Sendmail 0.77; $email = '[EMAIL PROTECTED]'; $subject = 'some stuff here'; $entire_msg = `/usr/local/mysql/bin/mysql -H -e 'some query here' somedatabase`; $mail_result = mail_out($email, $subject , $entire_msg); sub mail_out { local ($to,$sub,$msg) = @_; local(%mail) = ( SMTP = $smtp_server, from = '[EMAIL PROTECTED]', to = $to, subject = $sub, Message = $msg ); $mail{'Content-type'} = 'text/html'; $mail{'Return-path'} = '[EMAIL PROTECTED]'; return sendmail(%mail); } ## Disclaimer: this code is meant as a guide only. No responsibility will be assumed by author if it fails to compile, breaks, or blows up your server etc.. having said that it should work :) -- A -Original Message- From: Dan Tappin [mailto:[EMAIL PROTECTED]] Sent: 12 February 2003 16:37 To: [EMAIL PROTECTED] Subject: Generating an automatic e-mail via MySQL Does any one have a suggestion on running a daily / weekly e-mail notification based on results from a MySQL query? I have a table with date sensitive rows. The idea that as rows become stale (they were created / updated more than a week or month ago) the owner of the row is sent an e-mail with a summary of the stale items or even just a link back to a web page for updating. The e-mail addresses would come from a related 'user' table. The stale data table would have the 'user' id in a column for a JOIN statement. I have a feeling that I will get a few 'buy a PERL book' suggestions which is fine but I am wondering if there is another method. The same server is running Apache and PHP. Could I run this from the command line using PHP? In the end I would just like a simple CRON script that runs each day to send the notifications. Any first thoughts? Thanks, Dan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php This email has been scanned for all viruses by the MessageLabs SkyScan service. For more information on a proactive anti-virus service working around the clock, around the globe, visit http://www.messagelabs.com
Re: [ Creating a new user ]
Here are some commands to add a new user. Do this from the MySQL prompt: mysql GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP - ON databasename.tablename - TO username@localhost - IDENTIFIED BY 'password'; mysql GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP - ON samedatabasename.tablename - TO sameusername@hostname - IDENTIFIED BY 'samepassword'; Of course, you can modify the SELECT, INSERT, UPDATE, etc. to whatever you want the permissions to be. Also, you can use wildcards in place of hostname, db, and table incase you want to give global access. Well, this is how I do it at least. I think it's right? :) --- [EMAIL PROTECTED] http://www.hatesville.com On Wed, 12 Feb 2003, Elby Vaz wrote: Hello friends! How do I create a new user on MySQL? I want to create the respective password too. Thanks, e. _ MSN Hotmail, o maior webmail do Brasil. http://www.hotmail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[ANN] Beta version of Lasso Studio 6 for Dreamweaver MX
Greetings: If you use Dreamweaver MX and are looking for a very easy way to Web-enable your MySQL databases, please check out today's announcement of the immediate availability of the first beta release of Lasso Studio 6 for Dreamweaver MX. Details at: http://www.blueworld.com/blueworld/news/02.12.03-LS6DW-Beta.html Enjoy Bill -- - Bill Doerrfeld[EMAIL PROTECTED] Blue World Communications, Inc. http://www.blueworld.com/ - Build and serve powerful data-driven Web sites with Lasso Studio and Lasso Professional. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 compile 3.23, 4.0 or Redhat SRPMs
In the last episode (Feb 12), Nigel Wetters said: whichever way I try, I'm having no luck compiling on redhat 8.0. I've tried with the latest 3.23 and 4.0 tarballs, the latest pull from bitkeeper, and the redhat SRPMs. some details here: http://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=84137 gcc -DHAVE_CONFIG_H -I. -I../.././innobase/dict -I.. -I../../include -I../include-DDBUG_OFF -O3 -DDBUG_OFF -O2 -march=i386 -mcpu=i686 -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE -DDEBUG_OFF -DUNIV_INTEL_X86 -c `test -f dict0load.c || echo '../.././innobase/dict/'`dict0load.c dict0load.c: In function `dict_load_foreign_cols': dict0load.c:879: internal error: Segmentation fault Sounds like you hit a GCC bug. Try rebuilding just that file without any -O flags. -- Dan Nelson [EMAIL PROTECTED] 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
info-dir-section element missing in .texi (4.0.10)
Description: There is a missing element in the texi file. How-To-Repeat: N/A Fix: --- mysql-orig/Docs/manual.texi Wed Feb 27 23:45:07 2002 +++ mysql-patched/Docs/manual.texi Wed Feb 27 23:44:49 2002 @@ -56,6 +56,7 @@ @ifinfo @format +INFO-DIR-SECTION Database START-INFO-DIR-ENTRY * mysql: (mysql). MySQL documentation. END-INFO-DIR-ENTRY Submitter-Id: submitter ID Originator:Christian Hammers Organization: The Debian Project MySQL support: none Synopsis: info-dir-section missing in manual.texi (4.0.10) Severity: non-critical Priority: low Category: mysql Class: doc-bug Release: mysql-3.23.55 (Source distribution) Environment: System: Linux app109 2.4.20-app109-3 #4 Sun Feb 2 21:44:32 CET 2003 i686 unknown unknown GNU/Linux Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/3.2.2/specs Configured with: ../src/configure -v --enable-languages=c,c++,java,f77,proto,pascal,objc,ada --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --with-gxx-include-dir=/usr/include/c++/3.2 --enable-shared --with-system-zlib --enable-nls --without-included-gettext --disable-__cxa_atexit --enable-java-gc=boehm --enable-objc-gc i386-linux Thread model: posix gcc version 3.2.2 Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 2003-02-12 00:47 /lib/libc.so.6 - libc-2.3.1.so -rwxr-xr-x1 root root 1102984 2003-02-04 15:58 /lib/libc-2.3.1.so -rw-r--r--1 root root 2337940 2003-02-04 15:59 /usr/lib/libc.a -rw-r--r--1 root root 178 2003-02-04 15:59 /usr/lib/libc.so -rw-r--r--1 root root 716080 2002-01-13 21:06 /usr/lib/libc-client.so.2001 Configure command: ./configure --prefix=/usr --exec-prefix=/usr --libexecdir=/usr/sbin --datadir=/usr/share --sysconfdir=/etc/mysql --localstatedir=/var/lib/mysql --includedir=/usr/include --infodir=/usr/share/info --mandir=/usr/share/man --enable-shared --with-libwrap --enable-assembler --with-berkeley-db --with-innodb --enable-static --enable-shared --enable-local-infile --with-raid --enable-thread-safe-client --without-readline --with-unix-socket-path=/var/run/mysqld/mysqld.sock --with-mysqld-user=mysql --without-bench --without-docs --with-client-ldflags=-lstdc++ --with-extra-charsets=all - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Managing replication logs
Danny Haworth wrote: I too would be interested in a good way of clearing the binary log files (preferably non disruptive to the server ;-) The only thing thats saving me so far is that the systems capacity is 320Gb. danny Anirudha Kukreti wrote: hi all i have established a two way replication setup my problem is that my hard disk gets occupied by the log files; i tried purging the files but after some time again my hard disk gets filled with the log files mysql, queries - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Here is a script I wrote which archives the logs in 2 places. We run it every 5 minutes from the cron dameon It's designed to check a slave database located 40 miles away before moving the logs. Since you are not keeping the logs around, you may want to change the mv command to rm. Hope this helps! walt #!/bin/bash #achive_logs.sh # # Purpose - Archvive mysql log if size = 5MB # Log files are in master_server_name-bin.xxx format. # Main script calls check_slave which in turn calls copy_log. # server names SLAVE=slave.nea-fast.com MASTER=master # length we'll need to strip off of log file name LENGTH=${#MASTER} STRIP=$((LENGTH + 5)) # we add 5 for -bin. # archive directories BASE=/var/lib/mysql/ ARCH1=/var/lib/mysql/mysql_arch1/ ARCH2=/opt/mysql_arch2/ # email address [EMAIL PROTECTED] [EMAIL PROTECTED] # page() - Takes 2 arguments. function and dir page() { echo $1 couldn't copy to $2 | /bin/mail -s Help!! $PAGE } # copy_log - takes 2 arguments. The log file and a 0 or 1. # If 2nd arg is 0, the slave db is in sync and it's cool # to delete the log after coping. If 2nd arg is 1, the slave # has not caught up and we dont want to delete the log from the # mysql dir. # If there is an error coping to either dir, dont # delete the old log file! We'll try to copy again next time. copy_log() { PROBLEM=$2 cp -f $1 $ARCH1 if [ $? -ne 0 ]; then echo copy-log couldn't copy to arch1 page copy-log arch1 PROBLEM=1 fi cp -f $1 $ARCH2 if [ $? -ne 0 ]; then echo couldn't copy to arch2 page copy-log arch2 PROBLEM=1 fi if [ $PROBLEM -eq 0 ]; then echo removing file rm -f $1 fi } # check_slave - takes one argument which is the log name. We # need this function because we may end up with several log files # in the mysql dir because the slave was not caught up when we last # ran. check_slave() { M_LOG=$1 M_LOG_SEQ=${M_LOG:$STRIP} #strip off $MASTER-bin. from file name echo getting info from slave `date` DATA=`ssh $SLAVE cat /var/lib/mysql/master.info` echo got data from slave `date` SLAVE_LOG=`echo $DATA | awk '{print $1}'` # Master log is first line #strip off $MASTER-BIN. from file name to get sequence number S_LOG_SEQ=${SLAVE_LOG:$STRIP} if [ $M_LOG_SEQ -lt $S_LOG_SEQ ]; then # Slave has switched to new log so were ok. Send file name # and 0 to copy_log. 0 tells copy_log to delete the file when finished copy_log $1 0 else # Slave hasn't switched to new log. Send file name and 1 to copy_log. # 1 tells copy_log to NOT delete the file when finished. copy_log $1 1 fi } # main script### # The first thing we need to do is make sure we're not already running if [ -f /var/lib/mysql/archiving ]; then echo We appear to still be running!!! exit 0 else touch /var/lib/mysql/archiving chmod 400 /var/lib/mysql/archiving fi # Make sure we can talk to other site ping -c 5 $SLAVE /dev/null # dev/null so cron dameon doesn't spam if [ $? -ne 0 ]; then echo couldn't ping $SLAVE rm /var/lib/mysql/archiving exit 0 fi cd $BASE # Get current log from index file CUR_LOG=`tail -1 $MASTER-bin.index` # Log name is stored as ./mysql_master.xxx so we'll strip ./ FILE=${CUR_LOG:2} # Check size of file SIZE=`du -ks $FILE | awk '{print $1}'` if [ $SIZE -gt 2048 ]; then # Get all log files LOGS=`ls $MASTER-bin.* | grep -v $MASTER-bin.index` /usr/bin/mysqladmin flush-logs for i in $LOGS; do check_slave $i done fi # End if size = 5MB rm -f /var/lib/mysql/archiving exit 0 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble
A bug with innodb and non innodb multi-table delete.
Version: Mysql 4.0.10-gamma Description: Mysql client loses connection when doing a multi-table delete if one table is innodb and the other is myISAM. How to Repeat : 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), ) ; 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; fix ? Thank you for your time Scott Wong Meiko America, INC - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Bug with innodb multi-table delete and foreign keys.
Version: Mysql 4.0.10-gamma Description: ERROR 1105: Unknown error after issuing a multi-table delete on parent/child table. if there's no foreign keys .. works ok. How to Repeat : 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; insert into grandchild set id=1, child_id=1; delete parent,child from parent,child where parent.id=child.parent_id; ERROR 1105: Unknown error fix ? Thank you for your time Scott Wong Meiko America, INC - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Dump from big table in MySQL
Hello!! when I do mysqldump of a big table, the process is killed, and it is not posible make the dump. I read in the list of somebody who did a dump of database with 4G size. Which variable it is necessary to modify for making a dump using mysqldump, or it is necessary to move a better machine?? I have a machine with 1.7 G, 256 MB, using Red Hat. Grover Cussi N www.cs.umss.edu.bo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Exporting Data
How would you export your data from the mysql tables to a tab or coma delimiter. Thank you, Stephen A. Lewis [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: Exporting Data
How would you export your data from the mysql tables to a tab or coma delimiter. There are lots of ways, here are my favorite two: mysqldump: http://www.mysql.com/doc/en/mysqldump.html phpMyAdmin : http://phpmyadmin.sourceforge.net/ -- Greg Donald http://destiney.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: Licence Free Import/Export for Access?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Dave J, et al -- [re DBScripter and urSQL] Those are nice tools, but if I read you correctly they only work if one has MS Access. The original poster, if I read *him* correctly, wants a way to read Access DB files and turn them into MySQL files -- but without having to have MS Access. That would be my desire if I ever had to touch an MS Access file, since I don't have Access almost don't run Windows at all. Did I misunderstand anyone? HTH TIA HAND mysql query, :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE+SxTLGb7uCXufRwARAhvNAKCDaezt+gSN4BQinKadUoWzvw2wWACg5hrn apGMD7+rA8vIqlbp2ZkBS4Y= =N2rx -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: Licence Free Import/Export for Access?
Yes, I think you misunderstood. You don't have to own MS Access or have it on your PC to use DBScripter. You DO have to set up an ODBC data source that points to the Access database though. That process can be accomplished without owning Access. -Original Message- From: David T-G [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 12, 2003 9:45 PM To: mysql users Cc: j.urban; Christensen, Dave Subject: Re: Licence Free Import/Export for Access? -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Dave J, et al -- [re DBScripter and urSQL] Those are nice tools, but if I read you correctly they only work if one has MS Access. The original poster, if I read *him* correctly, wants a way to read Access DB files and turn them into MySQL files -- but without having to have MS Access. That would be my desire if I ever had to touch an MS Access file, since I don't have Access almost don't run Windows at all. Did I misunderstand anyone? HTH TIA HAND mysql query, :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE+SxTLGb7uCXufRwARAhvNAKCDaezt+gSN4BQinKadUoWzvw2wWACg5hrn apGMD7+rA8vIqlbp2ZkBS4Y= =N2rx -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: Licence Free Import/Export for Access?
Neil Williams wrote: Hi Is there a licence free way to Import (and Export) Access databases (mdb files) into (out from) mySQL? I've read the FAQs and looked at the converters available but it appears to me that all of these require the Access program to work. Is there any way of converting to/from MDB files without using the Access tool. I saw *someone* talking about this sort of thing. Hm. Let me search my email Have a look at this: http://mdbtools.sourceforge.net/gmdb/gmdb2screenshot.png Might be what you need. -- Daniel Kasak IT Developer * NUS Consulting Group* Level 18, 168 Walker Street North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: www.nusconsulting.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL table locking?
Hello, list, I'm having a weird issue with table locking. I'm running MySQL 3.23 on a Win2k server, used for eCommerce applications. All settings appear to be in order, that is, KeepAlive is 30, connection pooling is on, with a timeout of 30. The tables in any given database seem to remain locked for as long as 30 minutes after all clients have gone away, and all ODBC connections have completed. These are MyISAM tables. The long and short of it is that I am using PS MySQL Studio to remotely administer the db, and testing the software product concurrently. I need the software to lock the table, of course, but only for the amount of time I have specified, i.e. for 30 seconds after the client disappears, which should be 30 seconds after the KeepAlive times out, which is also 30 seconds. So, it shouldn't be any more than 1 minute after all clients go away, before I can commit a change to a table, right? I am also not quite sure if connection pooling even matters. Shouldn't ODBC just reuse the same connection if the KeepAlive times out before the ODBC pool, eh, so the 30 seconds for the inactive connection through the browser to time out is all that should matter? Am I missing something here? I am using iHTML for this particular eCommerce app, BTW. If anyone is familiar with this and knows if the issue is in iHTML, let me know that as well. TIA, --Scott Brown - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 q.
Hi, My name is Eliran and I'm working at Rimed company in Israel. We consider to use MySql as a database for our application. I installed MySql 3.23 on window XP. I want to know what I must do in order to be able to run the C++ example it give me the following error: Error: Unknown database 'mysql_cpp_data' I do not understand what I have to do after the installation. I tried to look at the document MySQL Installation and I tried to follow the instruction but it still does not work. I will be more the grateful if u can tell me what exactly I have to do. regards Eliran Tamir - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php