View Full Version : Best PHP/MySQL Development Platform?

04-15-2011, 03:06 PM
Hi all,

I have a half built site on 1and1 servers, and I want to move it to my local machine to continue the development so that I don't need to FTP files and hit refresh on my browser to view my changes.

What's a good platform for PHP/MySQL development? I've heard of WAMP and XXAMP - any recomendations for the easiest?

My other challenge is to export the existing database on 1and1 onto my local machine. When I get to the export page on 1and1, I'm presented with a few options which I don't understand (see attached image). Grateful if someone could explain some of these, e.g. what it "export type" (currently set to INSERT)?

(I have a 64-bit Windows 7 machine)

Thanks in advance

04-15-2011, 05:12 PM
WAMP is the way to go, in my opinion. I've used it for years and it does everything I need it to.

I would recommend installing WAMP (http://wampserver.com/en) and then backing up your database from your remote server.

On the page you took a screen shot of, leave all the top options the way they are and then check the box next to "Save as File." After you've checked that box, click the 'Go' button. This will download a copy of your database to your hard drive.

Once that's done you can open up phpMyAdmin in WAMP and use the Import function to choose that file from your hard drive and load it. This will create all tables and insert all the information you had in your remote database.

04-16-2011, 05:50 AM
WAMP is the way to go, in my opinion. I've used it for years and it does everything I need it to.


04-16-2011, 06:06 AM
I use XAMPP (http://www.apachefriends.org/en/xampp.html)as my local webserver.

Netbeans (http://netbeans.org/)as my html/css/javascript/php IDE.

SQLyog (http://www.webyog.com/en/)as my SQL gui.

04-16-2011, 11:36 AM
Thanks guys,

I think WAMP sounds the simplest of all.

And thanks ShaneC for the tip on exporting the DB. I'll let you know how that goes.