Old backup database to a new one

[ladyrider12]

Hi!

I have a major issue. I made a backup of my old database and want to transfer it to the new install, same database, as Joomla backed it up. How do I do this to populate my database with my old database.I'm lost and I need to get this website up asap.

Thanks,
Tammy

[ redacted ]

[Webdongle]

Best done on localhost
Install Joomla of the same version as the database was from
Edit the configuration.php to connect to the old database
Log in to /administrator and update.

If you want to add the content from the old database to a new site (that has data in it)
Follow the steps above and use https://extensions.joomla.org/extension/j2xml/ to transfer the data.

[ladyrider12]

There is absolutely no directions with this component. So I followed you advice and installed this one this website that I listed above, which is the same version of Joomla. Then I edited the database to connect to old database. It is throwing this error:

500 Table 'reatinl3_584fkg6g4h51d5rs.ra6ky_j2xml_websites' doesn't exist SQL=SELECT COUNT(*) FROM `ra6ky_j2xml_websites` AS a LEFT JOIN ra6ky_users AS uc ON uc.id=a.checked_out WHERE (a.state IN (0, 1)) Table 'reatinl3_584fkg6g4h51d5rs.ra6ky_j2xml_websites' doesn't exist SQL=SELECT a.id AS id,a.title AS title,a.alias AS alias,a.remote_url AS remote_url,a.username AS username,a.state AS state,a.checked_out AS checked_out,a.checked_out_time AS checked_out_time,uc.name AS editor FROM `ra6ky_j2xml_websites` AS a LEFT JOIN ra6ky_users AS uc ON uc.id=a.checked_out WHERE (a.state IN (0, 1)) ORDER BY a.title asc LIMIT 0, 20 Table 'reatinl3_584fkg6g4h51d5rs.ra6ky_j2xml_websites' doesn't exist SQL=SELECT COUNT(*) FROM `ra6ky_j2xml_websites` AS a LEFT JOIN ra6ky_users AS uc ON uc.id=a.checked_out WHERE (a.state IN (0, 1))

Needless to say this hasn't helped at all. As soon as I connect to this old database it breaks apart my site where there is no front end. That's why I reinstalled Joomla and was trying to get my content from the populated database.

What other way can I do this? I really just want my articles and a few modules (not even all of them). That's it.

[sozzled]

I'm sorry to hear of your troubles. We started with a bit of a jigsaw puzzle and not it seems we're confronted with a shattered vase.

Yeah, some people swear blind by "best doing these things on a localhost". I'm not one of 'em!

The situation may not necessarily be unrecoverable (at least, that's what I hope).

I don't quite know how the suggestion about using JX2ML was introduced into the subject but perhaps @Webdongle has more experience in using that component than I (who has zero experience with JX2ML) have.

Reconsituting a broken website from a database and a set of files is possible but it's not sure-fired guaranteed. There are a lot of variable factors involved.

Anyway here are a few thoughts that might save your skin.

You say that you want to salvage your articles and, maybe a few modules. No real drama here.

Joomla's articles rely on only a couple of database tables (the _content table and, to a lesser extent, the _categories table). So it might be possible to copy those tables and "ignore" the other tables that existed in the original database.

But, that's only the 10-second tutorial about Joomla datbases and I've left out a whole heap of other stuff. Joomla article also refer to the users who create those articles; so we also need the _users table and the _usergroups and _user_usergroup_map tables.

In addition to the database tables used by the articles in the old site, there's also the multimedia files—stored as files on the old site—that need to be copied to the new site.

Salvaging modules (used in one site) to be brought over to a new site brings its own set of problems (and that might be why @Webdongle recommended a third-party product). I don't want to overload you with too much information at this time.

You're stuck (I get that). Your beautiful website lies in shattered ruins. We can help but, in a forum Q&A context, it may take a while. There are other ways of handling the problem.

I hope some of this makes sense and I wish you good luck.

[leolam]

Joining this party ;-)

Do you have access still to the admin area of the old site?

Leo

[ladyrider12]

I just deleted the whole site I had online. Starting with a fresh database to install. So, yes I will be able to get access to the admin area. I didn't. What did you have in mind?

[sozzled]

If I understand correctly, you have a brand new Joomla website (straight out of the box) with nothing added—no content, no extensions. Please let us know if I have misunderstood you.

[Webdongle]

There is absolutely no directions with this component. So I followed you advice and installed this one this website that I listed above, which is the same version of Joomla. Then I edited the database to connect to old database. It is throwing this error:...

No, no and NO ... I did not say do that. If you need to add data from one database to the other you need to use an import/export extention like https://extensions.joomla.org/extension/j2xml/

[ladyrider12]

Hi,

I couldn't wait to figure this out as for the articles I actually don't have too many and I already kept my meta tags. So my site is online. I put them back in and started ove, just had my new design. creatingimages.biz This needed to be back up by Saturday and I still have a huge part to put back online.

Now, for the big part which I already lost...had my database though.

Was going to pick a different one, I had BT Portfolio purchased the upgrade and BT Media to have issues. Contacted support waited 2 weeks. Nothing...It crashed my site. Soto make a long story short, I am looking for a new portfolio. Containing video and images. Any suggestions? Has to be SEO friendly, containing title and descriptions.

Thanks for all your help.

Tammy

[ladyrider12]

There is absolutely no directions with this component. So I followed you advice and installed this one this website that I listed above, which is the same version of Joomla. Then I edited the database to connect to old database. It is throwing this error:...

No, no and NO ... I did not say do that. If you need to add data from one database to the other you need to use an import/export extention like https://extensions.joomla.org/extension/j2xml/

No worries, I figured it out. Not a big web site and it was 3 am, I just got up from work. I don't think my brain wasn't working properly.

Thank-you though,
Tammy

[ladyrider12]

If I understand correctly, you have a brand new Joomla website (straight out of the box) with nothing added—no content, no extensions. Please let us know if I have misunderstood you.

You would be correct.

[sozzled]

If there's any way I can to offer you a lifeline, you may contact me by PM.

[leolam]

Tammy,
If you have a backup of the old website you should restore it, and use this to transfer your data https://extensions.joomla.org/extension/sp-transfer/. If you do not have the full copy you use the method given by Webdongle above viewtopic.php?p=3487549#p3487389 to restore the database in Joomla after which you use SP Transfer

For portfolio you might have a look at

https://extensions.joomla.org/extension ... portfolio/
https://extensions.joomla.org/extension ... portfolio/

Leo