Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2003
    Posts
    134

    Unanswered: Save Physical File using MySQL

    Hi,

    I am using MySQL for employee WinForm application. Some tables have images and Ia m currently saving it as blob which is killing the size of the database.

    I want now to move it to a varchar field contains the file name or ID and save the physical file on the server instead of blob.

    I want to know what's the best practice in this? Do I need to include FTP server and client in my application?

    Is it possible to send the file with the database SqlConnection but receive it there in the server as physical file?

    Please assist..

    Thanks,
    Jassim

  2. #2
    Join Date
    Sep 2007
    Location
    Bangalore India
    Posts
    28
    Hi jrahma,

    You can save the large files into server, fetch the file based on the key or name from mysql.
    Which is faster than storing the entry file into blob.

    Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •