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 > Synchronizing DBs

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 02-21-09, 14:37
barleytwist barleytwist is offline
Registered User
 
Join Date: Feb 2006
Posts: 7
Synchronizing DBs

I have a wamp server website with mysql locally (laptop at home) and a puclic hosted website with mysql. I usually make changes locally test them and then upload the folders, etc. I need some easier way than just exporting the DB and going to my remote CPanel and phpMyAdmin to import the DB to get the changes synchronised. Can someone advise on a good method/program which will do this for me? I envisage something on my home setup which can (FTP?) inject the updates to the public DB. Maybe something which works both ways in case I change the public one first (but that's an extra really)?
Reply With Quote
  #2 (permalink)  
Old 02-22-09, 09:42
barleytwist barleytwist is offline
Registered User
 
Join Date: Feb 2006
Posts: 7
Hm, Doesn't exactly seem to describe a synchronising facility. Does it compare from the client end and then produce an update script with only the differences or is it a total migration tool?
Reply With Quote
  #3 (permalink)  
Old 02-22-09, 15:59
Pat Phelan Pat Phelan is offline
Resident Curmudgeon
 
Join Date: Feb 2004
Location: In front of the computer
Posts: 12,609
There was an advertising post between barleytwist's two posts. I moved that post to the MarketPlace forum, where advertising posts are permitted.

Although it seems kind of complex for this usage, would My-SQL Replication do what you want?

-PatP
Reply With Quote
Reply

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