nixCraft Linux Forum

nixCraft

Linux / UNIX Tech Support Forum

delete bin logs in Mysql Clients

This is a discussion on delete bin logs in Mysql Clients within the Databases servers forums, part of the Mastering Servers category; i am running mysql 5, and replication is setup. i deleted the binlog files from server for space issue. my ...

Register free or login to your existing account and remove all advertisements.


Go Back   nixCraft Linux Forum > Mastering Servers > Databases servers

Linux answers from nixCraft.


Databases servers Discussions of databases of all types - especially MySQL.

Reply

 

LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 03-16-2009, 01:20 PM
kasimani's Avatar
Senior Member
User
 
Join Date: Jul 2006
Location: India, Delhi
OS: CentOS, RedHat, Fedora, Ubuntu
Posts: 151
Thanks: 3
Thanked 1 Time in 1 Post
Rep Power: 4
kasimani is on a distinguished road
Send a message via Yahoo to kasimani
Question delete bin logs in Mysql Clients

i am running mysql 5, and replication is setup.

i deleted the binlog files from server for space issue.

my question is, can i also delete these files from clients, without any trouble in future.
Reply With Quote
  #2 (permalink)  
Old 03-16-2009, 08:38 PM
nixcraft's Avatar
Never say die
User
 
Join Date: Jan 2005
Location: BIOS
OS: RHEL
Posts: 2,662
Thanks: 11
Thanked 237 Times in 177 Posts
Rep Power: 10
nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute
Default

You can't. Bin logs is used on master replication servers as a record of the statements to be sent to slave servers. The master server sends the events contained in its binary log to its slaves, which execute those events to make the same data changes that were made on the master.
__________________
Vivek Gite
Linux Evangelist
Be proud RHEL user, and let the world know about your enterprise choices! Join RedHat user group.
Always use CODE tags for posting system output and commands!
Do you run a Linux? Let's face it, you need help
Reply With Quote
Reply

Tags
bin logs , cluser , mysql , replication , server


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads

Thread Thread Starter Forum Replies Last Post
Proxy server logs upanwar Proxy Servers 2 09-28-2008 11:17 AM
Need Help in installing and configuring NIS server and clients praveenjayak Linux hardware 1 05-31-2008 05:30 PM
Delete all tables mysql under Linux jerry Databases servers 1 06-09-2007 06:50 PM
CVS logs how to rajuk Linux software 1 12-14-2006 05:44 PM
Any idea on the maximum number of NFS clients? warren Linux software 2 09-12-2006 12:40 PM


All times are GMT +5.5. The time now is 06:02 AM.


Powered by vBulletin® Version 3.8.4 - Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.3.2
©2005-2009 nixCraft. All rights reserved

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38