How do I insert data from remote computer

[softprof]

I have lot of data on my remote computer and I want to insert it in to mySQL.
What is the best method to do it.

One way is to write a java program that convert my data into embedded SQL and insert it. But the problem is I can't connect to host.

Second way is to let the program convert
it to a SQL file that I run in mySQL. The problem here is the size of that file.

Any suggestion?

[jason]

You can set up an "Access Host" in the CPanel that will give you the ability to connect to MySQL from your remote machine. Go to the "Add/Remove MySQL Databases" page of CP and down at the bottom you'll see the access host section. Enter your local IP address and you'll be able to connect from your machine.

If you don't know your IP, go to (on Windows) Start > Run and type cmd. Then type "ipconfig" in the open box. Then at the command promt, type "ipconfig" and you should see your IP Address. On some windows versions you'll have to do Start > Run and then type "winipcfg" in the open box instead. On a Mac, just open your TCP/IP control panel and you should be able to see your IP address in there.

Another option is to use your Java program to write out the SQL statements to a text file, upload it to the server, and then use SSH to insert the data from the command line. Like you said, the file may be large, but it will be the same amount of data as your program would be sending directly, so it will take just as long for the program to send everyting. This step may be easier because you won't have to configure the access host to make it work.

--Jason

[softprof]

Thanks I will try it.