Re: automation question

2008-01-04 Thread Moon's Father
fidentiality note > >> Everything in this e-mail and any attachments relates to the official > >> business of Sender. This transmission is of a confidential nature and > >> Sender does not endorse distribution to any party other than intended > >> recipient. Send

Re: automation question

2008-01-03 Thread B. Keith Murphy
nded recipient. Sender does not necessarily endorse content contained within this transmission. > Date: Thu, 3 Jan 2008 13:06:07 -0500 > From: [EMAIL PROTECTED] > To: mysql@lists.mysql.com > Subject: automation question > > Everyone, > > So, I have been thinking recently abou

Re: automation question

2008-01-03 Thread B. Keith Murphy
gt; Date: Thu, 3 Jan 2008 13:06:07 -0500 > From: [EMAIL PROTECTED] > To: mysql@lists.mysql.com > Subject: automation question > > Everyone, > > So, I have been thinking recently about automation. This morning I > listened to a talk by one of the three dbas at Youtube (from the My

RE: automation question

2008-01-03 Thread Martin Gainty
and Sender does not endorse distribution to any party other than intended recipient. Sender does not necessarily endorse content contained within this transmission.> Date: Thu, 3 Jan 2008 13:06:07 -0500> From: [EMAIL PROTECTED]> To: mysql@lists.mysql.com> Subject: automation question

automation question

2008-01-03 Thread B. Keith Murphy
Everyone, So, I have been thinking recently about automation. This morning I listened to a talk by one of the three dbas at Youtube (from the MySQL Users Conference last year). Think about that. They mentioned 100,000,000 pageviews in one day (the data was from 2006). And THREE dbas. Of

RE: automation question: How do I copy the data from one table to another table with a time stamp every night?

2001-01-24 Thread Mark Maunder
from one DB, parsing and inserting into another. Mark. -Original Message- From: Chuck Barnett [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 24, 2001 6:22 PM To: Steve Ruby Cc: [EMAIL PROTECTED] Subject: Re: automation question: How do I copy the data from one table to another table wi

Re: automation question: How do I copy the data from one table to another table with a time stamp every night?

2001-01-24 Thread Eric Frazier
Hi, I do what to know this literal question. But what about if you are doing this across two servers? You certainly don't want to copy they whole table to the second database to update the second with the first. And I know someone will say use replication, but I am more interesting in a general

RE: automation question: How do I copy the data from one table to another table with a time stamp every night?

2001-01-24 Thread Cal Evans
CRON job. 'course you could do it in PERL as well. Cal http://www.calevans.com -Original Message- From: Chuck Barnett [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 24, 2001 12:22 PM To: Steve Ruby Cc: [EMAIL PROTECTED] Subject: Re: automation question: How do I copy the dat

Re: automation question: How do I copy the data from one table to another table with a time stamp every night?

2001-01-24 Thread Steve Ruby
Chuck Barnett wrote: > > Thanks for replying. > I know the SQL commands, I want to know how to automate the whole sequence. > > I've always written php pages that do the calls. I want to write a script > to do it on the server as a cron job or something. Ahhh, pardon my confusion, since this

Re: automation question: How do I copy the data from one table to another table with a time stamp every night?

2001-01-24 Thread Chuck Barnett
y" <[EMAIL PROTECTED]> To: "Chuck Barnett" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, January 24, 2001 12:34 PM Subject: Re: automation question: How do I copy the data from one table to another table with a time stamp every night? > Chuck Barnett

Re: automation question: How do I copy the data from one table to another table with a time stamp every night?

2001-01-24 Thread Steve Ruby
Chuck Barnett wrote: > > How do I copy the data from one table to another table with a time stamp > every night? > > example: table A contains x,y,z. > > at midnight, I want to copy table A's contents to table B (B has same > fields, just adds a date field) and reset x,y,z to zero. > what d

automation question: How do I copy the data from one table to another table with a time stamp every night?

2001-01-24 Thread Chuck Barnett
How do I copy the data from one table to another table with a time stamp every night? example: table A contains x,y,z. at midnight, I want to copy table A's contents to table B (B has same fields, just adds a date field) and reset x,y,z to zero. my setup is a cobalt raq4i MySQL 3.22.32 Thank