How to upload PHP and MySql into webserver

Question

I am Developing site in vertigoserver, now I need to test the webpage in webserver.

I am using the webserver Host-Europe VirtualServer 3.0

1. Now what are the steps to need to upload the PHP pages,
2. What are the softwares need to upload MySQL queries
3. Any tutorials or suggestions?

Answer 1

This seems like basic stuff, but I'll give you some pointers!

Upload the pages with an FTP client or similar. If you have shell access, tools like rsync can make this easier.

You've probably got some sort of web based front end for MySQL like phpMyAdmin - this will let you upload and restore a database dump. If you have shell access, or if the MySQL server is open to the Internet, you can pipe the dump into the mysql command line client, e.g.

mysql -h<hostname> -u<username> -p<password> mydatabase < dump.mysql

Answer 2

Okay you got a virtual machine and don't know how to upload stuff? This has been discussed in Host-Europe forums for a while. If you don't know the basics you probably don't want to run a server on your own. If you don't know how to use linux don't start with a machine which can get you in a lot of trouble. A hosting package is probably better you at the moment.

The problem I have is you didn't specify what OS you have. If you're using linux with plesk you want to activate FTP etc. if you are using linux without plesk you want to upload the php files with winscp and over ssh (scp).

If you are running windows with plesk use ftp if not you should install an ftp server on the machine.

Regarding the MySQL Stuff you're probably best of installing a webfrontend for mysql. !DONT FORGET TO SECURE IT!