my.ini vs. my.cnf on Winodws?
According to what I read in the manual, I'm lead to believe that MySQL on Windows can read from either C:\my.cnf or systemdir\my.ini. Which will it read first? The manual also seems to say that you can only use one. So if you create both, which will it prefer? Here's the part I'm reading: There are two configuration files with the same function: `my.cnf' and `my.ini' file, however please note that only of one these should can used. Both files are plain text. The `my.cnf' file should be created in the root directory of drive C and the `my.ini' file on the WinDir directory e.g: `C:\WINDOWS' or `C:\WINNT'. If your PC uses a boot loader where the C drive isn't the boot drive, then your only option is to use the `my.ini' file. Also note that if you use the WinMySQLAdmin tool, only the `my.ini' file is used. The `\mysql\bin' directory contains a help file with instructions for using this tool. If I had a suitable system handy to install on, I'd just install it and try (of course). Can anyone shed some light on this? Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 11 days, processed 261,751,768 queries (266/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL-Front Update: Version 2.0 available
Hello *.*, The new Version (2.0) of MySQL-Front is available: Download at http://www.anse.de/mysqlfront/download.php Again, this version comes with some new features, many bugfixes and improvements, which were requested by some users. -- Changes to the last version: -- New Features: - Usermanager now with support for editing existing users - Interface now Windows(r) XP ready - Added multi-language-support - currently only english and german (Set in Tools->Preferences) - Data-Grids: Specify your favorite font for viewing data - this is especially helpful for users which need a different characterset (e.g. greek) - Added table-types InnoDB and BDB on the create-table-window and to the table-popupmenu - Application-startup allows an sql-file as parameter, so you can associate ".sql"-files to be opened with MySQL-Front (this is an optional task during installation) - Added "auto-refresh"-option to the processlist-tab - Database-Tree allows dragging databases or tables into query-window - Query-tab: sql-memo accepts dragged files from Windows(r)-Explorer - Query-Tab: Added a timer for SQL-execution - SQL-History: Added menu-item "Save as textfile" Improvements: - ODBC-Import: Cursor for reading tables now server-side instead of client-side, which resulted in reading all data on selecting a table - Query-Tab: "Explain"-queries are now recognized to return a result-set - Adding a user automatically flushes privileges - Database-Tab: Removed annoying drag-and-drop-operation for using the "Copy table"-command - Date and Time-Fields are now displayed as native strings even when the option "show native contents of certain fields" is turned off. - Added MySQL ABs new official logo-image in the about-box - Added some information lines at startup to the sql-history, which report statistics and if some illegal database-names were found - Data-Tab: DB-navigator was moved to the main-toolbar at the top - Query-Tab: Toolbuttons were moved to the main-toolbar at the top - Toolbars now drag-and-drop'able - Tools->Preferences->SQL-Font-dropdownbox now only shows fixed-pitch fonts - Most internal queries now use the backtick (`) for databases, tables and columns - "Copy Table" now also copies indexes from the original table - Field-Editor: Disabled length/set- and default-edit for BLOB- and TEXT-fields Bugfixes: - Query-tab: fixed some bugs with internal escape-function, which caused problems with quotes and doublequotes - ODBC Import: Selected database will be used instead of mainscreen's actual db - Export tables: fixed bugs with escaping special characters - Removed access-violation on running queries at startup, when no database was selected - Export Tables: selecting only data without structure exports insert-statements now adds commas between values - Export Tables: export to another host/db, when there is only 1 DB on the target-host, clicking on this option does not produce an error message like "You need at least 2 connection windows". - Data-tab: sql-errors now don't disturb further functions of Data-Grid - Removed annoying bug at viewing data fixed, which executed "SHOW FIELDS..." and "SHOW KEYS..." twice. - Fixed bug at resizing the pagecontrol at the bottom - Fixed numerous tiny bugs see the complete changes-log on http://www.anse.de/mysqlfront/changes.php - Thanks for your interest! Greetings, Ansgar Becker (Anse) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: [midgard-user] Re: big problem with mysqldb
I would /strongly/ advise that you discontinue the use of the Isam table type in mysql. The Isam table type is a legacy of the mysql 3.22.x series. If you are using the stable 3.23.x series Myisam is the new default type. One of the cool things about Myisam is that you CAN repair it while the database is running. You can also configure mysqld to repair tables automatically when it finds a problem. Of course you it manually still with myisamchk -r Tarjei Huse wrote: > Hi, > > I would like to thank everyone (esp Carsten and Jocelyn) who helped me solve > this problem. It now seems that the db now works ok. > > For the record, I suggest that isamchk should contain a warning in the help text > that you should not run it when mysqld is running. This combined with isamchk -i > *.ISM. > > Also, I'll backup using mysqldump from now on, not just tarballing my dbdirs :) > > Tarjei > > > > "Carsten H. Pedersen" wrote: > >>>isamchk -e -o page.ISM >>>I get: >>>Found block with too small length at 2249; Skipped >>>... >>>Now what do I do?? >>> >>Restore from backup? >> >>Your table structure is definitely corrupted. >> >>What happens if you run isamchk with just "-r": >> >>isamchk -r page.ISM >> >>? >> >>/ Carsten >>-- >>Carsten H. Pedersen >>keeper and maintainer of the bitbybit.dk MySQL FAQ >>http://www.bitbybit.dk/mysqlfaq >> > > - > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > -- Vincent Stoessel [EMAIL PROTECTED] Java Linux Apache Mysql Php (JLAMP) Engineer (301) 362-1750 Mobile (410) 419-8588 AIM, MSN: xaymaca2020 , Yahoo Messenger: vks_jamaica - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: DAYOFYEAR()
At 3:24 + 1/14/02, Curtis Gordon wrote: >Hi! I'm storing a date in this format : > >2002-01-13 11:08:40 >-mm-dd hh:mm:ss > >This is great because it gives me the date and the time, which I need. >I want to compare this date from the database to the current DAYOFYEAR() > >but when I do this >select DAYOFYEAR('2002-01-13 11:08:40') > >I get this >Error - Perl execution failed > >Modification of non-creatable array value attempted, subscript -1 at >./mysql-lib.pl line 187, line 2. You're not showing the actual Perl code, only what you suspect is relevant to the problem at hand. DAYOFYEAR() works fine with literal dates and with NOW(), so my guess is that you're constructing your first query improperly (perhaps a problem with the quote marks). It's only a guess, because you haven't shown the code. > > > >It works great when I do select DAYOFYEAR(NOW()) though, I'm totally >confused, is this a known bug or is there a work around that anybody >knows of that you can let me in on? > >Ulitmately I want to compare todays DAYOFYEAR to the DAYOFYEAR from >fields in the database to establish entries that were created >"today". > >I'm looking at what I have written here and I think I have confused >myself, if this is not clear, please feel free to flame me. No flames, just show the code. > >I'm looking forward to any light that can be shed on this problem. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: DAYOFYEAR()
I came up with my own work around, I am now storing the date and time separately like this: CURDATE(),CURTIME() Then selecting my data with this WHERE statement: WHERE DAYOFYEAR(CURDATE()) = DAYOFYEAR(mdate) (mdate being the name of my CURDATE() field) I just thought I would pass that on incase anybody else was having similar trouble. (C: >From: "Curtis Gordon" <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] >Subject: DAYOFYEAR() >Date: Mon, 14 Jan 2002 03:24:02 + > >Hi! I'm storing a date in this format : > >2002-01-13 11:08:40 >-mm-dd hh:mm:ss > >This is great because it gives me the date and the time, which I need. >I want to compare this date from the database to the current DAYOFYEAR() > >but when I do this >select DAYOFYEAR('2002-01-13 11:08:40') > >I get this >Error - Perl execution failed > >Modification of non-creatable array value attempted, subscript -1 at >./mysql-lib.pl line 187, line 2. > > > >It works great when I do select DAYOFYEAR(NOW()) though, I'm totally >confused, is this a known bug or is there a work around that anybody knows >of that you can let me in on? > >Ulitmately I want to compare todays DAYOFYEAR to the DAYOFYEAR from fields >in the database to establish entries that were created "today". > >I'm looking at what I have written here and I think I have confused myself, >if this is not clear, please feel free to flame me. > >I'm looking forward to any light that can be shed on this problem. > > > > >_ >Join the worlds largest e-mail service with MSN Hotmail. >http://www.hotmail.com > > >- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail ><[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
DAYOFYEAR()
Hi! I'm storing a date in this format : 2002-01-13 11:08:40 -mm-dd hh:mm:ss This is great because it gives me the date and the time, which I need. I want to compare this date from the database to the current DAYOFYEAR() but when I do this select DAYOFYEAR('2002-01-13 11:08:40') I get this Error - Perl execution failed Modification of non-creatable array value attempted, subscript -1 at ./mysql-lib.pl line 187, line 2. It works great when I do select DAYOFYEAR(NOW()) though, I'm totally confused, is this a known bug or is there a work around that anybody knows of that you can let me in on? Ulitmately I want to compare todays DAYOFYEAR to the DAYOFYEAR from fields in the database to establish entries that were created "today". I'm looking at what I have written here and I think I have confused myself, if this is not clear, please feel free to flame me. I'm looking forward to any light that can be shed on this problem. _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Licensing
On Sun, Jan 13, 2002 at 09:15:37PM +0100, Frans Englich wrote: > I'm writing an adminstrative program for a hotel located in > Sweden. This program uses an mysql database as backend(the > implementation is not in use yet, but my intention is to use mysql). > > To be really sure about this: Do the hotel _have_ to get an MySql > database License or will they stay legal without one? I know, mySql > is released under the GPL license but I need to be really sure about > this. You need to buy nothing. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 11 days, processed 257,921,363 queries (270/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: relational tables
* Javier Gonzalo Gloria Medina > How I crate this relational tables with mysql. Using the CREATE TABLE statement: http://www.mysql.com/doc/C/R/CREATE_TABLE.html > > where the two tables must be related by id ok You combine the tables with the SELECT statement, you don't need to do anything special when you create the tables to tell mysql that the tables are related. http://www.mysql.com/doc/S/E/SELECT.html > -- 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
RE: Spam - a possible cause ?
I think Tony was having a laugh -Original Message- From: Marjolein Katsma [mailto:[EMAIL PROTECTED]] Sent: 13 January 2002 21:01 To: Tony Buckley [EMAIL PROTECTED] [RegSoft/mysql]; MySQL Subject: Re: Spam - a possible cause ? Tony, You have the same info on these opportunities as I had, and any other subscriber, since they were all posted on (um, spammed to) this list. (If you're a *very* recent subscriber you should be able to find them in the archives or Google.) I gave literal quotes from messages sent to the list. Of course if you "just deleted" them you'll have to wait (just a bit, surely not long) for the next irresistable "Business opportunity" to be announced here ;-) At 18:49 2002-01-13, Tony Buckley wrote: >- Original Message - >From: "Marjolein Katsma" <[EMAIL PROTECTED]> >To: "[EMAIL PROTECTED] [RegSoft/mysql]" ><[EMAIL PROTECTED]>; "MySQL" ><[EMAIL PROTECTED]> >Sent: Saturday, January 12, 2002 12:44 PM >Subject: RE: Spam - a possible cause ? > > >> Matthew, >> > > Spam is people not interested in MySQL at all posting a "Business >opportunity" ("Dear mysql, Join today for FREE and a chance to win a $100 >Shopping Spree at The DHS Club Outlet Center!") or "Golden Investment >Opportunity" or "Great Growth Potential" stock scams. >> > >Marjolein, > >They sound like great opportunities. Do you have any more info? > >Tony -- Marjolein Katsma HomeSite Help - http://hshelp.com/ - Extensions, Tips and Tools The Bookstore - http://books.hshelp.com/ - Books for webmasters and webrookies - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
relational tables
Hi people : How I crate this relational tables with mysql. Table users | id | user name| e-mail | password | carrier| semester | table assignments | id | assignments | where the two tables must be related by id ok thanks for the help... _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: A difficutl query I cannot do.
The following SELECT should produce your table mysql> Select id, ->Max(CASE TimeSlot -> WHEN 1 THEN Subject ->ELSE "" ->END) AS TS1, ->Max(CASE TimeSlot -> WHEN 2 THEN Subject ->ELSE "" ->END) AS TS2, ->Max(CASE TimeSlot -> WHEN 3 THEN Subject ->ELSE "" ->END) AS TS3, ->Max(CASE TimeSlot -> WHEN 4 THEN Subject ->ELSE "" ->END) AS TS4 -> From sch -> Group by id -> ; +-+--++--++ | id | TS1 | TS2| TS3 | TS4| +-+--++--++ | 215 | Science1 | Maths1 | Eng1 || | 648 | | Maths2 | | Art| | 901 | Science2 || Eng1 | French | +-+--++--++ 3 rows in set (0.00 sec) -Original Message- From: Sam Russo [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 09, 2002 5:25 PM To: [EMAIL PROTECTED] Subject: A difficutl query I cannot do. I have a delimited file sent to me with students ID subjects and when they do these subjects. This file (table) looks like: ID TimeSlotSubject 215 3 Eng1 648 2 Maths2 901 4 French 215 2 Maths1 901 1 Science2 648 4 Art 215 1 Science1 901 3 Eng1 I need to produce the following output (on a web page using php and mysql) with a mysql query. ID 1 2 3 4 215 Science1Maths1 Eng1 648 Maths2 Art 901 Science2Eng1 French any help would be appreciated. sam russo [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: Licensing
Frans: Legalities aside, why not let fairness and common decency prevail? The MySQL team has a created a powerful, functional DB server. If you use their product(s) in a commercial application for which you are being paid, why would you NOT want to purchase a license? If the US$200 price is too high, then perhaps you should re-examine the fee you are charging. Gerald Jensen - Original Message - From: "Frans Englich" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, January 13, 2002 2:15 PM Subject: Licensing I'm writing an adminstrative program for a hotel located in Sweden. This program uses an mysql database as backend(the implementation is not in use yet, but my intention is to use mysql). To be really sure about this: Do the hotel _have_ to get an MySql database License or will they stay legal without one? I know, mySql is released under the GPL license but I need to be really sure about this. I would love to buy an license to support the Mysql team but since the license would be drawn from my payment I'm hesitating.. 200USD is alot of money here in Sweden, atleast for me. regards, Frans Englich [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: Spam - a possible cause ?
Tony, You have the same info on these opportunities as I had, and any other subscriber, since they were all posted on (um, spammed to) this list. (If you're a *very* recent subscriber you should be able to find them in the archives or Google.) I gave literal quotes from messages sent to the list. Of course if you "just deleted" them you'll have to wait (just a bit, surely not long) for the next irresistable "Business opportunity" to be announced here ;-) At 18:49 2002-01-13, Tony Buckley wrote: >- Original Message - >From: "Marjolein Katsma" <[EMAIL PROTECTED]> >To: "[EMAIL PROTECTED] [RegSoft/mysql]" ><[EMAIL PROTECTED]>; "MySQL" ><[EMAIL PROTECTED]> >Sent: Saturday, January 12, 2002 12:44 PM >Subject: RE: Spam - a possible cause ? > > >> Matthew, >> > > Spam is people not interested in MySQL at all posting a "Business >opportunity" ("Dear mysql, Join today for FREE and a chance to win a $100 >Shopping Spree at The DHS Club Outlet Center!") or "Golden Investment >Opportunity" or "Great Growth Potential" stock scams. >> > >Marjolein, > >They sound like great opportunities. Do you have any more info? > >Tony -- Marjolein Katsma HomeSite Help - http://hshelp.com/ - Extensions, Tips and Tools The Bookstore - http://books.hshelp.com/ - Books for webmasters and webrookies - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
localhost and so on ....
Hi, I knew that already. But when I have a database connection in a application server configuration file and I want to use the file on different machines I need localhost as the name for the mySQL Server. And the App.-Server is using TCP/IP. Why does even the Telnet access not work ? How can I access the permissions to connect through 127.0.0.1 ? I set permissions to connect through localhost with the GRANT-Commmand as far as I remember ? Thanks in advance, Frank Marx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 question (bug?)
Hi! Unfortunately, I get too many e-mails to handle help requests which are sent directly to me. If you have purchased MySQL support, you may write to [EMAIL PROTECTED], and will get an answer quickly. If you would like to purchase support, please see the Support section of our web site: http://www.mysql.com/support/ If you do not want to purchase support, please send e-mail to the appropriate mailing list. We host several mailing lists related to MySQL: http://www.mysql.com/documentation/lists.html When you post your question, be sure to follow these hints about how to ask effective questions: http://www.mysql.com/documentation/mysql/commented/manual.php?section=Asking_questions On Jan 11, ICCFX wrote: > Hello Sergei, > > I know I shouldn't be mailing directly to you, but there is only one thing > in the whole SQL-world that I am fighting with you should be writing to [EMAIL PROTECTED] > I am trying out this FULLTEXT search, and it's real good! > But there is one thing that I still can't find... > > How can you search for words, containing non-alpha characters? > e.g. > > $result = mysql("db","SELECT *, MATCH title,body AGAINST ('song.mp3') AS > score FROM table WHERE MATCH (title,body) AGAINST ('$song.mp3')"); > > It ignores the '.' :( (or a minus sign, which is real text sometimes) > > Am I looking over something...? > Can you please help me out? > > Many thanks > Frederic MySQL splits words on non-alpha chars before putting them into index. so, you have two possibilities 1) make '-' and '.' legal word char - you have to alter ft_parser.c, word_char macro. 2) search like this MATCH (title,body) AGAINST ('$song') AND CONCAT(title,' ',body) LIKE '$song.mp3') Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany <___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Licensing
I'm writing an adminstrative program for a hotel located in Sweden. This program uses an mysql database as backend(the implementation is not in use yet, but my intention is to use mysql). To be really sure about this: Do the hotel _have_ to get an MySql database License or will they stay legal without one? I know, mySql is released under the GPL license but I need to be really sure about this. I would love to buy an license to support the Mysql team but since the license would be drawn from my payment I'm hesitating.. 200USD is alot of money here in Sweden, atleast for me. regards, Frans Englich [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: can't connet to localhost
> Hello, > > I use MySQL running as a service on Windows XP. > > My host has the name excalibur and the IP 66.121.159.212 which is the same > machine as localhost (127.0.0.1). > > when I use the following command to connect to the database: > > mysql --user=dummy --password=dummy --host=localhost > > I cannot not connect > > when I use: > > mysql --user=dummy --password=dummy --pipe --host=localhost > > I can connect. > > when I use: > > mysql --user=dummy --password=dummy --host=excalibur > > I CAN connect. > > when I use: > > telnet localhost 3306 > > my connection is refused (that what telnet tells me) > > but with: > > telnet excalibur 3306 > > I can see some output of the MySQL-Server which tries to make a handshake. > > Are there people here who had the same problem ? > I can connect using localhost using a pipe and not a socket. > But I can connect using a socket when I use the name "excalibur" which is > the identical machine as localhost. > > Has someone a idea how to solve this problem ? "localhost" and "excalibur" are not identical -- the first is connecting through 66.121.159.212, the other through 127.0.0.1. Most likely, you have not set permissions to connect from 127.0.0.1 "localhost" connections are by default done through a pipe, not TCP/IP. The server will refuse connections that seem to come from "127.0.0.1" -- unless you specifically set the perms. Don't specify "--host" when connecting to localhost -- then "--pipe" will be correctly be assumed. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
can't connet to localhost
Hello, I use MySQL running as a service on Windows XP. My host has the name excalibur and the IP 66.121.159.212 which is the same machine as localhost (127.0.0.1). when I use the following command to connect to the database: mysql --user=dummy --password=dummy --host=localhost I cannot not connect when I use: mysql --user=dummy --password=dummy --pipe --host=localhost I can connect. when I use: mysql --user=dummy --password=dummy --host=excalibur I CAN connect. when I use: telnet localhost 3306 my connection is refused (that what telnet tells me) but with: telnet excalibur 3306 I can see some output of the MySQL-Server which tries to make a handshake. Are there people here who had the same problem ? I can connect using localhost using a pipe and not a socket. But I can connect using a socket when I use the name "excalibur" which is the identical machine as localhost. Has someone a idea how to solve this problem ? Thanks in advance, Frank Marx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Spam - a possible cause ?
> > Spam is people not interested in MySQL at all posting a "Business > opportunity" ("Dear mysql, Join today for FREE and a chance to win a $100 > Shopping Spree at The DHS Club Outlet Center!") or "Golden Investment > Opportunity" or "Great Growth Potential" stock scams. > > > > Marjolein, > > They sound like great opportunities. Do you have any more info? > > Tony, Tony, Wouldn't your first step in such innocense and foolishness be to e-mail <[EMAIL PROTECTED]> !? =dn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: unable to get not exists left join to work--please help
* Roleigh Martin > -> from words w, events e, LEFT JOIN events e2 on ( e.url_id = Try removing a comma: from words w, events e LEFT JOIN events e2 on ( e.url_id = The comma is actually a 'synonym' for 'INNER JOIN', the statement fraction above is the same as: from words w INNER JOIN events e LEFT JOIN events e2 on ( e.url_id = -- Roger database, table - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: unable to get not exists left join to work--please help
* Roleigh Martin > mysql> insert h2 > -> select h1.word, ' ', 0 > -> from h1 left join h2 ah2 on h1.word = ah2.word > -> where ah2.word is NULL; > ERROR 1093: INSERT TABLE 'h2' isn't allowed in FROM table list You can not select from the table you are inserting to. Use a temporary table: create temporary table tmp1 select ... ; insert into h2 select * from tmp1; -- 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
Re: unable to get not exists left join to work--please help
I am able to get what I want with one workaround but am unable to insert the selected data into the target table - note below: mysql> select h1.word, ' ', 0 -> from h1 left join h2 ah2 on h1.word = ah2.word -> where ah2.word is NULL; +---+---+---+ | word | | 0 | +---+---+---+ | Products_and_Shopping | | 0 | +---+---+---+ 1 row in set (0.00 sec) note - the above works but when I repeat above statement but prefix the entire statement with "insert h2" - I get this error message -- any ideas on how to fix this? mysql> insert h2 -> select h1.word, ' ', 0 -> from h1 left join h2 ah2 on h1.word = ah2.word -> where ah2.word is NULL; ERROR 1093: INSERT TABLE 'h2' isn't allowed in FROM table list At 12:53 PM 1/13/2002, Roleigh Martin wrote: >Hello all, my first mysql posting. I've been a Sybase SQL Server >programmer for >10 years and the following select I know I have to translate as MySQL does not >support nested selects. > >My version: >mysql Ver 11.15 Distrib 3.23.41, for redhat-linux-gnu (i386) > > >insert h2 >select w.word,' ', 0 >from words w, events e >where e.word_id = w.word_id >ande.leftseq = 1 >and0 = (select count(*) from words w2, events e2 > where e2.url_id = e.url_id > and e2.leftseq = 2 > and w2.word_id = e2.word_id ) >group by w.word; > >I've tried the following variants and they generate error messages: > >mysql> select w.word,' ',0 > -> from words w, events e, LEFT JOIN events e2 on ( e.url_id = > e2.url_id and e2.leftseq = 2)-> where e.word_id = w.word_id > -> ande.leftseq = 1 > -> ande2.url_id is NULL > -> group by w.word; >ERROR 1064: You have an error in your SQL syntax near 'LEFT JOIN events e2 >on ( e.url_id = e2.url_id and e2.leftseq = 2) >where e.word_' at line 2 > >mysql> insert h2 > -> select w.word,' ',0 > -> from words w, events e, LEFT JOIN events e2 on e.url_id = e2.url_id > -> where e.word_id = w.word_id > -> ande.leftseq = 1 > -> ande2.leftseq = 2 > -> ande2.url_id = NULL > -> group by w.word; >ERROR 1064: You have an error in your SQL syntax near 'LEFT JOIN events e2 >on e.url_id = e2.url_id >where e.word_id = w.word_id >and ' at line 3 > >mysql> insert h2 > -> select w.word,' ',0 > -> from words w, events e, LEFT JOIN events e2 on e.url_id = e2.url_id > -> where e.word_id = w.word_id > -> ande.leftseq = 1 > -> ande2.leftseq = 2 > -> group by w.word; >ERROR 1064: You have an error in your SQL syntax near 'LEFT JOIN events e2 >on e.url_id = e2.url_id >where e.word_id = w.word_id >and ' at line 3 > >Appreciate your help in advance - thanks! > > > >- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail <[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
unable to get not exists left join to work--please help
Hello all, my first mysql posting. I've been a Sybase SQL Server programmer for 10 years and the following select I know I have to translate as MySQL does not support nested selects. My version: mysql Ver 11.15 Distrib 3.23.41, for redhat-linux-gnu (i386) insert h2 select w.word,' ', 0 from words w, events e where e.word_id = w.word_id ande.leftseq = 1 and0 = (select count(*) from words w2, events e2 where e2.url_id = e.url_id and e2.leftseq = 2 and w2.word_id = e2.word_id ) group by w.word; I've tried the following variants and they generate error messages: mysql> select w.word,' ',0 -> from words w, events e, LEFT JOIN events e2 on ( e.url_id = e2.url_id and e2.leftseq = 2)-> where e.word_id = w.word_id -> ande.leftseq = 1 -> ande2.url_id is NULL -> group by w.word; ERROR 1064: You have an error in your SQL syntax near 'LEFT JOIN events e2 on ( e.url_id = e2.url_id and e2.leftseq = 2) where e.word_' at line 2 mysql> insert h2 -> select w.word,' ',0 -> from words w, events e, LEFT JOIN events e2 on e.url_id = e2.url_id -> where e.word_id = w.word_id -> ande.leftseq = 1 -> ande2.leftseq = 2 -> ande2.url_id = NULL -> group by w.word; ERROR 1064: You have an error in your SQL syntax near 'LEFT JOIN events e2 on e.url_id = e2.url_id where e.word_id = w.word_id and ' at line 3 mysql> insert h2 -> select w.word,' ',0 -> from words w, events e, LEFT JOIN events e2 on e.url_id = e2.url_id -> where e.word_id = w.word_id -> ande.leftseq = 1 -> ande2.leftseq = 2 -> group by w.word; ERROR 1064: You have an error in your SQL syntax near 'LEFT JOIN events e2 on e.url_id = e2.url_id where e.word_id = w.word_id and ' at line 3 Appreciate your help in advance - thanks! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL Query+PHP
* Steger Andras > $result = mysql_query("SELECT * FROM employees WHERE first = $neve",$db) You need quotes. try "... WHERE first = '$neve'" -- 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
Re: Spam - a possible cause ?
- Original Message - From: "Marjolein Katsma" <[EMAIL PROTECTED]> To: "[EMAIL PROTECTED] [RegSoft/mysql]" <[EMAIL PROTECTED]>; "MySQL" <[EMAIL PROTECTED]> Sent: Saturday, January 12, 2002 12:44 PM Subject: RE: Spam - a possible cause ? > Matthew, > Spam is people not interested in MySQL at all posting a "Business opportunity" ("Dear mysql, Join today for FREE and a chance to win a $100 Shopping Spree at The DHS Club Outlet Center!") or "Golden Investment Opportunity" or "Great Growth Potential" stock scams. > Marjolein, They sound like great opportunities. Do you have any more info? Tony - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Query+PHP
I am trying to write a query that gets the name of every personr who has a neme: $neve This parameter come from a form like this: FORM ACTION="sqlphp.php" METHOD="post"> The following script is running, but if I write in the 7-th row: $result = mysql_query("SELECT * FROM employees WHERE first = $neve",$db) It is wrong... (I want to replace the "if" statement in the 21-th row.) Can anyone help? "; echo "\n"; echo "NameAddressPosition"; // $i=0; // while ($myrow = mysql_fetch_array($result)) for ($i = 0; $i <=$rows - 1; $i++) { if (mysql_result($result,$i,"first") == $neve){ printf("%s %s%s%s\n", mysql_result($result,$i,"first"), mysql_result($result,$i,"last"), mysql_result($result,$i,"address"), mysql_result($result,$i,"position")); } // $i++; } echo "\n"; mysql_free_result ($result); ?> - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MERGE Table & DELETE FROM component
I'd like to have precisions regarding MERGE TABLE. Let's say we have a MERGE on jan, feb, mar. If I do a DELETE FROM mar. Every thing seems to work correctly, however the manual says that this request have some unexpected results. I don't understand why. Emptying a MERGE component doesn't seem to me as a big problem. Is it really ? thanx, Antoine -- Antoine PICHOT PGP KEY : http://www-eleves.int-evry.fr/~pichot_a/pgp.txt ICQ : 455751 Port : +33 6 08747743 Tel : +33 1 69362278 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 marked as readonly
> Hi, > > I got a VB program running on Windows 2000 Pro Workstations > against a Linux mySql database. The Workstations got JET 4.0 > installed, ADO(used by the vb program) and Service Pack 2. The > program connects via MyOdbc. > MySql has a database named "hotel" which the program opens and > writes to(atleast tries..). The user used by the client got all > permissions to the "hotel" database. > > The funny thing is, as soon I tries an update or insert query it > returns "table 'bla bla' marked as readonly". What's wrong? > > A fast answer is really appreciated. Does 'bla bla' have a primary key? / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: big problem with mysqldb
Hi, I would like to thank everyone (esp Carsten and Jocelyn) who helped me solve this problem. It now seems that the db now works ok. For the record, I suggest that isamchk should contain a warning in the help text that you should not run it when mysqld is running. This combined with isamchk -i *.ISM. Also, I'll backup using mysqldump from now on, not just tarballing my dbdirs :) Tarjei "Carsten H. Pedersen" wrote: > > > isamchk -e -o page.ISM > > I get: > > Found block with too small length at 2249; Skipped > > ... > > Now what do I do?? > > Restore from backup? > > Your table structure is definitely corrupted. > > What happens if you run isamchk with just "-r": > > isamchk -r page.ISM > > ? > > / Carsten > -- > Carsten H. Pedersen > keeper and maintainer of the bitbybit.dk MySQL FAQ > http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Regexp Help !!!
>From the perl side, you could also split on / and then put each element in a hash with the value being a hashref for the next element's hash. - Original Message - From: "Jon Shoberg" <[EMAIL PROTECTED]> To: "Carsten H. Pedersen" <[EMAIL PROTECTED]>; "Beginners (E-mail)" <[EMAIL PROTECTED]> Cc: "*MySQL mail list" <[EMAIL PROTECTED]> Sent: Sunday, January 13, 2002 11:36 AM Subject: RE: Regexp Help !!! > > Thanks ! > > Glad I asked for some other thoughts on this. I totally over looked this > and given how my indexes are setup, this will work much better. > > Thanks again, > Jon > > -Original Message- > From: Carsten H. Pedersen [mailto:[EMAIL PROTECTED]] > Sent: Sunday, January 13, 2002 11:26 AM > To: Jon Shoberg; Beginners (E-mail) > Cc: *MySQL mail list > Subject: RE: Regexp Help !!! > > > > -Original Message- > > From: Jon Shoberg [mailto:[EMAIL PROTECTED]] > > Sent: Sunday, January 13, 2002 4:47 PM > > To: Beginners (E-mail) > > Cc: *MySQL mail list; Jon Shoberg > > Subject: Regexp Help !!! > > > > > > Ok, > > > > I have a list/database of words that follows as ... > > > > Top > > ... > > Top/Arts/Food > > Top/Arts/Food/Country > > ... > > Top/World/America > > Top/World/Japan > > Top/World/Japan/Economy > > Top/World/Japan/Food > > Top/World/Japan/Food/Country > > Top/World/Japan/Food/Country/By_Chef > > > > ... > > > > How can I setup a regexp query/filter such that I can choose the > > prefix and > > the number of "/" in the results? > > > > Example: How can I query/filter the list such that I am looking for all > > "Top/World/" matches that have only one more word after them. So my only > > results from the example about would be "Top/World/America" and > > "Top/World/Japan". Then I would do the same for "Top/World/Japan" and get > > "Top/World/Japan/Economy" and then "Top/World/Japan/Food". This > > is part of > > the program so I can count the number of "/" in the query/filter > > string. I > > jsut want to exclude the extra matches. > > > > Any thoughts? > > > > Thanks > > Jon > > Not sure I would do it using regexps. Unless I misunderstand what > you're trying to do, I would consider using LIKE as this will often > be much faster: > > SELECT ... > WHERE data LIKE "TOP/World/Japan/%" > AND data NOT LIKE "TOP/World/Japan/%/%" > > - in essence: select all those records which start with > "TOP/World/Japan/", then subtract those which contain > any further "/". > > / Carsten > -- > Carsten H. Pedersen > keeper and maintainer of the bitbybit.dk MySQL FAQ > http://www.bitbybit.dk/mysqlfaq > > > -- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Regexp Help !!!
Thanks ! Glad I asked for some other thoughts on this. I totally over looked this and given how my indexes are setup, this will work much better. Thanks again, Jon -Original Message- From: Carsten H. Pedersen [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 13, 2002 11:26 AM To: Jon Shoberg; Beginners (E-mail) Cc: *MySQL mail list Subject: RE: Regexp Help !!! > -Original Message- > From: Jon Shoberg [mailto:[EMAIL PROTECTED]] > Sent: Sunday, January 13, 2002 4:47 PM > To: Beginners (E-mail) > Cc: *MySQL mail list; Jon Shoberg > Subject: Regexp Help !!! > > > Ok, > > I have a list/database of words that follows as ... > > Top > ... > Top/Arts/Food > Top/Arts/Food/Country > ... > Top/World/America > Top/World/Japan > Top/World/Japan/Economy > Top/World/Japan/Food > Top/World/Japan/Food/Country > Top/World/Japan/Food/Country/By_Chef > > ... > > How can I setup a regexp query/filter such that I can choose the > prefix and > the number of "/" in the results? > > Example: How can I query/filter the list such that I am looking for all > "Top/World/" matches that have only one more word after them. So my only > results from the example about would be "Top/World/America" and > "Top/World/Japan". Then I would do the same for "Top/World/Japan" and get > "Top/World/Japan/Economy" and then "Top/World/Japan/Food". This > is part of > the program so I can count the number of "/" in the query/filter > string. I > jsut want to exclude the extra matches. > > Any thoughts? > > Thanks > Jon Not sure I would do it using regexps. Unless I misunderstand what you're trying to do, I would consider using LIKE as this will often be much faster: SELECT ... WHERE data LIKE "TOP/World/Japan/%" AND data NOT LIKE "TOP/World/Japan/%/%" - in essence: select all those records which start with "TOP/World/Japan/", then subtract those which contain any further "/". / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 marked as readonly
Hi, I got a VB program running on Windows 2000 Pro Workstations against a Linux mySql database. The Workstations got JET 4.0 installed, ADO(used by the vb program) and Service Pack 2. The program connects via MyOdbc. MySql has a database named "hotel" which the program opens and writes to(atleast tries..). The user used by the client got all permissions to the "hotel" database. The funny thing is, as soon I tries an update or insert query it returns "table 'bla bla' marked as readonly". What's wrong? A fast answer is really appreciated. best regards, Frans [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: Regexp Help !!!
> -Original Message- > From: Jon Shoberg [mailto:[EMAIL PROTECTED]] > Sent: Sunday, January 13, 2002 4:47 PM > To: Beginners (E-mail) > Cc: *MySQL mail list; Jon Shoberg > Subject: Regexp Help !!! > > > Ok, > > I have a list/database of words that follows as ... > > Top > ... > Top/Arts/Food > Top/Arts/Food/Country > ... > Top/World/America > Top/World/Japan > Top/World/Japan/Economy > Top/World/Japan/Food > Top/World/Japan/Food/Country > Top/World/Japan/Food/Country/By_Chef > > ... > > How can I setup a regexp query/filter such that I can choose the > prefix and > the number of "/" in the results? > > Example: How can I query/filter the list such that I am looking for all > "Top/World/" matches that have only one more word after them. So my only > results from the example about would be "Top/World/America" and > "Top/World/Japan". Then I would do the same for "Top/World/Japan" and get > "Top/World/Japan/Economy" and then "Top/World/Japan/Food". This > is part of > the program so I can count the number of "/" in the query/filter > string. I > jsut want to exclude the extra matches. > > Any thoughts? > > Thanks > Jon Not sure I would do it using regexps. Unless I misunderstand what you're trying to do, I would consider using LIKE as this will often be much faster: SELECT ... WHERE data LIKE "TOP/World/Japan/%" AND data NOT LIKE "TOP/World/Japan/%/%" - in essence: select all those records which start with "TOP/World/Japan/", then subtract those which contain any further "/". / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: big problem with mysqldb
Shit no. Thanks, I did backup :) Tarjei "Fournier Jocelyn [Presence-PC]" wrote: > > Hi, > > Did you run isamchk with mysql shut down ? (it's needed otherwise you'll > corrupt your table) > > Regards, > Jocelyn > - Original Message - > From: "Tarjei Huse" <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Sunday, January 13, 2002 4:54 PM > Subject: Re: big problem with mysqldb > > > > - At what size of the DB does it fail? > > ?? do you mean the size of the database? > > > > > - Do you have enough disk space for all those records? > > Yes. > > > And then: > > > > > > Have you run CHECK TABLE on your tables? > > midgardstaging.topic check error The handler for the table doesn't support > > check/repair > > > Which statements fail? > > > > > What is the structure of the tables involved? > > Table Action Records Type Size > >article nr recods: 1,094 ISAM size: 3.7 MB > >pagenr recods: 286 ISAM size: 703.3 KB > > > > > And most important of all: What is the error message > > > you get? > > > > > > > 2. Mysqldump does not dump the compleat tables. > > > > > > Which command do you use when running mysqldump? > > > What is missing? > > whole records. > > isamchk -e -o page.ISM > > I get: > > Found block with too small length at 2249; Skipped > > Found block with too small length at 49885; Skipped > > Found block with too small length at 62010; Skipped > > Found link that points at 1868710169 (outside data file) at 63660 > > Found block with too small length at 64030; Skipped > > Found block with too small length at 64050; Skipped > > Found block with too small length at 71453; Skipped > > Found link that points at 1952535311 (outside data file) at 76081 > > Found link that points at 1869889801 (outside data file) at 85331 > > Found link that points at 1785483012 (outside data file) at 85568 > > Found link that points at 1060896819 (outside data file) at 85573 > > Found block with too small length at 96345; Skipped > > Found link that points at 1869304580 (outside data file) at 96742 > > Found link that points at 1060896819 (outside data file) at 96747 > > Found link that points at 1684956426 (outside data file) at 98542 > > Found link that points at 1685013256 (outside data file) at 100089 > > Found block with too small length at 100703; Skipped > > Found block with too small length at 103330; Skipped > > Found block with too small length at 103464; Skipped > > Found block with too small length at 103469; Skipped > > Found block with too small length at 110131; Skipped > > Found link that points at 1937072644 (outside data file) at 116672 > > Found link that points at 1060896869 (outside data file) at 116677 > > Found block with too small length at 121234; Skipped > > Found block with too small length at 259446; Skipped > > Found link that points at 2037138960 (outside data file) at 316114 > > Found block with too small length at 317694; Skipped > > Found block with too small length at 317810; Skipped > > Found block with too small length at 318914; Skipped > > Found block with too small length at 320717; Skipped > > Found block with too small length at 326437; Skipped > > Found block with too small length at 327235; Skipped > > Found block with too small length at 327251; Skipped > > Found block with too small length at 332383; Skipped > > Found link that points at 1952871756 (outside data file) at 336925 > > Found link that points at 1818586217 (outside data file) at 354634 > > Found link that points at 538976288 (outside data file) at 368192 > > Found block with too small length at 401884; Skipped > > Found link that points at 1852270956 (outside data file) at 410866 > > Found block with too small length at 412086; Skipped > > Found block with too small length at 415513; Skipped > > Found block with too small length at 420405; Skipped > > Found block with too small length at 434583; Skipped > > Found block with too small length at 435551; Skipped > > Found block with too small length at 448955; Skipped > > Found link that points at 1006658816 (outside data file) at 460282 > > Found block with too small length at 461319; Skipped > > Found link that points at 1785491204 (outside data file) at 461883 > > Found link that points at 1060896792 (outside data file) at 461888 > > Found block with too small length at 468037; Skipped > > Found block with too small length at 520312; Skipped > > Found link that points at 1600415597 (outside data file) at 601955 > > Found block with too small length at 609236; Skipped > > Found block with too small length at 609241; Skipped > > Found block with too small length at 609640; Skipped > > Found link that points at 1701999620 (outside data file) at 626125 > > Found link that points at 1060900833 (outside data file) at 626130 > > Found block with too small length at 661866; Skipped > > Found block that points outside data file at 669603 > > Found block that points outside data file at 673841 > > Found block that points outside da
Re: big problem with mysqldb
> - At what size of the DB does it fail? ?? do you mean the size of the database? > - Do you have enough disk space for all those records? Yes. > And then: > > Have you run CHECK TABLE on your tables? midgardstaging.topic check error The handler for the table doesn't support check/repair > Which statements fail? > What is the structure of the tables involved? Table Action Records Type Size article nr recods: 1,094 ISAM size: 3.7 MB pagenr recods: 286 ISAM size: 703.3 KB > And most important of all: What is the error message > you get? > > > 2. Mysqldump does not dump the compleat tables. > > Which command do you use when running mysqldump? > What is missing? whole records. isamchk -e -o page.ISM I get: Found block with too small length at 2249; Skipped Found block with too small length at 49885; Skipped Found block with too small length at 62010; Skipped Found link that points at 1868710169 (outside data file) at 63660 Found block with too small length at 64030; Skipped Found block with too small length at 64050; Skipped Found block with too small length at 71453; Skipped Found link that points at 1952535311 (outside data file) at 76081 Found link that points at 1869889801 (outside data file) at 85331 Found link that points at 1785483012 (outside data file) at 85568 Found link that points at 1060896819 (outside data file) at 85573 Found block with too small length at 96345; Skipped Found link that points at 1869304580 (outside data file) at 96742 Found link that points at 1060896819 (outside data file) at 96747 Found link that points at 1684956426 (outside data file) at 98542 Found link that points at 1685013256 (outside data file) at 100089 Found block with too small length at 100703; Skipped Found block with too small length at 103330; Skipped Found block with too small length at 103464; Skipped Found block with too small length at 103469; Skipped Found block with too small length at 110131; Skipped Found link that points at 1937072644 (outside data file) at 116672 Found link that points at 1060896869 (outside data file) at 116677 Found block with too small length at 121234; Skipped Found block with too small length at 259446; Skipped Found link that points at 2037138960 (outside data file) at 316114 Found block with too small length at 317694; Skipped Found block with too small length at 317810; Skipped Found block with too small length at 318914; Skipped Found block with too small length at 320717; Skipped Found block with too small length at 326437; Skipped Found block with too small length at 327235; Skipped Found block with too small length at 327251; Skipped Found block with too small length at 332383; Skipped Found link that points at 1952871756 (outside data file) at 336925 Found link that points at 1818586217 (outside data file) at 354634 Found link that points at 538976288 (outside data file) at 368192 Found block with too small length at 401884; Skipped Found link that points at 1852270956 (outside data file) at 410866 Found block with too small length at 412086; Skipped Found block with too small length at 415513; Skipped Found block with too small length at 420405; Skipped Found block with too small length at 434583; Skipped Found block with too small length at 435551; Skipped Found block with too small length at 448955; Skipped Found link that points at 1006658816 (outside data file) at 460282 Found block with too small length at 461319; Skipped Found link that points at 1785491204 (outside data file) at 461883 Found link that points at 1060896792 (outside data file) at 461888 Found block with too small length at 468037; Skipped Found block with too small length at 520312; Skipped Found link that points at 1600415597 (outside data file) at 601955 Found block with too small length at 609236; Skipped Found block with too small length at 609241; Skipped Found block with too small length at 609640; Skipped Found link that points at 1701999620 (outside data file) at 626125 Found link that points at 1060900833 (outside data file) at 626130 Found block with too small length at 661866; Skipped Found block that points outside data file at 669603 Found block that points outside data file at 673841 Found block that points outside data file at 678463 Found block that points outside data file at 683373 Found block with too small length at 683390; Skipped Found block that points outside data file at 690679 Found block that points outside data file at 693446 Found block that points outside data file at 697102 Found block that points outside data file at 704604 Found block that points outside data file at 708929 Now what do I do?? > / Carsten > -- > Carsten H. Pedersen > keeper and maintainer of the bitbybit.dk MySQL FAQ > http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list arch
Regexp Help !!!
Ok, I have a list/database of words that follows as ... Top ... Top/Arts/Food Top/Arts/Food/Country ... Top/World/America Top/World/Japan Top/World/Japan/Economy Top/World/Japan/Food Top/World/Japan/Food/Country Top/World/Japan/Food/Country/By_Chef ... How can I setup a regexp query/filter such that I can choose the prefix and the number of "/" in the results? Example: How can I query/filter the list such that I am looking for all "Top/World/" matches that have only one more word after them. So my only results from the example about would be "Top/World/America" and "Top/World/Japan". Then I would do the same for "Top/World/Japan" and get "Top/World/Japan/Economy" and then "Top/World/Japan/Food". This is part of the program so I can count the number of "/" in the query/filter string. I jsut want to exclude the extra matches. Any thoughts? Thanks Jon - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Column Limits
> I have a couple of questions relating to limits on columns. > > First, is it OK to use numbers (1,2,3, etc.) as the names of columns? A > quick scan of the manual doesn't turn up any such restrictions, but that > doesn't mean that there isn't one. Try scanning a bit slower: 6.1.2 Database, Table, Index, Column, and Alias Names ... A name may start with any character that is legal in a name. In particular, a name may start with a number (this differs from many other database systems!). However, a name cannot consist only of numbers. > Second, I know that there is a 255 character limit per column, but is > there a limit on how many columns can be added at one time, or a limit > on how many characters in total can be assigned to columns? None related to your trouble. Those limits are much higher than what you're trying to do. Try reading http://www.bitbybit.dk/mysqlfaq/faq.html#ch9_0_0 / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: big problem with mysqldb
> I am having problems with my mysq db. The symthoms are many I'll > list them: > > 1. some select statements return error when the dataset grows to > a certain size, > I think this is because of defect records. You do not provide a lot of information to go by. Getting the obvious questions out of the way: - At what size of the DB does it fail? - Do you have enough disk space for all those records? And then: Have you run CHECK TABLE on your tables? Which statements fail? What is the structure of the tables involved? And most important of all: What is the error message you get? > 2. Mysqldump does not dump the compleat tables. Which command do you use when running mysqldump? What is missing? / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Column Limits
I have a couple of questions relating to limits on columns. First, is it OK to use numbers (1,2,3, etc.) as the names of columns? A quick scan of the manual doesn't turn up any such restrictions, but that doesn't mean that there isn't one. Second, I know that there is a 255 character limit per column, but is there a limit on how many columns can be added at one time, or a limit on how many characters in total can be assigned to columns? The reason for the questions is that I'm trying to create a table with 25 columns, 20 of them using the numbers 1 through 20 as column names and there is a message that says there's an error starting at the column labelled '1'. As it happens, this is also the point where 255 characters would be exceeded. Any help would be appreciated. Rich -- [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
big problem with mysqldb
Hi I am having problems with my mysq db. The symthoms are many I'll list them: 1. some select statements return error when the dataset grows to a certain size, I think this is because of defect records. 2. Mysqldump does not dump the compleat tables. Of cource this is a BIG problem for me. Does anyone know what I should do to save the day ? PS: I'm new to this list, so I do not know what you guys whant to know about my db etc. mysql -V: mysql Ver 11.13 Distrib 3.23.36, for redhat-linux-gnu (i386) Tarjei - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: dates times etc
rc, > off topic topic of mysql databaseperl > > i need to know how to build a linux timestamp from a date given to me in > the following format 01-18-99 (m-d-y) i am using mysql to store this as an > int(11). > > i know php has a mktime function, does anyone know if perl has something > similar? =off topic and off subject - what's all this talk of PHP and Perl on [EMAIL PROTECTED]? 1 consider the way the "date given to me" and if you can acquire it in three components. If you must continue to suffer the illogical (US) sequence then next consider how you could rearrange mm-dd-yy into the MySQL format of [cc]yyddmm (int) or [cc]yy-mm-dd (str). 2 thereafter with the date in non-ambiguous format it can be fed into another routine that will convert it to a timestamp (NB UNIX Epoch not "linux") To save you from developing separate routines in PHP and Perl, consider a single solution in SQL: > Before posting, please check: >http://www.mysql.com/manual.php (the manual) step 1: 6.3.2 String Functions step 2: 6.3.4 Date and Time Functions =Some people mistakenly think MySQL is only for holding data... =Regards, =dn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
C# and MySQL without ODBC
[Please CC me, I'm not subscribed] Does someone know if there's a native C# implementation available OR a wrapper around libmysqlclient for C#? thx, Markus - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Database Size Limit
Oganes, are your really using disk partitions as InnoDB data files? If you use raw disk partitions, then the operating system may put a limit on the number of them, for example, 16. But usually InnoDB data files will be just ordinary files of the file system. The number of data files is restricted by the maximum parameter line length in my.cnf, which is maybe 2048 bytes. Thus you can define hundreds of InnoDB data files. With very big databases it is probably easiest to use an operating system which supports > 4 GB files, so that you can make your data files bigger than 2 GB or 4 GB. InnoDB reuses the space in its tablespace (tablespace = all the data files concatenated). Thus space which is freed from one table is available for other tables to use. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB Benjamin Arai wrote in message ... >The size limitation is becauseof the operating system parameters. In >order to use tables larger then 3 GB, use either Redhat 7.2 or Solaris 8. >These operating systems allow file sizes greater then 2 GB. For the most >part I achievedtables sizes using these operating system of greater the 50 >GB. > >Benjamin Arai >[EMAIL PROTECTED] > >On Fri, 11 Jan 2002, Demirchyan Oganes-AOD098 wrote: > >> Hello everyone, >> >> I guess I have the similar question, that has been brought up. >> >> I have 36 InnoDB tables, and I have allocated two 2GB partitions for my data. >> >> Provided I have very big hard drive, how many partitions at 2GB each could I allocate? As many as my hard drive can handle? >> >> I also have questions with regards, to a table size. In my case it will be (4GB)/36 bytes per table? Is it distributed uniformly, or some tables can grow bigger on the expense of the others (if some only have limited data, and others keep having new data inserted into them). >> >> Sincerely, >> >> Oganes Demirchyan >> Motorola Life Science >> 757 S.Raymond >> Pasadena, CA 91105 >> Tel: 626-584-5900 >> 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: Select statement help...
Hi Carsten, Thanks. Your close. Im searching on depart and arrive - not the times. so I want to go from Los Angeles to NewYork. So the standard query would be - SELECT depart, arrive FROM flights WHERE depart = 'LA' OR arrive = 'NY'; Now from this query I should have all of the records where depart contains "LA" and all of the arrive records that contain "NY". So the last step is to match the depart and arrive using the flight_group. So this is where I'm stuck I'm not sure how to add - WHERE t1.flight_group = t2.flight_group; That you suggested in your previous post. Thanks, - Tom Jones [EMAIL PROTECTED] - Original Message - From: "Carsten H. Pedersen" <[EMAIL PROTECTED]> To: "Tom Jones" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Saturday, January 12, 2002 15:35 Subject: RE: Select statement help... > > Hello, > > I've been trying to figure this out but I feel like I'm just > > banging my head > > on the wall. > > That must be quite painful... > > > I hope this is the right forum to pose this question. > > It's certainly one of the better ones, yes. > > > I have a table of flights which has several fields > > > > >Table: flights > > >Fields: depart, depart_time, arrive, arrive_time, flight_no, flight_group > > > > I'm trying to do a search on "depart" and "arrive" and show only > > the records > > which have matching "flight_group" > > You're not providing a lot of information. Is it something > like this, you're looking for: > > SELECT t1.depart_time, t2.arrive_time > FROM flights AS t1, flights AS t2 > WHERE t1.flight_group = t2.flight_group; > > / Carsten > -- > Carsten H. Pedersen > keeper and maintainer of the bitbybit.dk MySQL FAQ > http://www.bitbybit.dk/mysqlfaq > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php