Database problem

[Jtague]

Hello all!
I am running vBulletin 3.6.8 patch level 2 on a Windows 2003 server
with MySQL 5.0.45

After configuring and testing functionality (users, attachments, avatars etc..) I backed up the database using the MySQL command line:
mysqldump --add-drop-table -uroot -p***** forums > forums.sql
This appears to work fine.
To simulate disaster recovery I then deleted (dropped) the Forums database. I then recreated an empty forums database and did a fresh install of vbulletin. I logged in and saw what I expected: 1 user (admin).
I then restored the database with th MySQL command line:
mysql -uroot -p**** forums < forums.sql. Again this appears to work fine. I now see all the users and their respective posts.
The problem is I cannot upload attachments or avatars using either the admin login or any other login.
Error: Unable to move/copy file
Using the controlpanel->diagnostics-> upload test works fine
Any ideas on what might have caused this?

Jim T.

[Jake Bunce]

Are you storing attachments / avatars in the database or file system?

Admin CP -> Attachments -> Attachment Storage Type

Admin CP -> Avatars -> User Picture Storage Type

If they are in the file system then make sure you are backing up / restoring those directories as well. If the paths are different after the restore then you need to update their locations in the above sections.

[Jtague]

Avatars: Images are currently being served from the database

Attachments: Attachments are currently being stored in the database

I assumed that this would make backup easier (a scheduled batch file) no need to backup the attachments in the file system (they aren't even there!).

I believe I have resolved this by:
vBulletin Options->Server Settingsand Optimization Options->Safe Mode Enabled. I set this to yes, restarted IIS, reset this back to No and
restarted IIS. Users can now upload avatars and attachments!

Thanks for your help!

Jim T.