mysql,wamp store procedure

Question

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 .

Nilesh Shah · 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

Nilesh Shah · Answer

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?

mayur pandit · Answer

I did it,very thank you.

mayur pandit · Answer

nice one.

mysql,wamp store procedure

Answers (4)