Wordpress development IDE

Hello guys,

I want to ask what is the most effective way moving a WP site between:

1. local server (I use XAMP)

2. testing server on my domain

3. client's server

I've done pure front-end only to this time but I started to learn how WP (client's just want it so bad) works and some basic php which would totally be enough for my side jobs (microsites).

Main issue is that DB migration. Doing it manually is kind of pain so how do you guys do it? How do you develope a WP site if you just want to make a some changes to the theme (via child theme) and be time efficient?

Disclaimer: "I do know only a bit about DB".
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

F PCommented:
You would have to first define when the commit would occur. How do you define when something should go live vs stay in development?
F PCommented:
I wrote a DB migration PHP application once which transfers and restores databases, which I could modify and show you the code if you want...
Fajer39Author Commented:
Well, I mean to develope the core things locally, then move it to test server where copywriters / seo guys etc. can then fill the content through admin panel and then after testing I want to move it to client's server.

Frank it would be really nice of you if you show me the code. I know there's a plugin called BackupBuddy which offers the migration too, but especially on microsites or maybe some minor changes to the theme it's pricy for me. Nowadays when freelancer, odesk and others push the price for this side jobs so down I would need an effective solution.
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

F PCommented:
This is a solution which is not designed for Wordpress, is designed for people who can work directly with PHP from a command line, and is not simple. I do have a degree in programming, and it's the best I could do with PHP about a year and a half ago. This literally does a MySQL dump for each table with the data, then uses SCP to send the dumps over to another server, then you can loop the code into a batch array of queries which does a  LOAD DATA INFILE, but.......

again this needs to be run once on each machine and is not a fully operational turnkey solution.

It does work though! (names, ip's, and passwords have been changed to protect the innocent.)

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Fajer39Author Commented:
Ok Frank, thank You very much. I'm sure I can benefit from your script in the future so It's very generous from you.
F PCommented:
Good luck!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.