I've just completed my first Silverstripe site locally and am wanting to upload it to my host (Bluehost.com).
I'm getting 404 Not Found errors - "The requested URL /CityCareClinic/sapphire/main.php was not found on this server."
I removed "CityCareClinic" (the folder in WAMP) and I get errors saying it can't access the MySQL database.
Have alook in your .htaccess on the live site. Because you installed in a subdirectory with WAMP it may have hard coded that folder name in the 'RewriteBase' line in that file. You will just need to change that line to / on the live site