Re: Trouble with LEFT JOIN

Peter, Thank you very much for your reply. Three weeks later I am realizing that the 'NOT IN' solution I had above does not work after all. Accordingly, I went back and looked at your solution and it is close but it only gives NULL results I am looking for something that excludes challenges that

RE: Trouble with LEFT JOIN

Cheers. AB -Original Message- From: Richard Reina [mailto:gatorre...@gmail.com] Sent: Saturday, 26 September 2015 1:09 AM To: peter.braw...@earthlink.net Cc: mysql@lists.mysql.com Subject: Re: Trouble with LEFT JOIN Peter, Thank you very much for your reply. Three weeks later I am

Trouble with LEFT JOIN

I have the following two tables; mysql> select * from challenge; +++-++--+-+--+ | ID | PLR_ID | ACC_TYPE_ID | season | year | CHAR_ID | +++-++--+-+--+ | 1 | 1 |

Re: Trouble with LEFT JOIN

On 2015-09-04 9:40 AM, Richard Reina wrote: I have the following two tables; mysql> select * from challenge; +++-++--+-+--+ | ID | PLR_ID | ACC_TYPE_ID | season | year | CHAR_ID |

Re: Trouble with LEFT JOIN

2015-09-04 11:18 GMT-05:00 Peter Brawley : > On 2015-09-04 9:40 AM, Richard Reina wrote: > >> I have the following two tables; >> >> mysql> select * from challenge; >> +++-++--+-+--+ >> | ID | PLR_ID |

Re: Trouble with LEFT JOIN

On 2015-09-04 11:39 AM, Richard Reina wrote: 2015-09-04 11:18 GMT-05:00 Peter Brawley >: On 2015-09-04 9:40 AM, Richard Reina wrote: I have the following two tables; mysql> select * from challenge;

Re: Having trouble with SQL query

Hi Nitin Thanks - I tried that and got 0 rows... I have spent more time on describing my problem -- see below hopefully this will make the issue more clear... Rich I have a MySQL database with a menu table and a product table. - The products are linked to the menus in a one-to-many

Re: Having trouble with SQL query

Hello Rich, On 8/27/2012 12:19 PM, rich gray wrote: Hi Nitin Thanks - I tried that and got 0 rows... I have spent more time on describing my problem -- see below hopefully this will make the issue more clear... Rich ... snip ... There are many resources out there that can tell you how to

Having trouble with SQL query

I have a MySQL database with a menu table and a product table linked to the menus *(each product can be linked to more than menu row)* and the menus are nested. The query is that when a user clicks on a menu entry then all products linked to that entry *(there may be none)* will get displayed

Re: Having trouble with SQL query

that works.     Regards,   From: rich gray r...@richgray.com To: mysql@lists.mysql.com Sent: Monday, August 27, 2012 2:46 AM Subject: Having trouble with SQL query I have a MySQL database with a menu table and a product table linked to the menus *(each product can

Re: trouble with perl

I really confussed about this. I don't know whether my mysql is 32bit or 64bit, so I just fresh installed mysql 5.5.27 for osx 10.6 64bit. And I did reinstalled DBI and DBD::mysql make give me a lot of warnings like warning: format not a string literal and no format arguments but make test did

Re: trouble with perl

On Wed, Aug 8, 2012 at 1:12 PM, Elim Qiu elim@gmail.com wrote: But when I use browser for the system testing (perl_test.cgi and forum.pl), both report me that DBD:mysql is not installed (or not available) It's possible that DBD::mysql is installed in a place where it's not in the library

RE: trouble with perl

responsabilité pour le contenu fourni. Date: Wed, 8 Aug 2012 13:28:42 -0400 Subject: Re: trouble with perl From: per...@elem.com To: elim@gmail.com CC: mysql@lists.mysql.com On Wed, Aug 8, 2012 at 1:12 PM, Elim Qiu elim@gmail.com wrote: But when I use browser for the system

RE: trouble with perl

I can't find his phone number to call him. -Original Message- From: Martin Gainty [mailto:mgai...@hotmail.com] Sent: Wednesday, August 08, 2012 12:22 PM To: elim@gmail.com Cc: mysql@lists.mysql.com Subject: RE: trouble with perl I know I had the same problem with PHP when mysql.dll

RE: trouble with perl

http://bixsolutions.net/forum/thread-18.html -Original Message- From: Elim Qiu [mailto:elim@gmail.com] Sent: Monday, August 06, 2012 5:42 PM To: mysql@lists.mysql.com Subject: trouble with perl To populate table for a perl forum, I got the following error: aMac:mwf elim$ perl

Re: trouble with perl

Thanks Stillman Benjamin. The link is about the mismatch of 32/64 bit among mysql, perl and os processor but I don't have that issues. My system is missing DBD::mysql module, and I still have trouble with that. On Tue, Aug 7, 2012 at 6:49 AM, Stillman, Benjamin bstill...@limitedbrands.com

Re: trouble with perl

Hi, This probably means you changed your MySQL libraries but didn't recompile or reinstall DBD::mysql, Usually this kind of issue is solved by reinstalling DBD::mysql in the same way that you previously installed it, so it can build against your current libraries. - Perrin On Mon, Aug 6, 2012

trouble with perl

To populate table for a perl forum, I got the following error: aMac:mwf elim$ perl install.pl dyld: lazy symbol binding failed: Symbol not found: _mysql_init Referenced from: /Library/Perl/5.10.0/darwin-thread-multi-2level/auto/DBD/mysql/mysql.bundle Expected in: flat namespace dyld: Symbol

RE: Trouble with Average

2012/07/16 14:25 -0700, Rick James Here's a different way to smooth numbers. It uses an exponential moving average instead of the last 5. SELECT Time, @a := (9 * @a + Value) / 10 AS moving_avg FROM tbl JOIN ( SELECT @a := 0 ) AS x; Notes: * Make 10 larger or smaller, depending on

RE: Trouble with Average

only the first few rows. -Original Message- From: Hal?sz S?ndor [mailto:h...@tbbs.net] Sent: Monday, July 16, 2012 8:25 PM To: mysql@lists.mysql.com Subject: RE: Trouble with Average 2012/07/16 14:25 -0700, Rick James Here's a different way to smooth numbers. It uses

RE: Trouble with Average

* @a := 0 should be changed to some reasonable starting value, else the graph will be artificially low to start with. -Original Message- From: Hal?sz S?ndor [mailto:h...@tbbs.net] Sent: Monday, July 09, 2012 7:48 PM To: mysql@lists.mysql.com Subject: Re: Trouble with Average 2012/07

Re: Trouble with Average

2012/07/07 12:10 -0600, Albert Padley I have a log file that captures data from various sensors every minute that we use to draws graphs on our website. The table looks like this: CREATE TABLE `log` ( `id` int(14) NOT NULL auto_increment, `VarName` varchar(255) NOT NULL, `TimeString`

Trouble with Average

I have a log file that captures data from various sensors every minute that we use to draws graphs on our website. The table looks like this: CREATE TABLE `log` ( `id` int(14) NOT NULL auto_increment, `VarName` varchar(255) NOT NULL, `TimeString` datetime NOT NULL, `VarValue`

Version-differing replication trouble

Hey list, Got another strange problem. I'm in the process of migrating a 4.1 server to a 5.1. Replication is not compatible between them, so I have an intermediate 5.0 server. Setup is thus: 4.1 - 5.0 - 5.1 The server-id is different on all servers. It's been soft-set, followed by a flush

Re: Trouble joining 3 tables

Darn, it's not working after all. SELECT people.*, COUNT ( DISTINCT cars.car_id ) AS car_count, COUNT ( DISTINCT pets.pet_id ) AS pet_count, SUM ( IF ( pets.date_bought NOW() - INTERVAL 7 DAY, 1, 0 ) ) AS new_pet_count WHERE...etc car_count and pet_count are calculating correctly, but

Re: Trouble joining 3 tables

You are asking for all records form all tables. So, If 1 person has 1 car and 1 pet, there will be 2 records returned for that 1 person. You'll need to use SUM() instead of COUNT(): SELECT people.*, SUM(IF(cars.id IS NULL,0,1)) AS car_count, SUM(IF(pets.id IS NULL,0,1)) AS pet_count,

Re: Trouble joining 3 tables

Thanks, this solved it! On Nov 2, 2009, at 12:37 AM, Michael Dykman wrote: I suspect 'distinct' might help you out here. SELECT people.*, count(distinct cars.car_id) as car_count, count(distinct pets.pet_id) as pet_count -- MySQL General Mailing List For list archives:

Re: Trouble joining 3 tables

Johnny - Your solution might actually help me solve my next step, which is to also return a count of pets bought only within the last 7 days. Something like this: SELECT people.*, SUM(IF(cars.id IS NULL,0,1)) AS car_count, SUM(IF(pets.id IS NULL,0,1)) AS pet_count, SUM ( IF (

Re: Trouble joining 3 tables

Yes, I don't see why that wouldn't work... On Mon, Nov 2, 2009 at 11:09 AM, Brian Dunning br...@briandunning.comwrote: Johnny - Your solution might actually help me solve my next step, which is to also return a count of pets bought only within the last 7 days. Something like this:

Trouble joining 3 tables

Hi all - I have a table of PEOPLE, and a table of CARS owned by various people, and a table of PETS owned by various people. Each person may have 0 or more pets, and each person may have 0 or more cars. I'm trying to return a list of all the people, showing how many pets each person has,

RE: Trouble with large data in MySql

Hi Martin, Sorry, I am not able to understand this. Can you explain in detail please? -Karthik From: Martin Gainty [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 15, 2008 6:56 PM To: Krishna Chandra Prajapati; Karthik Pattabhiraman Cc: mysql@lists.mysql.com Subject: RE: Trouble

RE: Trouble with large data in MySql

: Re: Trouble with large data in MySql Hi Karthik, You have many columns in a single table (although you can). But, if you break the below table into two tables ( Vertical partitioning). It will help you to run your query faster. You haven't shown join_buffer_size and sort_buffer_size. Secondly

Re: Trouble with large data in MySql

: Trouble with large data in MySql Hi Karthik, You have many columns in a single table (although you can). But, if you break the below table into two tables ( Vertical partitioning). It will help you to run your query faster. You haven't shown join_buffer_size and sort_buffer_size. Secondly

Re: Trouble with large data in MySql

with this? I have 6GB RAM, 2 cores and 7200 RPM disk with 1TB size. Thanks in advance Karthik *From:* Krishna Chandra Prajapati [mailto:[EMAIL PROTECTED] *Sent:* Wednesday, October 15, 2008 3:43 PM *To:* Karthik Pattabhiraman *Cc:* mysql@lists.mysql.com *Subject:* Re: Trouble

RE: Trouble with large data in MySql

:[EMAIL PROTECTED] Sent: Wednesday, October 15, 2008 3:43 PM To: Karthik Pattabhiraman Cc: mysql@lists.mysql.com Subject: Re: Trouble with large data in MySql Hi, It depends on your query using join and sort. Also, on how much ram you have. You can refer to huge_my.cnf You can find huge_my.cnf

Re: Trouble with large data in MySql

records per month. We are having trouble getting results from MySql as it takes about 4-5 hours to complete for each query. We are using this primarily for reporting purposes. My table schema is as follows SMAS Table: Column Name Type Key adnetwork

RE: Trouble with large data in MySql

for such large datasets. Hope this helps! John We have 4 tables in which we have approximately 40 Million records per month. We are having trouble getting results from MySql as it takes about 4-5 hours to complete for each query. We are using this primarily for reporting purposes

Re: Trouble with large data in MySql

with explain. On Wed, Oct 8, 2008 at 4:00 PM, Karthik Pattabhiraman [EMAIL PROTECTED] wrote: Hi, We have 4 tables in which we have approximately 40 Million records per month. We are having trouble getting results from MySql as it takes about 4-5 hours to complete for each query. We are using

RE: Trouble with large data in MySql

@lists.mysql.com Subject: Trouble with large data in MySql Hi, We have 4 tables in which we have approximately 40 Million records per month. We are having trouble getting results from MySql as it takes about 4-5 hours to complete for each query. We are using this primarily for reporting purposes. My

Trouble with large data in MySql

Hi, We have 4 tables in which we have approximately 40 Million records per month. We are having trouble getting results from MySql as it takes about 4-5 hours to complete for each query. We are using this primarily for reporting purposes. My table schema is as follows SMAS Table

Re: trouble with group by and similar tables

Eben, all, I'm very sorry this got out of sight for so long :-( When I first read your mail, I had no idea, and then it was hidden. Just now, I check it again and detect what may explain this. I quote nearly the full mail leading to this, so that you readers need not scan your archives.

Re: trouble with group by and similar tables

Hi Eben, all ! Eben schrieb: I have the following tables: table1 --- id1 some_field table2 --- id id1 score table3 --- id id1 score I then have the following query: SELECT table1.id,SUM(table2.score) as table2_score FROM table1, table2 WHERE table1.some_field = 'value' AND

Re: trouble with group by and similar tables

Hi Joerg, Joerg Bruehe wrote: Hi Eben, all ! Eben schrieb: I have the following tables: table1 --- id1 some_field table2 --- id id1 score table3 --- id id1 score I then have the following query: SELECT table1.id,SUM(table2.score) as table2_score FROM table1, table2 WHERE

trouble with group by and similar tables

I have the following tables: table1 --- id1 some_field table2 --- id id1 score table3 --- id id1 score I then have the following query: SELECT table1.id,SUM(table2.score) as table2_score FROM table1, table2 WHERE table1.some_field = 'value' AND table2.id1 = table1.id GROUP BY

Re: trouble with group by and similar tables

What you need, basically, is to combine two queries, one of which addresses t1 and t2 while the other addresses t1 and t3. Create two views similar to your first query and then join the two views on t1.id and you'll get what you're after. hth, Arthur On Thu, Jun 5, 2008 at 3:44 PM, Eben [EMAIL

Re: trouble with group by and similar tables

Eben [EMAIL PROTECTED] wrote on 06/05/2008 02:44:42 PM: I have the following tables: table1 --- id1 some_field table2 --- id id1 score table3 --- id id1 score I then have the following query: SELECT table1.id,SUM(table2.score) as table2_score FROM table1,

Re: table join trouble

Hi Edward, (see below) Edward Corbett wrote: Hi, I am trying to join a bunch of tables together. I want a row for each learner, and on the row, I want some user, centre, client and centreManager information if there is any. Thus, I am trying to outer join from the learner table to 4 other

table join trouble

Hi, I am trying to join a bunch of tables together. I want a row for each learner, and on the row, I want some user, centre, client and centreManager information if there is any. Thus, I am trying to outer join from the learner table to 4 other tables. The query I have so far is below but it

table join trouble

Hi, I hope this finds itself as an answer to my last post. I'm new to this email message format of lists. It turns out that the problem with the join was that I had a column being selected that I removed from my posting example for brevity which was causing the select to fail. The extra

Left outer join trouble

Hi, I'm trying to write a query which returns a single record which contains concatenated values for referencing records: SELECT tickets.id AS id, CAST(GROUP_CONCAT(tags.name SEPARATOR ' ') AS CHAR) AS tags, CAST(GROUP_CONCAT(events.value SEPARATOR ' ') AS CHAR) AS text FROM

Re: Left outer join trouble

Hi, Morten wrote: Hi, I'm trying to write a query which returns a single record which contains concatenated values for referencing records: SELECT tickets.id AS id, CAST(GROUP_CONCAT(tags.name SEPARATOR ' ') AS CHAR) AS tags, CAST(GROUP_CONCAT(events.value SEPARATOR ' ') AS

Re: Left outer join trouble

Baron Schwartz wrote: I'm tempted to solve this using a view or two, but would like to know if there's a better way. GROUP_CONCAT() takes an optional DISTINCT modifier, and that might do what you're looking for. It sure does the trick. I'll use that, I was afraid that I was missing

Re: Left outer join trouble

Martin Gainty wrote: Good Morning- Good afternoon :-) http://www.mysqlperformanceblog.com/2006/09/04/group_concat-useful-group-by- extension/ I did'nt see your where clause ? I'm probably missing your point here. But there's no where clause because I want all records from the tickets

Re: Having trouble storing monetary values...

trouble storing monetary values... Rick Faircloth wrote: Hi, all. I'm having trouble storing monetary values. When MySQL 5.0 stores the entered value of 5.23, it storing it as 5, dropping off the values after the decimal. The field is the decimal type with 2 specified as the number

RE: Having trouble storing monetary values...

To: Rick Faircloth Cc: MySQL List Subject: Re: Having trouble storing monetary values... Hi Rick, (I'm CCing the list in again -- keeping the discussion on-list lets everyone see it and potentially solve their own problems by searching archives in future). It looks to me like it ought

Having trouble storing monetary values...

Hi, all. I'm having trouble storing monetary values. When MySQL 5.0 stores the entered value of 5.23, it storing it as 5, dropping off the values after the decimal. The field is the decimal type with 2 specified as the number of values to store after the decimal. Can anyone

Re: Having trouble storing monetary values...

Rick Faircloth wrote: Hi, all. I'm having trouble storing monetary values. When MySQL 5.0 stores the entered value of 5.23, it storing it as 5, dropping off the values after the decimal. The field is the decimal type with 2 specified as the number of values to store after

trouble selecting DB

Morning All- I connect to Mysql 4.0.13 using mysql_connect AND returned handle is not false then I call access to mysql_select_db which always returns NULL and causes Exception I also tried mysql_connect with supplied 4th param as DB with no joy The DB name is uppercase..does this matter?

trouble sending mail to [EMAIL PROTECTED]

Has anyone else been having problems sending mail to mysql- [EMAIL PROTECTED] I tried it with two mail accounts (one at work and also GMail) I get this as a response...for some reason it doesn't seem to be getting to the list at all. The mail servers are somehow taking that address and

Re: trouble selecting DB

At 12:26 PM -0400 9/14/07, Martin Gainty wrote: Morning All- I connect to Mysql 4.0.13 using mysql_connect AND returned handle is not false then I call access to mysql_select_db which always returns NULL and causes Exception I also tried mysql_connect with supplied 4th param as DB with no

Trouble connecting to server

I have a mysql v 5.0 server running on Suse Linux 10.1. It has been running steadily and properly for several months now. However, when I came in this morning, my network card in the machine was bad. I replaced the card and reconfigured the network, but ever since then, I can only connect to

Re: Trouble connecting to server

At 11:36 AM 4/23/2007, Drew Burchett wrote: I have a mysql v 5.0 server running on Suse Linux 10.1. It has been running steadily and properly for several months now. However, when I came in this morning, my network card in the machine was bad. I replaced the card and reconfigured the network,

RE: Trouble connecting to server

@lists.mysql.com Subject: Re: Trouble connecting to server At 11:36 AM 4/23/2007, Drew Burchett wrote: I have a mysql v 5.0 server running on Suse Linux 10.1. It has been running steadily and properly for several months now. However, when I came in this morning, my network card in the machine was bad

Trouble with WHERE Clause

I have two tables I just what the data from the 1 table that is not in the 2 table So in this example I what row formelements_id 22 and 23. I have tried different sql statements one is below SELECT customformelements.formelements_id

trouble starting mysqld daemon

Hi! I'm a rookie, so bear with me... Keep getting: Starting mysqld daemon with databases from /opt/mysql/mysql/data Stopping server from pid file /opt/mysql/mysql/data/unknown.pid 061228 17:16:04 mysqld ended After this command bin/safe_mysqld --user=mysql Very open to suggestions

Re: trouble starting mysqld daemon

Check for .err text log files .. they are probably in /opt/mysql/mysql/data/ called servername.err servername is the hostname of your box. On Thu, 28 Dec 2006, Jeff Jones wrote: Hi! I'm a rookie, so bear with me... Keep getting: Starting mysqld daemon with databases from

Re: trouble starting mysqld daemon

] To: Jeff Jones [EMAIL PROTECTED] CC: mysql@lists.mysql.com Subject: Re: trouble starting mysqld daemon Date: Sun, 31 Dec 2006 14:23:53 -0500 (EST) Check for .err text log files .. they are probably in /opt/mysql/mysql/data/ called servername.err servername is the hostname of your box

Some trouble with a Join after upgrade from 3.23 to 5.0

Hi I moved a lot of databases from a 3.23 system to a new 5.0 system that was taking over because of hardware upgrades. I had no major problems until the last database. This query: SELECT a.id, a.nr, a.parent_id, a.designation, a.designation2, a.short_description, a.road_desc,

Re: Some trouble with a Join after upgrade from 3.23 to 5.0

!!! - Original Message - From: nocturnal [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Wednesday, October 18, 2006 10:31:13 AM GMT-0500 US/Eastern Subject: Some trouble with a Join after upgrade from 3.23 to 5.0 Hi I moved a lot of databases from a 3.23 system to a new 5.0 system

Re: Some trouble with a Join after upgrade from 3.23 to 5.0

I read the documentation on this link: http://dev.mysql.com/doc/refman/5.0/en/join.html and found the section describing changes made to MySQL 5.0.12. The problems is that i couldn't find any errors in the query when i read about the new JOIN syntax described. The info you need is in that

Re: Some trouble with a Join after upgrade from 3.23 to 5.0

This is due to a change in MySQL 5.0.12 that was done to align with SQL:2003. Here, we started to be more conservative regarding what could go into the ON clause. The whole thing is documented here: http://dev.mysql.com/doc/refman/5.0/en/join.html In your case, the JOIN would look something

Trouble duplicating a mongo live table

I have a 17,000,000 record table that I'm trying to duplicate in order to make some changes and improvements, then I'll rename it and drop the original table. So I need this duplicate to be a live table in the same database as the original. I tried the copy table function in the Operations

Re: Trouble duplicating a mongo live table

At 11:01 AM 9/30/2006, you wrote: I have a 17,000,000 record table that I'm trying to duplicate in order to make some changes and improvements, then I'll rename it and drop the original table. So I need this duplicate to be a live table in the same database as the original. I tried the copy

Trouble compiling C on OS X

First off, I apologize for the fact that I'm not more versed in the inner workings of GCC and linking libraries and etc, I'm a web developer and I'm just using C to try to cut down on some speed problems. This is my little test program: #include stdio.h #include stdlib.h #include math.h #include

Re: Trouble with using IN for a sub-query statement

Chris wrote: Chris White wrote: On Monday 07 August 2006 12:13 pm, William DeMasi wrote: I meant to have it say : select * from c2iedm_dev2.act where act_id IN (select obj_act_id from c2iedm_dev2.act_functl_assoc where subj_act_id =24); What does the output of (the subselect): select

having trouble with a trigger

hi guys: I'm not the sharpest tack in the box. I'm having trouble making a trigger work. CREATE TRIGGER update_calldate BEFORE INSERT ON contacts FOR EACH ROW UPDATE contacts SET calldate=2006-08-15 where calldate NOT IN ('2006-08-15') ; The trigger accepts in so far as it creates the trigger

Trouble with using IN for a sub-query statement

The select statement I am trying to run is: select * from c2iedm_dev2.act where act_id =(select obj_act_id from c2iedm_dev2.act_functl_assoc where subj_act_id =24); But I get the error below: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for

Re: Trouble with using IN for a sub-query statement

On Monday 07 August 2006 12:02 pm, William DeMasi wrote: The select statement I am trying to run is: select * from c2iedm_dev2.act where act_id =(select obj_act_id from c2iedm_dev2.act_functl_assoc where subj_act_id =24); Well the problem I'm seeing is that you're not using IN anywhere in the

Re: Trouble with using IN for a sub-query statement

On Monday 07 August 2006 12:13 pm, William DeMasi wrote: I meant to have it say : select * from c2iedm_dev2.act where act_id IN (select obj_act_id from c2iedm_dev2.act_functl_assoc where subj_act_id =24); What does the output of (the subselect): select obj_act_id from

Re: Trouble with using IN for a sub-query statement

Chris White wrote: On Monday 07 August 2006 12:13 pm, William DeMasi wrote: I meant to have it say : select * from c2iedm_dev2.act where act_id IN (select obj_act_id from c2iedm_dev2.act_functl_assoc where subj_act_id =24); What does the output of (the subselect): select obj_act_id from

Trouble with read-only

Hello, I'm trying to set up a replication slave as read-only, but the read-only part doesn't seem to be working. Replication between the master and the slave works fine. I have added the read-only keyword to the slave's my.cnf, and looking at the output of show variables indicates that

Re: Trouble with read-only

Are you inserting rows as a root user? The root user will be able to write to tables even if read-only is set to 'ON'. --Ravi Rod Heyd wrote: Hello, I'm trying to set up a replication slave as read-only, but the read-only part doesn't seem to be working. Replication between the master and

Re: Trouble with read-only

On 6/14/06, ravilr [EMAIL PROTECTED] wrote: Are you inserting rows as a root user? The root user will be able to write to tables even if read-only is set to 'ON'. Ah, yes. That was it. I forgot about that. Thanks. -Rod

Re: Trouble with read-only

Rod Heyd wrote: Hello, I'm trying to set up a replication slave as read-only, but the read-only part doesn't seem to be working. Replication between the master and the slave works fine. I have added the read-only keyword to the slave's my.cnf, and looking at the output of show variables

Trouble pulling the Trigger

I'm having some trouble writing this trigger and wasn't sure what I'm doing wrong. My goal is after a row has been added to tcphdr it will pull data from several other tables based on the NEW rows event.cid and event.timestamp and insert it into acid_event. However I'm not sure how to tell

Trouble with aborted connections

Hello everybody, I'm using mysql in an clustered environment: Several loadbalanced webservers get the requests from the users' clients and query the needed information from several webservers. Every webserver connects to every database-server. So in this case the webservers are the mysql-clients.

trouble finding WinMySQLadmin, and opening MySQLadmin

Hi everybody, I have Windows XP computer and I've installed Apache, and MySQL 5.0.18. I downloaded MySQL from: http://www.softpedia.com/progDownload/MySQL-for-Windows-Download-2668.html but the following problem occurs. According to the instructions in php and mysql for dummies (I'm a newbee) I

Re: trouble finding WinMySQLadmin, and opening MySQLadmin

Bibi, WinMySqlAdmin has been disocntinued. Try mysql/bin/MySqlInstqanceConfig.exe. Getting PHP to work with MySQL under Windows is a bit tricky at first, but once set up it's solid. For setup have a look at http://forums.mysql.com/read.php?52,70381,70628#msg-70628. PB

Trouble connecting to 5.0.18

I've been running MySQL 4.0.20 on Mac OS 10.3.5 for some months and had been working on a custom client. It was working well until I upgraded by computer to 10.4.3 and MySQL to 5.0.18. My client can not longer connect - I get an error message: Client does not support authentication protocol

Re: Trouble connecting to 5.0.18

this refers to a new password scheme used in mysql 4.1 and above. see here to fix this... http://dev.mysql.com/doc/refman/5.0/en/old-client.html b John Hoover wrote: I've been running MySQL 4.0.20 on Mac OS 10.3.5 for some months and had been working on a custom client. It was working well

Re: Trouble connecting to 5.0.18

oh i forgot to mention, the new passwords are stored in the database already. you need to reset the password with the OLD_PASSWORD() function. they detail that in the documentation b Brandon Ooi wrote: this refers to a new password scheme used in mysql 4.1 and above. see here to fix

Re: mysql-4.1.16 starting trouble

On Tuesday 17 January 2006 14:37, Gleb Paharenko wrote: This is a bug: http://bugs.mysql.com/bug.php?id=15965 Have a look here as well: http://bugs.mysql.com/bug.php?id=15151 Most probable you will have to install the latest development source, which has this bug fixed:

Re: mysql-4.1.16 starting trouble

Trux wrote: Hi! Sorry for my english, im russian. I have trouble with starting mysql-4.1.16. I compiled it from source, and when i run: # mysql_install_db --user=mysql i've got: - ERROR: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL

Re: mysql-4.1.16 starting trouble

On Tuesday 17 January 2006 14:37, Gleb Paharenko wrote: This is a bug: http://bugs.mysql.com/bug.php?id=15965 Have a look here as well: http://bugs.mysql.com/bug.php?id=15151 Most probable you will have to install the latest development source, which has this bug fixed:

Re: mysql-4.1.16 starting trouble

What about next release in 4.1.x? May be it will fix this bug? I hope it will. Trux wrote: On Tuesday 17 January 2006 14:37, Gleb Paharenko wrote: This is a bug: http://bugs.mysql.com/bug.php?id=15965 Have a look here as well: http://bugs.mysql.com/bug.php?id=15151 Most probable

mysql-4.1.16 starting trouble

Hi! Sorry for my english, im russian. I have trouble with starting mysql-4.1.16. I compiled it from source, and when i run: # mysql_install_db --user=mysql i've got: - ERROR: 1064  You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version

Re: install trouble, perl DBI

Lewis, As you already have perl installed, an easier way of getting modules is by way of CPAN (www.cpan.org). Give this a try, as superuser: cpan install DBI Regards, Imran -- http://www.EjectDisc.com Get your Digital Identity - Domain Names, Web Space, E-mail More! -- MySQL General Mailing

Re: install trouble, perl DBI

Rasnita wrote: From: Lewis Ashley Foster [EMAIL PROTECTED] I'm trying to get mySQL installed on my machine but im having a bit of trouble, obviously :) When i come to install mySQL server as below: rpm -ivh MySQL-server-standard-5.0.16-0.rhel3.i386.rpm I get this result: warning: MySQL

Re: install trouble, perl DBI

Hello. the first error, cant find Time/HiRes.pmthen later on 56/56 tests Now it is rather a pure Perl problem than MySQL. However, have you installed Time/HiRes.pm? As far as I know, you can use 'force install ...' instead of just 'install' command in the cpan shell. This should

Re: install trouble, perl DBI

trying to get mySQL installed on my machine but im having a bit of trouble, obviously :) When i come to install mySQL server as below: rpm -ivh MySQL-server-standard-5.0.16-0.rhel3.i386.rpm I get this result: warning: MySQL-server-standard-5.0.16-0.rhel3.i386.rpm: V3 DSA signature: NOKEY

  1   2   3   4   5   >