Migrate site data to new site

General questions relating to Joomla! 4.x.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting.
Forum Post Assistant - If you are serious about wanting help, you should use this tool to help you post.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10
Post Reply
SPDJoomla4
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 132
Joined: Mon Jun 27, 2022 11:27 am

Migrate site data to new site

Post by SPDJoomla4 » Sat Sep 10, 2022 3:33 pm

Hi,
I'm planning to move my site to another location and was going to take the opportunity to start from scratch as I may want to drop the current framework and builder I am using and just builder from Cassiopeia. I also want to do a clean install of Joomla using the latest version as my current one is from a Quickstart setup provided by the framework/page builder company. I am not saying there is anything wrong with it I just don't know what may have been added to get things to work properly so want a clean slate

So I was wondering if there was a way for me to extract Articles, Authors, Categories and Tags from my current site and add it to the new site (new URL) without developing my own SELECTs - INSERTs
Cheers

gws
Joomla! Virtuoso
Joomla! Virtuoso
Posts: 4868
Joined: Tue Aug 23, 2005 1:56 pm
Location: South coast, UK
Contact:

Re: Migrate site data to new site

Post by gws » Sat Sep 10, 2022 5:03 pm

There is a function in Akeeba back up pro where you can exclude directories/files and data base tables from the back up. Exclude everything you do not want,make a backup and then install it on your new site. See Akeeba's documentation for help.

User avatar
sozzled
Joomla! Master
Joomla! Master
Posts: 13038
Joined: Sun Jul 05, 2009 3:30 am
Location: Canberra, Australia

Re: Migrate site data to new site

Post by sozzled » Sat Sep 10, 2022 9:05 pm

SPDJoomla4 wrote:
Sat Sep 10, 2022 3:33 pm
I was wondering if there was a way for me to extract Articles, Authors, Categories and Tags from my current site and add it to the new site (new URL) ...
Yeah, I did this for a friend a week or so ago. My friend had an old J! 3.x website but it was clogged with a lot of rubbish. The technique involved creating a new J! 3.x website, exporting the categories, articles, users and tags tables from the old site and importing them to the new site using phpMyAdmin.

Took me twelve hours spread over three days.

Although in my example I mentioned J! 3.x, the principle is the same for any J! website. As long as the source site is using the same version of J! as the target site, you can copy database tables between one and the other. The trick is knowing which tables you need to copy. J! 4.x is a little more involved than J! 3.x because there are some extra tables in addition to _categories, _content, _users and _tags (and I've simplified the list, BTW).

So, yeah, you can export/import database tables if you know what you're doing. There are also third-party extensions on the market that may do the job too.
“If you think I’m wrong then say, ‘I think you’re wrong.’ If you say ‘You’re wrong!’, how do you know?”
Walking the talk: https://j4xdemo.enduring.com.au
:)

User avatar
Webdongle
Joomla! Master
Joomla! Master
Posts: 42088
Joined: Sat Apr 05, 2008 9:58 pm

Re: Migrate site data to new site

Post by Webdongle » Thu Sep 15, 2022 12:10 am

http://www.weblinksonline.co.uk/
https://www.weblinksonline.co.uk/updating-joomla.html
"When I'm right no one remembers but when I'm wrong no one forgets".

jay1010
Joomla! Apprentice
Joomla! Apprentice
Posts: 9
Joined: Mon Sep 26, 2022 9:59 am

Re: Migrate site data to new site

Post by jay1010 » Mon Sep 26, 2022 10:38 am

Joomla import export users is the plugin which helps you to import your users and there information in file and you can export it to joomla 4 site . just one click process.

User avatar
Webdongle
Joomla! Master
Joomla! Master
Posts: 42088
Joined: Sat Apr 05, 2008 9:58 pm

Re: Migrate site data to new site

Post by Webdongle » Mon Sep 26, 2022 12:41 pm

jay1010 wrote:
Mon Sep 26, 2022 10:38 am
Joomla import export users is the plugin which helps you to import your users and there information in file and you can export it to joomla 4 site . just one click process.
Where is that plugin?
http://www.weblinksonline.co.uk/
https://www.weblinksonline.co.uk/updating-joomla.html
"When I'm right no one remembers but when I'm wrong no one forgets".

User avatar
AMurray
Joomla! Exemplar
Joomla! Exemplar
Posts: 8152
Joined: Sat Feb 13, 2010 7:35 am
Location: Australia

Re: Migrate site data to new site

Post by AMurray » Mon Sep 26, 2022 9:08 pm

Webdongle wrote:Where is that plugin?
I don't know if @jay1010 is referring to this: https://docs.joomla.org/index.php?title ... rid=399874? (this article would seem to be a 'promotion' for this specific extension https://extensions.joomla.org/extension ... or-joomla/) but the links in the article are direct links to the developer, not to the JED listing.
Regards - A Murray

User avatar
Webdongle
Joomla! Master
Joomla! Master
Posts: 42088
Joined: Sat Apr 05, 2008 9:58 pm

Re: Migrate site data to new site

Post by Webdongle » Mon Sep 26, 2022 11:35 pm

If someone knows enough to create the csv file with the correct info they could export/import using sql. The difficulty is knowing which tables to include without messing the database that imports the data. It is not that simple.
http://www.weblinksonline.co.uk/
https://www.weblinksonline.co.uk/updating-joomla.html
"When I'm right no one remembers but when I'm wrong no one forgets".

jay1010
Joomla! Apprentice
Joomla! Apprentice
Posts: 9
Joined: Mon Sep 26, 2022 9:59 am

Re: Migrate site data to new site

Post by jay1010 » Tue Sep 27, 2022 5:46 am

My use case is I am having 5 Joomla sites. When I going to make new site that time I need my users data from One of my Joomla site. That time I had used import export plugin which help me to move my users with user data to new site.

User avatar
Webdongle
Joomla! Master
Joomla! Master
Posts: 42088
Joined: Sat Apr 05, 2008 9:58 pm

Re: Migrate site data to new site

Post by Webdongle » Tue Sep 27, 2022 7:27 am

@jay1010
Which import export plugin did you use?
http://www.weblinksonline.co.uk/
https://www.weblinksonline.co.uk/updating-joomla.html
"When I'm right no one remembers but when I'm wrong no one forgets".

jay1010
Joomla! Apprentice
Joomla! Apprentice
Posts: 9
Joined: Mon Sep 26, 2022 9:59 am

Re: Migrate site data to new site

Post by jay1010 » Thu Sep 29, 2022 7:23 am

Webdongle wrote:
Tue Sep 27, 2022 7:27 am
@jay1010
Which import export plugin did you use?
I tested both Akeeba https://extensions.joomla.org/extension/akeeba-backup/ and the Import-Export plugin https://extensions.joomla.org/extension ... or-joomla/,
Akeeba costs more so I went with Import-Export.
Akeeka has more features but I just wanted to migrate my users so went with the cost effective solution

User avatar
Webdongle
Joomla! Master
Joomla! Master
Posts: 42088
Joined: Sat Apr 05, 2008 9:58 pm

Re: Migrate site data to new site

Post by Webdongle » Thu Sep 29, 2022 10:41 am

Akeeba backup will migrate J3 to J4 ???
Does miniorange preserve the user groups?
http://www.weblinksonline.co.uk/
https://www.weblinksonline.co.uk/updating-joomla.html
"When I'm right no one remembers but when I'm wrong no one forgets".

jay1010
Joomla! Apprentice
Joomla! Apprentice
Posts: 9
Joined: Mon Sep 26, 2022 9:59 am

Re: Migrate site data to new site

Post by jay1010 » Fri Sep 30, 2022 9:35 am

Webdongle wrote:
Thu Sep 29, 2022 10:41 am
Akeeba backup will migrate J3 to J4 ???
Does miniorange preserve the user groups?
Yess

User avatar
Webdongle
Joomla! Master
Joomla! Master
Posts: 42088
Joined: Sat Apr 05, 2008 9:58 pm

Re: Migrate site data to new site

Post by Webdongle » Fri Sep 30, 2022 11:43 am

Yes to which one?
http://www.weblinksonline.co.uk/
https://www.weblinksonline.co.uk/updating-joomla.html
"When I'm right no one remembers but when I'm wrong no one forgets".

jay1010
Joomla! Apprentice
Joomla! Apprentice
Posts: 9
Joined: Mon Sep 26, 2022 9:59 am

Re: Migrate site data to new site

Post by jay1010 » Sat Oct 01, 2022 6:16 am

Yess for miniOrange

User avatar
sozzled
Joomla! Master
Joomla! Master
Posts: 13038
Joined: Sun Jul 05, 2009 3:30 am
Location: Canberra, Australia

Re: Migrate site data to new site

Post by sozzled » Sat Oct 01, 2022 8:00 am

I've been watching this topic. First of all (like @Webdongle and @AMurray), I have little understanding of what @jay1010 is talking about.

1) Akeeba Backup is not used for converting websites from J! 3.x to J! 4.x. Akeeba Backup can backup a J! website and (with Akeeba Kickstart) you can transfer (or restore) that website. Therefore, as far as the original question asked by @SPDJoomla4 is concerned, the discussion about Akeeba Backup is off-topic.

2) I've read about "miniorange" before. If you search for "miniorange" and "Joomla" on Google you won't find much. There are a few references to "miniorange" in connection with Wordpress. This is the J! forum. Let's stay with what we know about J! and not discuss tools that may be useful for other CMS products.

The OP asked at the beginning:
SPDJoomla4 wrote:
Sat Sep 10, 2022 3:33 pm
I'm planning to move my site to another location and was going to take the opportunity to start from scratch as I may want to drop the current framework and builder I am using and just builder from Cassiopeia. I also want to do a clean install of Joomla using the latest version as my current one is from a Quickstart setup provided by the framework/page builder company. I am not saying there is anything wrong with it I just don't know what may have been added to get things to work properly so want a clean slate

So I was wondering if there was a way for me to extract Articles, Authors, Categories and Tags from my current site and add it to the new site (new URL) without developing my own SELECTs - INSERTs
In that context, I wrote
sozzled wrote:
Sat Sep 10, 2022 9:05 pm
SPDJoomla4 wrote:
Sat Sep 10, 2022 3:33 pm
I was wondering if there was a way for me to extract Articles, Authors, Categories and Tags from my current site and add it to the new site (new URL) ...
Yeah, I did this for a friend a week or so ago. My friend had an old J! 3.x website but it was clogged with a lot of rubbish. The technique involved creating a new J! 3.x website, exporting the categories, articles, users and tags tables from the old site and importing them to the new site using phpMyAdmin.

Took me twelve hours spread over three days.

Although in my example I mentioned J! 3.x, the principle is the same for any J! website. As long as the source site is using the same version of J! as the target site, you can copy database tables between one and the other. The trick is knowing which tables you need to copy. J! 4.x is a little more involved than J! 3.x because there are some extra tables in addition to _categories, _content, _users and _tags (and I've simplified the list, BTW).

So, yeah, you can export/import database tables if you know what you're doing. There are also third-party extensions on the market that may do the job too.
I stand by my previous remarks.

If the OP is happy with that as an answer then that's good enough. If the OP requires more detailed information then let's hear from the OP. I don't want to see more "panel discussions" about off-topic matters.
“If you think I’m wrong then say, ‘I think you’re wrong.’ If you say ‘You’re wrong!’, how do you know?”
Walking the talk: https://j4xdemo.enduring.com.au
:)

User avatar
Per Yngve Berg
Joomla! Master
Joomla! Master
Posts: 29475
Joined: Mon Oct 27, 2008 9:27 pm
Location: Romerike, Norway

Re: Migrate site data to new site

Post by Per Yngve Berg » Sat Oct 01, 2022 8:09 am

@sozzled

Miniorange have made several extensions for Joomla.

https://extensions.joomla.org/instant-s ... miniorange

The question is, if these authentication plugins are compatible with J4.2.

User avatar
sozzled
Joomla! Master
Joomla! Master
Posts: 13038
Joined: Sun Jul 05, 2009 3:30 am
Location: Canberra, Australia

Re: Migrate site data to new site

Post by sozzled » Sat Oct 01, 2022 8:24 am

Thank you for that information, @Per. Yes, there is an extension that will import/export users from one J! website to another: Import Export Users for Joomla. There is nothing in the description that refers to importing from J! 3.x and converting the user tables so that they can be used with J! 4.x, though. Now, if someone can swear on a stack of Joomla manuals a mile high that there's a "miniorange" extension that will do what the OP wants (and the OP accepts that answer) we can mark this topic as solved.

And, just in passing, you can—I guess you can, I haven't tried it—export/import to CSV without using the Import Export Users for Joomla component. When I was helping my friend with his migration battles, I just used plain "vanilla-flavoured" phpMyAdmin to export the database tables from the old J! 3.x website, imported them into the new J! 3.x website and then used Joomla! Update to migrate the site to J! 4.x. Took a while, as I wrote, but it was successful.

But ... Import Export Users for Joomla just exports/imports the user tables! The OP wants to copy other data
SPDJoomla4 wrote:
Sat Sep 10, 2022 3:33 pm
[Is] there ... a way for me to extract Articles, Authors, Categories and Tags from my current site and add it to the new site?
So, this one extension won't do all that!

Until then, good luck to @SPDJoomla4 in finding an answer that they works for them.
“If you think I’m wrong then say, ‘I think you’re wrong.’ If you say ‘You’re wrong!’, how do you know?”
Walking the talk: https://j4xdemo.enduring.com.au
:)

User avatar
Webdongle
Joomla! Master
Joomla! Master
Posts: 42088
Joined: Sat Apr 05, 2008 9:58 pm

Re: Migrate site data to new site

Post by Webdongle » Sat Oct 01, 2022 4:30 pm

I tested miniorange.
The free version exported Users and User Groups in J3, but J4 you can only export Users.
You need the paid version to import Users and User Groups into both J3 and J4

The export format for users is csv Column names (with users and values in each line underneath)
id,name,username,email,password,block,sendEmail,registerDate,lastvisitDate,activation,params,lastResetTime,resetCount,otpKey,otep,requireReset,authProvider,group,
Categories are not Exported/Imported. Therefore the relationship between Users and Categories will be lost if Categories had been added.


The export format for User Groups is a straight list:
All Groups
Public
Registered
Author
Editor
Publisher
Manager
Administrator
Super Users
Guest
Testing

None of the columns or values are saved in the export.


Sorry but it looks like that plugin will be the cause of problems further down the line.
http://www.weblinksonline.co.uk/
https://www.weblinksonline.co.uk/updating-joomla.html
"When I'm right no one remembers but when I'm wrong no one forgets".


Post Reply

Return to “General Questions/New to Joomla! 4.x”