Attachment In Sql Hack

[puertoblack2003]

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

[Ntfu2]

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

[puertoblack2003]

Originally Posted by Ntfu2

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.

Originally Posted by puertoblack2003

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

133,840 Bytes

just curiuos making sure it worked.

[Ntfu2]

looks like it.

Good job and hopefully this helps your servers workload for now

[grains]

how do we move attachments from DB to filesystem?