Change settings directly in database don't work???

[zackw]

Hi, I have an install of VB (4.0.7) that I am moving from one server to another. The versions of VB match but MySQL is different version.

Never mind that though! The real problem is that when I move the database, the site won't work because the URLs don't match the different server.

Say for example the working forum has bburl set to www.mydomain.com but when I copy the database to my local computer, it's going to be localhost/vb. This means that the data will copy (and it does), but no links work, can't log in, can't click anything, because all the links go to the original www.mydomain.com instead of localhost/vb.

I thought I would be clever and just edit the values directly in the database. I found the bburl setting, put in localhost/vb and tried again, no luck. Cleared browser cache, restarted server services, nope. It continues to use the old values.

I also changed bburl_basepath and it's still no good, links remain the same. I changed "homeurl" value and no good still.

I cannot change this value so that it will work! One thing I could do is change this value through the VB admin panel on the main server, THEN copy the DB. But of course if I put localhost/vb in the main server, then IT will stop working!

What am I missing here? I update the values in the DB but it just seems to ignore the changes? I update the values from the control panel itself, and the site dies. I actually locked myself out of the admin panel because once I changed bburl or basepath, the links to get in the admin panel no longer work, can't login, etc...

So guys, how do I change the URL structure in the database directly, or in other ways transfer the database so that this linking issue doesn't happen?

Thanks a ton!