TurnKey Linux Virtual Appliance Library

TKLBAM - what about test and live data?

Jonathan Lister's picture

Hello,

I am in a team working on a Wordpress-based web app, and we have a development process that goes local->test server->live server. It seems to me that TKLBAM could allow us to move through these steps by backing up one step and restoring at the next. I am assuming databases changes are migrated.

However, I am confused about how to handle the data - the live server has data on it being changed by other people, which we don't want to lose by accidentally overwriting with a backup from the test server.

I feel I need something a bit like "git stash" on the production server.

Any ideas?

Thanks,

 

Jonathan Lister

Don Sanderson's picture

Overrides

tklbam-backup allows 'overrides' allowing you to select folders/databases to include or exclude from the backup.

See here: http://www.turnkeylinux.org/node/1534

Not sure if this will do what you need but look it over.

If your users data is in it's own folder/folders/databases it may work for you.

And, as always, be sure the 'live server' has a current backup just in case.


Jonathan Lister's picture

Wordpress uses one big database

Thanks Don,

I believe Wordpress keeps all the data in one file, although it does make use of several tables, and some plugins create their own tables. I can see that you can specify particular tables to exclude/include when creating the backups.

However, most of the data changes that I would need to migrate through from local to test, to live, would be changes within tables - a new page, or a change to a plugin setting. I don't know how to ensure these changes don't get missed, whilst not pulling a bunch of chuff test data with it.

 

J.

Post new comment

The content of this field is kept private and will not be shown publicly. If you have a Gravatar account, used to display your avatar.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <p> <span> <div> <h1> <h2> <h3> <h4> <h5> <h6> <img> <map> <area> <hr> <br> <br /> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <em> <b> <u> <i> <strong> <font> <del> <ins> <sub> <sup> <quote> <blockquote> <pre> <address> <code> <cite> <strike> <caption>

More information about formatting options

Leave this field empty. It's part of a security mechanism.
(Dear spammers: moderators are notified of all new posts. Spam is deleted immediately)