Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> Post Installation Help
Author Message
beerfrog
Regular
Regular


Joined: Sep 11, 2005
Posts: 54
Location: Sweden

PostPosted: Mon Jul 02, 2007 5:11 am Reply with quote

Hi all.

I just installed the new RN .01 and as always it runs smothly.

I had an old site that was hacked running PhpNuke7.6 (i think) and I would like to transfer some of the old content to the new installation.
Such as forums, news, topics, users and so on

The old database is attributed nuke_
The new database is attributed Pv2_

How do I copy the data from one db to the other, i've tried running it as an "operation" i myphpadmin, but it fails for some reason.

Is there any way to copy multiple tables (nuke_) and rename the old attributes to replace the new empty tables at Pv2_

Cheers / B

_________________
Only registered users can see links on this board! Get registered or login! 
View user's profile Send private message Visit poster's website Yahoo Messenger MSN Messenger ICQ Number
Gremmie
Former Moderator in Good Standing


Joined: Apr 06, 2006
Posts: 2415
Location: Iowa, USA

PostPosted: Mon Jul 02, 2007 7:07 am Reply with quote

If the tables had the exact same structure you could use phpMyAdmin to export (as SQL and keep the data) and then import the data into the new database. There are export and import tabs in phpMyAdmin.

If the structures don't match you may have to ALTER the old tables first. A tool like mysqldiff will help tell you that.

_________________
Only registered users can see links on this board! Get registered or login! - An Event Calendar for PHP-Nuke
Only registered users can see links on this board! Get registered or login! - A Google Maps Nuke Module 
View user's profile Send private message
Gremmie
PostPosted: Mon Jul 02, 2007 7:08 am Reply with quote

Oh and to get around the different table prefixes you would have to edit the SQL generated by the export before doing the import.
 
nextgen
Worker
Worker


Joined: Sep 28, 2006
Posts: 227
Location: Maryland

PostPosted: Wed Sep 05, 2007 5:15 pm Reply with quote

What if you had 2 different databases and you wanted to pull the forum posts, users and PM's from one to the other and they are different tables like the user table had nuke_points, respect etc and the other didnt. What would i use to join one to the other.
 
View user's profile Send private message Send e-mail Visit poster's website Yahoo Messenger MSN Messenger
Gremmie
PostPosted: Wed Sep 05, 2007 6:09 pm Reply with quote

Do you want the other one to get those fields or just ignore them in the new table?

You could export the data with phpMyAdmin and massage it with a text editor. Or you could use a tool like MySQLDiff.
 
nextgen
PostPosted: Wed Sep 05, 2007 6:23 pm Reply with quote

I need to keep those fields and add the other users to the users tables so they will begin to earn points, respect etc. Thanks for the very quick response by the way. Smile
 
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> Post Installation Help

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©