RMDatabase Frequently Asked Questions (FAQ)
Do all my tables get converted when I upgrade? Q: I am currently running version 3.1f. I read in the README file about how the script copies the alumni.db, pres.db and lost.db to the new data directory, but it said nothing about any of the other tables (lang.db, settings.db, etc). Do they get converted as well? A: Good question. The answer is no they do not. Version 4 does not change the database structure of the main alumni table (alumni.db) or the pres.db and lost.db (these tables represent the bulk of the data in the alumni database). That is why these tables are upgraded since basically all the installation script is doing is just "copying" them to the new data directory. The structure of the language table changes with the new version, so it is necessary for the admin to re-configure the langauge database once installation is complete. The old "settings" table gets replaced by the new "custom" table. And its structure is completely different. There are also some new tables that get created as well (badips.db and rmdb4.log).