This is my first post and it is a newbie question for sure.. I promise to contribute once things get rolling, even if on a small scale.
I have always wanted to learn php/mysql but could never get that first step going. I am familar with client/server, html, mysql, etc. as I have a very active social network website. The thing is I have worked from the role of project manager for virtually every module we create on my network. Therefore I have become very familar with the general concepts, but I am reliant upon the developers to do the actual work. I would very much like this to change so I need to learn..
Ok, so I have an existng website on an Apache server (CENTOS 5.10) running PHP 5.2.17 and Percona 5.5.35. I am comfortable accessing the server directly and making small modifications via SFTP and SSH and even accessing phpmyadmin to access the tables directly.
However I want to create a project and import my entire site into phpstorm. Thus being able to work locally on the files/database. This way I can work on the site in the same way as if it was online, but do it all from a local environment. Then once the work is completed and tested on the local machine I can upload it to the live environment.
I created a new project, then clicked on 'tools' -> 'deployment' -> 'configuration'. I then entered the settings and was able to connect to the remote host. Then from the New Project wizard, choose New Project from Existing Files. The site files were then imported.
But it appears that right now it is just the files and site struture. What I want to do is build a full replica of my site (database included), so I can work on the site locally.
Do I need to install WAMPServer to act as the mysql database? I am sorry for such a basic question..