Create multiple SFTP user in a VPS for accessing respective website folders. Access is limited to the respective folders only. Use FileZilla to access remote Host.
ubuntu
MySQL Commands for Hosting in Linux VPS
You need to copy olddb.sql file to your new host. You may use FTP programme to download the SQL file from old host and then upload to the new host.
Implement Sphinxsearch in phpBB
Sphinxsearch is believed to be the fastest search engine. It is very much useful for large websites. Sphinxsearch can only be installed in a Nginx server.
PHP: Missing MySQL Extension
Your PHP installation appears to be missing the MySQL extension which is required by WordPress. Run: apt-get install php5-mysql in hosting account.
Error: Unable to Resolve Hostname
After changing hostname of your VPS, you need to restart VPS (Type sudo reboot in command line). This will solve the issue, “Unable to resolve hostname”.
Host Websites in Linode (LAMP stack)
Linode 1 GB is a good start to host single or multiple websites. It costs 10 USD per month. We recommend you buy VPS hosting from Linode only because it is awesome.