Need to Copy Members from old site to new site

Private Joined: Apr 27, 2006 Posts: 46

Hey, I am not sure the best place to post this question. I run a site for djs and it keeps getting hacked. I tried to install the patches and Sentinel but I don't think they were installed correct. They went in today and deleted all my forums. I have had enough so I installed RavenNuke because of the extra built in securtiy. I have them both installed on my server now. I am wondering if I can transfer my members database from my old phpnuke site to my new RavenNuke Site. I have almost 7,500 and I REALLY don't want to loose them.

Thanks
Steve

Posted: Tue Apr 10, 2007 12:34 pm

Go into your old database and export the nuke_users table . Once you export that , take the data from the user's table (should look like below only with a lot more users)

Code:

-- Dumping data for table `nuke_users`
--

INSERT INTO `nuke_users` VALUES (1, '', 'Anonymous', '', '', '', 'blank.gif', 'Nov 10, 2000', '', '', '', '', '', 0, 0, '', '', '', '', 10, '', 0, 0, 0, '', 0, '', '', 4096, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 10, NULL, 'english', 'D M d, Y g:i a', 0, 0, 0, NULL, 1, 1, 1, 1, 1, 1, 1, 1, 0, 3, NULL, NULL, NULL, 0, '0', 0, 0);

and simply run those sql queries on your new database . Also, since you have already installed a new site , you will not need to insert the data for the Anonymous user or the admin . You will only need to insert the data for the users that have not registered on the new site yet . Hope this helps .

Private Joined: Apr 27, 2006 Posts: 46

I am into phpmyadmin and clicked export under nuke_users and have it sent to a .rtf file. Is This Right ? I am not sure what to do next. I am kind of new to this.

This is the screen I have

Thanks,

Steve

Posted: Tue Apr 10, 2007 2:58 pm

Where it says , "Save as file" choose "zipped" then click go . Save the zip file to your hard drive somewhere . Once you get the file, un-zip it and open it up . You will want to copy everything from below where it says

Quote:

-- Dumping data for table `nuke_users`

. So everthing you need to copy should start like this

Code:

INSERT INTO

As I said before, you do not need to copy the Anonymous user or the admin , since your site is already installed (the new one) . So , to ensure this , I would skip the first three lines that start with

Code:

INSERT INTO

.
Now, go into your database area for the new site and somewhere you should see where it says " SQL" (probably top left corner of your page) . Click that and you should see a query window . This is where you are going to paste all of your member data that you just copied .

Private Joined: Apr 27, 2006 Posts: 46

Hey man thanks for the help I have all my download and forums backup except I still can't get the users back. Because there are no users the forums show there are posts but you can't see the posts. I exported the list from the old nuke_users and when I try to import it this is the error I keep getting.

I removed the anonymous account and have zero accounts made in the RavenNuke install besides the admin account.

Thanks for all the help man

Slue

Posted: Wed Apr 11, 2007 2:01 am

What version what your old nuke site?

Private Joined: Apr 27, 2006 Posts: 46

Its 7.9 just recently updated

Posted: Wed Apr 11, 2007 10:42 am

Post your structure of nuke_users .

Posted: Wed Apr 11, 2007 11:39 am

Let me clarify a bit more . Log into phpmyadmin and go to your database . Click on the nuke_users table . That should open up the structure of that table (if not, then click on the tab at the top that says Structure) . Copy and paste it so I can see what the difference is between the two versions . The goal is to get your old nuke_users as close to Raven's 7.6 as possible . Also, while you are there , get another backup of your old site and keep it somewhere on your hard drive Wink

Private Joined: Apr 27, 2006 Posts: 46

I will try that now and let you know how it goes. Does it matter if people are registered on my New site now? They might be using the same username

thanks

Steve

Posted: Wed Apr 11, 2007 11:58 am

djslue wrote:

Does it matter if people are registered on my New site now?

Once you submit your query and if the username is already taken , then it's going to spit an error . If members have already started to register than instead of copying all of the data for the nuke_users , you will now have to surf through it to make sure that you don't copy someone that has already registered on the new site .

Private Joined: Apr 27, 2006 Posts: 46

Would This be the reason my forums aren't working correct? It shows the number of posts but does'nt show the posts? Can I just remove my new database and use this one? How would I do that?

thanks again for all the help man.

Steve

Posted: Wed Apr 11, 2007 3:10 pm

djslue wrote:

Would This be the reason my forums aren't working correct?

No . It's probably because you were running a different version from your old site then whats on your new one .

djslue wrote:

Can I just remove my new database and use this one? How would I do that?

You won't be able to just use your old database info without doing some tweaking . You would need to get the old database as close as possible to that of Raven's 7.6 .

Edit I looked at your site and it appears as though your members are there now?

Private Joined: Apr 27, 2006 Posts: 46

Yah Man I Got it Working Tonight. I did what you said and got it to work. Had to make 2 additions to the old one and it was good to go. Some members are showing up twice while online and I think its just cause they were online when I did it and they might of been added twice. Everything else works great though including the forums. I had like 3,000 posts in there and was the last thing I wanted to loose. Thanks for the help man. Going to read up on the shout box issue now and hopefully get that back on the go.

Thanks Again

Steve

Private Joined: Apr 27, 2006 Posts: 46

Fixed It. Thanks Man. I have a Strange issue where everything is centered in IE but not FireFox. I don't want it to be centered. Any help would be great.

Your a life savor. I am not so scared of my .sql databases now haha.

steve