Attachment In Sql Hack
 

Good day vb Associates,

i have a question that I'm hoping that it can be answered.Is there such a hack to redirect attachment files that is uploaded to a server to where the vb is stored at and redirected it to another server to relieve the space size in my sql and attachments?

Reason that I'm asking is i was backing up mysql when i noticed the file size so far is up to 126,713 kb and would like to take the load off from the sql.

Thanks in advance , pb

Dont store your attachments in the database. Move them all to the filesystem and that would greatly shrink your db size and remove some unneccasary load.

If you need a quick how to for this just let me know

yes please because i thought i done that through admincp and it still showing the file size i moved it to the directory file.


ok i did it i transfered all attachment to file dir. Now it's still showing 693 in sql is that normal? i went to the dir to see and all file apparently is there and it's stored by file number.But in mysql is showing just curiuos making sure it worked.:)

looks like it.

Good job and hopefully this helps your servers workload for now ;)

how do we move attachments from DB to filesystem?