Just a basic question to make sure I don't mess up

Hey guys, I had to do a restore from a previous backup because of some database issues. I lost information on one important module, namely my news module. I would like to know if I drop in the backed up folder with all the latest news content and overwrite the folder that my site now has, will the content be restored, or is it more complicated and will I have to do other steps. BTW I have each article saved on my desktop, I just want to avoid having to redo each article.

Thanks

Quote · 20 Nov 2012

No, the articles data was in the database, not in the folders.

ManOfTeal.COM a Proud UNA site, six years running strong!
Quote · 20 Nov 2012

I had something similar..

I updated to 7.1, and had extensive forums content on the site.

Making a new database and restoring your old data to it should/maybe, if it's not totally corrupt, allow you to pull all the articles via phpMyAdmin.

Then import into the current database.

Can you use phpMyAdmin?

In the photo, this is my database for a site with four articles on it. I exported these, and then import into the new site.

Anytime I have a lot of articles or forums topics and data, this is where I pull the old..

exporting-articles.png · 292.6K · 442 views
ManOfTeal.COM a Proud UNA site, six years running strong!
Quote · 20 Nov 2012

Hey Newton27, thanks for the insight. I'm using a different module than the boonex official. I want to try the export/ import option, what should I do to make sure I can go back to my current state if I mess things up. Oh and when I import, will the 'entries' data simply overwrite the current entries data, or would I need to do anything more.  

Quote · 20 Nov 2012

OK I see the two databases, I tried exporting one entry from the old database to the new. Can you explain the process? Do I do the quick or custom method and also do I export it as an sql? WHen I finally tried importing, I select the correct database and then imported the downloaded entry file. This is the error message I recieved...

SQL query:

-- -- Dumping data for table `imagenews_entries` -- INSERT INTO `imagenews_entries` (`id`, `author_id`, `caption`, `snippet`, `image`, `content`, `when`, `uri`, `tags`, `categories`, `comment`, `vote`, `date`, `status`, `featured`, `rate`, `rate_count`, `view_count`, `cmts_count`) VALUES (298, 0, 'NES 8-bit Google Maps April Fools Prank Goes Viral', 'What was just an idea to prank the world, has now become quite a world-wide phenomenon.', '1333233714.png', '<script type="text/javascript">// <![CDATA[rngoogle_ad_client = "ca-pub-3721534537499027";rn/* big banner news */rngoogle_ad_slot = "6820325762";rngoogle_ad_width = 728;rngoogle_ad_height = 90;rn// ]]></script>rn<script src="http://pagead2.googlesyndication.com/pagead/show_ads.js" type="text/javascript">rn</script>rn<p><a href="http://www.socialeaf.com" target="_blank"><img src="http://i261.photobucket.com/albums/ii59/peter7del/socialeafcomarticlelogo.png" border="0" alt="Socialeaf News | technology, science, [...]

MySQL said: Documentation

#1062 - Duplicate entry '298' for key 1 

I'm fairly familiar navigating the databases, just need a little help from someone more experience. thanks for helping out!

Quote · 20 Nov 2012

 

OK I see the two databases, I tried exporting one entry from the old database to the new. Can you explain the process? Do I do the quick or custom method and also do I export it as an sql? WHen I finally tried importing, I select the correct database and then imported the downloaded entry file. This is the error message I recieved...

SQL query:

-- -- Dumping data for table `imagenews_entries` -- INSERT INTO `imagenews_entries` (`id`, `author_id`, `caption`, `snippet`, `image`, `content`, `when`, `uri`, `tags`, `categories`, `comment`, `vote`, `date`, `status`, `featured`, `rate`, `rate_count`, `view_count`, `cmts_count`) VALUES (298, 0, 'NES 8-bit Google Maps April Fools Prank Goes Viral', 'What was just an idea to prank the world, has now become quite a world-wide phenomenon.', '1333233714.png', '<script type="text/javascript">// <![CDATA[rngoogle_ad_client = "ca-pub-3721534537499027";rn/* big banner news */rngoogle_ad_slot = "6820325762";rngoogle_ad_width = 728;rngoogle_ad_height = 90;rn// ]]></script>rn<script src="http://pagead2.googlesyndication.com/pagead/show_ads.js" type="text/javascript">rn</script>rn<p><a href="http://www.socialeaf.com" target="_blank"><img src="http://i261.photobucket.com/albums/ii59/peter7del/socialeafcomarticlelogo.png" border="0" alt="Socialeaf News | technology, science, [...]

MySQL said: Documentation

#1062 - Duplicate entry '298' for key 1 

I'm fairly familiar navigating the databases, just need a little help from someone more experience. thanks for helping out!

 Yes, that is a duplicated entry, I had no problem starting with empty database.

Now for like Profiles, the key 1 is for admin.. then import.

It's a complicated process, posting a video of how to is my only way to explain further if your not that good with phpMyAdmin..

I'll get one together and post in while on a basic process..

ManOfTeal.COM a Proud UNA site, six years running strong!
Quote · 20 Nov 2012

I hope you can follow this video. It is how I always backup info "selectively;" for the articles there are six entries, you will need to look at each one to see what to change, usually not much, especially with articles. Other modules that allow members to post like blogs, is another story. Members profile info has to match.. anyway here is how you can import articles to another site, if you have a database with the old still there.

http://www.youtube.com/watch?v=_xZVQJKLDHI

ManOfTeal.COM a Proud UNA site, six years running strong!
Quote · 20 Nov 2012

Michael I can't begin to thank you enough, The video really helps and now I can see exactly what I need to do. You're amazing, keep up the good work. I won't be able to get to this until later tonight but thanks. If I run into any snags along the way, I know I can refer to that great vid. 

Thanks a million

-Peter

Quote · 21 Nov 2012

 

Michael I can't begin to thank you enough, The video really helps and now I can see exactly what I need to do. You're amazing, keep up the good work. I won't be able to get to this until later tonight but thanks. If I run into any snags along the way, I know I can refer to that great vid. 

Thanks a million

-Peter

 He Michael, your advice worked like a charm. I saw that I had a discrepancy with one of the article "#'s" so that's why the process didn't work at first. You saved my hours of work thank you. Now if I could only make some decent cash off my site I'd be set ;) Take care bud!

Quote · 21 Nov 2012
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.