Problems creating and managing mySQL on remote Linux server

[JDepot]

I am currently working on a project where I have created a complex, multi-table database using Microsoft Access. This database now needs to be transferred to a remote Linux server with mySQL.

I am way out of my depth here, I am currently a rising senior in college and im not even majoring in CS. I have experience with creating databases from a high school summer job and that's it.

So what I need is a way to either link the mySQL database on the Linux server to Access, using Access as a front end, or find a different front-end software.

Also I have never worked with Linux before, how do I move a file from my Windows 7 PC to the linux server, i currently connect using putty.

Thank you for your help.

 

[normntwrk]

this looks like an easy way to do just that

http://www.stardeveloper.com/articles/display.html?article=2003101901&page=1

If you need to transfer files ftp or sftp is the way to go

on your PC go to a CMD line and change directories to where the file is located then type

ftp linuxserverIPaddress
login
password
cd (directory where you want to put the file)
put filename
bye


Norm

 

[JDepot]

Great, thanks for the direction to Navicat, im trying to get it to work but hitting problems. 30 day free trial so i have some time to work it out and free support which is great.

Thanks again