Thread

I am trying to port my production site from Engine Hosting down to an XAMPP “localhost” development and test server.  Which, for the most part, is now working fine.

My question/problem is that, if I now rework section/blob page content using the local EE CP Edit function, how can I selectively move these updates back to my production MySQL database on Engine Hosting as a partial restore and not a wholesale restore of the whole database?

Any and all suggestions on this one are VERY MUCH welcomed.  Thanks!!  Larry A.

Hi, Larry. One way of doing this is to use a third party add-on called DataGrab. You’ll find it on Devot-ee.com. It’s not free, but does allow you to import via an RSS feed, or a .csv file, that sort of thing. There are other ways of getting the information back in there, are you using categories?

Are these new channels, or have you created any newer custom fields?

Thanks, Sue.  Not sure about categories.  I’m thinking not.  We just have straight EDIT tab pages, and we edit pages individually as we ready our start-up company’s pitch content and devlivery through a successive series of screens all using the same template page and format.  But, yes, I have defined 2 or 3 custom fields as well which are integral to our pages working.  For instance, a “next: ” link.  And image references and captions.

I want to be able to tweak our content delivery off-line separate from our production site.  Once good, I then want to move back over to production.

I’m thinking that an EDIT page likely translated to one defined SQL table, and that it might be possible to grab and work with those records separately and individually using SQL.  If so, I’d have to consider myself extremely lucky if it is that “easy”.

And I’m thinking that I can’t be the first to have wrestled with this question.  Though the commentary I’;m reading on how to use git with EE all specifically seem to indicate that the DB side of version control is still a difficult animal.

But I thought I would start here and ask. Again, any suggestions are greatly appreciated.

Thanks!!  Larry A.

The DataGrab add-in, unfortunately, is for EE 2.x and I’m currently running 1.6.9 and not quite yet in position, timing wise, to convert, though I have purchased the 2.0 license.

So, my other thought is to perhaps use a browser macro add-in, such as iMacro, to naviagte to Edit pages, pull off all field content, and then apply in reverse on the other server.

Anyone have any experience with such an approach?  And possible suggestions?

Thanks.

My apologies for not remembering you were using EE1.x.

However, if you aren’t using categories, there are only two tables that are going to be at play:

exp_weblog_titles
-and-
exp_weblog_data

I’d make sure to keep custom fields and the like in sync between your local install and your eventual “real” install.

Your other option is to develop on the regular server, with some creating renaming.. but that may be more trouble than it’s worth.

That looks to be pretty straight forward.  I’ll pull the tables up and give a look.  Thanks!!

Very good. Please let us know if there’s anything else we can do for you.