Keveen

I could not get Mambo 4.5.1 to install with my old database - probable too many complicated components like phpshop - one line error is enough to block the whole thing!

Now I have upgraded via a fresh install to 4.5.1 and it is great but - is there a way of extracting the data from my 1.0.9 backed up mySQL database and importing it into my new database?

Specifically - the Content with the categories I created, or just the content and no category.

phpShop categories and content.

I have tried importing my backup of phpshop made before I deleted my old system - I'm not savvy enough to work out the error messages.

I tried cutting and pasting what I thought were the relevant bits from the databse file via QUERY. I tried that with phpshop entries and it was accepted by mySQL but when I go to the new phpshop component there is not sign of the product list I just imported. The same thing for my old Content.

Importing and exporting seems to be full of pitfalls and there's not much in Mambo documentation to help. Is there an Idiot's Guide?

Probably I will have to update everything manually!!

zvonci

If you want to import content from old mambo to a 4.5.1, you must export table mos_content from old mambo(you could do that in phpmyadmin, it's very easy), open saved sql file in notepad(you should save it as with out compresion,this is optional in phpmyadmin),delete rows (beggining of file) till "INSERT INTO"(you must delete table creation because that table in 4.5.1 already exist),save file, and select 4.5.1 database (in phpmyadmin), find table "mos_content", click above button "SQL", then you should find a button "browse" (location of text file), select file that you preveusly edit, and click "go" That's it Hope you get it I counfused even my self

Keveen

Thanks

I tried it - almost works but not quite.

I understand what you mean - just selecting the content data section from the mySQL dump and NOT the table creation part.

In phpMyAdmin I had to:

Select the table I want to import into
Click on INSERT option under the ACTION column and then
Click on SQL - and the table I am working on is clearly listed at the top of the page

I can use a text file or just cut and paste the section I want.

But I got an error:

#1062 - Duplicate entry '1' for key 1

I tried changing the numbers of my data rows but the same result.

It's almost working. It would be useful to be able to find a way because it would be a fast way of data transfer from other backed up databases.

zvonci

I think that's not working because you have same ID's in old & new mambo.I'm not sure, but you must delete all entries in mos_content table (don't delete table mos_content) from mambo4.5.1 ,then import mos_content.sql file(from mambo4.5). Note, this way you will lose every content items in mambo 4.5.1,if you have some,but all 4.5 content should work. It worked for me

Keveen

Deleted the entries and imported successfully - nearly there - except! - I can't find any of the imported content except one item which suggests the others are there but not recognised. I've tried all the content submenus.

I even tried creating a new database, importing my backup, updating with update.sql and then exporting etc. Same thing. IMport a success but it does not show up in the Admin section. There must be some small step missing. I'll find it eventually because it could be very useful for the next upgrade!

zvonci

Wait,wait.. Are you talking about phpshop content or mambo content? If you are talking about phpshop content you must find a table where are stored phpshop content items, i don't know which table,because I dont use phpshop component.And insert into phpshop table in mambo 4.5.1. Note, I dont know is this gonna work.

For mambo content I'm sure it must work, because it worked for me and I dont see any reasen why it shouldn't work for you.

ps.
Maybe there is a problem with phpshop component working with new mambo..I think phpshop have plenty tables, you should export them all, and import them into new mambo..

You better have all backups

__________________
-----
Mambo HR Team

WebMaster

Keveen

No, just plain Mambo content. I've got them all backed up. When and if I find a solution I'll post it. It'll be quicker just to rebuild it all again. I don't think I'll be upgrading for a while! Thanks though, I've learned a bit more...

OffLead

Okay, this is a wild random guess, because I have only moderate amounts of actual sql knowledge, and have only done transfers like this a few times (including yesterday). I also don't have time right now to open up phpmyadmin and check the mos_content table structure. But...

Is it possible that the content items you pulled from your old database are assigned a category or section id that either doesn't exist or exists under a different ID number in your new database? If so, might this content not show up properly?

And, I assume you've double checked via phpmyadmin that the data IS in fact in the table?

Like I said, it's a long shot, but that's the sort of thing that I'd think of to check if I ran into this same problem.