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: 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!


Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes:

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

This site uses Akismet to reduce spam. Learn how your comment data is processed.