Mysql – How to setup separate MySQL and PHP VPS servers

Yes, you can make your own virtual server and it can run from a laptop.

It might not be very fast. I wouldn't recommend an Atom CPU based laptop. Something with dual core like an Asus N would be fine though. Try to have at least 2Gb of RAM on your laptop, so you can give the virtual system 1Gb or so.

First, install SUN VirtualBox (Free at http://www.virtualbox.org) to create the virtual machine. When setting this up there is a Networking option. You can choose from NAT (it can get out but others cant get in), Bridged (asks for a new IP address from your network's DHCP server and is fully on the network for 2-way traffic), or internal network (no internet traffic, internal only -- useful if you have several virtual boxes). The Bridged setting is still fairly safe if your laptop is attached to one of those home networking boxes. You may encounter some issues using wired vs wireless on your laptop. Wired works better.

On the virtual machine, install a Linux of the same flavor as the ISP will use and you will have a virtual linux computer you can play with from under windows.

This won't match exactly, but can get you started.

If you can't find the ISPs linux -- if you want something easy to install, try installing Ubuntu on the virtual box. If you install Ubuntu server edition it has most everything you want already.

I installed IUS and RPM Forge Release and then removed old packages. with a dump from MySQL for sure. and then re-installed PHP54 and MySQL55.

assuming it's CentOS/RHL 5 and you have old PHP & MySQL installed

first find all packges related to php by:

rpm -qa | grep php

then remove matched packages:

yum remove [packages]

then search for mysql:

rpm -qa | grep mysql

again remove matched packages:

yum remove [packages]

now install IUS & RPMForge release for latest versions of PHP and MySQL:

wget http://dl.iuscommunity.org/pub/ius/stable/Redhat/5/i386/epel-release-5-4.noarch.rpm
wget http://dl.iuscommunity.org/pub/ius/stable/Redhat/5/i386/ius-release-1.0-10.ius.el5.noarch.rpm
wget http://packages.sw.be/rpmforge-release/rpmforge-release-0.5.2-2.el5.rf.i386.rpm

Install DAG's GPG key :

rpm --import http://apt.sw.be/RPM-GPG-KEY.dag.txt

then install those rpms:

rpm -i epel-release-5-4.noarch.rpm
rpm -i ius-release-1.0-10.ius.el5.noarch.rpm
rpm -i rpmforge-release-0.5.2-2.el5.rf.*.rpm

now check for an update:

yum update

to install PHP54 & MySQL55:

yum install php54 mysql55-server

all dependencies will be installed

to install module for PHP applications that use MySQL databases:

yum install php54-mysql

restart apache:

service httpd restart

run mysql secure installation:

mysql_secure_installation

restart mysqld:

service mysqld restart

I think It's done.

and for exporting MySQL database:

mysqldump -u root -p --all-databases > all_databases.sql

to import that database I think this works:

mysql -u root -p < all_databases.sql

as you installed IUS release you can easily download latest versions of phpMyAdmin:

assuming you have installd phpMyAdmin package. remove it first:

yum remove phpMyAdmin

install phpMyAdmin3:

yum install phpMyAdmin3

then look for phpMyAdmin directory where files are stored:

whereis phpMyAdmin 

make a symbolic link of the directory that contains phpMyAdmin management interface where it is accessible from Apache

ln -s [phpMyAdmin Directory]

if you recive forbidden error while accessing phpMyAdmin from browser try this:

chown -h [user]:[group] [Path to phpMyAdmin  symbolic link]