Hi Everybody,
I need a suggestion regarding mysqldump. My problem is my application is
creatiing around 500Mb of data per day. As i want my application run
24*7*365. I need a mechanisem where i can move, previous day's data to
another location(i.e) at any given time i just want to store one or
Is it possible to setup replication so you would have another server to do
backups on? Replicate the data, do whatever you want to the spare, and then
delete the data from the production server.
On 4/19/06, balaraju mandala [EMAIL PROTECTED] wrote:
Hi Everybody,
I need a suggestion
--
Ed Pauley II
Internet Software Developer
Bloodstock Research Information Services
859.223.
800.354.9206 ext. 297
[EMAIL PROTECTED]
http://www.brisnet.com
http://www.brisbet.com
---BeginMessage---
If I am not mistaken deleting from the production server would delete
the data on the
If I am not mistaken deleting from the production server would delete
the data on the slave in a replication environment.
Not if you disable the binlog of the query that will delete data...
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
out of curiosity, how do you do that?
Daniel da Veiga wrote:
If I am not mistaken deleting from the production server would delete
the data on the slave in a replication environment.
Not if you disable the binlog of the query that will delete data...
--
Daniel da Veiga
Computer Operator
On 4/19/06, Ed Pauley II [EMAIL PROTECTED] wrote:
out of curiosity, how do you do that?
Daniel da Veiga wrote:
If I am not mistaken deleting from the production server would delete
the data on the slave in a replication environment.
Don't get me wrong, try not to top-post, it makes the
Daniel da Veiga wrote:
On 4/19/06, Ed Pauley II [EMAIL PROTECTED] wrote:
out of curiosity, how do you do that?
Daniel da Veiga wrote:
If I am not mistaken deleting from the production server would delete
the data on the slave in a replication environment.
Don't get me
Thank you guys, let me try in this way, i will come back if i get any
problems.
On 4/19/06, balaraju mandala [EMAIL PROTECTED] wrote:
Hi Everybody,
I need a suggestion regarding mysqldump. My problem is my application is
creatiing around 500Mb of data per day. As i want my application
