Converting 1.5 databases to 2.5

[mudskippa]

Hi,

I am trying to migrate my old 1.5 website to 2.5 using only backup files and databases. I am not able to use the usual migration extensions to do it, because there was no room left on my hosting to upload them. So instead, I have had to delete all the old info and start again with 2.5. So I am currently uploading the old files via FTP to the new public html, which seems ok. But importing the SQL database is proving problematic.

If I try to create a blank new database and import it, myphp comes up with this sort of thing:

SQL query:

-- -- Dumping data for table `jos_assets` -- INSERT INTO `jos_assets` (`id`, `parent_id`, `lft`, `rgt`, `level`, `name`, `title`, `rules`) VALUES (1, 0, 1, 71, 0, 'root.1', 'Root Asset', '{"core.login.site":{"6":1,"2":1},"core.login.admin":{"6":1},"core.login.offline":{"6":1},"core.admin":{"8":1},"core.manage":{"7":1},"core.create":{"6":1,"3":1},"core.delete":{"6":1},"core.edit":{"6":1,"4":1},"core.edit.state":{"6":1,"5":1},"core.edit.own":{"6":1,"3":1}}'), (2, 1, 1, 2, 1, 'com_admin', 'com_admin', '{}'), (3, 1, 3, 6, 1, 'com_banners', 'com_banners', '{"core.admin":{"7":1},"core.manage":{"6":1},"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}'), (4, 1, 7, 8, 1, 'com_cache', 'com_cache', '{"core.admin":{"7":1},"core.manage":{"7":1}}'), (5, 1, 9, 10, 1, 'com_checkin', 'com_checkin', '{"core.admin":{"7":1},"core.manage":{"7":1}}'), (6, 1, 11, 12, 1, 'com_config', 'com_config', '{}'), (7, 1, 13, 16, 1, 'com_contact', 'com_contact', '{"core.admin":{"7":1},"core.mana[...]

MySQL said: Documentation

#1062 - Duplicate entry '1' for key 'PRIMARY'

Any clues, or walkthroughs to do this?
Many thanks!

[conlippert]

The primary key is the id field so check your import and make sure there is not either 2 inserts for the same table or another row with the id set to "1". I'm pretty sure the "Root" asset needs to be a 1 so the other issue might be if the id is being automatically incremented by mysql. Pretty much I've found that the error messages are indicative of what is really happening.

[kenmcd]

 
Download the database and migrate the the site on your local testing server.



 

[mudskippa]

Thanks for your helpful replies