Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#1 2007-01-05 01:31:30

squaredeye
Member
From: Greenville, SC
Registered: 2005-07-31
Posts: 1,495
Website

copy sites assetts/sql on a regular basis for testing

I am interested in maintaining a kind of sister site to one that I work on regularly. I am often making changes to the public site that I know won’t break anything, but then when I want to test things, the old sister site isn’t up to date. Is there any utility that can keep these sites in sync? So that one is the master and the other the slave. Changes made to the slave would not effect the master, but changes made to the master would affect the slave?


Offline

#2 2007-01-05 01:54:57

Walker
Plugin Author
From: Boston, MA
Registered: 2004-02-24
Posts: 592
Website

Re: copy sites assetts/sql on a regular basis for testing

if you’re using txp, just make sure the DBs synch up.

If you need the actual files to synch up too, consider using subversion and then checking out to each server.

Offline

#3 2007-01-05 02:34:53

squaredeye
Member
From: Greenville, SC
Registered: 2005-07-31
Posts: 1,495
Website

Re: copy sites assetts/sql on a regular basis for testing

I’ve not walked headlong into subversion. I probably need to at some point, but had hoped that there was some nice script to run instead of needing to learn how to use SVN.

Thanks for the input.


Offline

#4 2007-01-05 03:18:14

Mary
Sock Enthusiast
Registered: 2004-06-27
Posts: 6,236

Re: copy sites assetts/sql on a regular basis for testing

Doing an svn checkout can really fudge up your permissions though, I don’t really recommend it for a live site. For files, I would look for a simple FTP synch utility.

Offline

#5 2007-01-05 04:00:56

squaredeye
Member
From: Greenville, SC
Registered: 2005-07-31
Posts: 1,495
Website

Re: copy sites assetts/sql on a regular basis for testing

okay, fairplay. That’s what I’m doing now. Just thought I’d check.
Thanks.


Offline

#6 2007-01-05 04:43:05

hcgtv
Plugin Author
From: Key Largo, Florida
Registered: 2005-11-29
Posts: 2,722
Website

Re: copy sites assetts/sql on a regular basis for testing

matthew,

If you have a Linux box, rsync is a dream to use. It’s what I use to keep my home server in sync with my VPS. On a Windows machine, WinSCP does synchronization rather well for files, and for the databases, if they are small enough, you can have AutoMySQLBackup mail them to you.

Offline

#7 2007-01-05 05:01:04

squaredeye
Member
From: Greenville, SC
Registered: 2005-07-31
Posts: 1,495
Website

Re: copy sites assetts/sql on a regular basis for testing

hcgtv,
I should probably check with my host to see if they have a emailing backup scheme? Still though, it would be nice to have this purely automated. dream dream dream


Offline

#8 2007-01-05 07:15:12

mrdale
Member
From: Walla Walla
Registered: 2004-11-19
Posts: 2,215
Website

Re: copy sites assetts/sql on a regular basis for testing

rsync is automatic via a cron job or 2. Just did it myself in fact. I also use…

[edit]
autoMySQLbackup is a super, auto database backup solution too. Set it up once. Set up a gmail account as a backup location and email yourself daily, weekly, monthly backups of all your DBs.

Last edited by mrdale (2007-01-05 17:08:43)

Offline

Board footer

Powered by FluxBB