Copy the remote database to my local machine

Finnally I succeeded to copy the remote database to my local machine!

1. Log in the remote machine(redhat) via Putty, and cd to the database directory, which consists of the '.frm' '.myd' and 'myi' files.

2. Type command 'zip myDatabase *', which put all the files in the current directory into myDatabase.zip

3. cd the directory where myDatabase.zip locates via psftp, and type the command
'get myDatabase.zip'. Now the myDatabase.zip is on my machine, under the same directory as psfyp.

4. Unzip the file, create a database on local machine, and copy all the file from the zip file to the local database file directory. The database file directory could be found via MySQLAdministrator: Click 'Startup Variables', and then the 'Data Directory' under the 'Directories' is the place where the database table hosts.