Does anyone know if the tables from 1.6.0 are any different from a the tables from 1.6.5? I have ~500 client instances I want to move from 1.6.0 to 1.6.5 and I was thinking of just copying over the database if that's possible. Since they are all hosted on the same set of files, I can't really run any kind of upgrade scripts.
Thanks!
get the 1.6.0 and 1.6.5 files \install\resources\mysql_tables.php and run a DIFF
That won't necessarily be the best way of doing it as sometimes stuff is done to existing data.
Assuming you use MySQL, there's this query:
$db->add_column("adminviews", "custom_profile_fields", "text NOT NULL AFTER conditions");
And then all the queries in ./install/resources/upgrade21.php. And you'll have to rebuild all the caches on every forum.
Must say I'm a bit surprised you're running this sort of setup though, sounds like a nightmare...