extracting old joomla data Topic is solved

Need help upgrading your Joomla! website or converting to Joomla! 3.x?

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10.
Post Reply
costacaptain
Joomla! Intern
Joomla! Intern
Posts: 78
Joined: Sat Dec 12, 2009 7:57 pm

extracting old joomla data

Post by costacaptain » Tue Aug 03, 2021 12:12 am

i have an old joomla site (database) backed up in my hostgator cpanel . i would like to use this content but do not know how to access it. anyone that can help i would be greatly appreciated.

User avatar
imanickam
Joomla! Master
Joomla! Master
Posts: 27807
Joined: Wed Aug 13, 2008 2:57 am
Location: Chennai, India

Re: extracting old joomla data

Post by imanickam » Tue Aug 03, 2021 3:10 am

If you have only backed up the database, you could restore the database and export the content. For example, the table xyz_content would contain the contents of the articles - one row per article.

If you have backed-up your entire site, you could restore it and try to use some third party extensions such as J2XML (https://extensions.joomla.org/extension/j2xml/) to Export and Import the data.
Ilagnayeru (MIG) Manickam | இளஞாயிறு மாணிக்கம்
Joomla! - Global Moderators Team | Joomla! Core - Tamil (தமிழ்) Translation Team Coordinator
ex-Joomla! Translations Coordination Team
Eegan - Support the poor and underprivileged

User avatar
leolam
Joomla! Master
Joomla! Master
Posts: 20401
Joined: Mon Aug 29, 2005 10:17 am
Location: Netherlands/ Germany/ S'pore/Bogor/ North America
Contact:

Re: extracting old joomla data

Post by leolam » Tue Aug 03, 2021 6:30 pm

@costacaptain
although MIG's reply is valid we need more info. What version of Joomla is the database from?

Leo 8)
Joomla's #1 Professional Services Provider:
#Joomla Professional Support: https://gws-desk.com -
#Joomla Specialized Hosting Solutions: https://gws-host.com -
#Joomla Webmaster Services: gws-webmaster.services

costacaptain
Joomla! Intern
Joomla! Intern
Posts: 78
Joined: Sat Dec 12, 2009 7:57 pm

Re: extracting old joomla data

Post by costacaptain » Tue Oct 12, 2021 1:55 am

I have the files in drop box . Help extracting and recovering content is welcome.

costacaptain
Joomla! Intern
Joomla! Intern
Posts: 78
Joined: Sat Dec 12, 2009 7:57 pm

Trying to recover content from old Joomla Site

Post by costacaptain » Fri Oct 15, 2021 12:41 am

hello i have an old joomla site both backed up in the Cpanel of my hosting and also in dropbox?

https://www.dropbox.com/s/redacted

https://www.dropbox.com/s/redacted

I would like to use the content for a new wordpress site or a sitebuilder on the hostgator platform

If someone could help with the data recovery I appreciate it.
Last edited by mandville on Fri Oct 15, 2021 10:49 am, edited 1 time in total.
Reason: redacted url for security reasons

User avatar
toivo
Joomla! Master
Joomla! Master
Posts: 13800
Joined: Thu Feb 15, 2007 5:48 am
Location: Sydney, Australia

Re: extracting old joomla data

Post by toivo » Fri Oct 15, 2021 5:42 am

Feel free to post your requirements to the Professional Development Services forum so that interested Joomla specialists can contact you. Read the instructions in the sticky topic first.
Toivo Talikka, Global Moderator

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

Re: extracting old joomla data

Post by sozzled » Fri Oct 15, 2021 6:37 am

costacaptain wrote:
Fri Oct 15, 2021 12:41 am
I would like to use the content for a new wordpress site or a sitebuilder on the hostgator platform
The best—the fastest, most efficient—thing to do if you have questions about Wordpress or HostGator is to ask your question on the Wordpress support forum (https://wordpress.org/support/forums/) or write to HostGator (https://www.hostgator.com/help/article/ ... -hostgator). 8)
“If you think I’m wrong then say, ‘I think you’re wrong.’ If you say ‘You’re wrong!’, how do you know?” :)

costacaptain
Joomla! Intern
Joomla! Intern
Posts: 78
Joined: Sat Dec 12, 2009 7:57 pm

Re: extracting old joomla data

Post by costacaptain » Fri Oct 15, 2021 1:46 pm

i'm wanting to recover the content of the old joomla site. thank you.

User avatar
leolam
Joomla! Master
Joomla! Master
Posts: 20401
Joined: Mon Aug 29, 2005 10:17 am
Location: Netherlands/ Germany/ S'pore/Bogor/ North America
Contact:

Re: extracting old joomla data

Post by leolam » Fri Oct 15, 2021 4:43 pm

This person (whoever he is...he never introduced himself)) has contacted us through the Joomla forums to our email and we have looked at the sql-file he has on his dropbox account (no site backup)

3x databases inside the file: Joomla 2.5, Joomla 1.5 and a WP site. All with only a single super user. It does not make sense to spend a lot of money on a site with either outdated data and no user data (Kunena extension in J25 site for instance has no entries) or any entries anywhere besides plain installation data so we have advised this person to just reinstall Joomla and the extensions used and he will be ready in 30 minutes for recovering his database entries with fresh Joomla extensions (which could be done without any issues). Actual site is costacaptain.com which is a WP-site so not clear what this person actually is looking for on a Joomla forum


Leo 8)
Joomla's #1 Professional Services Provider:
#Joomla Professional Support: https://gws-desk.com -
#Joomla Specialized Hosting Solutions: https://gws-host.com -
#Joomla Webmaster Services: gws-webmaster.services

costacaptain
Joomla! Intern
Joomla! Intern
Posts: 78
Joined: Sat Dec 12, 2009 7:57 pm

Re: extracting old joomla data

Post by costacaptain » Fri Oct 15, 2021 6:12 pm

This person is a sport fishing captain with limited knowledge. Leo tells me what to do. What Leo doesn't understand is i don't know how to do what Leo is advising.

I have old content that I want access to so I can use that info on my new site. Customer testimonials, photos, fishing information about tides, time of year, etc. Work that I would not like to do again.

So Leo. I am looking for someone who understands my needs. That wouldn't be you. Thanks for the explanation hopefully the company who can help will find it useful.

gsmela
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 192
Joined: Thu Jun 10, 2010 12:38 pm
Contact:

Re: extracting old joomla data

Post by gsmela » Fri Oct 15, 2021 6:31 pm

costacaptain wrote:
Fri Oct 15, 2021 6:12 pm
This person is a sport fishing captain with limited knowledge. Leo tells me what to do. What Leo doesn't understand is i don't know how to do what Leo is advising.

I have old content that I want access to so I can use that info on my new site. Customer testimonials, photos, fishing information about tides, time of year, etc. Work that I would not like to do again.

So Leo. I am looking for someone who understands my needs. That wouldn't be you. Thanks for the explanation hopefully the company who can help will find it useful.
This is a self-help forum for people looking to solve problems. What you need is professional assistance. Look here: https://community.joomla.org/service-pr ... ctory.html

costacaptain
Joomla! Intern
Joomla! Intern
Posts: 78
Joined: Sat Dec 12, 2009 7:57 pm

Re: extracting old joomla data

Post by costacaptain » Fri Oct 15, 2021 6:33 pm

Thank you.

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

Re: extracting old joomla data

Post by Webdongle » Fri Oct 15, 2021 7:18 pm

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
sozzled
Joomla! Master
Joomla! Master
Posts: 11191
Joined: Sun Jul 05, 2009 3:30 am
Location: Canberra, Australia

Re: "Extracting" old Joomla data in order to build a Wordpress website with it

Post by sozzled » Fri Oct 15, 2021 7:29 pm

As I wrote above
sozzled wrote:
Fri Oct 15, 2021 6:37 am
The best—the fastest, most efficient—thing to do if you have questions about Wordpress ... is to ask your question on the Wordpress support forum (https://wordpress.org/support/forums/) ...
As @gsmela wrote:
gsmela wrote:
Fri Oct 15, 2021 6:31 pm
This is a self-help forum for people looking to solve problems.
The biggest problem here is that the OP has a pile of data looking for a new home but the OP doesn't understand how they might conceivably use that data. This forum is to support people who want to work with J!; this forum is not here to support people who want to take data from a J! website and rebuild it using a different CMS technology. There are lots of services available where people can do that, if they wish.

costacaptain wrote:
Fri Oct 15, 2021 6:12 pm
I have old content that I want access to so I can use that info on my new site. Customer testimonials, photos, fishing information about tides, time of year, etc. Work that I would not like to do again.
Tough luck! Even if this is work that you would not like to have to do again, it's work that someone has to do. Trust me: I don't enjoy doing work of any kind! :laugh:

Time spent on doing work for someone else is time that is not being spent on working for oneself. If people don't have the required know-how or equipment needed to do some piece of work then you pay people who have that knowledge and the tools of the trade to do that work.

You have everything you need to know in order to get any job done.
“If you think I’m wrong then say, ‘I think you’re wrong.’ If you say ‘You’re wrong!’, how do you know?” :)

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

Re: extracting old joomla data

Post by Webdongle » Fri Oct 15, 2021 8:08 pm

@sozzled
He has posted in professional board, so he must be willing to pay.
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".

costacaptain
Joomla! Intern
Joomla! Intern
Posts: 78
Joined: Sat Dec 12, 2009 7:57 pm

Re: extracting old joomla data

Post by costacaptain » Fri Oct 15, 2021 10:30 pm

yes, i am willing to pay and was instructed to post in a different area of this forum . tx

User avatar
leolam
Joomla! Master
Joomla! Master
Posts: 20401
Joined: Mon Aug 29, 2005 10:17 am
Location: Netherlands/ Germany/ S'pore/Bogor/ North America
Contact:

Re: extracting old joomla data

Post by leolam » Sat Oct 16, 2021 6:10 am

costacaptain wrote:
Fri Oct 15, 2021 6:12 pm
So Leo. I am looking for someone who understands my needs.
I do understand your needs but the problem is that you only have (and mostly empty) old database info from old versions of Joomla and WP but the Dropbox folder you gave to me does not contain any other folders but for the database as mentioned. So if you have no images nobody can restore that data for instance since the database stores the path to the images folder where they are located but won't be able to find that info since it is not present.

Anybody Joomla developer could restore your Joomla J25 website because we can see what extensions you have used for instance from the database but it would be a limited installation since you are missing crucial files that are not present on the dropbox link you gave to me. Therefore I advised you to build on the latest Joomla from scratch. Now if you only need certain content you can have the Joomla 25 website restored and copy/paste that content into your WP website or use an external service to migrate the Joomla25 site to WP (cms 2 cms for instance) (That the data from Joomla should be used to add to a WP website was never communicate with me btw)

GWS makes a living from serving people but since you have not provided proper information and files are not present your requirements cannot be fulfilled and therefore we said "rebuild" which advise should be corrected to "Rebuild in WP)

Goodluck

Leo 8)
Joomla's #1 Professional Services Provider:
#Joomla Professional Support: https://gws-desk.com -
#Joomla Specialized Hosting Solutions: https://gws-host.com -
#Joomla Webmaster Services: gws-webmaster.services

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

Re: "Extracting" old Joomla data in order to build a Wordpress website with it

Post by sozzled » Sat Oct 16, 2021 6:33 am

Y'know, Leo, this topic has been kicking around for eleven weeks (nearly three months) and hasn't progressed anywhere. If the OP was genuinely interested in resurrect their website or sites (?) from the dead, you would have thought that some progress would have been made by now.

I am an optimist by nature; however, no amount of optimism can restore life once it's extinct. If the OP has a different opinion then that's OK by me.

I've patched together broken websites from shattered remnants but, in this case, it would take a miracle to satisfy the OP's needs no matter how much money was being offered. It would be interesting to know how much money was being offered ... (well, how much money is on the table?)

As I wrote before, and I'll repeat it again
sozzled wrote:
Fri Oct 15, 2021 7:29 pm
You have everything you need to know in order to get any job done.
I hope that now this discussion, like the OP's website(s), can now be allowed to die peacefully. 8)
“If you think I’m wrong then say, ‘I think you’re wrong.’ If you say ‘You’re wrong!’, how do you know?” :)

User avatar
mandville
Joomla! Master
Joomla! Master
Posts: 15082
Joined: Mon Mar 20, 2006 1:56 am
Location: The Girly Side of Joomla in Sussex

Re: extracting old joomla data

Post by mandville » Sat Oct 16, 2021 6:49 pm

before we close the casket, did anyone who looked at the file dump notice the hack files, and the webshell in there?
leolam - hint look for the royal file
HU2HY- Poor questions = Poor answer
Un requested Help PM's will be reported, added to the foe list and possibly just deleted
{VEL Team Leader}{TM Auditor }{ Showcase & Security forums Moderator}

User avatar
leolam
Joomla! Master
Joomla! Master
Posts: 20401
Joined: Mon Aug 29, 2005 10:17 am
Location: Netherlands/ Germany/ S'pore/Bogor/ North America
Contact:

Re: extracting old joomla data

Post by leolam » Sat Oct 16, 2021 7:02 pm

mandville wrote:
Sat Oct 16, 2021 6:49 pm
before we close the casket, did anyone who looked at the file dump notice the hack files, and the web shell in there?
leolam - hint look for the royal file
Got that thanks Claire. It is sad that somebody (owner) does not realize these things "You have been hacked, buddy!"
Sadly he only posted his SQL file to me so could not check his files

But of course, I do not understand these issues :D Agree 'Jeremy' ? I am so dumb...(and Oops how could I find out your real name IRL if I would not have visited your current site? -you did not introduce yourself in your emails-)

Leo 8)
Joomla's #1 Professional Services Provider:
#Joomla Professional Support: https://gws-desk.com -
#Joomla Specialized Hosting Solutions: https://gws-host.com -
#Joomla Webmaster Services: gws-webmaster.services

costacaptain
Joomla! Intern
Joomla! Intern
Posts: 78
Joined: Sat Dec 12, 2009 7:57 pm

Re: extracting old joomla data

Post by costacaptain » Tue Oct 19, 2021 4:34 pm

Posted to the professional forum and was able to connect with someone that understands what I need. Rather easily resolved.

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

Re: extracting old joomla data

Post by Webdongle » Tue Oct 19, 2021 6:17 pm

Are they dealing with the hack?
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
leolam
Joomla! Master
Joomla! Master
Posts: 20401
Joined: Mon Aug 29, 2005 10:17 am
Location: Netherlands/ Germany/ S'pore/Bogor/ North America
Contact:

Re: extracting old joomla data

Post by leolam » Tue Oct 19, 2021 6:18 pm

Are they dealing with the Joomla 1.5 migration to WP?

Leo 8)
Joomla's #1 Professional Services Provider:
#Joomla Professional Support: https://gws-desk.com -
#Joomla Specialized Hosting Solutions: https://gws-host.com -
#Joomla Webmaster Services: gws-webmaster.services


Post Reply

Return to “Migrating and Upgrading to Joomla! 3.x”