Uploading files to remote host by MySQL server?

[r4BBiT]

Hi,

I searched on google and manual for mysql for windows for this, but couldnt find anything, so maybe someone here will know this. Is there any way to upload files to remote host(my box) by MySQL server (win version)? If is what commands should I use? Thanks in advance.

[HTRegz]

Feel free to correct me if I'm wrong.... (we all know I usually am)...but MySQL is db software. You create tables and fields and store data in those fields... PHP and MySQL are usually used hand-in-hand on websites, so you are probably talking about PHP.

http://www.webclass.ru/eng/Tutorials...load_with.html
http://www.experts-exchange.com/Web/..._20367575.html


You'll also want to check out the PHP manual @ http://www.php.net/manual/en/

[alittlebitnumb]

r4BBiT, try an FTP client. You will find that to be much easier.

I hope this helps.

[Kezil]

by what I understand, you want to modify/add-to a MySQL db on one system from another, correct? Going off of what HTRegz said, your best bet would be to create a php form for this, or something like it. If all you want to do is put files on/take files off of a server, alittlenumb's suggestion of ftp is what would be best.

[r4BBiT]

Thanks to all for replies, I'll try to learn PHP(im noob at PHP) and use it to upload files.

[Tedob1]

SQLAnywhere uses DBremote, a program that takes all the new messages and FTPs them to a directory where you can retreve them and add the messages to the main database again using dbremote.

So id have to agree with alittlebitnumb. search for a program that collects the changes and ftps them.