Daevid, another idea is to consider InnoDB Hot Backup. While it is not
free (perhaps NOT the most important point!), it does have the ability to do
online (hot backups) of InnoDB tables while they are being used and
updated. It also backs up MyISAM tables, with a minimal period of time
Hi All,
I am working on the production server. I have been assigned the task of
keeping 3 months data on the production server and archive the whole data
also and move it to another system.(Innodb data)
Experts, Please give me the efficient way of do this task.
-Regards,
Krishna
Hi all,
Most of the web site and document talk about master to slave or
master to slaves setting. Is it possible to do masters to slave
replication? Say I have 2 masters, one has a database call d1 and
other one has a database call d2. I want to replicate both d1 and d2
to a slave. Is it
Rilawich Ango wrote:
Hi all,
Most of the web site and document talk about master to slave or
master to slaves setting. Is it possible to do masters to slave
replication? Say I have 2 masters, one has a database call d1 and
other one has a database call d2. I want to replicate both d1 and d2
krishna chandra prajapati wrote:
Hi All,
I am working on the production server. I have been assigned the task of
keeping 3 months data on the production server and archive the whole data
also and move it to another system.(Innodb data)
Experts, Please give me the efficient way of do this task.
Hi Giulio !
Giulio Troccoli wrote:
Since my original post has been hijacked I'm writing a new one with
maybe some more info.
I have downloaded the GNU TAR source code. I'm using gcc 3.0.2 and GNU
make 3.76.1
I have configure as follows
CC=gcc CFLAGS=-O3 \
CXX=gcc CXXFLAGS=-O3
Hi John, all !
John Penman (jopenman) wrote:
Hello all,
I am trying to build mysql-5.0.41 under a cross compiling environment.
Below is the beginning of the configure:
[[...]] Reviewing this code leads me to believe that there is
no support for cross compiling, or I am missing something.
Joerg,
Thanks for you reply. I have to say that I was expecting a reply anymore.
Looking on the internet I found an article that simply suggested adding the
prototype for the sleep function where the compiler was complaining. I did it
and it compiled fine. And it seems to work.
Although I did
krishna chandra prajapati schrieb:
Hi All,
I am working on the production server. I have been assigned the task of
keeping 3 months data on the production server and archive the whole data
also and move it to another system.(Innodb data)
Experts, Please give me the efficient way of do
Hi there,
I have a situation where I have duplicate data within
several tables, but they are all indexed in the same way. How do I pull
out all the non-duplicate records?
Would I have to create a temporary table, add one data set, then add the
second where it doesn't equal
In the last episode (Aug 02), Giulio Troccoli said:
Anyway, as I said I managed to build it and it seems to work. We're
having some issues on upgrading to Solaris 8, that's why we still
have Solaris 6. I hope the pre-build package for Solaris 8 will work
without any intervention. But if it
Craig
How do I pull out all the non-duplicate records?
With an exclusion join. To find non-duplicates with respect to one key...
SELECT keycandidate
FROM tbl t1
LEFT JOIN tbl t2 ON t1.keycandidate=t2.keycandidate
WHERE t2.keycandidate IS NULL;
To expand the comparison to multiple keys...
After a shutdown regular on my mysql master, when the mysql process startup
apper the error below
070802 16:07:08 [Warning] The syntax for replication startup options is deprecat
ed and will be removed in MySQL 5.2. Please use 'CHANGE MASTER' instead.
070802 16:07:10 InnoDB:
Hello, I'm not sure if I can use union here or what syntax I should use.
I will simplify the tables to only include the necessary information.
I have table1 containing : message, senderid, reference
and table2 contains: senderid, name, address
I want to do a query that gives me : message,
Richard
I have table1 containing : message, senderid, reference
and table2 contains: senderid, name, address
I want to do a query that gives me : message, reference and name ...
Do you mean ...
SELECT t1.message, t1.reference, t2.name
FROM tbl1 t1
JOIN tbl2 ON t1.senderid=t2.senderid;
PB
I have a database tracking registrations of software products with two related tables, registered_products and people. I need to pull a list of email addresses from the people table BUT I only want to pull people records who own very specific combinations of products from the registered_products
select distinct email_address
from people P,registered_products A,registered_products B
where P.person_id = A.person_id
and A.product_type = Product A
and P.person_id = B.person_id
and B.product_type = Product B
;
Give it a try !!!
- Original Message -
From: Benjamin Ventura
That query will give one row per table1 row matching your WHERE clause,
with matched row from table2. Is that what you want?
PB
Richard wrote:
Thanks,
I think I have found the correct syntax in a book I've got :
SELECT A.message,B.name
FROM table1 A
JOIN table2 B ON A.senderid=B.senderid
Hi Benjamin,
Benjamin Ventura wrote:
I have a database tracking registrations of software products with two
related tables, registered_products and people. I need to pull a
list of email addresses from the people table BUT I only want to pull
people records who own very specific combinations
Brilliant, this one works perfect! Thank you for the quick reply!
Ben
Rolando Edwards wrote:
select distinct email_address
from people P,registered_products A,registered_products B
where P.person_id = A.person_id
and A.product_type = Product A
and P.person_id = B.person_id
and
Hello,
My client has a mfg. unit at 65 Km from a city in India. He wants to connect
to his corporate office in the city. Both offices will use same data and
same ERP system. He is using Win 2K3 server and MySQL 5.0.17. Is it possible
to make them synchronized at a particular or regular intervals?
I've tried it and it does not work,
the problem is that there needs to be 1 table1 row for each table2 row,
and table 1 is the message list and the table two is the members
information list.
So I need the same row to be joined to all the message rows with the
same senderid ...
I guess I
Replication works with Windows (we do it extensively here at work). And
it's definitely one option. But if there are any problems, then without
some monitoring mechanism, you'll not be alerted if replication chokes
(all that will happen is that updates to the slave will seemingly just
stop).
Richard,
This is elementary---you most definitely do not need to do it with PHP
code. Given tables messages(senderid, message, reference) and
senders(senderid, name, address), this query
SELECT m.message, m.reference, s.name
FROM messages m
JOIN senders s ON m.senderid=s.senderid
WHERE
Hi:
I use 5.0.38 on my ubuntu desktop
and I have to work with ver 3.23.56 on a solaris-based server.
The following update query:
UPDATE wine_list,FRED SET wine_list.wine_ID=FRED.WMJ_ID WHERE
wine_list.wine_ID=FRED.wine_ID;
works on 5.038, but on 3.23.56 I get the following:
ERROR 1064 (0):
Hi,
Tim Johnson wrote:
Hi:
I use 5.0.38 on my ubuntu desktop
and I have to work with ver 3.23.56 on a solaris-based server.
The following update query:
UPDATE wine_list,FRED SET wine_list.wine_ID=FRED.WMJ_ID WHERE
wine_list.wine_ID=FRED.wine_ID;
works on 5.038, but on 3.23.56 I get the
Hi
My guess is I have not described my problem well enough then ...
Here is an example of table one :
MESSAGE | REFERENCE | SENDER
message1 text | 05 | M01
message2 text | 10
On Thursday 02 August 2007, Tim Johnson wrote:
Hi:
I use 5.0.38 on my ubuntu desktop
and I have to work with ver 3.23.56 on a solaris-based server.
The following update query:
UPDATE wine_list,FRED SET wine_list.wine_ID=FRED.WMJ_ID WHERE
wine_list.wine_ID=FRED.wine_ID;
works on 5.038, but
DROP TABLE IF EXISTS messages;
CREATE TABLE messages( message text, reference char(10), sender char(10));
INSERT INTO MESSAGES VALUES
('message1 text' , '05' , 'M01'),
('message2 text' , '10' , 'M15'),
('message3 text' , '05' , 'M04'),
('message4
Thanks!!
I must have a problem with my code then !! I will check it out then.
Peter Brawley a écrit :
DROP TABLE IF EXISTS messages;
CREATE TABLE messages( message text, reference char(10), sender char(10));
INSERT INTO MESSAGES VALUES
('message1 text' , '05' , 'M01'),
Hi,
Set up two-way replication between Corporate and Manufacturing. As long
as a live network connection is available between the two sites,
replication will carry on. Make sure that all your hardware is able to
handle the peak I/O loads, in order to keep replication humming along
seamlessly.
If
Thanks for your help.
From: Peter Brawley [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 02, 2007 10:47 AM
To: Weston, Craig (OFT); mysql@lists.mysql.com
Subject: Re: [mysql] reverse join
Craig
How do I pull out all the non-duplicate records?
With an
i have a Database called Betatest in MySQL
i have three tables : Projects
ProjBom
Inventory
i wanna enter into projects the project name and date and later on i
wanna be able to add the Projectbom(bill of
Hello, I've got a good book for learning php, very complete and goes
through almost everything. However I'm now looking for a good mysql
book. I don't want ebooks, only paper versions.
I know how to connect and the real basics of mysql (I can connect, do a
basic search, insert data etc ...
MYSQL Third Edition by Paul DuBios (a frequent list contributor)
On 8/2/07, Richard [EMAIL PROTECTED] wrote:
Hello, I've got a good book for learning php, very complete and goes
through almost everything. However I'm now looking for a good mysql
book. I don't want ebooks, only paper versions.
He's saying that instead of this:
fprintf (fp1, r[content]);
You at least want something like this:
fprintf (fp1, %s, r[content]);
if you're going to use fprintf, or, if you want something more
c++-like, you'd use a function besides fprintf altogether.
Thank's I have already seen this book, says it's well transladed, but as
I am also fluent in French and don't like translations ( I've had a few
problemes with English books badly translated to French) I tried to find
it in it's original language but could not.
However if you say it's good in
At 3:31 PM -0700 8/2/07, sol beach wrote:
MYSQL Third Edition by Paul DuBios (a frequent list contributor)
I think that's slightly misspelled. Perhaps you meant dubious? :-)
On 8/2/07, Richard [EMAIL PROTECTED] wrote:
Hello, I've got a good book for learning php, very complete and goes
38 matches
Mail list logo