Log in

View Full Version : Attachment In Sql Hack

puertoblack2003
08-18-2006, 10:53 PM
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
08-18-2006, 10:57 PM
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
08-18-2006, 11:23 PM
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.

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
08-19-2006, 06:04 AM
looks like it.

Good job and hopefully this helps your servers workload for now ;)
grains
11-03-2006, 06:13 AM
how do we move attachments from DB to filesystem?