If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > MySQL > database replication or backup

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 03-10-10, 19:55
codemerge codemerge is offline
Registered User
 
Join Date: Feb 2010
Posts: 4
database replication or backup

Hi. i am working on a project where database is growing very quickly [100MB] daily. i was reading about replication and it is offering much more i needed at the moment.
i am interested in backing up data daily to another server automatically which is my dev machine.

at the moment i use mysqldump to backup to sql file and and then restore from it.

as database size now is 4GB it takes lot of time to backup and restore.

replication looks promising but i have never done that before so i have to give a good reading to use it.

please guide me in right direction

thanks
Reply With Quote
  #2 (permalink)  
Old 03-13-10, 18:59
scottb scottb is offline
Registered User
 
Join Date: Oct 2003
Posts: 60
use a simple master slave replication, dumps take forever to load.

there is some really easy to follow instructions on the mysql.com webiste

basically you have to add a user on the master, add a little something to your my.cnf's and run the change master command..
Reply With Quote
  #3 (permalink)  
Old 03-14-10, 23:57
codemerge codemerge is offline
Registered User
 
Join Date: Feb 2010
Posts: 4
Thanks Scott.
i gave MySQL doc about replication a good reading and decided to go for replication.

thanks
Reply With Quote
Reply

Tags
backup, mysql, replication, restore

Thread Tools Search this Thread
Search this Thread:

Advanced Search
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 Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On