On Sun, Aug 24, 2003 at 02:02:06PM -0400, Eric Frazier wrote:
> Sounds very biblical. :)
Yeah, I have it etched on a pair of stone tablets around here
somewhere... :-)
> Wouldn't there be a way to do this with two copies of mysql that
> share a common data dir?
Maybe. But that's not what he's
Sounds very biblical. :)
Wouldn't there be a way to do this with two copies of mysql that share a
common data dir? I don't know if you could do that with InnoDB, but I wonder
if you could with myisam? At least if you had a system where the two sets of
tables came from a different master, and ther
On Sun, Aug 24, 2003 at 09:03:16PM +, [EMAIL PROTECTED] wrote:
> Hi,
>
> I am running MySQL V4.0.14 with replication.
>
>
> I want to replicate specified databases from 2 different masters into one
> slave. Is this possible?
No.
A slave may only have one master.
--
Jeremy D. Zawodny
> Lots of stuff
> STEMMING! (controlled more finely than server level I hope),
multi-byte
> character set support, proximity operators. Anything to get it closer
to
> Verity's full-text functionality. ;-)
Yes, all these things would be nice... :)
> And the FULLTEXT index shouldn't always be chose
Hi,
I am running MySQL V4.0.14 with replication.
I want to replicate specified databases from 2 different masters into one
slave. Is this possible?
Michael
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTE
I'm new to MySql and I'm having a problem figuring out how to configure my
Connect command so I can test on my PC and upload scripts to my ISP without
constantly changing the Connect command to reflect the applicable host. I use
LocalHost on my machine and then change it to my ISP's IP on their
I put a change into the import(1) function for PHPList by changing
'replace' to 'insert delayed' and it seems to have actually SLOWED
importing records. Thanks for your response.
Creigh
At 07:33 PM 8/24/2003 +0300, you wrote:
Creigh Shank <[EMAIL PROTECTED]> wrote:
> For example, does 'delayed
Creigh Shank <[EMAIL PROTECTED]> wrote:
> For example, does 'delayed' work with 'insert' and 'replace' like it does
> for ISAM and MyISAM tables?
>
INSERT DELAYED works only with ISAM/MyISAM tables.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is spo
Ok, let's collect the spamming addresses:
> [EMAIL PROTECTED]
> [EMAIL PROTECTED] ("The Oracle")
> [EMAIL PROTECTED]
[EMAIL PROTECTED]
--
To Unix or not to Unix. That is the question whether 'tis nobler in the
mind to suffer slings and arrows of vast documentation or to take arms
against a sea o
Hi Sanjay,
I made a chart which shows the tables and their supported functions.
Please have a look here:
http://www.knowd.co.jp/staff/nils/
I hope this helps.
Best regards
Nils Valentin
Tokyo/Japan
2003年 8月 22日 金曜日 18:45、sanjay gupta さんは書きました:
> Hi all ,
>
> can anybody tell me the differan
Neculai Macarie wrote:
[]
> select 'gallery' as table_name, d_image_small, d_image_big
> from gallery
> UNION
> select 'gallery_categ' as table_name, d_image, NULL
> from gallery_categ
> order by table_name;
[]
> select 'gallery' as table_name, d_image_small, d_image_big
> from gallery
> union
> se
Krichene:
> I have installed mysql on my Linux redhat 7.2 System. when I try to lauch the
> mysqld ,the message is [ok] but when i launch service mysql status, i got the
> folowwing :"mysql is dead but subsys is locked" and I can't connect to my database
> Can you help me please
> Think you
P
Hi!
Many people have complained over years that Borland's dbExpress driver does
not work with MySQL and transactions, because it disconnects from mysqld
after each SQL statement. The postings below suggests that this problem
might now be fixed by Borland.
Best regards,
Heikki Tuuri
Innobase Oy
h
Roger Baklund wrote:
> * Robert Morgan
>> Hi, is it possible to link databases within mysql?
> I'm not sure what it means to "link databases"...
Given "I have a access database ..." the OP probebly wants to (±symbolic)
link a table to an external data-source, being an Acces-file.
That's the mecha
Hans,
the problem is partially fixed in 4.1.1. You get a warning from inserting a
nonsensical date. But it still accepts '1996-02-31' without a warning,
though there are max 29 days in February. I have now notified the developers
about this bug.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.
Hi!
Using Union and Order By gives strange behaviour in the following test-case:
drop table if exists gallery;
drop table if exists gallery_categ;
# create test tables
create table gallery (d_image_small char(100), d_image_big char(100));
create table gallery_categ (d_image char(100));
# insert t
Asif,
- Original Message -
From: "Asif Iqbal" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Sunday, August 24, 2003 8:47 AM
Subject: Re: innodb doc in mysql.com
> On Sun, 24 Aug 2003, Heikki Tuuri wrote:
>
> > Asif,
> >
> > - Original Message -
> > From: "Asif Iqb
Asif,
- Original Message -
From: "Asif Iqbal" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Sunday, August 24, 2003 8:44 AM
Subject: split database
> I am running mysql 4.0.13 with innodb. I have data since 2000. I don't
> necessarily need to work with any data older than
Hi all,
I'm planning to use MySQL's full-text search for my forum system
(possibly 5+ million posts). I've been playing with it a lot lately to
see the performance and functionality and have some
suggestions/questions.
First, since a few of you may be wanting to know, here is a thread where
I was
On Sun, Aug 24, 2003 at 07:44:10AM +0100, Pag wrote:
>
> >
> >"localhost" is used in mysql to refer to the Unix domain socket. For
> >security, they may not even provide remote TCP access to the mysql
> >server. If "SHOW VARIABLES LIKE 'skip_networking'" returns ON, then
> >TCP access has been d
"localhost" is used in mysql to refer to the Unix domain socket. For
security, they may not even provide remote TCP access to the mysql
server. If "SHOW VARIABLES LIKE 'skip_networking'" returns ON, then
TCP access has been disabled. Otherwise, "SHOW VARIABLES LIKE 'port'"
will tell you what po
On Sun, 24 Aug 2003, Heikki Tuuri wrote:
> Asif,
>
> - Original Message -
> From: "Asif Iqbal" <[EMAIL PROTECTED]>
> Newsgroups: mailing.database.mysql
> Sent: Saturday, August 23, 2003 10:09 PM
> Subject: innodb doc in mysql.com
>
>
> > In mysql.com site on section 7.5.4.1 it says and I q
I am running mysql 4.0.13 with innodb. I have data since 2000. I don't
necessarily need to work with any data older than one year. Therefore I would
like to split the database. Then I like to backup data older than one year and
keep anything newer than one year and put it back to the same tables.
Dan Jones unknowingly asked us:
UPDATE table1 SET table2ID = NULL WHERE table1.table2ID NOT FOUND IN
table2.ID;
The NOT FOUND IN isn't SQL, of course, but I'm not sure what should go
there.
In MySql, its 'NOT IN'
and not
'NOT FOUND IN'.
To delete all references, you need to set up a Trigger.
O
In the last episode (Aug 24), Pag said:
> Heres the problem. I have one of my client's site hosted on a
> crappy server, and i have it running with php+mysql ok, the thing is
> i need to connect to that site's mysql's database from a remote site
> to get some data. The problem is that on the
Hello,
I've downloaded 4.1 and am experimenting with a thai-english word list
to discover just how this will work with mysql.
So far I'm not having success.
First I tried
create table words (
thai varchar(30) character set tis620,
thai_sense int,
english varchar(30) character set latin
Heres the problem. I have one of my client's site hosted on a crappy
server, and i have it running with php+mysql ok, the thing is i need to
connect to that site's mysql's database from a remote site to get some
data. The problem is that on the origin site (the crappy server), to
connect to th
* Robert Morgan
> Hi, is it possible to link databases within mysql?
I'm not sure what it means to "link databases"...
> I have a
> access database that I need to import into mysql this db consists
> of 4 other dbs linked together sharing a common switchboard. Can
> I link the tables in one db to
* Andy Jackman
[...]
> Spelling mistakes: ORACLE has a SOUNDEX() function which returns the
> phonetic pronunciation of a word. This can help in fuzzy searches. I
> don't know of similar functions in mysql
The SOUNDEX() function is also supported n MySQL:
http://www.mysql.com/doc/en/String_funct
Asif,
- Original Message -
From: "Asif Iqbal" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Saturday, August 23, 2003 10:09 PM
Subject: innodb doc in mysql.com
> In mysql.com site on section 7.5.4.1 it says and I qoute
>
> "If something goes wrong in an InnoDB database cr
30 matches
Mail list logo