Question: Is there a way to test for correctness once the SQL DB copy has been installed on the local machine so I can confidently move to step number 3? Is there any information on the web that would help with the below goals? Are the below goals even possible or a good idea?
Info: I would like to set up a VM server on my local computer which will serve pages in the exact same way as my current hosting(but only to me on my local computer). I currently pay a big web hosting company to host my website & web store and they are doing a great job, but I would like to be able to work on my Web store and its corresponding MySQL database without being at risk of messing something completely up on the live servers.
My current plan of action:
- Set up a VM with debian server, MySQL, PHP, Apache(or something else)
- Copy my current MySQL databases from my hosting provider and install on VM server.
- Copy web store (PHP/HTML) code to VM server.
- Modify and test new features on VM server.
- upload MySQL DB and HTML/PHP code back to web host's server where it should work as before but with new modifications.
Now I'm pretty sure I have step one down correctly but I can't for the life of me figure out where to began for steps 2 and 3. I've looked online for resources about how to make a 1 to 1 copy and install the database on a different machine but none of the information seems to be working or correct for my SQL DB (MySQL).