Sync/Version control

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Sync/Version control

Postby kateland » 14. April 2013 13:12

Hi all,

I'm looking for advice on setting up a development environment. I am using Win 7 locally with Xampp 1.8.1, and want to sync to an Apache remote db testing server. I'd also like to easily push testing to production. Right now my push process is manual and tedious.

I currently use Editplus 3 to individually save scripts on the remote server.

I want to sync a Wordpress db, files, and a phpbb community (also php and mysql). I am not a pro developer and have never used versioning. If anyone has suggestions of what setups I should investigate I would really appreciate it.

Thanks,
Kate
kateland
 
Posts: 4
Joined: 12. April 2013 01:19
XAMPP Version: 5.6.3
Operating System: Win 7 64 bit

Re: Sync/Version control

Postby kateland » 18. April 2013 13:28

Bump - does anyone use mysql replication or a tool that can be configured to do so? What editor do you like?
kateland
 
Posts: 4
Joined: 12. April 2013 01:19
XAMPP Version: 5.6.3
Operating System: Win 7 64 bit

Re: Sync/Version control

Postby Nobbie » 18. April 2013 14:07

kateland wrote:I'm looking for advice on setting up a development environment.


Xampp already is an development environment.

kateland wrote:I'd also like to easily push testing to production. Right now my push process is manual and tedious.


There is no standard tool for such complex process. I recommend to use the following standards:

a) Use same domain name for your local development as for production. Therefore you should apply the domain name to the local development to the hosts file of windows.

b) Use same directory names for development and production (as far as possible).

c) Use same MySQL Release and same PHP release as far as possible.

There is stil no other way than pushing manually your locally developed software to the production server. If you use same MySQL Releases (or at least Major Releases, MySQL 5.x for example), it might be enough to copy the whole MySQL data folder (which holds all databases and tables) between production and development.

My personal editor is "vi" on linux systems, sometime as well on windows (whereas I also like "TextPad" on Windows). Keep in mind, that on Windows text lines end differently to linux with "\r\n" (Carriage Return, Newline), whereas linux textfiles usually only have "\n" (Newline) at the end of textlines. Your Editor should support linux style textfiles. Usually FTP can handle this by setting transfer mode to ASCII instead of BINARY, but I do not recommend this handling, as it often leads to corrupted files when used in the wrong context. Therefore i recommend to use BINARY Transfer always and use an Windows Editor which supports linux like textfiles.

kateland wrote:I want to sync a Wordpress db, files, and a phpbb community (also php and mysql). I am not a pro developer and have never used versioning. If anyone has suggestions of what setups I should investigate I would really appreciate it.


See my comments above. But dont forget: this is NOT an Wordpress, phpbb etc. forum, this is the Xampp forum. Your questions are far from the goal of this forum.

P.S.: What you are looking for ist not "versioning" (this is for "versions" only), instead you are looking for (very sophisticated) "cross development" (as you want to develop on Windows Systems, where the production environment is a Linux server). This has always been a very sophisticated task and i dont know any tools which will do the necessary steps automatically. There are too many differences between the production and the target environment.
Nobbie
 
Posts: 7147
Joined: 09. March 2008 13:04

Re: Sync/Version control

Postby kateland » 18. April 2013 14:29

I appreciate your feedback. I'm a junior developer (and it's only a hobby, not a job) so I apologize for using the wrong forum and terminology :)

I figured developing on a local windows machine and pushing to a remote Apache server would end up being manual, just thought I'd check with people who know a lot more in case there's a tool I could try. I used to only use Notepad for dev back in the day but I find the remote opening/saves/project collections in EditPlus to be helpful. I do transfer in ASCII for certain file extensions and binary for media/images etc, been down that road many times over the years!

Anyway, again, thanks for the feedback. I'll look into mysql replication and just be vigilant about the steps I take to push out to staging and prod.
kateland
 
Posts: 4
Joined: 12. April 2013 01:19
XAMPP Version: 5.6.3
Operating System: Win 7 64 bit


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 33 guests