June 15th, 2003, 02:41 AM
Uploading files to remote host by MySQL server?
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.
June 15th, 2003, 03:12 AM
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.
You'll also want to check out the PHP manual @ http://www.php.net/manual/en/
IT Blog: .:Computer Defense:.
(Pronounced Pinched): Acronym - Point 'n Click Hacked. As in: "That website was pinched" or "The skiddie pinched my computer because I forgot to patch".
June 15th, 2003, 03:15 AM
r4BBiT, try an FTP client. You will find that to be much easier.
I hope this helps.
June 15th, 2003, 03:32 AM
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.
Preliminary operational tests were inconclusive (the dang thing blew up)
\"Ask not what the kernel can do for you, ask what you can do for the kernel!\"
June 16th, 2003, 02:53 AM
Thanks to all for replies, I'll try to learn PHP(im noob at PHP) and use it to upload files.
June 16th, 2003, 05:48 AM
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.
Bukhari:V3B48N826 “The Prophet said, ‘Isn’t the witness of a woman equal to half of that of a man?’ The women said, ‘Yes.’ He said, ‘This is because of the deficiency of a woman’s mind.’”