mysql,wamp store procedure

mayur pandit

9y874

Dear all ,

I want select data from mysql table and convert this data in text file and, upload that text in ftp server using mysql store procedure , this is possible or not , if possible please help .

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nilesh Shah9y ago
Accepted answer
Hi Mayur,

Does my answer satisfy your question?

Can you mark it as "accepted answer" if it does.

You can close this question if you are not expecting any more answers
mayur pandit9y ago
I did it,very thank you.
mayur pandit9y ago
nice one.
Nilesh Shah9y ago
I'm not quite sure if possible or not, but even if possible it should not be done this way, I mean accessing FTP server from database.

This is because in production/live environment, you want your database to be secure and not exposed, connecting to an FTP or other server over internet.

Ask you IT team - will they allow sql database server, most probably lying in DMZ, to be exposed for FTP? mine will not allow.

So why not you change your process a bit?

Let MySql create the text file and write it over a shared path or some drive.
then you can create a batch file or service using some language and have it scheduled timely basis and check this folder (let's say every 5 minutes), and if it finds a file in this folder then upload to FTP.

sounds good?