I have XBMC installed on a HTPC. I use it to play the movies I have copied from my DVD collection. I store those movies on a separate server. I had to move the files to a different location on the server. Now when I try to play a movie I get an error stating the file does not exist. How can I delete the entire database in XBMC so it can rebuild itself with the new correct location of the movie files?
What version of XBMC is this?! You might need to upgrade to the latest XBMC release which is currently 11.0 (code named "Eden").
You also didn't say what OS XBMC was running on! There is a XBMCBuntu version that runs on a stripped down version of Ubuntu (Linux). Then there's the XBMC app that runs under Windows. There's still other releaes of XBMC for other OS's like Mac too. So you your problems may be completely unrelated to XBMC but rather stem with your operating system.
But frankly, I'm inclined to think this may be a Windows problem totally unrelated to XBMC.
You could also go to Settings > Video and clean the library. That will remove any items in the library that it can no longer find on the disk, then just rescan.
I recently migrated my XBMC library from one server to another and just changed the locations in the database, but I was using MySQL, so I'm not sure how I would do the same thing in SQLite, which is the built-in database.
Mine all moved from a NFS export on one server to a CIFS share on another.