Replication is taking time

Hi, I have prepared a RING Architecture in MySQL using three MySQL servers. I name these MySQL servers as A, B and C. My configuration is like this : A is the Master to B, B is the Master to C, and C is the Master to A. But, the replication from A to B is taking about 60 sec, and th

RE: mysql replication error

No ... I'm just setting up the replication for the first time. I make a dump of the master and i replaced it on the slave. thanks and bye. --- Victor Pendleton <[EMAIL PROTECTED]> ha scritto: > Has the replication worked previously for you? > If so, have you reset the master and the slave?

RE: Great news mysql , your $8000 per month income

So, apparently, you don't need to be a member of this list to send mail to it? What a great idea! -Original Message- From: The Certain Way [mailto:freedom4u3233118@;aol.com] Sent: Wednesday, October 23, 2002 4:21 PM To: [EMAIL PROTECTED] Subject: Great news mysql , your $8000 per month inc

I want LEFT JOIN to return NULL if WHERE not matched

Two tables, groups and user_permissions. Groups is indexed by groupid as primary key. User_permissions is indexed by username and groupid. For each user that's in a group, a row in user_permissions exists. I want to select from groups and user_permissions looking for a certain user in user_pe

Re: mysql startup

Joakim Ryden wrote: Hi - I just upgraded a development server from 3.23.53a to 4.0.4 and have not since been able to start MySQL as root using the init script included in the dist (or 'mysqld_safe --user=mysql' either). I get an immediate seg fault and exit. Starting the server as user 'mysql'

mysql startup

Hi - I just upgraded a development server from 3.23.53a to 4.0.4 and have not since been able to start MySQL as root using the init script included in the dist (or 'mysqld_safe --user=mysql' either). I get an immediate seg fault and exit. Starting the server as user 'mysql' works fine but then

Re: Great news mysql , your $8000 per month income

On Wed, Oct 23, 2002 at 04:34:51PM -0700, David Kramer wrote: > To the crackers out there on this list, > > Can someone send Greg a virus for this spam [EMAIL PROTECTED] > > sincerely, > > a concerned MySql citizen!! But obviously not a concerned net citizen. Fighting abuse with more abuse d

RE: Question about AUTO_INCREMENT

Thank you, that works :)) I'm a bit confused because query: select LAST_INSERT_ID(); did not show me anything first time (I tried to execute that query using phpMyAdmin tool), that is why I tried to ask that question in mailing list. Now I get it. phpMyAdmin probably opens a new connection to MySQL

RE: Question about AUTO_INCREMENT

>From http://www.mysql.com/doc/en/Miscellaneous_functions.html: LAST_INSERT_ID([expr]) Returns the last automatically generated value that was inserted into an AUTO_INCREMENT column. See section 8.4.3.126 mysql_insert_id(). mysql> SELECT LAST_INSERT_ID(); -> 195 The last ID that was gener

Question about AUTO_INCREMENT

Hello, I'm a newbie in MySQL and also in this mailing list. I've a problem and I hope some gurus can help me. So the question is: How to obtain an index of the row which is inserted ? for example : INSERT INTO some_tbl (ID,field1) VALUES ('','blahblahblah'); I need 'ID' to use as reference value

RE: Great news mysql , your $8000 per month income

To the crackers out there on this list, Can someone send Greg a virus for this spam [EMAIL PROTECTED] sincerely, a concerned MySql citizen!! -Original Message- From: The Certain Way [mailto:freedom4u3233118@;aol.com] Sent: Wednesday, October 23, 2002 4:21 PM To: [EMAIL PROTECTED] Subj

Great news mysql , your $8000 per month income

Greetings mysql , My name is Greg. I know you have to be tired of get-rich-quick promises. I know I am. It seems that the Internet is full of opportunities that promise you don't have to do anything in order to "get everything you ever wanted". READ ON and discover. I was involved for 6 ye

RE: large amount of aborted_connects

Do I need to post any further information to make this question easier to answer? I have snippets from SHOW STATUS and SHOW VARIABLES if needed. > -Original Message- > From: Jennifer Goodie [mailto:goodie@;apollointeractive.com] > Sent: Friday, October 18, 2002 5:19 PM > To: [EMAIL PROTEC

Using the embedded mysql server - how do I create a database on the fly?

Hello. I'm just getting started with the embedded mysql server and I'm not trying to do anything fancy. I just want to initialize the server and call "mysql_create_db" and have the database get created and then start using it. I've modified the basic "embedded server" example as follows: mysq

Looking for sample my.cnf

Im looking for an example of my.cnf. Just want to see what some of the basic parameters and admin tools(mysqldump, mysqlimport, mysqlshow,mysqladmin) settings should look like in my.cnf. I have searched all over the web and havent found much, if someone has a site they recommend outside of mysql.

Help Please ... PHP Problem - /libraries/grab_globals.lib.php

I still can't get get PHP working - Apache and MySQL work fine, but loading PHP pages continually show errors such as: Fatal error: Failed opening required './libraries/grab_globals.lib.php' Compiling from source presented a lot of dependency issues, so I reinstalled everything via deb files -

Re: Another bit off-topic question

Hello. On Wed 2002-10-23 at 10:47:28 -0400, [EMAIL PROTECTED] wrote: > I'm planning on using Win2k Adv. server, IIS, MYSQL, PHP on a dual > processor 2.4GHz processor with 1 or 2GB RAM, with either SCSI or ATA HDs. > > The webpage will be dynamic. > 1)How many concurrent connections would someth

relevance ranking with IN BOOLEAN MODE

Hi, How do I get a full-text relevance ranking when using IN BOOLEAN MODE? The manual shows how to get the relevance, but if I try to apply the same technique to a boolean search, I get a score of either 0 or 1 as the relevance. There are relevance parameters < > for boolean searches, so it must b

Re: MySQL not starting.

Are you sure your sym-links have not been deleted? - Mark System Administrator Asarian-host.org --- "If you were supposed to understand it, we wouldn't call it code." - FedEx - Original Message - From: "gerald_clark" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROT

Re: MySQL not starting.

One line says : The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable Does it exist? Is it executable? Is it owned my mysql? Does mysql own /usr/local/mysql and all its subdirectories and files? Another line says ./mysqld: Can't change dir to '/usr/local/mysql-3.23.52-pc

Re: full-text performance question

Hi! On Oct 23, Monte Ohrt wrote: > I have a table with a full-text index that spans four text columns. It > seems that the more records a query matches, the longer it takes to > execute. Is that normal? To quote my two-days-ago reply on exactly the same issue: ===

Re: Compiling v3.23.53 on Linux 2.2.19 with glibc 2.1.3

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wednesday 23 October 2002 21:37, Michael T. Babcock wrote: > I'm trying to compile MySQL v3.23.53 on Linux 2.2.19 with glibc 2.1.3 > and I'm getting an error: > > libmysql.c: In function `mysql_real_connect': > libmysql.c:1325: warning: passing a

Re: MySQL not starting.

I have tried both as myself and as root and received the same results. Thanks, Ed On Wed, 23 Oct 2002, gerald_clark wrote: > You are not logged in as root. > > [EMAIL PROTECTED] wrote: > > >I recently installed MySQL-3.23.52 and ranthrough the config and > >installation without any trouble

match against ('best') bug?

Hi- I don't know if this is a bug (I'm pretty new at mysql), but I figured I would fill out the report anyway. I don't know how to answer some of the questions, but did my best. I have looked in the manual, searched the list archives, and am using 4.0.4-beta-max-nt on Win2000. Description: When

show version problem

hello, I'm running version 4.0.3-beta-max-log on SunOS 5.8 (Generic_108528-15 sun4u sparc SUNW,Sun-Fire-280R) output from mysqlshow -V: mysqlshow Ver 9.4 Distrib 4.0.3-beta, for sun-solaris2.8 (sparc) I'm finding that executing either 'show variables' from a mysql session or 'mysqladmin -variab

RE: Optimizing Query to use Index in ORDER BY

What version of MySQL are you currently running? There exist a feature in release 3.23.x where a filesort will be used to perform GROUP BY and ORDER BY's actions when the key part is not used in the where clause. If I am correct, the optimizer has been tweaked in version 4.x. Forgive me if I am off

mysql query help

Hello, I have the following table structure and need assistance on a mysql query: Members MemberID (unique) Name Address Credits CreditID MemberID Project Title Credit_Images = ImageID CreditID Location Comments Showroom = ShowroomID MemberID Size Comments I

Compiling v3.23.53 on Linux 2.2.19 with glibc 2.1.3

I'm trying to compile MySQL v3.23.53 on Linux 2.2.19 with glibc 2.1.3 and I'm getting an error: libmysql.c: In function `mysql_real_connect': libmysql.c:1325: warning: passing arg 5 of `gethostbyname_r' from incompatible pointer type libmysql.c:1325: too few arguments to function `gethostbyname_

Re: Optimizing Query to use Index in ORDER BY

The explain shows that it is using the muzeid key for the pt table, so yes it is using it for the join. The query takes 1.46 seconds with the GROUP BY and 0.01 without. I was hoping to find a way to speed with query up. Thanks, Joe > From: gerald_clark <[EMAIL PROTECTED]> > Date: Wed, 23 Oct 2002

Re: BOM (Bill of Material)

Hi, About what you are interested ? Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: "Mike Westkamper" <[EMAIL PRO

full-text performance question

I have a table with a full-text index that spans four text columns. It seems that the more records a query matches, the longer it takes to execute. Is that normal? Examples: I have 15,376 records in this table: mysql> select count(*) from NS_articles where match(artHeadline,artTagline,artByline,

Re: RedHat 8 and mysql-server-3.23.52-3

My dear friend, TCP/IP is a protocol with KNOWLEDGE at ICMP level(see RFC792 ). The DNS server have a different purpose(see RFC 1034 or RFC 952 "HostNames table"). Ping work at ICMP level. The KERNEL is responsible about what is happened in the OS including the TCP/IP protocol. The TCP/IP IPV4/IPV6

Re: Old installation on Solaris 7, can't admin...

Mark Jaffe wrote: I've inherited an existing system and am attempting to do some admin tasks. I can't get access as root, and no one seems to know anything about the system. I've just modified the /usr/local/mysql/data/my.cnf (that's what 'ps -aef' shows mysqld is using) with a password and

Re: Optimizing Query to use Index in ORDER BY

Does explain say an index is used on pt for the join? Only one index per table is used in a query. It is probably more efficient to use the index for the where clause than the order by. Joseph Koenig wrote: Hi, I'm having trouble getting the following query to use the indexes on the order by.

Vague error message...

A colleague asked me what was wrong with this query: mysql> select user.id, email, count(click.id) as c from user, click where when_signup >= '2002-11-10' and click.user_id = user.id group by c; ERROR 1056: Can't group on 'c' Of course, it's logically impossible to group by the result of an exp

RE: Rounding floats

Another alternative for storage of currency values is to use the DECIMAL type, which allows you to explicitly specify scale and precision. You're still constrained to a maximum precision that matches that of DOUBLE, and you get the inefficiency of storing values as strings but you don't have to wor

Re: Error when compiling mysql 3.23.53 on Solaris 9

Jeremy, May not be helpful to you - perhaps you are seeking some specific compiled-in function, but for what it's worth: The mysql-max-4.0.4-beta-sun-solaris2.8-sparc tarball also runs great on Solaris 9 SPARC. We are using it... Lou Essex Systems > Hi all, > > I am compiling mysql 3.23.53 on

Old installation on Solaris 7, can't admin...

I've inherited an existing system and am attempting to do some admin tasks. I can't get access as root, and no one seems to know anything about the system. I've just modified the /usr/local/mysql/data/my.cnf (that's what 'ps -aef' shows mysqld is using) with a password and I still get this: > m

Optimizing Query to use Index in ORDER BY

Hi, I'm having trouble getting the following query to use the indexes on the order by. SELECT vr.muzeid, vr.releaseformat, vr.releasestatus, vr.collectorsedition, pt.title FROM v_videorelease vr, v_producttitle pt, v_prodcategory pc WHERE pc.muzeid = vr.muzeid AND pt.muzeid = vr.muzeid AND vr.rel

Re: How to index a large table?

Also, use "myisamchk -dv tablename" Pay attention to datafile pointer (bytes) and Keyfile pointer (bytes) and the Max keyfile/datafile length. The keyfile pointer must be at least 4 bytes for a large table, if it says 3 you have a problem! This is isn't clear from the CREATE TABLE section of the

Re: Error when compiling mysql 3.23.53 on Solaris 9

At 11:13 -0700 10/23/02, Jeremy Lau wrote: Hi all, I am compiling mysql 3.23.53 on Solaris 9 using gcc 3.2. Any clue to the following errors: mkdir .libs g++ -O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -DHAVE_RWLOCK_T -o gen_lex_hash gen_lex_hash.o ../isam/libnisam.a ../mer

Error when compiling mysql 3.23.53 on Solaris 9

Hi all, I am compiling mysql 3.23.53 on Solaris 9 using gcc 3.2. Any clue to the following errors: mkdir .libs g++ -O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -DHAVE_RWLOCK_T -o gen_lex_hash gen_lex_hash.o ../isam/libnisam.a ../merge/libmerge.a ../myisam/libmyisam.a ../myis

Re: Rounding floats

Oh, for BCD floating point. My first computer with a language (SWTP 6800) had BCD math. It had something like 6 byte mantissa and a 1 byte exponent. That would give 11 digits with e +-99 Maybe we should have BCD data types. Jan Steinman wrote: From: "Michael T. Babcock" <[EMAIL PROTECTED]> Kenne

RE: how do you define a relationship?

Perhaps what is confusing you is that you never explicitly define a relationship as such: there are no relationship objects. Rather, at the table leve you define a foreign key that references the primary key of another table. Second, you must use the InnoDB or BDB table types to get foreign keys.

Re: Rounding floats

>From: "Michael T. Babcock" <[EMAIL PROTECTED]> >Kenneth Hylton wrote something about SQL or QUERYs: >>I NEVER use float or double to store values like you appear to be doing... >FWIW, all of our financial database software stores values in either pennies or >tenths of a cent, not dollars, to avoi

Re: Bit off topic

>From: John Chang <[EMAIL PROTECTED]> > >I am looking for an external drive case that will be connected to a Xeon >server with SCSI (Ultra-160) interface. I want something like 6-12 >drives. I bought an older server computer from a dot-bomb. Trashed all electronics but the power supply. (I think

Re: Bug with Query in MySQL 4.0.4/RedHat 8.0

Mark T. Dame writes: > [EMAIL PROTECTED] wrote: > > > > >Description: > > > > This query produces 16 results: > > > > SELECT * FROM table1 > > LEFT JOIN table2 ON (field1 = field2) > > WHERE field2 = 'something' > > ORDER BY field2,field3,field4 > > > > But this query produces 0 results: > > >

Re: Bug with Query in MySQL 4.0.4/RedHat 8.0

[EMAIL PROTECTED] wrote: > > >Description: > > This query produces 16 results: > > SELECT * FROM table1 > LEFT JOIN table2 ON (field1 = field2) > WHERE field2 = 'something' > ORDER BY field2,field3,field4 > > But this query produces 0 results: > > SELECT * FROM table1 > LEFT JOIN table2 ON (fi

Re: Problem with select.

Without an ORDER BY, there is no order. Any order you see is purely accidental. If no order is requested, how could it be quicker to read through the index, and jump madly about the table extracting small records from large buffers. A linear read from the table is much faster. Andrey Hristov wrot

RE: my.cnf settings and running admin commands such as mysqldump or m

Is it a save assumption that I need to create a section for every admin command that I want to use? i.e., create another section for mysqladmin and so on??? Thx, dK -Original Message- From: Victoria Reznichenko [mailto:victoria.reznichenko@;ensita.net] Sent: Wednesday, October 23, 200

Re: MySQL not starting.

You are not logged in as root. [EMAIL PROTECTED] wrote: I recently installed MySQL-3.23.52 and ranthrough the config and installation without any trouble. The server was running just fine. Today I performed a reboot of the system and the server will not start up again. I also tried to start th

RE: RedHat8.0 and MySQL

Thanks Mark. Iago. > -Mensaje original- > De: Mark Matthews [mailto:mark@;thematthews.org] > Enviado el: miercoles, 23 de octubre de 2002 18:30 > Para: Iago Sineiro > CC: [EMAIL PROTECTED] > Asunto: Re: RedHat8.0 and MySQL > > > Iago Sineiro wrote: > >>-Mensaje original- > >>De: M

Re: RedHat8.0 and MySQL

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wednesday 23 October 2002 17:55, Iago Sineiro wrote: > How custom is the glibc used for compile the binaries provided by MySQL AB? Not much - we apply one patch (see glibc-2.2.5.patch in our BK source tree) to the vanilla glibc sources and compile

Re: RedHat8.0 and MySQL

Iago Sineiro wrote: -Mensaje original- De: Mark Matthews [mailto:mark@;mysql.com] Enviado el: miercoles, 23 de octubre de 2002 16:38 Para: Rolf Nilsen CC: [EMAIL PROTECTED] Asunto: Re: RedHat8.0 and MySQL Rolf Nilsen wrote: Hi, dont know if this is old information, but: RedHat 8.0, M

MySQL not starting

I recently installed 3.23.52 on a server and everything went fine throughout the configuration and install. The server started fine and has been running flawlessly for the past 3 months. However, I needed to reboot the system this morning and MySQL wouldn't start back up. I have tried using both .

Re: Problem with select.

- Original Message - From: "gerald_clark" <[EMAIL PROTECTED]> To: "Andrey Hristov" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, October 23, 2002 6:23 PM Subject: Re: Problem with select. > > > Andrey Hristov wrote: > > >HI, > >I don't know is it bad or not but I face queri

Re: sql problem

On Wednesday, Oct 23, 2002, at 00:13 America/Phoenix, Mylin Campos wrote: Hi all, I just wanted to know if you guys can help me out with this error. It's actually an sql and jdbc error. I have a class called employeeDBUtil. In this class, it has a method called updateEmployee. I wanted to

Re: INSERT query crashes MySQL

> $ perror 144 > 144 = Table is crashed and last repair failed > > Your table is corrupted, try to repair it with REPAIR TABLE or > myisamchk: > http://www.mysql.com/doc/en/Repair.html Hmm. REPAIR TABLE gives | mydb.IDRefs | repair | error| Can't create new tempfile: './mydb/IDRefs.T

RE: RedHat8.0 and MySQL

> -Mensaje original- > De: Mark Matthews [mailto:mark@;mysql.com] > Enviado el: miercoles, 23 de octubre de 2002 16:38 > Para: Rolf Nilsen > CC: [EMAIL PROTECTED] > Asunto: Re: RedHat8.0 and MySQL > > > Rolf Nilsen wrote: > > Hi, > > > > dont know if this is old information, but: > > > > Re

MySQL not starting.

I recently installed MySQL-3.23.52 and ranthrough the config and installation without any trouble. The server was running just fine. Today I performed a reboot of the system and the server will not start up again. I also tried to start the server by hand and these are the error messages I'm rece

Re: Bit off topic

John Chang wrote: I am looking for an external drive case that will be connected to a Xeon server with SCSI (Ultra-160) interface. I want something like 6-12 drives. Anyone have any suggestions? I do not want to go with Dell, IBM, etc. They cost way too much. I just want one I can build. T

re: using special chars in table names

Beuserie, Tuesday, October 22, 2002, 8:15:33 PM, you wrote: BF> i'm in process of migrating from a commercial dbms to mysql and BF> have legacy tables referenced everywhere with names like 'tbl1#c' --> '#' is not accepted for table names and must be escaped to create BF> one (but dissapeared from

re: how to join two tables in different server

Vivian, Wednesday, October 23, 2002, 5:24:13 PM, you wrote: VW> I like to have a query like this, VW> select * from tableA left join tableB on. VW> But tableA is in hostA, and tableB is in hostB. VW> What I should do? I can use either PHP or python. VW> Any ideas? Vivian, if your tables are l

re: RedHat8.0 and MySQL

Rolf, Wednesday, October 23, 2002, 4:42:24 PM, you wrote: RN> dont know if this is old information, but: RN> RedHat 8.0, MySQL 3.23.52. RN> It works like a charm from the local machine, but when you try to RN> connect by TCP, the active thread seg-faults. RN> (strace on mysqld) RN> The soluti

re: Re: INSERT query crashes MySQL

John, Wednesday, October 23, 2002, 5:21:38 PM, you wrote: JP> PHP starts to output the error "Too many references: cannot splice - error JP> 144" JP> When logging into mysql, I get: JP> "Didn't find any fields in table IDRefs" JP> started with -A, I get: JP> "cannot open file: IDRefs.MYD (error:

Re: Problem with select.

Andrey Hristov wrote: HI, I don't know is it bad or not but I face queries the work quite long time. the sql is : select * from log_answers_index limit 0,10 and it takes too much time for me to receive the result. I got indexes on most of the fields, i got primary key which is auto_increment

Re: how to join two tables in different server

At 9:41 -0500 10/23/02, gerald_clark wrote: You can't do that. You will have to open two connections, and do nested loops to build your result set. Or copy one table to the other server temporarily. This can be useful if you need to run a lot of joins between the tables. Vivian Wang wrote:

help displaying results from a mysql query with php

Can someone please tell me what's wrong with the following code? This info is inside a function that I defined. One of the arguments that I pass the function is the actual query. Based on the info that I know is loaded in the database (it's a development database...there are only 2 rows of info)

Bit off topic

I am looking for an external drive case that will be connected to a Xeon server with SCSI (Ultra-160) interface. I want something like 6-12 drives. Anyone have any suggestions? I do not want to go with Dell, IBM, etc. They cost way too much. I just want one I can build. Thank you MySQL. ---

Another bit off-topic question

I'm planning on using Win2k Adv. server, IIS, MYSQL, PHP on a dual processor 2.4GHz processor with 1 or 2GB RAM, with either SCSI or ATA HDs. The webpage will be dynamic. 1)How many concurrent connections would something like this handle? 2) Will it make a big difference if I use SCSI or ATA? E

Problem with select.

HI, I don't know is it bad or not but I face queries the work quite long time. the sql is : select * from log_answers_index limit 0,10 and it takes too much time for me to receive the result. I got indexes on most of the fields, i got primary key which is auto_increment int(11). When I did expla

Re: how to join two tables in different server

You can't do that. You will have to open two connections, and do nested loops to build your result set. Vivian Wang wrote: MySQL, I like to have a query like this, select * from tableA left join tableB on. But tableA is in hostA, and tableB is in hostB. What I should do? I can use either PH

Re: RedHat8.0 and MySQL

Rolf Nilsen wrote: Hi, dont know if this is old information, but: RedHat 8.0, MySQL 3.23.52. It works like a charm from the local machine, but when you try to connect by TCP, the active thread seg-faults. (strace on mysqld) The solution was to place the host I connect from in /etc/hosts. Voi

Re: INSERT query crashes MySQL

> Error 144 that the table is crashed and the last repair failed. You should > run a check and optimize on this table if possible. Error 13 indicates that > you do not have permission to access the file. If you are the System > Administrator you may want to check the file permissions. Otherwise, yo

Re: INSERT query crashes MySQL

perror 144 144 = Table crashed and last repair failed perror 13 Error code 13: Permission denied It looks to me like mysql does not own all the files, and can't repair the table. John P wrote: Another error! PHP starts to output the error "Too many references: cannot splice - error 144" Whe

RE: INSERT query crashes MySQL

John, Error 144 that the table is crashed and the last repair failed. You should run a check and optimize on this table if possible. Error 13 indicates that you do not have permission to access the file. If you are the System Administrator you may want to check the file permissions. Otherwise, you

[ANN] LP6 on Linux

Last week during Lasso Summit 2002, in addition to unveiling the MySQL list archives on ListSearch.com, Blue World announced the immediate availability of a beta version of its new Lasso Professional 6 (LP6) Web Data Engine running on Red Hat Linux. For those of you looking for a robust Web app

Rounding floats

Kenneth Hylton wrote something about SQL or QUERYs: I NEVER use float or double to store values like you appear to be doing. I always used DECIMAL so that they are stored as strings and you do not have problems associated with what you see here. I then have complete control over what is stored

how to join two tables in different server

MySQL, I like to have a query like this, select * from tableA left join tableB on. But tableA is in hostA, and tableB is in hostB. What I should do? I can use either PHP or python. Any ideas? Thanks - Before posting, please

Re: INSERT query crashes MySQL

Another error! PHP starts to output the error "Too many references: cannot splice - error 144" When logging into mysql, I get: "Didn't find any fields in table IDRefs" started with -A, I get: "cannot open file: IDRefs.MYD (error: 144)" optimize table IDRefs; "Can't open file: 'IDRefs.MYD'. (errn

re: Re: problem upgrading

At 03:29 PM 10/23/02 +0300, Egor Egorov wrote: Lance, Wednesday, October 23, 2002, 3:23:10 AM, you wrote: LU> I have /tmp symlinked to /var/tmp, and /var is a writable partition, while / LU> is readonly. When / is readonly mysqld is not able to run. LU> I've tracked down the problem to the saf

CPU size

One we know how much data we are going to store we can calculate HDD size. Then we look at the types of question we are going to use on the DB and combined with the size of data we now know how mush memory we should need. But how do I know what CPU I will need to run this? I know we need to look a

re: lost connection inquery : ODBC

Petre, Tuesday, October 22, 2002, 9:18:27 PM, you wrote: PA> Any known issues with RH8.0 and ODBC? PA> I keep getting lost connection messages when trying to connect from a PA> windows box to mysql, it worked 100% on a 7.3RH box. PA> There is no firewall. PA> Any workarounds? "Lost connection" yo

Re: [Fwd: 3rd Attempt: Fwd: Access Denied (1045)]]

Anthony W. Marino wrote: Any thoughts with regards to the problem outlined below would be appreciated! Thank You, Anthony Original Message Subject: 2nd Attempt: Fwd: Access Denied (1045)] Date: Fri, 18 Oct 2002 06:59:21 -0400 From: "Anthony W. Marino" <[EMAIL PROTECTED]> To

RedHat8.0 and MySQL

Hi, dont know if this is old information, but: RedHat 8.0, MySQL 3.23.52. It works like a charm from the local machine, but when you try to connect by TCP, the active thread seg-faults. (strace on mysqld) The solution was to place the host I connect from in /etc/hosts. Voila, no more seg-fau

re: Re: RedHat 8 and mysql-server-3.23.52-3

Terra, Wednesday, October 23, 2002, 1:08:34 AM, you wrote: TI> Got it. It is "--skip-name-resolve" and that worked around the problem. TI> What should I be on the lookout for to get a real fix? Will there be a TI> patch/update/etc for glibc from RH or is there something that the mysql TI> dev te

re: RE : millseconds

Eric, Wednesday, October 23, 2002, 3:45:34 PM, you wrote: EG> Thanks for all to help me solve my subselect problem. EG> An other question about date / time type EG> Is there any possibilitie to include milliseconds in a date / time EG> column Nope. -- For technical support contracts, goto htt

re: insert into CHAR() column using KOI8-R charset

Andrew, Tuesday, October 22, 2002, 11:27:06 PM, you wrote: AS> I setup server (my.ini/my.cnf) with AS> default-character-set = koi8_ru AS> Than do 'myisamchk -r -q' AS> It seems to use correct charset. AS> i do: AS> 1.it's ok: AS> INSERT INTO allg AS> (znum_allg,name) VALUES (20,"À") AS> 2.it

mysql replication error

i get the following error in the connection slave->master while setting up a replication between two MySQLServer(slave and master both windows XP): .err file on slave: MySql: ready for connections 021023 14:08:34 InnoDB: Started 021023 14:08:35 Slave I/O thread: connected to master '[EMAIL PROTE

Re: sql problem

It looks like you're missing a comma in your SQL statement in between placeOfBirth and civilStatus. Good Luck! Dennis - Original Message - From: "Mylin Campos" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, October 23, 2002 2:13 AM Subject: sql problem > > Hi all, > > I j

RE : millseconds

Hi, Thanks for all to help me solve my subselect problem. An other question about date / time type Is there any possibilitie to include milliseconds in a date / time column Thanks, Eric -Message d'origine- De : [EMAIL PROTECTED] [mailto:mysql@;lists.mysql.com] Envoyé : mercredi 23 oct

Re: INSERT query crashes MySQL

> JP> 021022 18:20:16 mysqld ended > JP> 243749 Query INSERT INTO IDRefs > JP> VALUES('5136110c98b89de5d389df0754182ff2','','',NOW(),'Not available','','') > MySQL server always crashes on this query? What is the structure of > the table IDRefs? Not always, just a few times in the last fe

Re: Bug with Query in MySQL 4.0.4/RedHat 8.0

[EMAIL PROTECTED] wrote: > > >Description: > > This query produces 16 results: > > SELECT * FROM table1 > LEFT JOIN table2 ON (field1 = field2) > WHERE field2 = 'something' > ORDER BY field2,field3,field4 > > But this query produces 0 results: > > SELECT * FROM table1 > LEFT JOIN table2 ON (fi

re: Re: problem upgrading

Lance, Wednesday, October 23, 2002, 3:23:10 AM, you wrote: LU> I have /tmp symlinked to /var/tmp, and /var is a writable partition, while / LU> is readonly. When / is readonly mysqld is not able to run. LU> I've tracked down the problem to the safe_mysqld script. The problem is it LU> does: LU>

re: subselect solution

Eric, Wednesday, October 23, 2002, 2:06:30 PM, you wrote: EG> I’m a new user on this list as well as Mysql. EG>   EG> I use it with coldfusion EG>   EG> My first problem is the following : EG>   EG>     I have a table where I created a timestamp column named EG> date_creation EG>   EG>   

re: beginner's question - cannot connect with database

Sistertech, Wednesday, October 23, 2002, 4:11:31 AM, you wrote: S> I'm trying to host a discussion forum for my philosophy class...to make a long story short: S> I've now got phpBB2 and MySQL on my virtual domain. S> My host doesn't offer any MySQL support. I'm installing phpBB and S> I receive

re: my.cnf settings and running admin commands such as mysqldump or m

David, Wednesday, October 23, 2002, 12:23:36 AM, you wrote: DK> I was wondering if someone could shed some light on setting parameters in DK> my.cnf. When I set params such as user and password in my my.cnf file I DK> dont need to then pass these parameters to commands such as mysqldump or DK> my

re: INSERT query crashes MySQL

John, Wednesday, October 23, 2002, 1:17:54 PM, you wrote: JP> This morning our MySQL exited for no good reason! JP> mysql.err: JP> 021020 17:25:53 JP> 021020 17: JP> 021022 18:20:16 mysqld ended JP> mysql.log: JP> 021022 18:20:09 JP> 243748 Connect mysql_user@localhost on JP> 243748 Init DB

re: odbc connect problem

Liu, Wednesday, October 23, 2002, 11:03:16 AM, you wrote: LQq> I installed myodbc on windows and want to connect mysql with odbc, but something is wrong. System indicated: MySQL ODBC 3.51 DRIVER :03.51.02 LQq> [MySql][ODBC 3.51 Driver]Host ' ' is not allowed to connect to this MySQL server. LQq

re: Import from files

Alan, Wednesday, October 23, 2002, 2:06:05 PM, you wrote: AM> Is it possible to update a field using SQL with the contents of a text file AM> previoously written to disk? AM> I want to update a mediumtext field with the contents of c:\data\mytext.txt AM> file. AM> update mytable set mymediumtext

  1   2   >