如何将PHP和MySQL上传到网络服务器

Question

I am developing a 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 I need to upload the PHP pages?
2. What is the software needed to upload MySQL queries?
3. Are there 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, for example,

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