Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 5 of 5
  1. #1
    New Coder
    Join Date
    Jul 2009
    Location
    London, UK
    Posts
    58
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Best PHP/MySQL Development Platform?

    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
    Sean
    Attached Thumbnails Attached Thumbnails Best PHP/MySQL Development Platform?-untitled-1.jpg  

  • #2
    Codeasaurus Rex
    Join Date
    Jun 2008
    Location
    Redmond, WA
    Posts
    659
    Thanks
    31
    Thanked 100 Times in 94 Posts
    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.
    Unless otherwise stated, any code posted is most likely untested and may contain syntax errors.
    My posts, comments, code, and suggestions reflect only my personal views.
    Web Portfolio and Code Snippets: http://shanechism.com

  • Users who have thanked ShaneC for this post:

    seanhalley (04-16-2011)

  • #3
    Super Moderator Inigoesdr's Avatar
    Join Date
    Mar 2007
    Location
    Florida, USA
    Posts
    3,647
    Thanks
    2
    Thanked 406 Times in 398 Posts
    Quote Originally Posted by ShaneC View Post
    WAMP is the way to go, in my opinion. I've used it for years and it does everything I need it to.
    Agreed.

  • #4
    Banned
    Join Date
    Feb 2011
    Posts
    2,699
    Thanks
    13
    Thanked 395 Times in 395 Posts
    I use XAMPP as my local webserver.

    Netbeans as my html/css/javascript/php IDE.

    SQLyog as my SQL gui.

  • #5
    New Coder
    Join Date
    Jul 2009
    Location
    London, UK
    Posts
    58
    Thanks
    8
    Thanked 0 Times in 0 Posts
    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.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •