I have an issue concerning the database, on phpBB the files are stored on the file system and I never had any issues but now I am going over to Vbulletin the files first have to be transferred to the database.
There are options to have attachments as a file system but impex which is the tool provided by vBulletin to transfer another forum type into VB doesn't seem to like transferring straight into a file system so I am forced to use the database default storage type.
Now on to the problem, first of all I had a really hard time being able to transfer large files into the database , I have 15000 attachments some as big as 140MB and over 20GB of attachments in total, but the big problem is taking them out again once in there, even though for instance I have a file that is 20mb in size and I can see it in the database at that size I can not download the file, it will stick at 1mb, I have also tried transferring the database into a file system but when that happens all files are shrunk to 1mb in size.
Now I am thinking there must be a set limit on the file transfer from the database, now I don't know if that is somehow configured into VB somewhere or if it a setting that be changed on mysql or somewhere else that could be
restricting that size.
I don't know if any of you have ever encountered this problem before but I have tried searching everywhere for an answer and I don't seem to be having any luck and hoping you may be able to help find the solution.
Best regards
Mark
There are options to have attachments as a file system but impex which is the tool provided by vBulletin to transfer another forum type into VB doesn't seem to like transferring straight into a file system so I am forced to use the database default storage type.
Now on to the problem, first of all I had a really hard time being able to transfer large files into the database , I have 15000 attachments some as big as 140MB and over 20GB of attachments in total, but the big problem is taking them out again once in there, even though for instance I have a file that is 20mb in size and I can see it in the database at that size I can not download the file, it will stick at 1mb, I have also tried transferring the database into a file system but when that happens all files are shrunk to 1mb in size.
Now I am thinking there must be a set limit on the file transfer from the database, now I don't know if that is somehow configured into VB somewhere or if it a setting that be changed on mysql or somewhere else that could be
restricting that size.
I don't know if any of you have ever encountered this problem before but I have tried searching everywhere for an answer and I don't seem to be having any luck and hoping you may be able to help find the solution.
Best regards
Mark
Comment