Migrating an old Joomla DB from 1.6 to 3.x
Yesterday I decided to resurrect my website and blog which I took down about five years ago when my dedicated host died. My domain has sat empty since then and I had not been sharing my wisdom with the world. So I've decided to bring it back, but the database was Joomla 1.6 and the new Joomla is 3.x and that is one hell of a leap in versions, clearly it wasn't plain sailing. I imported the database elements I needed from an SQL dump that I had from my backups and they had a different Joomla table prefix which was essential because the tables had different schemas (the columns were different). The important thing was finding how I could make a transfer of the articles from the old table to the new table, I started to construct an insert statement which mapped all the new table to the old values, but I am impatient and I wondered if there was another way of doing this. Fortunately I found the upgrade SQL for 3.x: https://forum.joomla.org/viewtopic.php?t=760150#p2910019 then I used a simple "Operation" to transfer the "_content" table in phpMySQLAdmin. Then I needed to fix the "_categories" section and there were some numbering issues which needed dealing with. My work is not complete but it has filled things out!