×

Notice

The forum is in read only mode.
Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: Export/Import

Export/Import 11 years 5 months ago #21319

  • Stephen England
  • Stephen England's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 15
  • Thank you received: 0
I am migrating my site ( www.beecavebee.com ) from a 1.5 Joomla install to a new 2.5 instance. I do not intend to migrate all of my articles or comments, just the most recent 100 or so. Is there any way to export and import a subset of my comments to do that systematically. Thank you SE.

Export/Import 11 years 5 months ago #21320

  • Daniel Dimitrov
  • Daniel Dimitrov's Avatar
  • Away
  • Administrator
  • Administrator
  • Posts: 9618
  • Karma: 155
  • Thank you received: 1081
Well, you can just login with phpmyadmin and write the following query:
SELECT * FROM #__comment ORDER BY id DESC LIMIT 100;

#__ = your table prefix

This query should get you the latest 100 comments and then you can use the export feature in phpmyadmin to export just those 100 comments.

Regards,
Daniel

Export/Import 11 years 5 months ago #21321

  • Daniel Dimitrov
  • Daniel Dimitrov's Avatar
  • Away
  • Administrator
  • Administrator
  • Posts: 9618
  • Karma: 155
  • Thank you received: 1081
Also make sure that on 1.5 you are running the latest 4.2.1 version. Then when you move to 2.5 install 4.2.1 and after that you can upgrade to 5.0rc2.

Export/Import 11 years 5 months ago #21322

  • Stephen England
  • Stephen England's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 15
  • Thank you received: 0
Where do I get my table # and will it work without upgrade on old site (which I'm about to switch over and dump)

Export/Import 11 years 5 months ago #21325

  • Daniel Dimitrov
  • Daniel Dimitrov's Avatar
  • Away
  • Administrator
  • Administrator
  • Posts: 9618
  • Karma: 155
  • Thank you received: 1081
Go to your joomla's config and have a look at the server tab -> database.

Why not just copy all the tables from 1.5 move them to 2.5 and install ccomment 4.2.1 there? It should pick up all the comments, make the necessary updates and then you could use the backend to delete the comments that you don't need.
  • Page:
  • 1
Time to create page: 0.112 seconds