ANNOUNCE: moodss-16.2
### CHANGES ### --- version 16.2 --- - pages tabs now reflect, by their background color, the crossed thresholds of highest importance in a page - pages tabs now feature a widget tip (balloon) containing up to 3 summaries of the crossed thresholds in a page - implemented colors sequencing (frequency: 1 Hertz) in pages tabs when there are several crossed thresholds of the same importance but of different colors in a page - messenger header (message label at the bottom left of the application window) now also serves as a global active thresholds viewer and implements the new pages tab features (crossed thresholds colors and summaries) but for all the thresholds in the loaded modules, independently of the presence of pages - allowed tables or viewers transfer between pages by move into a page tab, using the internal window manager handles - allowed viewer deletion by move into the eraser, using the internal window manager handles - hopefully handled all cases causing an update of pages tabs colors and widget tips (unloading modules, deleting viewers, moving viewers and tables between pages, updating thresholds, creating first page) - pages cannot be deleted when running in read-only mode - in preferences dialog box, validation would fail when there were no pages displayed - deleting a page between others would make all tables and viewers invisible in the following pages - current values table viewers now support non numerical data - improved anti-vibration code in automatic scroll widgets (please let me know if you see scrollbars in viewers, tables, canvas, help, ... hang the user interface by constantly appearing and disappearing, as in an infinite loop) - when loading from a save file, viewers using summary table viewer cells could show void values, due to a conceptual hole in the summary table restoration code (if you have such dashboards, repair by making sure all viewers show valid values, correct if necessary, then save) - when loading from a save file, cells with thresholds crossed immediately would not be colored on the initial refresh cycle - in thresholds dialog box, update original cell label so that it is correct in all cases, such as when loading from a save file - in global help window, scrolling using the keyboard is immediately enabled - in moomps daemon, removed debug trace - use helvetica font again in HTML widget, used in help, as italics are no longer displayed with an ugly fixed font on XFree 4.2 - use a common background color for all viewers so that free text viewer color is not different from the other viewers on Windows - successfully tested on Redhat 7.3 - in rpm, shared libraries successfully compiled and tested with gcc 3.1 ### README ### This is moodss (Modular Object Oriented Dynamic SpreadSheet) version 16.2. Moodss won in the Best System Admin Technology category (Tcl Tips and Tricks, Valuable Real World Programming Examples) at the O'Reilly Tcl/Tk 1999 Conference. Linux Magazine calls it a lifesaver. Tucows gives it 5 stars (cows or penguins :-). Moodss is a modular application. It displays data described and updated in one or more modules, which can be specified in the command line or dynamically loaded or unloaded while the application is running. Data is originally displayed in tables. Graphical viewers (graph, bar, 3D pie charts, ...), summary tables (with current, average, minimum and maximum values) and free text viewers can be created from any number of table cells, originating from any of the displayed viewers. The display area can be extended by adding pages with notebook tabs. Thresholds can be set on any number of cells. Moomps (shipped with moodss) is a monitoring daemon which works using configuration files created by moodss. Thresholds, when crossed, create messages in the system log, and eventually trigger the sending of email alert messages. Specific modules can easily be developed in the Tcl, Perl and Python scripting languages or in C. A thorough and intuitive drag'n'drop scheme is used for most viewer editing tasks: creation, modification, type mutation, destruction, ... and thresholds creation. Table rows can be sorted in increasing or decreasing order by clicking on column titles. The current configuration (modules, tables and viewers geometry, ...) can be saved in a file at any time, and later loaded at the user's convenience, thus achieving a dashboard functionality. The module code is the link between the moodss core and the data to be displayed. All the specific code is kept in the module package. Since module data access is entirely customizable (through C code, Tcl, Perl, Python, HTTP, ...) and since several modules can be loaded at once, applications for moodss become limitless. For example, thoroughly monitor a dynamic web server on a single dashboard with graphs, using the Apache, MySQL, ODBC, cpustats, memstats, ... modules. If you have replicated servers, dynamically add them to
InnoDB foreign key constraints
Hello list! I'm having a bit of trouble getting foreign key constraints to work. I'm running MySQL 2.23.50-Max. Here's what I got: mysql SHOW CREATE TABLE conn\G *** 1. row *** Table: conn Create Table: CREATE TABLE `conn` ( `id` int(10) unsigned NOT NULL auto_increment, `wall_nr` int(10) unsigned NOT NULL default '0', `hub_switch` varchar(20) NOT NULL default '', `comp_name` varchar(80) NOT NULL default '', `name_id` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `name_id` (`name_id`), UNIQUE KEY `comp_name` (`comp_name`), KEY `conn_idx` (`name_id`) ) TYPE=InnoDB 1 row in set (0.00 sec) mysql SHOW CREATE TABLE ip_name_tbl\G *** 1. row *** Table: ip_name_tbl Create Table: CREATE TABLE `ip_name_tbl` ( `id` int(10) unsigned NOT NULL auto_increment, `comp_loc` smallint(5) unsigned NOT NULL default '0', `comp_sub_loc` smallint(5) unsigned NOT NULL default '0', `ip_stat_dyn` enum('DHCP','STATIC') NOT NULL default 'DHCP', `IP` varchar(15) default NULL, `MAC` varchar(17) NOT NULL default '', `network` enum('Hallinto','Asiakas') NOT NULL default 'Hallinto', `name_id` int(11) NOT NULL default '0', `comments` text, PRIMARY KEY (`id`), UNIQUE KEY `name_id` (`name_id`), KEY `ip_idx` (`name_id`) ) TYPE=InnoDB 1 row in set (0.00 sec) Here's what I get: mysql ALTER TABLE ip_name_tbl - ADD CONSTRAINT FOREIGN KEY (name_id) - REFERENCES conn(name_id) - ON DELETE CASCADE; ERROR 1005: Can't create table './koneet/#sql-355_4.frm' (errno: 150) I know error 1005 with an errno 150 means the foreign key would be incorrectly formed, but I can't just figure out what's wrong. I've been reading TFM, and the sentence there must be an index where the foreign key and the referenced key are listed as the first columns seems to have something to do with my problem, I just find the above a bit... well... cryptic. If anyone could lend me a hand, I'd be more than happy. Thank's in advance! Cheers, Markus -- Markus Lervik Linux-administrator Vaasa City Library - Regional Library, Finland [EMAIL PROTECTED] +358-6-325 3589/+358-40-832 6709 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InnoDB foreign key constraints
First of all the referenced key must be on PRIMARY KEY. But I've seen in your table definition a quite strange thing. You have a UNIQUE and an ORDINARY key definition on the same field. Here: ... UNIQUE KEY `name_id` (`name_id`), - THIS IS THE FIRST DEFINITION UNIQUE KEY `comp_name` (`comp_name`), KEY `conn_idx` (`name_id`) - AND THIS IS THE SECOND ONE ... At 10:59 2002.06.10. +0300, you wrote: Hello list! I'm having a bit of trouble getting foreign key constraints to work. I'm running MySQL 2.23.50-Max. Here's what I got: mysql SHOW CREATE TABLE conn\G *** 1. row *** Table: conn Create Table: CREATE TABLE `conn` ( `id` int(10) unsigned NOT NULL auto_increment, `wall_nr` int(10) unsigned NOT NULL default '0', `hub_switch` varchar(20) NOT NULL default '', `comp_name` varchar(80) NOT NULL default '', `name_id` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `name_id` (`name_id`), UNIQUE KEY `comp_name` (`comp_name`), KEY `conn_idx` (`name_id`) ) TYPE=InnoDB 1 row in set (0.00 sec) mysql SHOW CREATE TABLE ip_name_tbl\G *** 1. row *** Table: ip_name_tbl Create Table: CREATE TABLE `ip_name_tbl` ( `id` int(10) unsigned NOT NULL auto_increment, `comp_loc` smallint(5) unsigned NOT NULL default '0', `comp_sub_loc` smallint(5) unsigned NOT NULL default '0', `ip_stat_dyn` enum('DHCP','STATIC') NOT NULL default 'DHCP', `IP` varchar(15) default NULL, `MAC` varchar(17) NOT NULL default '', `network` enum('Hallinto','Asiakas') NOT NULL default 'Hallinto', `name_id` int(11) NOT NULL default '0', `comments` text, PRIMARY KEY (`id`), UNIQUE KEY `name_id` (`name_id`), KEY `ip_idx` (`name_id`) ) TYPE=InnoDB 1 row in set (0.00 sec) Here's what I get: mysql ALTER TABLE ip_name_tbl - ADD CONSTRAINT FOREIGN KEY (name_id) - REFERENCES conn(name_id) - ON DELETE CASCADE; ERROR 1005: Can't create table './koneet/#sql-355_4.frm' (errno: 150) I know error 1005 with an errno 150 means the foreign key would be incorrectly formed, but I can't just figure out what's wrong. I've been reading TFM, and the sentence there must be an index where the foreign key and the referenced key are listed as the first columns seems to have something to do with my problem, I just find the above a bit... well... cryptic. If anyone could lend me a hand, I'd be more than happy. Thank's in advance! Cheers, Markus -- Markus Lervik Linux-administrator Vaasa City Library - Regional Library, Finland [EMAIL PROTECTED] +358-6-325 3589/+358-40-832 6709 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: InnoDB foreign key constraints
Heya! You need an INDEX. Try doing this first : alter table ip_name_tbl add INDEX(name_id); And add then your constraint. EG mysql SHOW CREATE TABLE ip_name_tbl\G *** 1. row *** Table: ip_name_tbl Create Table: CREATE TABLE `ip_name_tbl` ( `id` int(10) unsigned NOT NULL auto_increment, `comp_loc` smallint(5) unsigned NOT NULL default '0', `comp_sub_loc` smallint(5) unsigned NOT NULL default '0', `ip_stat_dyn` enum('DHCP','STATIC') NOT NULL default 'DHCP', `IP` varchar(15) default NULL, `MAC` varchar(17) NOT NULL default '', `network` enum('Hallinto','Asiakas') NOT NULL default 'Hallinto', `name_id` int(11) NOT NULL default '0', `comments` text, PRIMARY KEY (`id`), UNIQUE KEY `name_id` (`name_id`), KEY `ip_idx` (`name_id`) ) TYPE=InnoDB 1 row in set (0.00 sec) Here's what I get: mysql ALTER TABLE ip_name_tbl - ADD CONSTRAINT FOREIGN KEY (name_id) - REFERENCES conn(name_id) - ON DELETE CASCADE; ERROR 1005: Can't create table './koneet/#sql-355_4.frm' (errno: 150) I know error 1005 with an errno 150 means the foreign key would be incorrectly formed, but I can't just figure out what's wrong. I've been reading TFM, and the sentence there must be an index where the foreign key and the referenced key are listed as the first columns seems to have something to do with my problem, I just find the above a bit... well... cryptic. If anyone could lend me a hand, I'd be more than happy. Thank's in advance! Cheers, Markus -- Markus Lervik Linux-administrator Vaasa City Library - Regional Library, Finland [EMAIL PROTECTED] +358-6-325 3589/+358-40-832 6709 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: InnoDB foreign key constraints
On Monday 10 Jun 2002 11:17 am, you wrote: First of all the referenced key must be on PRIMARY KEY. ...which means my 'id' -field can't be a primary key, right? But I've seen in your table definition a quite strange thing. You have a UNIQUE and an ORDINARY key definition on the same field. Here: UNIQUE KEY `name_id` (`name_id`), - THIS IS THE FIRST DEFINITION UNIQUE KEY `comp_name` (`comp_name`), KEY `conn_idx` (`name_id`) - AND THIS IS THE SECOND ONE I've probably messed something up while fooling around with indexes and trying to get it to work. Now, I took the advices I got, but I still can't get it to work. I altered the table to make the 'id' -field an ordinary index, and changed the name_id -field to a primary key, without luck. So now my SHOW CREATE TABLE gives: mysql show create table ip_name_tbl\G *** 1. row *** Table: ip_name_tbl Create Table: CREATE TABLE `ip_name_tbl` ( `id` int(10) unsigned NOT NULL auto_increment, `comp_loc` smallint(5) unsigned NOT NULL default '0', `comp_sub_loc` smallint(5) unsigned NOT NULL default '0', `ip_stat_dyn` enum('DHCP','STATIC') NOT NULL default 'DHCP', `IP` varchar(15) default NULL, `MAC` varchar(17) NOT NULL default '', `network` enum('Hallinto','Asiakas') NOT NULL default 'Hallinto', `name_id` int(11) NOT NULL default '0', `comments` text, PRIMARY KEY (`name_id`), KEY `id` (`id`) ) TYPE=InnoDB ...and mysql show create table conn\G *** 1. row *** Table: conn Create Table: CREATE TABLE `conn` ( `id` int(10) unsigned NOT NULL auto_increment, `wall_nr` int(6) unsigned NOT NULL default '0', `hub_switch` varchar(20) NOT NULL default '', `comp_name` varchar(50) NOT NULL default '', `name_id` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`name_id`), KEY `id` (`id`) ) TYPE=InnoDB and, again: mysql ALTER TABLE ip_name_tbl - ADD CONSTRAINT FOREIGN KEY (name_id) - REFERENCES conn (name_id) - ON DELETE CASCADE; ERROR 1005: Can't create table './koneet/#sql-355_4.frm' (errno: 150) *sigh* Cheers, Markus -- Markus Lervik Linux-administrator Vaasa City Library - Regional Library, Finland [EMAIL PROTECTED] +358-6-325 3589/+358-40-832 6709 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InnoDB foreign key constraints
On Monday 10 Jun 2002 11:44 am, Markus Lervik wrote: mysql show create table ip_name_tbl\G *** 1. row *** Table: ip_name_tbl Create Table: CREATE TABLE `ip_name_tbl` ( [snip] `name_id` int(11) NOT NULL default '0', [snip] mysql show create table conn\G *** 1. row *** Table: conn Create Table: CREATE TABLE `conn` ( [snip] `name_id` int(10) unsigned NOT NULL default '0', [snip] Ok, thank's to Jocelyn the problem is solved and can be seen above. Kinda makes sence that both fields should be the same. : ) Slipped my attention ; ) Cheers, Markus -- Markus Lervik Linux-administrator Vaasa City Library - Regional Library, Finland [EMAIL PROTECTED] +358-6-325 3589/+358-40-832 6709 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 SERVERS
Everyone, Im just curious if possible, I had two MySQL server...one is the replica of the master server. And to make the database in safe and intact even if there's a hang-up. I use auto back-up using the MySQL dump program. But if master server is downed. All I do is redirect my front-end application to point to the slave server. But I done this manually. All I want is to make it transparent to users in changing from server A to server B. is there an easy way to implement this on Windows platform?...I use the Win32 version of MySQL...and all my front-end is also in Win32 environment...is it possible to build a decision maker between the two server?...if master is up then all loads are directed to master but if the master is dead then automatically all loads are carried by the slave...I just wondering if someone can help me to this...and I highly appreciate any ideas... R.B.Roa Traffic Management Engineer PhilCom Corporation Tel. No.(Office) 858-1028 (Home) 858-8889 Mobile No. (63) (919-3085267) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Design
I don't quite understand the distinction you are drawing between an image and an image_attrib. To what real-world concept does image_attrib correspond? I'd suggest that the entities in your system are: Image: with fields such as title and [film type stuff] Comment: with a field for the comment text ImageFile: with a field for the file location, as well as cached info from the file itself, like its size or format I'd set up a one-to-many relationship between images and comments, as well as a one-to-many relationship between images and imagefiles (so that you can provide the same image in many formats and sizes). Where you put pricing information is primarily a matter of pricing policy. If you have one policy for each image regardless of size or format (and the actual price is a combination off this policy and the file they actually choose) then you can just put in the image table, if the policy is entirely dependent on the exact size and format you can put it in the file table, and if it is some combination of the two you can put data in both tables. (And I've tried to come up with some excuse for attempting a many-to-many relationship between images and files, but can't get my head around a really sensible system in which separate files for the same image might be included separately in an entirely different image; I guess you could have a 'low-res' or 'jpeg only' version of the image, but I'd think it would make a lot of sense to indirect the image table through a second 'filter' table which performs the many-to-many than to just store redundant copies of the image entries. Regardless, in this case you might have pricing specific to the particular file, but you can no longer store it in the file table, so now you'd have to relate the image (or this new 'filter' table) through yet another pricing table with its own many-to-one relationship to the file table, and that table would be used as the join table for the many-to-many relationship.) -rob On 9/6/02 at 2:11 pm, Jason Soza [EMAIL PROTECTED] wrote: I think I'm in need of a little bit of database design guidance. I have a website that will be selling photos. I want to store all the information about the photo and any comments about it, and give a list of sizes it's available in, plus a price depending on which price scale the photo falls into, low, medium, or high. So far, I have 3 tables I'm confident in: |images| id MEDIUMINT NOT NULL PRIMARY KEY filename VARCHAR(50) |image_comments| image_id MEDIUMINT NOT NULL PRIMARY KEY comment TEXT |image_attrib| image_id MEDIUMINT NOT NULL PRIMARY KEY title VARCHAR(50) (bunch of film type stuff) price ENUM(L,M,H) NOT NULL Now, my problem is I don't know how to link a photo to a specific set of sizes it's available in (4x6, 5x7, 8x10, etc) AND link those sizes to a particular price scale. Sorry if this is more of a gen DB question instead of MySQL, but I'd appreciate any help. Jason Soza - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
is it worth to wait for version 4.1?
Hi all, I'm implementing a bridge between MySQL and Lotus Domino. In our application we realy need stored procedures (triggers). I saw that MySQL does not yet support stored procedures. (This will be one of the features of version 4.1). Is it worth to wait for version 4.1 or should we switch to some other database management system like postgresql (which does support stored procedures)? We realy would like to use mysql. Because the Lotus Domino bridge work perfectly with mysql, but it does not realy work with PostgreSQL. Any ideas here? Many Thanks, Harm de Laat Informatiefabriek The Netherlands - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: InnoDB foreign key constraints
What I think, is that your syntax for creating the primary key is slightly incorrect. I'm not sure if this is also true vor MySQL but I got teached at school that a foreign key can only point to the primary key of a table. Perhaps you can try to do the following: Create Table: CREATE TABLE `conn` ( `id` int(10) unsigned NOT NULL auto_increment, `wall_nr` int(6) unsigned NOT NULL default '0', `hub_switch` varchar(20) NOT NULL default '', `comp_name` varchar(50) NOT NULL default '', `name_id` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`name_id`), KEY `id` (`id`) ) TYPE=InnoDB CREATE TABLE `ip_name_tbl` ( `id` int(10) unsigned NOT NULL auto_increment, `comp_loc` smallint(5) unsigned NOT NULL default '0', `comp_sub_loc` smallint(5) unsigned NOT NULL default '0', `ip_stat_dyn` enum('DHCP','STATIC') NOT NULL default 'DHCP', `IP` varchar(15) default NULL, `MAC` varchar(17) NOT NULL default '', `network` enum('Hallinto','Asiakas') NOT NULL default 'Hallinto', `name_id` int(11) NOT NULL default '0', `comments` text, PRIMARY KEY (`name_id`), FOREIGN KEY (name_id) REFERENCES conn ON DELETE CASCADES KEY `id` (`id`) ) TYPE=InnoDB; Notice the foreign key already in the table definition, and off course creating table `conn` before the other one. If this doesn't work, try rewriting your foreign key constraint to: ALTER TABLE ip_name_tbl ADD CONSTRAINT FOREIGN KEY (name_id) REFERENCES conn ON DELETE CASCADE; * without pointing to which column the key points, just the table. Btw, why do you have an `id` field, set as NOT NULL and with an auto_increment, with besides another field `name_id` set as primary key? Greetzz, Wouter (being my first msg to this list, btw: hello everybody .. i'm wouter and new to this list ;) hihi ) -- Alle door mij verzonden email is careware. Dit houdt in dat het alleen herlezen en bewaard mag worden als je goed omgaat met al het leven op aarde en daar buiten. Als je het hier niet mee eens bent dien je mijn mailtje binnen 24 uur terug te sturen, met opgaaf van reden van onenigheid. All email sent by me is careware. This means that it can only be reread and kept if you are good for all the life here on earth and beyond. If you don't agree to these terms, you should return this email in no more than 24 hours stating the reason of disagreement. -Oorspronkelijk bericht- Van: Markus Lervik [mailto:[EMAIL PROTECTED]] Verzonden: maandag 10 juni 2002 10:45 Aan: Kiss Dániel CC: [EMAIL PROTECTED] Onderwerp: Re: InnoDB foreign key constraints On Monday 10 Jun 2002 11:17 am, you wrote: First of all the referenced key must be on PRIMARY KEY. ...which means my 'id' -field can't be a primary key, right? But I've seen in your table definition a quite strange thing. You have a UNIQUE and an ORDINARY key definition on the same field. Here: UNIQUE KEY `name_id` (`name_id`), - THIS IS THE FIRST DEFINITION UNIQUE KEY `comp_name` (`comp_name`), KEY `conn_idx` (`name_id`) - AND THIS IS THE SECOND ONE I've probably messed something up while fooling around with indexes and trying to get it to work. Now, I took the advices I got, but I still can't get it to work. I altered the table to make the 'id' -field an ordinary index, and changed the name_id -field to a primary key, without luck. So now my SHOW CREATE TABLE gives: mysql show create table ip_name_tbl\G *** 1. row *** Table: ip_name_tbl Create Table: CREATE TABLE `ip_name_tbl` ( `id` int(10) unsigned NOT NULL auto_increment, `comp_loc` smallint(5) unsigned NOT NULL default '0', `comp_sub_loc` smallint(5) unsigned NOT NULL default '0', `ip_stat_dyn` enum('DHCP','STATIC') NOT NULL default 'DHCP', `IP` varchar(15) default NULL, `MAC` varchar(17) NOT NULL default '', `network` enum('Hallinto','Asiakas') NOT NULL default 'Hallinto', `name_id` int(11) NOT NULL default '0', `comments` text, PRIMARY KEY (`name_id`), KEY `id` (`id`) ) TYPE=InnoDB ...and mysql show create table conn\G *** 1. row *** Table: conn Create Table: CREATE TABLE `conn` ( `id` int(10) unsigned NOT NULL auto_increment, `wall_nr` int(6) unsigned NOT NULL default '0', `hub_switch` varchar(20) NOT NULL default '', `comp_name` varchar(50) NOT NULL default '', `name_id` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`name_id`), KEY `id` (`id`) ) TYPE=InnoDB and, again: mysql ALTER TABLE ip_name_tbl - ADD CONSTRAINT FOREIGN KEY (name_id) - REFERENCES conn (name_id) - ON DELETE CASCADE; ERROR 1005: Can't create table './koneet/#sql-355_4.frm' (errno: 150) *sigh* Cheers, Markus -- Markus Lervik Linux-administrator Vaasa City Library - Regional Library, Finland [EMAIL PROTECTED] +358-6-325 3589/+358-40-832 6709 - Before posting, please check:
how to define my max_connections?
Hello list, I am running mysql-3.23.49 on Linux 2.4.18 for production purpose. Now I want to define a proper max_connections value in mysql. The document said, The maximum number of connects MySQL is depending on how good the thread library is on a given platform. Linux or Solaris should be able to support 500-1000 simultaneous connections, depending on how much RAM you have and what your clients are doing. My question is, how can I raise the max_connections value as many as possible? Does it depend on the hardware resource limit or how the OS implement thread library? -- Patrick Hsieh [EMAIL PROTECTED] GPG public key http://pahud.net/pubkeys/pahudatpahud.gpg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How do I connect to two databases at the same time
Can you help!! I have two databases on one MySql sever and I would like to transfer certain information from one databases to another. I want to transfer, record by record, from a particular table, after examining the record. How can I open the two databases at the same time? The only way I am able to do this is by 1. opening one database - 2. read a record from a particular table - 3. close the database - 4. examine the records - 5. open the other database - 6. save information and close. 7. repeat the process for all the records. I am worried that this may be in efficient. It there another I could do it? Fred Kamwaza - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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.server script does not honor datadir settings
tlack, Saturday, June 08, 2002, 2:19:39 AM, you wrote: Description: t Change datadir in /etc/my.cnf or elsewhere. Start server (i.e., t /usr/local/share/mysql/mysql.server start) and then try to stop it t (/usr/local/share/mysql/mysql.server stop) All worked fine for me. How-To-Repeat: t # joe /etc/my.cnf t Change some settings, especially datadir t # /usr/local/share/mysql/mysql.server start t wait a few seconds.. t # /usr/local/share/mysql/mysql.server stop t No mysqld pid file found. Looked for /var/db/mysql/farmer.pid. Your MySQL server was not started. Check your host_name.err file in MySQL data dir to find causes of failed start. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: RE: Innodb
Weaver, Friday, June 07, 2002, 11:28:41 PM, you wrote: W I believe the autoextend functionality won't be available until 4.0.2. autoextend is only supported since 3.23.50 Anyway it's not available in 4.0.1 W --Walt Weaver W Bozeman, Montana W -Original Message- W From: vlady [mailto:[EMAIL PROTECTED]] W Sent: Friday, June 07, 2002 2:19 PM W To: [EMAIL PROTECTED] W Subject: Innodb autoextended W I am using mysql-4.0.1. I am trying to set up a second innodb datafile. W Following the instructions in the manual I added : W innodb_data_file_path=ibdata1:64M;ibdata2:100M:autoextend W in my my.cnf file, but when I restart the mysql I get the error: W InnoDB: syntax error in innodb_data_file_path W I found that the reason for that is the last field autoextend. W Can some one has had the same problem or somthing is wrong with my W instalation? W Vlady -- 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: little bug
asong, Sunday, June 09, 2002, 5:16:00 PM, you wrote: a I change the max_connections to 200, and I am not sure it works, when I a use mysqladmin to check the variables, I find the value is still displayed a as 100, but trough checking the log file, I am sure the max_connections have a changed to 200, so, is it a bug of mysqladmin? How did you changed max_connections value? Did you started mysqld with -O (--set-variable) option or edited my.cnf file? If you edited my.cnf file have you restarted mysqld? -- 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: suddenly mysql is up and down
System, Sunday, June 09, 2002, 10:24:27 PM, you wrote: SAakaTRotP Since 020606 mysql has been crashing and then I have to manually SAakaTRotP restart. SAakaTRotP The error log is below: SAakaTRotP 020607 00:46:27 mysqld started SAakaTRotP /usr/contrib/libexec/mysqld: ready for connections SAakaTRotP 020607 19:30:58 mysqld restarted SAakaTRotP /usr/contrib/libexec/mysqld: ready for connections SAakaTRotP A mysqld process already exists at Fri Jun 7 19:31:14 MDT 2002 SAakaTRotP A mysqld process already exists at Sat Jun 8 09:00:35 MDT 2002 SAakaTRotP 020608 09:01:30 mysqld started SAakaTRotP /usr/contrib/libexec/mysqld: File './doctor.log' not found (Errcode: 13) SAakaTRotP 020608 9:01:31 Could not use doctor.log for logging (error 0) SAakaTRotP /usr/contrib/libexec/mysqld: ready for connections error 13 means Permission denied. MySQL has no permissions on the doctor.log. -- 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
when will mysql 4.1 be released?
Hi all, I'm implementing a bridge between MySQL and Lotus Domino. In our application we realy need stored procedures (triggers). I saw that MySQL does not yet support stored procedures. (This will be one of the features of version 4.1). Is it worth to wait for version 4.1 or should we switch to some other database management system like postgresql (which does support stored procedures)? We realy would like to use mysql. Because the Lotus Domino bridge work perfectly with mysql, but it does not realy work with PostgreSQL. Any ideas here? Many Thanks, Harm de Laat Informatiefabriek The Netherlands - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
dynamic table width
Hi, I got a table with standard userdata (email, address). I want to be able to provide additional fields (like age, gender etc). Generally I have about 8 standard fields and up to 30 optional fields which may vary. Say something like this: Customer A wants its users to provide email, address and gender. Customer B email, address, age, shopping-preferences. Now Customer A has a million users and Customer B 2 million. And there will be a Customer C..something too :) I wonder what would be the best way to achieve this. I will have to handle a huge number of users in that table. My first guess would be to create a table with 40 columns where most columns are most of the time empty. Does this have an impact on the performance? I cannot predict which customer will use which fields since they should be totally free in their selection. I cannot predict the number of customers either. Is using a single table the best choice? (I know we learned not to do so at university - but hey, this is real life... :) Thanks, Peter magic words: 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
Sql query
What are the main api's available for Mysql? And what is the meaning of API? And can one use VB with mysql? IS API are used for making connection? plz reply __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: when will mysql 4.1 be released?
First of all, let me apologize for repeaditly sending my e-mail message to the list. Roger Baklund wrote: I don't know. Not in the nearest future, they have just begun the coding. Oka I don't get it... does it work perfectly with mysql, or do you realy need stored procedures? And how come you consider postgresql, when it does not realy work with PostgreSQL? First you should decide if it works or not with mysql. If it does not, you can consider if it works with postgresql. If it does not, you can consider if it is worth waiting for 4.1, or if you should consider other products. The word worth implies some kind of economic considerations, it is hard to answer without the knowledge of your economic situation. How important is this application for you? Can you afford to not make the bridge in 6-12 months? Can you work on other projects in the meanwhile? (6-12 months is just me guessing, I feel safer with Not in the nearest future.) IBM (Vendor of Lotus Domino) provides a Lotus Notes module called DECS which purpose is to provide a 'bridge' to relational databases like MySQL, Sybase and Oracle. (This goes via ODBC) This 'bridge' seems to work fine with MySQL (and it's ODBC driver). But it does not work with postgreSQL (and the postges-ODBC driver). This is a known bug (and IBM is working on it). We could use MySQL and imlement stored procedures outselves. (Using some scriptlanguages like perl or python). But this is (ofcourse) a lot of work. If we could use stored procedures in MySQL that would realy help!. So I read that Mysql 4.1 would have stored procedures. But no release date was mentioned. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: dynamic table width
As usual, there are several different approaches, each with different advantages and disadvantages. The simplest approach is just to put all the optional fields in the main table, and each user can decide how many of them they can be bothered to fill in. The disadvantages here are that there is potentially a lot of wasted storage, and adding new optional fields is tough- you've got to change the schema for your main table. If you know exactly which fields each user will use, you can provide each user their own table with its own schema. When that user views the data, you join the main table with their custom table, and when you use whatever user-independent administrative data management tools you've put together you just look at the main table. The disadvantage here is that you're got to create a new table for every user, leaving an 'open' database schema, which is a real maintenance burden. If one particular user comes up with a new optional field, however, you've only got to change their custom table, which in some situations is a major advantage over the previous method (if security is important or the main table is so large that the alter command is a very hefty op you'd like to avoid). I'm not sure this is right for you if you think you'll have more than a handful of users, although there are a great many variations on this theme (one or a small number of 'secondary' tables) that might be appropriate. The most flexible approach is to abandon type safety altogether and use a 'property list' table with 'name' and 'value' fields, along with the primary key of the entry in the main table. Then users can create any set of optional fields they want, and there is no administrative maintenence burden. The disadvantages, of course, are that you'll probably make the field values be 'text' or something, so applying spiffy date or numeric operations to them is not so simple, and that the abundance of JOINs necessary to replicate the original layout, while not necessarily hurting asymptotic complexity, can definitely slow down your database ops. -rob On 10/6/02 at 2:25 pm, Peter Romianowski [EMAIL PROTECTED] wrote: Hi, I got a table with standard userdata (email, address). I want to be able to provide additional fields (like age, gender etc). Generally I have about 8 standard fields and up to 30 optional fields which may vary. Say something like this: Customer A wants its users to provide email, address and gender. Customer B email, address, age, shopping-preferences. Now Customer A has a million users and Customer B 2 million. And there will be a Customer C..something too :) I wonder what would be the best way to achieve this. I will have to handle a huge number of users in that table. My first guess would be to create a table with 40 columns where most columns are most of the time empty. Does this have an impact on the performance? I cannot predict which customer will use which fields since they should be totally free in their selection. I cannot predict the number of customers either. Is using a single table the best choice? (I know we learned not to do so at university - but hey, this is real life... :) Thanks, Peter magic words: 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: Unique Indexes across multiple columns
It looks to me like 'a' is '127-30-127-1' Notice the dashes. I don't believe you are splitting the IP address into 4 separate numbers. Chris Knipe wrote: Hi again, Not to long ago, I had a query regarding the best way to store IP addresses in a DB, and make sure that they are unique. It was pointed out to me that I could use four smallint columns instead of a varchar to store these numbers, and just implement a UNIQUE index across all four columns to make sure the combination of the four columns, would never be in duplicate. It seems, the UNIQUE index however still insist on having unique values for all of the four columns... The DB looks like this (the four smallint columns): NS1_IP1 smallint(5) NS1_IP2 smallint(5) NS1_IP3 smallint(5) NS1_IP4 smallint(5) SQL-query : ALTER TABLE `domains` ADD UNIQUE `NS1_Unique` (`NS1_IP1`,`NS1_IP2`,`NS1_IP3`,`NS1_IP4`) MySQL said: Duplicate entry '127-30-127-1' for key 2 Which, tells me that I can have the following: a, b, c, d - works b, c, d, e - works a, b, c, d - fails a, a, b, b - fails -- This should however not fail... (the combination is unique??) Any idea on how I can get this working?? -- 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: No Warnings after changed data
Hello, I think that my problem boils down to the unimplemented getWarnings() method in the mm. JDBC driver. If it was implemented, I could detect if the data was e.g. truncated. Can anybody help me find an implementation for this method? Thank you again, Charlie Hi. :I'd like to find out how I could convince mysql to generate warnings :whenever the data I want to insert is modified by the server. I believe there's no built-in way of doing that. I keep a checksum of a data stored. And when i want to write to that raw next time I just check the checksum (md5 digest) _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
flow control instruction case value working wrong
Description: i got wrong values from a select statement using a case value when .. then .. else .. end instruction i made a select statement from this two tables corriere | Field | Type| Null | Key | Default | Extra | +---+-+--+-+-++ | ID| tinyint(3) unsigned | | PRI | NULL| auto_increment | | sigla | char(20)| | | || | id | sigla | +++ | 1 | Executive | | 2 | TNT Global Express | | 3 | Borghi | | 4 | DHL| upacco | Field | Type | Null | Key | Default | Extra | +---+---+--+-+-- ---++ | id| mediumint(8) unsigned | | PRI | NULL| auto_increment | | rif_ddt | varchar(20) | YES | | NULL|| | qty | smallint(5) unsigned | | | 0 || | addr_shipp| smallint(5) unsigned | | | 0 || | awb | varchar(20) | YES | | NULL|| | id_corriere | tinyint(3) unsigned | YES | | NULL|| | pack_details | varchar(20) | YES | | NULL|| | data_consegna | date | YES | | NULL|| | status| enum('APERTO','REC','SH-W','SH-C','SH-L') | | | APERTO || | id | rif_ddt | qty | addr_shipp | awb | id_corriere | pack_details | data_consegna | status | ++-+-++--+-+--+- --++ | 12 | gf | 0 | 29 | pacco 12 | 3 | asdf | 2002-06-07| APERTO | | 16 | ddt8| 1 | 9 | pacco 16 | 3 | asdf | 2002-06-10| SH-C | | 17 | NULL| 3 | 24 | pacco 17 | 2 | xyz | NULL | REC| | 18 | NULL| 0 | 33 | pacco 18 | 3 | asdf | NULL | APERTO | | 19 | NULL| 0 | 5 | NULL |NULL | NULL | NULL | APERTO | | 20 | NULL| 4 | 24 | NULL |NULL | NULL | NULL | REC| | 21 | NULL| 1 | 50 | NULL |NULL | NULL | NULL | APERTO | | 22 | ddt8| 4 | 23 | pacco 22 | 3 | pacco 22 | 2002-06-10| SH-C | | 23 | NULL| 0 | 24 | NULL |NULL | NULL | NULL | APERTO | | 24 | NULL| 0 | 24 | NULL |NULL | NULL | NULL | APERTO | this select statement retrives wrong values in field status: SELECT DISTINCT up.id as id,IFNULL(up.awb,'') as awb ,IF(up.id_corriere,c.sigla,'') as corriere ,IFNULL(up.pack_details,'') as pack_details ,up.data_consegna as data_consegna ,(CASE up.status WHEN 'REC' THEN 'CHIUSO' WHEN 'SH-W' THEN 'FERMO' WHEN 'SH-C' THEN 'SPEDITO' WHEN 'SH-L' THEN 'SPEDITO' ELSE up.status END) as status FROM upacco up, corriere c WHERE (c.id = up.id_corriere or up.id_corriere IS NULL) AND (up.rif_ddt='ddt8' OR up.rif_ddt IS NULL) ORDER BY up.rif_ddt,up.id; | id | awb | corriere | pack_details | data_consegna | status | expected value is ++--++--+---+--- -+ | 17 | pacco 17 | TNT Global Express | xyz | NULL | APERTO | - CHIUSO | 18 | pacco 18 | Borghi | asdf | NULL | APERTO | | 19 | || | NULL | APERTO | | 20 | || | NULL | APERTO | - CHIUSO | 21 | || | NULL | APERTO | | 23 | || | NULL | APERTO | | 24 | || | NULL | APERTO | | 16 | pacco 16 | Borghi | asdf | 2002-06-10| APERTO | - SPEDITO | 22 | pacco 22 | Borghi | pacco 22 | 2002-06-10| APERTO | - SPEDITO her i removed the case statement to se what is the real value an it's ok SELECT DISTINCT up.id as id,IFNULL(up.awb,'') as awb ,IF(up.id_corriere,c.sigla,'') as corriere ,IFNULL(up.pack_details,'') as pack_details ,up.data_consegna as data_consegna ,up.status as status FROM upacco up, corriere c WHERE (c.id = up.id_corriere or up.id_corriere IS NULL) AND (up.rif_ddt='ddt8' OR up.rif_ddt IS NULL) ORDER BY up.rif_ddt,up.id; | id | awb | corriere | pack_details | data_consegna | status |
mysql problem
Hi! I am new to mysql and this is my problem. The daemon runs well but I can start it only with --skip-grant-tables option, otherwise nothing will work. I set the password for the root user but when I exit the Mysql monitor and try to get in again, no password is request. When I set the password I entered flush privileges, but it returns 0 rows affected, if I try with mysqladmin it returns You have no privileges. Please, help me... I am almost out of mind for this! Simona - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: when will mysql 4.1 be released?
Errata: We could use MySQL and imlement stored procedures outselves. (Using some scriptlanguages like perl or python). A stored procedure is by definition a collection of SQL statement stored and executed in the RDBMS, not an external script, etc. //Anders - 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
replication question
hello, can someone please explain why it is not possible to do the replication between e.g. linux and bsd systems ? why wouldnt it be possible to exchange data in system-independent fashion ? i have set up replication between mysql running on win2k, but am unable to do that with linuxw2k nor linuxopenbsd combination. i would like to see technical explanation, not just 'filesystem difference' best regards, terry - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: replication question
I am replicating to NT Server system from Red Hat Linux was not aware of any issues to win2k from linux with replication Is there something I am not aware of? -Original Message- From: Bartomiej Dolata [mailto:[EMAIL PROTECTED]] Sent: Monday, June 10, 2002 9:44 AM To: Mysql@Lists. Mysql. Com Subject: replication question hello, can someone please explain why it is not possible to do the replication between e.g. linux and bsd systems ? why wouldnt it be possible to exchange data in system-independent fashion ? i have set up replication between mysql running on win2k, but am unable to do that with linuxw2k nor linuxopenbsd combination. i would like to see technical explanation, not just 'filesystem difference' best regards, terry - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 problem
What happend when you ran scripts/mysql_install_db ? Also when you run the databases with --skip-grant-tables as soon as you grant a user acess and flush privileges it will then use the grant tables (I think).. Simon -Original Message- From: Simona D'Ambrosio [mailto:[EMAIL PROTECTED]] Sent: 10 June 2002 14:32 To: [EMAIL PROTECTED] Subject: mysql problem Hi! I am new to mysql and this is my problem. The daemon runs well but I can start it only with --skip-grant-tables option, otherwise nothing will work. I set the password for the root user but when I exit the Mysql monitor and try to get in again, no password is request. When I set the password I entered flush privileges, but it returns 0 rows affected, if I try with mysqladmin it returns You have no privileges. Please, help me... I am almost out of mind for this! Simona - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: FW: RE: support UTF-8
Mehdi, Saturday, June 08, 2002, 8:33:29 PM, you wrote: MZ Egor, MZ Could you let me know when 4.1 will be release ? MZ I'm building a website and want to decide whether I can use mySQL MZ instead of SQL Server or not? MZ The most important factor is support of Unicode. I don't know exactly the date of release 4.1, but the alpha will come till this year end. MZ I also want to know if I can convert an access database or SQL Server MZ 2000 database to mySQL. Yes, you can. If you use Access you can do it: 1. Export file in the CVS format. Then you should create schema for each table in MySQL. The order of columns in the table is IMPORTANT. In case of wrong column ordering you can't import your data. And after that put your database into MySQL. To import you can use mysqlimport utility or LOAD DATA INFILE statement. 2. Use different administration packages. You can find URL if you check archives ... MZ Sincerely, MZ Mehdi Zare -- 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: How do I connect to two databases at the same time
Fred, Monday, June 10, 2002, 2:22:25 PM, you wrote: FK I have two databases on one MySql sever and I would like to transfer FK certain information from one databases to another. I want to transfer, FK record by record, from a particular table, after examining the record. How FK can I open the two databases at the same time? FK The only way I am able to do this is by FK 1. opening one database - FK 2. read a record from a particular table - FK 3. close the database - FK 4. examine the records - FK 5. open the other database - FK 6. save information and close. FK 7. repeat the process for all the records. FK I am worried that this may be in efficient. It there another I could do it? You can specify database name in SQL statement, f.e. INSERT database1.table1 SELECT * FROM database2.table2 WHERE ... ; It will work if your databases are located on the same MySQL server (in one MySQL data dir). FK Fred Kamwaza -- 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: mysqld --flush
Ritu, Friday, June 07, 2002, 8:11:34 AM, you wrote: RS Starting mysqld with --flush, flushes tables to database or disk RS log?? If you start mysqld with --flush option all your changes will be written on the disk immediately. So, --flush will make less probable that data will lost on crashes, but it will slow down all things. RS Thanx in advance, RS Ritu Singla -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql problem
Simona, Monday, June 10, 2002, 4:31:33 PM, you wrote: SDA Hi! I am new to mysql and this is my problem. SDA The daemon runs well but I can start it only with --skip-grant-tables SDA option, otherwise nothing will work. SDA I set the password for the root user but when I exit the Mysql monitor and SDA try to get in again, no password is request. SDA When I set the password I entered flush privileges, but it returns 0 rows SDA affected, if I try with mysqladmin it returns You have no SDA privileges. SDA Please, help me... I am almost out of mind for this! Simona, you provided incomplete info! Please, show full error messages, full connection string and commands. SDA Simona -- 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: replication question
hello, I am replicating to NT Server system from Red Hat Linux was not aware of any issues to win2k from linux with replication Is there something I am not aware of? i dont know, but i am having major problems with it. i keep getting Slave: Failed reading log event, reconnecting to retry, log 'FIRST' position ... whats strange is that master.info has no remote logfile name in it. i cant think of any reason why my setup of replication between w2k and w2k would be different from one i am trying to setup between linux (slave) and w2k (master) maybe my mysql rpm is broken ? ... regards, terry - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
45 seconds
i have a table and 51000 records in it. it has got an index on HOST_NAME field. next query lasts 45 seconds to execute... is it normal ? server is PIII 500 double cpu SELECT b.ip as ip, b.country , b.hostname , a.HOST_NAME as host, COUNT(a.HOST_NAME) as number FROM new_raw_log as a, dns as b WHERE (a.HOST_NAME regexp rtrim(b.ip)+'%') AND a.GID=44 AND a.SID=12 GROUP BY a.HOST_NAME ORDER BY number DESC LIMIT 0,20 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Timezone question
Hello, I am using the now() function to insert the current timestamp in a mysql table. My problem is that the server is using EST while I would like the time to reflect PST. Can this be done? Thanks. --Kevin [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
Foreign keys in query optimization
I studied the MySQL and InnoDB manual, but I did not find anything about the internal usage of foreign keys. I mean that I would like to know if foreign keys are used for query optimizations or functions like that. Because I think foreign keys should be used not only for keeping the data integrity of the DB. Thanks, Daniel Kiss - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 do I connect to two databases at the same time
Thanks for your reply. I am actually using PHP and I tried what you suggested. $link1 = mysql_connect(server1.com, www, pass) or die(could ...); $link2 = mysql_connect(server1.com, www, pass) or die(could ...); there is no error but it is not working. Please not that I am using the same server. Fred Kamwaza. I don´t know what API or languaje are you usin, but i think in c, perl, php you should open two conection with two diferent names $link=mysql_connect(192.168.1.11, www, pass) or die (Could not connect); $link2=mysql_connect(192.168.1.10, www, pass) or die (Could not connect); and work with the pointers all time I think it should work -Mensaje original- De: Fred Kamwaza [mailto:[EMAIL PROTECTED]] Enviado el: lunes, 10 de junio de 2002 13:22 Para: [EMAIL PROTECTED] Asunto: How do I connect to two databases at the same time Can you help!! I have two databases on one MySql sever and I would like to transfer certain information from one databases to another. I want to transfer, record by record, from a particular table, after examining the record. How can I open the two databases at the same time? The only way I am able to do this is by 1. opening one database - 2. read a record from a particular table - 3. close the database - 4. examine the records - 5. open the other database - 6. save information and close. 7. repeat the process for all the records. I am worried that this may be in efficient. It there another I could do it? Fred Kamwaza - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Rotating mysqld.log
Hi All, I have a RH-7.2 server running mysql 3.23.41-1. I need to rotate the mysqld.log based on some size criteria. I have a config file as follows : mysqlrotparams.conf *** /var/log/mysqld.log { rotate 5 size=100k missingok create 0644 mysql mysql } I have configured a cron entry to execute this every one minute as follows. */1 * * * * /usr/sbin/logrotate -v mysqlrotparams.conf I increased the size of mysqld.log to 1200k but rotation didn't happen. The following was the output reading config file /root/mysqlrotparams.conf reading config info for /var/log/mysqld.log Handling 1 logs rotating pattern: /var/log/mysqld.log 102400 bytes (5 rotations) empty log files are rotated old logs mailed to [EMAIL PROTECTED] rotating file /var/log/mysqld.log log does not need rotating Can anyone help me in this regard ??? Thanks in advance. Regards Rams -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: replication question
Are you positive that you are running compatible versions of MySql on both platforms? - Original Message - From: Terry [EMAIL PROTECTED] To: Luc Foisy [EMAIL PROTECTED]; MYSQL-List (E-mail) [EMAIL PROTECTED] Sent: Monday, June 10, 2002 9:59 AM Subject: RE: replication question | hello, | | I am replicating to NT Server system from Red Hat Linux | was not aware of any issues to win2k from linux with replication | | Is there something I am not aware of? | | i dont know, but i am having major problems with it. | i keep getting Slave: Failed reading log event, reconnecting to retry, | log 'FIRST' position ... | | whats strange is that master.info has no remote logfile name in it. | | i cant think of any reason why my setup of replication between w2k and | w2k | would be different from one i am trying to setup between linux (slave) | and w2k (master) | | maybe my mysql rpm is broken ? ... | | regards, | terry | | | | - | Before posting, please check: |http://www.mysql.com/manual.php (the manual) |http://lists.mysql.com/ (the list archive) | | 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: replication question
Subject: Re: replication question Are you positive that you are running compatible versions of MySql on both platforms? linux: mysql rebuild from source rpm: /usr/sbin/mysqld, Version: 3.23.49-log, started with: Tcp port: 3306 Unix socket: /tmp/mysql.sock openbsd: mysql build from sources: /opt/mysql/libexec/mysqld, Version: 3.23.49-log, started with: Tcp port: 3306 Unix socket: /tmp/mysql.sock 2 win2k machines: mysql installed by installer: MySql, Version: 3.23.49-max-debug-log, started with: Tcp port: 3306 Unix socket: /tmp/mysql.sock best regards, terry - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Foreign keys in query optimization
Kiss Dániel wrote: I studied the MySQL and InnoDB manual, but I did not find anything about the internal usage of foreign keys. MySQL does not support foreign keys at the moment. This will be implemented in version 4.1. For more info see: http://www.mysql.com/products/mysql-4.0/index.html Cheers, Harm de Laat Informatiefabriek The Netherlands - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: 45 seconds
Check that your fields are indexed. This usually fixes it. George - Original Message - From: Elsad YUSIFLI [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 10, 2002 3:10 PM Subject: 45 seconds i have a table and 51000 records in it. it has got an index on HOST_NAME field. next query lasts 45 seconds to execute... is it normal ? server is PIII 500 double cpu SELECT b.ip as ip, b.country , b.hostname , a.HOST_NAME as host, COUNT(a.HOST_NAME) as number FROM new_raw_log as a, dns as b WHERE (a.HOST_NAME regexp rtrim(b.ip)+'%') AND a.GID=44 AND a.SID=12 GROUP BY a.HOST_NAME ORDER BY number DESC LIMIT 0,20 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Foreign keys in query optimization
If you create in index on your FK then it will be used to optimize the query. =C= * * Cal Evans * Techno-Mage * http://www.calevans.com * - Original Message - From: Kiss Dániel [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 10, 2002 9:19 AM Subject: Foreign keys in query optimization I studied the MySQL and InnoDB manual, but I did not find anything about the internal usage of foreign keys. I mean that I would like to know if foreign keys are used for query optimizations or functions like that. Because I think foreign keys should be used not only for keeping the data integrity of the DB. Thanks, Daniel Kiss - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 do I connect to two databases at the same time
Both of the connections shown below are for the same database server. If both dbs are on the same server you only need one connection, but then you need to use mysql_select_db($database_name,$link1) for each database. Andrew Hazen -Original Message- From: Fred Kamwaza [mailto:[EMAIL PROTECTED]] Sent: Monday, June 10, 2002 10:21 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: How do I connect to two databases at the same time Thanks for your reply. I am actually using PHP and I tried what you suggested. $link1 = mysql_connect(server1.com, www, pass) or die(could ...); $link2 = mysql_connect(server1.com, www, pass) or die(could ...); there is no error but it is not working. Please not that I am using the same server. Fred Kamwaza. I don´t know what API or languaje are you usin, but i think in c, perl, php you should open two conection with two diferent names $link=mysql_connect(192.168.1.11, www, pass) or die (Could not connect); $link2=mysql_connect(192.168.1.10, www, pass) or die (Could not connect); and work with the pointers all time I think it should work -Mensaje original- De: Fred Kamwaza [mailto:[EMAIL PROTECTED]] Enviado el: lunes, 10 de junio de 2002 13:22 Para: [EMAIL PROTECTED] Asunto: How do I connect to two databases at the same time Can you help!! I have two databases on one MySql sever and I would like to transfer certain information from one databases to another. I want to transfer, record by record, from a particular table, after examining the record. How can I open the two databases at the same time? The only way I am able to do this is by 1. opening one database - 2. read a record from a particular table - 3. close the database - 4. examine the records - 5. open the other database - 6. save information and close. 7. repeat the process for all the records. I am worried that this may be in efficient. It there another I could do it? Fred Kamwaza - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Rotating mysqld.log
You need to get logrotate to flush-logs otherwise mysql will still write to the old file. eg add after the create 0644 mysql mysql line: postrotate if test -n `ps acx | grep mysql`;then /path/to/mysqladmin -u logflusher -ppassword flush-logs fi endscript Assuming a mysql users called logflusher with password password has the flush privilege. Greg -Original Message- From: Ramasubramanian [mailto:[EMAIL PROTECTED]] Hi All, I have a RH-7.2 server running mysql 3.23.41-1. I need to rotate the mysqld.log based on some size criteria. I have a config file as follows : mysqlrotparams.conf *** /var/log/mysqld.log { rotate 5 size=100k missingok create 0644 mysql mysql } I have configured a cron entry to execute this every one minute as follows. */1 * * * * /usr/sbin/logrotate -v mysqlrotparams.conf I increased the size of mysqld.log to 1200k but rotation didn't happen. The following was the output reading config file /root/mysqlrotparams.conf reading config info for /var/log/mysqld.log Handling 1 logs rotating pattern: /var/log/mysqld.log 102400 bytes (5 rotations) empty log files are rotated old logs mailed to [EMAIL PROTECTED] rotating file /var/log/mysqld.log log does not need rotating Can anyone help me in this regard ??? Thanks in advance. Regards Rams -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php 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: Foreign keys in query optimization
InnoDB supports foreign keys. And, an index must be created on the foreign key; this would help from an optimization point of view. --Walt Weaver Bozeman, Montana -Original Message- From: harm de laat [mailto:[EMAIL PROTECTED]] Sent: Monday, June 10, 2002 8:43 AM To: Kiss Dániel Cc: [EMAIL PROTECTED] Subject: Re: Foreign keys in query optimization Kiss Dániel wrote: I studied the MySQL and InnoDB manual, but I did not find anything about the internal usage of foreign keys. MySQL does not support foreign keys at the moment. This will be implemented in version 4.1. For more info see: http://www.mysql.com/products/mysql-4.0/index.html Cheers, Harm de Laat Informatiefabriek The Netherlands - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 problem
Now it works!!! My problem was that I didn't know that if I set up passwords for users I had to tell it to the web pages where I connect to the database (postgres doesn't work like that). I know this is stupid, but I began my message with I am new to mysql :-) Anyway thank you for your replies. Simona What happend when you ran scripts/mysql_install_db ? Also when you run the databases with --skip-grant-tables as soon as you grant a user acess and flush privileges it will then use the grant tables (I think).. Simon -Original Message- From: Simona D'Ambrosio [mailto:[EMAIL PROTECTED]] Sent: 10 June 2002 14:32 To: [EMAIL PROTECTED] Subject: mysql problem Hi! I am new to mysql and this is my problem. The daemon runs well but I can start it only with --skip-grant-tables option, otherwise nothing will work. I set the password for the root user but when I exit the Mysql monitor and try to get in again, no password is request. When I set the password I entered flush privileges, but it returns 0 rows affected, if I try with mysqladmin it returns You have no privileges. Please, help me... I am almost out of mind for this! Simona - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: No Warnings after changed data
- Original Message - From: Charlie Thunderberg [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 10, 2002 8:23 AM Subject: RE: No Warnings after changed data Hello, I think that my problem boils down to the unimplemented getWarnings() method in the mm. JDBC driver. If it was implemented, I could detect if the data was e.g. truncated. Can anybody help me find an implementation for this method? The reason that it's not implemented in the JDBC driver, is that MySQL issues warnings on every single query, except it's called Extra Info, and it's not always a warning. The overhead in parsing these messages (which happen to be different depending on the locale installed, complicating matters even further), has not been asked for by users of the driver, yet. In any case, what the server returns in the case of a real warning will not give you _any_ diagnostics on a warning, just that something happened (e.g. see http://www.mysql.com/doc/I/N/INSERT.html at the bottom of the page), so it's not helpful in diagnosing that data has changed. The protocol for MySQL 4.1 will have a way to retrieve only warnings, and hopefully a more descriptive warning message implementation. -Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: 45 seconds
Hello, The reason that it takes so long is because you are using regexp on a function to join the table. That means that MySQL can't use indexes for that column. If you run an EXPLAIN on the query you will see that is true. To speed up the query some you could add an index on new_raw_log(GID,SID). That will at least allow some filtering using an index and might give some speed up, depending on how many matching results there are. The ideal case would be redesign your database to be able to join the tables using some other mechanism than a regular expression statement which MySQL will then be able to use indexes to join on. Harrison Elsad YUSIFLI wrote: i have a table and 51000 records in it. it has got an index on HOST_NAME field. next query lasts 45 seconds to execute... is it normal ? server is PIII 500 double cpu SELECT b.ip as ip, b.country , b.hostname , a.HOST_NAME as host, COUNT(a.HOST_NAME) as number FROM new_raw_log as a, dns as b WHERE (a.HOST_NAME regexp rtrim(b.ip)+'%') AND a.GID=44 AND a.SID=12 GROUP BY a.HOST_NAME ORDER BY number DESC LIMIT 0,20 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Foreign keys in query optimization
Kiss, Monday, June 10, 2002, 5:19:17 PM, you wrote: KD I studied the MySQL and InnoDB manual, but I did not find anything about KD the internal usage of foreign keys. KD I mean that I would like to know if foreign keys are used for query KD optimizations or functions like that. KD Because I think foreign keys should be used not only for keeping the data KD integrity of the DB. Yes, you are right. Foreign keys implement constraints or referential integrity. But you can create foreign key only on indexed column. KD Thanks, KD Daniel Kiss -- 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: Timezone question
Kevin, Monday, June 10, 2002, 5:20:00 PM, you wrote: K I am using the now() function to insert the current timestamp in a mysql K table. K My problem is that the server is using EST while I would like the time to K reflect PST. K Can this be done? K Thanks. It depends on what OS do you use. If you use *nix, it's possible. Run mysqld with --timezone option. If you use Windows you can only set up environment variable. K --Kevin K [EMAIL PROTECTED] -- 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: GRANTs and %
In the last episode (Jun 10), Kaan Oglakci said: Hi, For some reason when I try to set up grants for a database by typing this GRANT ALL ON newstesting.* to clients@% IDENTIFIED BY 'pass'; I get this error ERROR 1064: You have an error in your SQL syntax near '% IDENTIFIED BY 'pass'' a t line 1 Try quoting the %: '%' In fact, to be safe, I always quote the username and the hostname: 'clients'@'%' -- 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: Not using indexes???
E.g. the non-equivalence operator is the same. MySQL will use indexes for foo0, but not foo0, which ask for the same result (presumed foo is an unsigned column). Perhaps I was a bit unclear... Using foo 0 does *NOT* use an index. Using foo 0 AND foo somevalue *DOES* use an index. As Erv did not know why this could help: It uses a different operator than IS NOT NULL, namely greather-than. One, that MySQL supports to make use of indexes. Again, merely using greater than by itself produces results identical to using IS NOT NULL. -JF - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: 45 seconds
I have multiple tables on a 166MMX with 64MB ram, all containing more than 250,000 records each Mine takes less than 5 seconds I think there's something wrong at your side :-) Kind Regards, Chris Knipe MegaLAN Corporate Networking Services Tel: +27 21 854 7064 Cell: +27 72 434 7582 - Original Message - From: Elsad YUSIFLI [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 10, 2002 4:10 PM Subject: 45 seconds i have a table and 51000 records in it. it has got an index on HOST_NAME field. next query lasts 45 seconds to execute... is it normal ? server is PIII 500 double cpu SELECT b.ip as ip, b.country , b.hostname , a.HOST_NAME as host, COUNT(a.HOST_NAME) as number FROM new_raw_log as a, dns as b WHERE (a.HOST_NAME regexp rtrim(b.ip)+'%') AND a.GID=44 AND a.SID=12 GROUP BY a.HOST_NAME ORDER BY number DESC LIMIT 0,20 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: 45 seconds
Try using LIKE instead of regexp and create index on HOST_NAME if not present. Nilesh -Original Message- From: Chris Knipe [mailto:[EMAIL PROTECTED]] Sent: Monday, June 10, 2002 1:24 PM To: Elsad YUSIFLI; [EMAIL PROTECTED] Subject: Re: 45 seconds I have multiple tables on a 166MMX with 64MB ram, all containing more than 250,000 records each Mine takes less than 5 seconds I think there's something wrong at your side :-) Kind Regards, Chris Knipe MegaLAN Corporate Networking Services Tel: +27 21 854 7064 Cell: +27 72 434 7582 - Original Message - From: Elsad YUSIFLI [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 10, 2002 4:10 PM Subject: 45 seconds i have a table and 51000 records in it. it has got an index on HOST_NAME field. next query lasts 45 seconds to execute... is it normal ? server is PIII 500 double cpu SELECT b.ip as ip, b.country , b.hostname , a.HOST_NAME as host, COUNT(a.HOST_NAME) as number FROM new_raw_log as a, dns as b WHERE (a.HOST_NAME regexp rtrim(b.ip)+'%') AND a.GID=44 AND a.SID=12 GROUP BY a.HOST_NAME ORDER BY number DESC LIMIT 0,20 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Cannot use mysql as
Hi, I have just installed and run my mysql server as the root user. I have entered the MYSQL minitor. WHen I typed 'use mysql', I got the message-- Error 1044: Access denied fro user: 'root@localhost' to database mysql'. Same error message appeared when I tried to grant all on mysql to root user, or when I tried to create a new databse. Could anybody help out of this problem? Thank you very much! DUo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
php+mysql+multiple lines qry
hello . i use php 4.12 + mysql 3.23.49 on linux . i've developed a online testing(quiz) -aplication that now is expected to behave somehow different from what i've had in mind at the begining . More exactly : i have 3 tables (MyIsam): 1. tests (id,name,desc) 2. questions (id,id_test_fk,desc) 3. answer(id,id_q_fk,desc,points) . i want to copy a question from one test to another . If i knew that from the start , i would have designed the tables differntly , but that's another problem . the point is i'm trying to do a 'quick_and_dirty' patch like this : -- set @test_id=$test_target; set @q_id=$qid; create temporary table q_temp as select * from questions; create temporary table ans_temp as select * from answers; insert into questions select '',@test_id,t2.q_type,t2.description,t2.dimension,t2.combination,t2.checkit from q_temp as t2 where id=@q_id; select @last:=LAST_INSERT_ID(); insert into answers select '',@last,score,description from ans_temp where id_question_fk=@q_id; -- where $test_target and $qid are given from php . my problem is that this query works and dows what is expected when run from mysql , but NOT from php . No error , nada . I even tryed to do dirty thing (shell_exec('mysql -u user -p password database /tmp/qry.txt')) where qry.txt was generated by php (containing the above code) but NO luck . could you please give a suggestion or ..smth ? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: when will mysql 4.1 be released?
I guess it's a question of semantics, but I would consider a stored procedure, in general, any series of commands to be executed 'in' the database engine. Postgres, for instance, allows stored procedures to be written in a number of different languages. Commercial engines have similar capabilities. I would think that a stored procedure would not be required to do much of anything with SQL. SQL would simply be a way of invoking it. Cheers. -Dana -Original Message- From: Svensson, B.A.T. (HKG) [SMTP:[EMAIL PROTECTED]] Sent: Monday, June 10, 2002 8:40 AM To: [EMAIL PROTECTED] Subject: RE: when will mysql 4.1 be released? Errata: We could use MySQL and imlement stored procedures outselves. (Using some scriptlanguages like perl or python). A stored procedure is by definition a collection of SQL statement stored and executed in the RDBMS, not an external script, etc. //Anders - 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 ** Notice: The area code for the Wal-Mart Bentonville General Office in the US has changed from 501 to 479. Please make sure that you are dialing 479 when making calls to any General Office location. ** This email and any files transmitted with it are confidential and intended solely for the individual or entity to whom they are addressed. If you have received this email in error destroy it immediately. ** Wal-Mart Stores, Inc. Confidential ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem with MyCC download from the mirror site.
Hi All, I wish to download MyCC from mysql official site and i try allmost all the mirroring site.The message is the next: You are downloading: mycc-0.8.3-src.tar.gz There was an error with the mirror site you selected. Please choose another mirror. My question is: from where i can download the mycc-0.8.3-src.tar.gz ? Thanks, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
license...
I'm developing a program, that is not free software and i'm using mysql with myodbc. The question is if i need a license or not... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: license...
[snip] I'm developing a program, that is not free software and i'm using mysql with myodbc. The question is if i need a license or not... [/snip] According to this http://www.mysql.com/support/arrangements.html yes.. HTH! Jay - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: license...
[snip] But my program not use only mysql (able to oracle, paradox and MS Sql Server), However, do i need license? I'm developing a program, that is not free software and i'm using mysql with myodbc. The question is if i need a license or not... According to this http://www.mysql.com/support/arrangements.html [/snip] If you do not ship MySQL with the application, then no. HTH! Jay mysql, 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
Indexing on a DATE field/bizarre speed issue with a LEFT JOIN?
Hi List, I sure do appreciate this list. I'm stumped on the following query: SELECT head.po FROM head LEFT JOIN line ON (head.sn=line.snHead) WHERE head.po 1 AND line.dateETA='2002-06-10' LIMIT 50 As is, this query is very fast (0.01 seconds when there are 25,000 records in 'head', and 50,000 records in 'line'). However, when I change the query to search on line.dateETA = or even = [somedate], the query takes a long time to return (2-3 seconds). The line.dateETA field is indexed. And, for both = and = queries, EXPLAIN returns the same information. The only thing I can think of is that NULL values are allowed in line.dateETA, and about half the values are NULL (22,000 lines). However, I tested changing the line.dateETA field to NOT NULL, and I didn't get any better performance. Is there a known speed issue in searching on date fields with = versus =? Thanks, Matt - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: php+mysql+multiple lines qry
Why not just use something like: insert into questions (field1,field2,...) select... You don't need to create temp tables for your data and all the other complicated stuff. hello . i use php 4.12 + mysql 3.23.49 on linux . i've developed a online testing(quiz) -aplication that now is expected to behave somehow different from what i've had in mind at the begining . More exactly : i have 3 tables (MyIsam): 1. tests (id,name,desc) 2. questions (id,id_test_fk,desc) 3. answer(id,id_q_fk,desc,points) . i want to copy a question from one test to another . If i knew that from the start , i would have designed the tables differntly , but that's another problem . the point is i'm trying to do a 'quick_and_dirty' patch like this : -- set @test_id=$test_target; set @q_id=$qid; create temporary table q_temp as select * from questions; create temporary table ans_temp as select * from answers; insert into questions select '',@test_id,t2.q_type,t2.description,t2.dimension,t2.combination,t2.checkit from q_temp as t2 where id=@q_id; select @last:=LAST_INSERT_ID(); insert into answers select '',@last,score,description from ans_temp where id_question_fk=@q_id; -- where $test_target and $qid are given from php . my problem is that this query works and dows what is expected when run from mysql , but NOT from php . No error , nada . I even tryed to do dirty thing (shell_exec('mysql -u user -p password database /tmp/qry.txt')) where qry.txt was generated by php (containing the above code) but NO luck . could you please give a suggestion or ..smth ? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- 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
I have a problem....
We are running mysql on a red hat box. We replicate a single database twice, once on another red hat box(thank whatever is holy), once on a winnt box. The winnt box cares not for case sensitivity, so it created all our table names in lower case ( our standard is to use CAPS for tablenames ) ( i knew this was an issue, but I forgot about it when i got a new toy to play with: the nt server ) Now, I did a dump to a development red hat box, and it created all the tables in lower case ( which is useless since our application is geared to the uppercase table names ) Does anyone have a solution or work around for this ? I briefly considered creating a script for the linux box to rename the files but thought I should ask if there was any other way to do this... Luc - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Indexing on a DATE field/bizarre speed issue with a LEFT JOIN?
Sorry for the long reply: At 02:57 PM 6/10/2002 -0500, you wrote: [snip] SELECT head.po FROM head LEFT JOIN line ON (head.sn=line.snHead) WHERE head.po 1 AND line.dateETA='2002-06-10' LIMIT 50 As is, this query is very fast (0.01 seconds when there are 25,000 records in 'head', and 50,000 records in 'line'). However, when I change the query to search on line.dateETA = or even = [somedate], the query takes a long time to return (2-3 seconds). The line.dateETA field is indexed. And, for both = and = queries, EXPLAIN returns the same information. [/snip] Since head.po is the return item here, indexing it will speed up the query. HTH! Jay sql, mysql, query head.po is already indexed (as are head.sn and line.snHead), but I'm not so sure that indexing the other fields is the issue since the query is very fast in the = case. Thanks, Matt - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Installation problem
Hi I am pretty new to linux and I was trying to setup and use mysql, I followed the directions you provided about compiling it and installing it, but when I try to start the server the mysql daemon fail right away : saying mysqld ended. I looked at the error log and this is what it says : /usr/local/mysql/bin/mysqld: Can't find file : './mysql/host.frm' (errno : 13). Now the file host.frm is in the directory /var/lib/mysql/mysql/host.frm, I was gonna put this somewhere in the msqld file but it is not in human readeable form. Thank you. John - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Compare 2 resultsets from 1 table
Hi, I'd like to do the following in mysql: I have a table with field1 and field2. Both fields are not unique. Field2 can have the value of 0 or 1. I'd like to join the results of these two queries: query 1: select field1, count(field2) as total from table1 group by field1 query 2: select field1, count(field2) as sub from table1 where field2=1 group by field1 Now I'd like to output the result into 1 set where I get 3 columns: field1, total, sub. so it would look something like this: field1 | total | sub -+-+ AAA | 200 | 93 BBB| 143 | 22 CCC| 344 | (NULL) - There are NO field2=1 where field1=CCC DDD | 287 | 38 etc. How can I do this? Thanks, Danny - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Installation problem
Mysql does not own the database and its tables; chown -R mysql /usr/local/mysql/var ( or whatever the database location is. ) Kariuki, JohnX K wrote: Hi I am pretty new to linux and I was trying to setup and use mysql, I followed the directions you provided about compiling it and installing it, but when I try to start the server the mysql daemon fail right away : saying mysqld ended. I looked at the error log and this is what it says : /usr/local/mysql/bin/mysqld: Can't find file : './mysql/host.frm' (errno : 13). Now the file host.frm is in the directory /var/lib/mysql/mysql/host.frm, I was gonna put this somewhere in the msqld file but it is not in human readeable form. Thank you. John - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Delphi Mysql
What is the best way to connect with Delphi 5/6 to Mysql? Johan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Delphi Mysql
ASTA at www.astatech.com M:) What is the best way to connect with Delphi 5/6 to Mysql? Johan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: support UTF-8
You may find the Access conversion easier to do using MysqlFront, downloadable at www.mysqlfront.de. - Original Message - From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 10, 2002 8:08 AM Subject: Re: FW: RE: support UTF-8 Mehdi, Saturday, June 08, 2002, 8:33:29 PM, you wrote: MZ I also want to know if I can convert an access database or SQL Server MZ 2000 database to mySQL. Yes, you can. If you use Access you can do it: 1. Export file in the CVS format. Then you should create schema for each table in MySQL. The order of columns in the table is IMPORTANT. In case of wrong column ordering you can't import your data. And after that put your database into MySQL. To import you can use mysqlimport utility or LOAD DATA INFILE statement. 2. Use different administration packages. You can find URL if you check archives ... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 price
Subject: MySQl price From: Peder Hanghøj [EMAIL PROTECTED] === I will make a delphi-program that uses MySQL. I want to sell the program, do I have to pay each time I sell a program? Do I have to pay for MySQL? Thanks Peder - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Timezone question
Yes. MySQL attempts to get the current time zone from the OS, but this can be overridden by setting the TZ variable. (The manual suggests doing this in the safe_mysqld script; there's already code in there for setting it from a command line argument.) Valid settings of TZ are technically not time zones but rather time locales, which on linux at least correspond to paths relative to /usr/share/zoneinfo, such as America/Los_Angeles or US/Pacific. Note, however, that this causes problems since most locales actually refer to two time zones- one daylight and one standard- so MySQL will sneakily change time zones behind your back without telling you. If this will cause you problems I suggest staying away from these nefarious locales and using one of the single-zone locales in Etc/, such as Etc/GMT-8. -rob On 10/6/02 at 7:20 am, Kevin [EMAIL PROTECTED] wrote: Hello, I am using the now() function to insert the current timestamp in a mysql table. My problem is that the server is using EST while I would like the time to reflect PST. Can this be done? Thanks. --Kevin [EMAIL PROTECTED] Can be done on the fly as part of a query? Thanks. --Kevin [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL AB: Need documentation clarification
MySQL AB staff: 1) The recent discussion on the subject Not using indexes??? brought to light an opportunity for interpreting the documentation in contradictory ways. The page http://www.mysql.com/doc/M/y/MySQL_indexes.html does not mention the IS NOT NULL comparison operator, nor does it mention the inequality () operator. This allows the reader to believe that since those operators are not mentioned, it goes without saying that they never use an index. It also allows the reader to believe that since each is simply the negation of a comparison whose index use is specifically documented, it goes without saying that they also use an index. Which of these interpretations is the truth that goes without saying, and which is the error that should be obvious even to the uninitiated? Or (removing my tongue gingerly from my cheek), what is going on here? 2) Also, the discussion of ANALYZE TABLE at http://www.mysql.com/doc/A/N/ANALYZE_TABLE.html leaves the user of InnoDB tables in limbo. If this doesn't work on InnoDB tables, what takes its place, or why does its place not need to be taken? Thanks. --Erv Young - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 set max_connections ?
what do you mean it doesn't do anything? you should be able to set it on the command line as: --set-variable=max_connections=200 or you could edit the my.cnf file that mysql is using when it starts-up. if you can't find the my.cnf, then you should create one. here is a link to the manpage and some default entires on mysql.com: http://www.mysql.com/doc/O/p/Option_files.html either way, you can check to see if the max connections has been updated by running the below command at the mysql prompt: show variables; katen At 06:05 PM 6/10/2002, Rekha Das wrote: Hi all, I am trying to set max_connections to 200 on my server. Currently it is 100. My mysql version 3.22.32. My problem is I am not able to find my.cnf. And if I set the variable on command line like this: --set-variable = max_connections=200; Then it does not do anything. What am I doing wrong ? Thanks, Rekha - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Oracle roles in MySQL?
Does MySQL offer anything to take the place of Oracle's roles? I'm especially interested in the ability, when adding a new table (or a new view, in the future) to the database, to be able to grant the desired access to everyone who ought to have access, without having to enumerate those people. Specifically, GRANT SELECT, INSERT ON my_new_table TO data_tech; GRANT SELECT, INSERT, UPDATE, DELETE ON my_new_table TO research_assistant; lets you grant the necessary permissions without having to know who the research assistants are this semester, and who is on the data entry staff at this moment. Is there a similar facility with a different name in MySQL? If not, is it planned? Thanks. --Erv Young - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
sql query(group by + order by)
Hi, I got a table named patient_treatment_history Below is some of the records inside the table. patient_id,treatment_date,charges 1014,2002-01-28,20 1001,2002-02-02,100 1026,2002-04-08,74 1001,2002-04-15,85 1014,2002-05-05,50 1030,2002-05-16,125 1030,2002-06-18,180 1001,2002-06-25,125 I try to retrieve the last visit date for each patient using this query: select patient_id,treatment_date from patient_treatment_history group by(patient_id) order by treatment_date desc. But the result is not what i expected. Can anybody assist me on this? 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: sql query(group by + order by)
do a select patient_id,treatment_date from patient_treatment_history order by treatment_date desc limit 1; I am not sure but max(treatmen_date) might work too as such: select patient_id, max(treatment_date) from patient_treatment_history group by treatment_date; In your original query the group by clause is causing undesired results. - Original Message - From: lorenzo.kh [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 10, 2002 6:53 PM Subject: sql query(group by + order by) Hi, I got a table named patient_treatment_history Below is some of the records inside the table. patient_id,treatment_date,charges 1014,2002-01-28,20 1001,2002-02-02,100 1026,2002-04-08,74 1001,2002-04-15,85 1014,2002-05-05,50 1030,2002-05-16,125 1030,2002-06-18,180 1001,2002-06-25,125 I try to retrieve the last visit date for each patient using this query: select patient_id,treatment_date from patient_treatment_history group by(patient_id) order by treatment_date desc. But the result is not what i expected. Can anybody assist me on this? 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
Here's something
Hi all. This is my first post here, so please be patient with me. I dont know if theres a program already made that does what I need, so I dont have to reinvent the wheel. Im using PHP MySQL to make most of the web sites and web-based Corporate Intranets programs. What I need now, is to make a program that can keep track of a social club affiliates and their monthly payments. Also keep track of the teachers and classes hours. Because Im taking my first steps into RDBMs, I would appreciate very much all the help I can get in order to create the perfect DB structure. What I have in mind, is something like this: Table users (user_id, affil_number, last_name, first_name, etc ) Table teachers (teach_id, last_name, first_name, etc ) Table classes (class_id, name, hours) Table teach_clases (class_id, teach_id) Table payments (payment_id, user_id, month, year, main_fee, class1_fee, class2_fee, etc ) What I need to do is show, as an example, the total payments made by affiliate # 0345 in the last 12 months. Other example would be to show all the persons who hasnt paid last month fee. Is what Im thinking correct or should I consider doing some other table or perhaps changing one thats already made? Thanks in advance, Cesar Aracena [EMAIL PROTECTED] CE / MCSE+I Neuquen, Argentina +54.299.6356688 +54.299.4466621 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Delphi Mysql
Hmmm... If your just requiring two tier client server there are several. This one is open source and free. http://sourceforge.net/projects/zeoslib - Original Message - From: Proliant Business Solutions [EMAIL PROTECTED] To: mysql [EMAIL PROTECTED] Sent: Monday, June 10, 2002 2:07 PM Subject: Delphi Mysql What is the best way to connect with Delphi 5/6 to Mysql? Johan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Here's something
Looks okay to me except table teach_classes should have a unique id for each record. teach_clases (taught_id, class_id, teach_id) Over the long term, the same class probably will be taught more than once and the same teacher probably will teach more than one class so neither class_id nor teach_id would remain unique in the table for classes taught. - Original Message - From: César L. Aracena [EMAIL PROTECTED] To: MySQL General [EMAIL PROTECTED] Sent: Monday, June 10, 2002 8:23 PM Subject: Here's something Hi all. This is my first post here, so please be patient with me. I don't know if there's a program already made that does what I need, so I don't have to reinvent the wheel. I'm using PHP MySQL to make most of the web sites and web-based Corporate Intranet's programs. What I need now, is to make a program that can keep track of a social club affiliates and their monthly payments. Also keep track of the teachers and classes hours. Because I'm taking my first steps into RDBM's, I would appreciate very much all the help I can get in order to create the perfect DB structure. What I have in mind, is something like this: Table users (user_id, affil_number, last_name, first_name, etc.) Table teachers (teach_id, last_name, first_name, etc.) Table classes (class_id, name, hours) Table teach_clases (class_id, teach_id) Table payments (payment_id, user_id, month, year, main_fee, class1_fee, class2_fee, etc.) What I need to do is show, as an example, the total payments made by affiliate # 0345 in the last 12 months. Other example would be to show all the persons who hasn't paid last month fee. Is what I'm thinking correct or should I consider doing some other table or perhaps changing one that's already made? Thanks in advance, Cesar Aracena [EMAIL PROTECTED] CE / MCSE+I Neuquen, Argentina +54.299.6356688 +54.299.4466621 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 AB: Need documentation clarification
In the last episode (Jun 10), Erv Young said: MySQL AB staff: And the thousands and thousands of regular people reading this list :) 1) The recent discussion on the subject Not using indexes??? brought to light an opportunity for interpreting the documentation in contradictory ways. The page http://www.mysql.com/doc/M/y/MySQL_indexes.html does not mention the IS NOT NULL comparison operator, nor does it mention the inequality () operator. This allows the reader to believe that since those operators are not mentioned, it goes without saying that they never use an index. It also allows the reader to believe that since each is simply the negation of a comparison whose index use is specifically documented, it goes without saying that they also use an index. Indexes are only used if they significantly reduce the number of reads required vs a full table scan (I believe 30% is mysql's threshhold). An IS NOT NULL clause may very well use an index if almost all of the records have NULL in that particular field. A != clause is a bit harder, since that basically devolves into field ## OR field ##, and I don't think can optimize that. -- 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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Here's something
Well... thanks Cal Day. Your thoughts are brillant. It makes me very proud that more experienced DB designers think I'm doing great. About the normalization rules, I have them inside the PHP and MySQL Web Development book, written by Luke Welling and Laura Thomson, but since my native language is Spanish, it's very hard for me to keep up with understanding after reading 200 pages in a row (kinda in a hurry here ;-) Well, thanks for your help and for letting me know that I can count on all of you to make my life easier. César Aracena IS / MCSE+I Neuquén, NQN (0299) 156-356688 (0299) 446-6621 -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Enviado el: Lunes, 10 de Junio de 2002 11:57 p.m. Para: César L. Aracena; MySQL General Asunto: Re: Here's something Wow, for your first shot, you've got a very normalized database. GOOD JOB! The only thing wrong is your payments table. It needs to be more like: payment - payment_id = class_id user_id date amount - - (The primary key is the combination of class_id and userID) Then you could : * join it with the classes table to see how much each class brought in, * Join it with the users table to see how much each person has paid * join it with the classes to get a roster of attendees. * join it with the classes where amount is null to get a list of deadbeats. * join it with teachers and classes to see how much each teacher is grossing. You get the idea. A couple of rules I always go by: (They are my rules, others may debate them but so far nobody has convinced me to change them...you'll come up with your on as you go on) * All tables have a primary key of tableNameID (or in your case tableName_id...but I hate [_]!) * Table names should be singular. this way a person does not have a people_id...he/she has a person_id. :) Go hit google.com and search for the 5 rules of data normalization. You are already doing most of the first 3 now but they will help you formalize what you are doing. (and 4 5 are not used that much, concentrate on 1-3) Keep up the good work! =C= * * Cal Evans * Techno-Mage * http://www.calevans.com * - Original Message - From: César L. Aracena [EMAIL PROTECTED] To: MySQL General [EMAIL PROTECTED] Sent: Monday, June 10, 2002 9:23 PM Subject: Here's something Hi all. This is my first post here, so please be patient with me. I don't know if there's a program already made that does what I need, so I don't have to reinvent the wheel. I'm using PHP MySQL to make most of the web sites and web-based Corporate Intranet's programs. What I need now, is to make a program that can keep track of a social club affiliates and their monthly payments. Also keep track of the teachers and classes hours. Because I'm taking my first steps into RDBM's, I would appreciate very much all the help I can get in order to create the perfect DB structure. What I have in mind, is something like this: Table users (user_id, affil_number, last_name, first_name, etc.) Table teachers (teach_id, last_name, first_name, etc.) Table classes (class_id, name, hours) Table teach_clases (class_id, teach_id) Table payments (payment_id, user_id, month, year, main_fee, class1_fee, class2_fee, etc.) What I need to do is show, as an example, the total payments made by affiliate # 0345 in the last 12 months. Other example would be to show all the persons who hasn't paid last month fee. Is what I'm thinking correct or should I consider doing some other table or perhaps changing one that's already made? Thanks in advance, Cesar Aracena [EMAIL PROTECTED] CE / MCSE+I Neuquen, Argentina +54.299.6356688 +54.299.4466621 - Before posting, please check: http://www.mysql.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 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
housekeeping
Each time I post to the MySQL list I get two messages as follows. - Original Message - From: Mailer-Daemon [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 10, 2002 9:10 PM Subject: NDN: Re: Here's something Sorry. Your message could not be delivered to: mailing list (Mailbox or Conference is full.) And yet my message comes through from the list. Is anybody else having this experience? Also, how do you handle addressing when replying to a post on the list? At this point I'm having to put the [EMAIL PROTECTED] address in by hand because the default reply-to address of messages received from the list is that of the person who posted it. (A minor annoyance, to be sure, but it seems to me the default reply-to address of a message received from the list should be the list.) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem when POSTING
G'day César I have a problem when posting. The thing is that every time I post to the mailing list, I get an error saying that the message could not be delivered but it does indeed. It's getting delivered to the list OK but one of the subscribers to the list is rejecting it. I've seen this a fair bit from MySQL lists and it can be for a number of reasons - eg. people's Hotmail accounts filling up or a mail server's automated rules rejecting it for one reason or another. I wouldn't worry about it. cheers kim - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem when POSTING
In the last episode (Jun 10), Dan Nelson said: In the last episode (Jun 11), César L. Aracena said: I have a problem when posting. The thing is that every time I post to the mailing list, I get an error saying that the message could not be delivered but it does indeed. I had the same problem when posting at one of the php.net mailing lists, and was solved after I announced it. Does it also have a solution here? You mean the NDN: messages? :) I complained to one of the admins but never got a response. It's apparently some commonly-used email gateway software that doesn't know how to properly bounce emails. And thanks to the bounce messages generated by my last post, the culprit is: FirstClass ESMTP Mail Server v6.1 ready FirstClass ESMTP Mail Server v5.50 ready The current version (or at least the version that the company that produces the software runs) is 220 mail.centrinity.com FirstClass ESMTP Mail Server v7.0 ready -- Dan Nelson [EMAIL PROTECTED] sql query blah blah - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Rotating mysqld.log
Hi, I tried to flush the logs but still the rotation doesn't happen. What else could be the problem ?? I get the same message again My config file read like this /var/log/mysqld.log { rotate 5 size=100k create 0644 mysql mysql postrotate if test -n `ps acx | grep mysql`;then /usr/bin/mysqladmin flush-logs fi endscript mail [EMAIL PROTECTED] missingok } I execute the config file as follows. /usr/sbin/logrotate -v /root/mysqlrotparams.conf I still get the old message reading config file mysqlrotparams.conf reading config info for /var/log/mysqld.log Handling 1 logs rotating pattern: /var/log/mysqld.log 102400 bytes (5 rotations) empty log files are rotated old logs mailed to [EMAIL PROTECTED] rotating file /var/log/mysqld.log log does not need rotating - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem with Escaping quotes
I'm writing some routines which generate SQL queries, and I'm trying to keep things generic. As such, I have a routine to SQL Escape some text, such that it can be used in a query without breaking anything. This routine predominantly consisted of preceeding all single quotes (') with a backslash. ie; \' However, this method of escaping does not seem to work with some other DBs (eg; Oracle), so it breaks when talking to other DBs. I changed my routine to instead replace all single quotes (') with two single quotes (''), which seems to be a more standard way of doing things. The routine now works for Oracle, and mostly works for MySQL, but... The problems occur when you need to escape something like, for example: \' If we use the double-quote method, then escaped, this becomes: \'' For a DB which only supports the double-quote technique, internally unescaping this replaces each double-single quote with one single quote: \' For MySQL, however, it sees the \' as a single quote, and the second single quote as closing the string (which means anything after it is seen as SQL code). Any ideas on how I can resolve this problem, preferrably without resorting to custom Escaping routines for different DBs? -- . Trevor Phillips - http://jurai.murdoch.edu.au/ . : Web Technical Administrator - [EMAIL PROTECTED] : | IT Services- Murdoch University | | On nights such as this, evil deeds are done. And good deeds, of / | course. But mostly evil, on the whole. / \ -- (Terry Pratchett, Wyrd Sisters) / - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php