Results 1 to 17 of 17
-
03-08-2012, 11:13 AM #1Junior Guru
- Join Date
- May 2003
- Location
- Sweden
- Posts
- 185
How do I sync data between servers?
I have migrated to a new server and some data ended up on the old server (don't ask...). Now I need to sync the old data to the new server and I wonder what the easiet way to do that is (and yes, if you want to help me with it feel free to send a PM)
-
03-08-2012, 11:16 AM #2Web Hosting Master
- Join Date
- Feb 2007
- Posts
- 3,666
ReliableSite.Net LLC - Offering Enterprise Grade Dedicated Servers Since 2006 [New York City metro / Miami, FL / Los Angeles, CA]
Customers are our #1 priority - Read Our Reviews
Need epic pricing on 1G and 10G unmetered? We have amazing deals and a 10 minute setup time! Click here to view incredible deals.
-
03-08-2012, 11:22 AM #3Junior Guru Wannabe
- Join Date
- Feb 2012
- Posts
- 36
Linux:
Rsync - best solution. If you are looking for something automated then you can also use an ssh trust and have it run nightly.
Windows:
Robocopy - best solution. Command line tool that gives you the same type of options as rsync.███ - PlanetSudoku.com
███ - Millions of Sudoku puzzles including Sudoku 9x9, Multi 2, Multi 4, and Samurai
███ - Puzzles from Very Easy to Hard, Logical Solver, Custom Backgrounds, Learning Center, and more...
-
03-08-2012, 11:23 AM #4Junior Guru
- Join Date
- May 2003
- Location
- Sweden
- Posts
- 185
Yes, but I am unfamiliar with how to set it up and seem to recall that using it on cPanel servers is not always a good idea?
-
03-08-2012, 11:24 AM #5Web Hosting Guru
- Join Date
- May 2009
- Posts
- 312
You can rsync the data over to the new server.
-
03-08-2012, 11:27 AM #6Web Hosting Guru
- Join Date
- May 2009
- Posts
- 312
-
03-08-2012, 11:27 AM #7Newbie
- Join Date
- Jan 2012
- Posts
- 22
The good choice is rsyncing as it will not overwrite existing data but copies the data which is not in new server.
-
03-08-2012, 11:56 AM #8Junior Guru
- Join Date
- May 2003
- Location
- Sweden
- Posts
- 185
Anyone know a good tech that could help with this?
-
03-08-2012, 12:34 PM #9Junior Guru Wannabe
- Join Date
- Dec 2010
- Location
- UK
- Posts
- 80
No need to pay a tech, just get something such as this going in a screen on the new server:
Code:rsync -avhzS --stats --progress root@oldserver:/home/userold/ /home/usernew/
-
03-08-2012, 01:27 PM #10Disabled
- Join Date
- Nov 2011
- Location
- Nasik, MH,INDIA
- Posts
- 862
You just need to shot following command for sync between two server.
rsync -avz "directory path" root@yourserverIPorhostname:directory where you want to sync your data.
I hope it's helpful for you.
-
03-08-2012, 01:47 PM #11Junior Guru
- Join Date
- May 2003
- Location
- Sweden
- Posts
- 185
The problem seem to be that I have new data from today so syncing the old data from yesterday would not work?
-
03-08-2012, 01:48 PM #12Junior Guru
- Join Date
- May 2003
- Location
- Sweden
- Posts
- 185
Just to clarify I need to move MySQL data and emails, not WWW content.
-
03-08-2012, 01:59 PM #13Web Hosting Master
- Join Date
- Oct 2002
- Location
- Vancouver, B.C.
- Posts
- 2,699
rsync is only worthwhile if you already have a copy of data on the other server, and you just want to transfer over the differences. If you have to transfer over the whole thing, it will be a slow method of doing this.
I would highly recommend using the tcputils package from the Debian project, to create a TCP connection between the two servers. If you're running a Debian based OS, install the package like this:
Code:apt-get install tcputils
http://ftp.de.debian.org/debian/pool....2.orig.tar.gz
Then, tarball the files to stdout, piped over the TCP connection. This method is several times faster than rsync, regular scp, or even scp with compression enabled.
http://www.webhostingtalk.com/showpo...1&postcount=16
Once you have tcputils installed on both side, just do the following:
destination:
Code:tcplisten -r <port> | tar xzvf -
Code:tar czvf - <files or folder> | tcpconnect -i <destination ip> <port>
ASTUTE INTERNET: Advanced, customized, and scalable solutions with AS54527 Premium Performance and Canadian Optimized Network (Level3, Shaw, CogecoPeer1, GTT/Tinet),
AS63213 Cost Effective High Performance Network (Cogent, HE, GTT/Tinet)
Dedicated Hosting, Colo, Bandwidth, and Fiber out of Vancouver, Seattle, LA, Toronto, NYC, and Miami
-
03-08-2012, 02:05 PM #14Junior Guru
- Join Date
- May 2003
- Location
- Sweden
- Posts
- 185
Would this work to sync the missing emails and datbase entries?
-
03-08-2012, 02:55 PM #15Disabled
- Join Date
- Nov 2011
- Location
- Nasik, MH,INDIA
- Posts
- 862
What error are you getting while sync data on server ? Also let me know are you using any control panel ?
-
03-08-2012, 03:25 PM #16Web Hosting Guru
- Join Date
- May 2008
- Location
- Philadelphia, PA
- Posts
- 250
As most already said rsync is likely your best option:
remote -> local
rsync -avzr -e ssh user@host:/remote_directory /local_directory
local -> remote
rsync -avzr -e ssh /local_directory user@host:/remote_directory
Where "a" is the archive flag which preserves permissions and ownership ect.
Where "v" is for verbose output
Where "z" is for compression
Where "r" is for recursive rsync
Where "-e ssh" explicitly specifies SSH protocol.Database By Design, LLC
Philadelphia, PA Datacenter (401 North Broad)
Premium Dedicated Server Hosting, Complex Hosting Solutions and Public/Private Cloud.
866.488.7770 | Contact Us | www.databasebydesignllc.com
-
03-08-2012, 04:45 PM #17Disabled
- Join Date
- Mar 2012
- Posts
- 12
What type of data is it? Are we talk database data or just normal files?
Similar Threads
-
Sync data to backup server
By cian1500ww in forum Dedicated ServerReplies: 2Last Post: 07-06-2010, 07:55 AM -
How to sync data from old server?
By Cyber404 in forum VPS HostingReplies: 5Last Post: 04-19-2010, 04:19 AM -
Suggestions for data sync between to servers, different locations
By hartwelltv in forum Dedicated ServerReplies: 5Last Post: 10-25-2007, 12:44 AM -
Full data / user sync. between two cpanel boxes possible?
By DataCentric in forum Hosting Software and Control PanelsReplies: 4Last Post: 06-19-2006, 02:36 PM -
Is it possible to use 2 dedicated servers and sync data for 100% uptime?
By morehost in forum Web HostingReplies: 6Last Post: 10-18-2004, 07:40 PM