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!

[Lynne]

Is your config.php file set to use the datastore_cache? And did you transfer over that file also? And, did you change the url in the datastore table also (that ones a bit trickier)?

[zackw]

I found the main limiting factor was the <base> tag in the HTML would remain pointed to the old URL even after I changed the database. And the variable used in code to make the <base> tag IS bburl. So there must be a cache somewhere.

I did not transfer any "files", this is only the database.
If there are cache tables that I can safely empty after transferring the database I'd like to know what. Given that it is a new forum install on a new server, some cache dumps would probably be good.

That leads me to another question, after transferring a database in this manner, what type of maintenance chores should I run on the database to make sure we have a good start before letting the 20K users back on again?