PHP + MySQL Deployment

Question

I'm just trying to find an easier way to deploy a site I'm working on. I'm working alone with a test a production server and right now deployment means copying a subset of the files and database data onto my computer and uploading it to the prod site. I'm sure there's a simple synchronization tool out there but so far I've had no luck in finding anything.

What I'd really like is an application I can run locally (on windows) or something I could install on my server for let me have a one-click deployment. Any suggestions?

Thanks! godwin

Edit
I have decided for now to go with GoodSync and Toad. Thanks for the suggestions.

Answer 1

man scp

SCP(1) BSD General Commands Manual SCP(1)

NAME scp - secure copy (remote file copy program)

SYNOPSIS scp [-1246BCpqrv] [-c cipher] [-F ssh_config] [-i identity_file] [-l limit] [-o ssh_option] [-P port] [-S program] [[user@]host1:]file1 [...] [[user@]host2:]file2

DESCRIPTION scp copies files between hosts on a network. It uses ssh(1) for data transfer, and uses the same authentication and provides the same security as ssh(1). Unlike rcp(1), scp will ask for passwords or passphrases if they are needed for authentication.

 Any file name may contain a host and user specification to indicate that the file is to be copied to/from that host.  Copies between two
 remote hosts are permitted.

 When copying a source file to a target file which already exists, scp will replace the contents of the target file (keeping the inode).

 If the target file does not yet exist, an empty file with the target file name is created, then filled with the source file contents.  No
 attempt is made at "near-atomic" transfer using temporary files.

 The options are as follows:

 -1      Forces scp to use protocol 1.

 -2      Forces scp to use protocol 2.

...