New answers tagged mysql
0
The thing with projects like this is it never really works the way its suppose to I've imported my database and my HTML/PHP/JS code but something is never right. To those reading about doing this its more then just code and a database, its permissions, users, etc, etc. Below are somethings I've learned, some advice, and tools I've used.
I'm using Virtual ...
2
Although it looks like Stephen answered your question I figured I would respond to the title of the question, "Setting up a LAMP VM server for Development and Testing?"
Get Virtual Box, it's free and easy to use.
Get the ISO for Ubuntu, Debian or the operating system that best mimics your production environment. You might have to spend money. Microsoft ...
2
MySql
Use mysqldump to get the data out of your live database
Transfer the dump file to your VM
Use mysql command to import the data
Here is a website that can walk you through the process: http://www.mydigitallife.info/how-to-backup-and-restore-export-and-import-mysql-databases-tutorial/
If your PHP code has the db user and password hard coded, then ...
0
not really: if you know where your code stores db access details you can create a single user on you VM mysql instance and usa those credentials to access all dbs, and configure with such details all your code
1
This is exactly what I do all the time. There is a full LAMP stack installed locally on my home machine. The hosting provider also uses LAMP and between cPanel and the output of php_info(), I know which software versions to match both configurations.
All you need is to make sure the files (PHP/HTML/CSS/JPEG/PNG/etc) are the same which you can do with rsync ...
Top 50 recent answers are included
