There are 2 main update methods.
I have found this way better. You have clean install and you are sure there are no old files left exigently.
Now you have to transfer all your users. For that start with SQL patch on your old Joomla 2.5 DB.
ALTER TABLE `jos_users` ADD COLUMN `lastResetTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' AFTER `params`, ADD COLUMN `resetCount` int(11) NOT NULL DEFAULT '0' AFTER `lastResetTime`, ADD COLUMN `otpKey` varchar(1000) NOT NULL DEFAULT '' AFTER `resetCount`, ADD COLUMN `otep` varchar(1000) NOT NULL DEFAULT '' AFTER `otpKey`;
This query will make users table the same as it is in J! 3.
Edit this dump file. At the very top you will find queries to create DB and use that DB. Something like that.
CREATE DATABASE IF NOT EXISTS `joomla_mint` /*!40100 DEFAULT CHARACTER SET utf8 */; USE `joomla_mint`;
Make sure that DB names conform to DB name on your new Joomla.
This is probably worst method. Because when I was trying to update Joomal from
2.5.7 to latest
3.2.1 I could not. I always had a lot of errors. Even the fact that I am 10 years experienced full time Joomla developer, and I tried to apply SQL patches manually, and I edited update package to stop some processes, I had failed.
But if you finally managed successfully update Joomla then you can proceed to the final steps.
Install latest Cobalt. Cobalt use it’s own DB update mechanism. It is not based on standard Joomla SQL files update mechanism. That was not very reliable way.
On every build, Cobalt makes snapshot of current DB and save it in
JSON files. And on install, Cobalt compare DB to snapshot and apply required changes. Thus you may be sure no matter what was changes during Cobalt development, after install latest version you have very current DB structure.
Edit sections, types, template parameters and even some fields to alter it’s settings.
Note that most changed part of Cobalt 8 comparing ro Cobalt 7 is templates. First it is changed how templates store settings, so you need to edit all settings of templates. Second templates looks differ, so most probably you will have to restyle them.