Migrating to Joomla 3.2

I upgraded my site to Joomla 3.3 and changed the template.
So I had to pretty much start from scratch.

I have the sql file from the old site, and tried to import it, then install ZH GoogleMaps.
That didn't work, so I was hoping there was a solution.

I looked around and see that you really don't have an import/export feature.

I really don't know much about SQL files.
Is there anything I can do?

I support j.3.3 and it doesn't need to upgrade from 3.2

For what reason you want to use SQL. You just upgrage your joomla, and all works.

As for my exts, if you move from 2.5 to 3.x - just get it from JED, extract, and install over exists version (WITHOUT uninstall - in this case you loose your data)

Sorry I didn't explain better.

I needed to upgrade to 3.0

The site was 2.5
I built a new site using 3.2

I have the sql file from the 2.5 site

So I was hoping there was a way to migrate the data from a 2.5 site to a 3.2 site.

I also sent you the Sql file.

Thank You :^)

Why you in that case don't use joomla's upgrade (menu item), it upgrades to 3.x.
After that you just need to install my exts just over exists.

And in your case, when you export sql you need some manual work, ie if you not simple upgrade joomla, and want use old data from the other site version and use export-import:
try to do that trick
- if you load sql file (with all my extension tables)
- then you can't install my extension, because it tries to create tables, and there are exitst
- if I right - unzip my component for j.3.x version
- open folder \com_zhgooglemap\admin\sql
- open file install.sql, clear all text, save file
- open all sql-files in updates\mysql\
- clear all text here and save files
- zip it, and install that version into your new site

In this case joomla executed install.sql (empty), and mark that all OK, and mark all updates files loaded.

In that case I think you can get working my extension on old tables.

I mean that you have last version my extension on j2.5 - I mean table structure the same as you want use in j3 (columns on both site version havo to be the same).

If you export from 2.5 site not the last version - you have to install onto j3 site the same version - you have to tell me your version for j2.5, and I'll give you link to version for 3.x. In that case you download that version, install it, and after that just use autoupdate feature to get last version.

May be a lot of text.
The other esplaination:
- my exts for j2.5 and for 3.x - have to be the same, if you use export-import tables
- the prefix of tables have to be the same, ie if you create new j3 site with new table prefix - you have to rename table names in your export file for import data

Moreover - if you use the same database for different version of your site (j2.5 and j3), and you just only have different table prefix, - you can try easy to load data from one table to other by insert <table_name>(<column list>) select <column list> from <table_name_old>

That worked on the first try!!!

I have attached the file I used to do the install after your edits.
This worked for me, and may help others.

Thank you so much!!

Fine.

In a few days there will be new release (I only have plans to modification) - fixing little bugs and add Hungarian translation.

When you get joomla updater message about ready new release - install it, if all will done without errors - I suggest you to check column list in your database tables with script install.sql - because if you migrate from-to different extension versions (component) - you can miss some of columns. In this case you need some more "manual work"