Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> Raven's RavenNuke(tm) v2.02.02 Distro
Author Message
Maclain
Regular
Regular


Joined: Feb 25, 2006
Posts: 60
Location: England

PostPosted: Thu Feb 01, 2007 11:32 am Reply with quote

Evening all.

Well, I've done some searching, but i think i'd prefer to start a dedicated thead for this one Smile

Fallen out with current web host for Only registered users can see links on this board! Get registered or login! so moving to a new host.

Decided to go with raven nuke for the new installation.

My plan was to do a afresh install of raven nuke, then bring my table data across, I;m only actually bothered about user, forums, downloads, weblinks and news - the usual really.

problem is the tables dont match up, i've altered the nuke_users table in ravennuke to match the colums of my 7.5 installation, and then imported the data. It comes accross ok - Your sql quirey has beene executed successfully. But the users are not actually in the table.

Any clues?

P.S new installation is @ filesharinginfo.com

P.P.S What kind of cost would I be looking at for one of you professionals to move it over for me? Very Happy

_________________
Insert funky message here: 
View user's profile Send private message Visit poster's website
hitwalker
Sells PC To Pay For Divorce


Joined:
Posts: 5661

PostPosted: Thu Feb 01, 2007 1:56 pm Reply with quote

my 7.5 installation ?
and the topic says 7.6 patched....so what version do you mean ?
 
View user's profile Send private message
Maclain
PostPosted: Thu Feb 01, 2007 2:49 pm Reply with quote

sorry, my phpnuke 7.6 with the chatserv patch.

heh multitasking Wink
 
fkelly
Former Moderator in Good Standing


Joined: Aug 30, 2005
Posts: 3312
Location: near Albany NY

PostPosted: Thu Feb 01, 2007 3:00 pm Reply with quote

There's a "for hire" forum to discuss issues related to that and see if someone will help.

A couple things on your post: If you are doing a Ravennuke installation then you need to make the tables match that. Altering the RN tables to match your 7.6 tables won't work.

You don't say what type of query you executed to import your data. I'm not sure that you couldn't just alter your existing table, with the data in it, to match the structure of RN. Then you wouldn't have to import anything. The same goes for your other tables.
 
View user's profile Send private message Visit poster's website
Maclain
PostPosted: Thu Feb 01, 2007 3:10 pm Reply with quote

So basically the best way to go is to backup my existing database, move the data into a second database and then alter that to match the Rn structure. That way i dont screw up my original site.

Then I can just pull the tables into the RN database.

Sound about right?
 
fkelly
PostPosted: Thu Feb 01, 2007 3:30 pm Reply with quote

Yeah, that sounds like a plan to me. You don't need to hire anyone Smile

You won't really be "pulling the tables" ... you will just be altering them, with existing data, to match the RN structure. That way the RN programs will work with them.

Just thinking as I write; there are certain tables in the RN distribution, such as Groups, that may not be in your old distribution. So for any missing tables you'll need to load them separately.
 
Maclain
PostPosted: Thu Feb 01, 2007 3:38 pm Reply with quote

well my plan was to alter the tables i actually want to keep.

ie the users table, forums, downloads links etc and replacing the tables that RN installs with my existing tables. - after altering my existing tables to match RN's
 
fkelly
PostPosted: Thu Feb 01, 2007 5:08 pm Reply with quote

I think we are on the same page. But I hate to leave things to chance. So to be sure: what you are saying is that you will alter the tables that have data in them that you want to retain. The other tables you will just use straight from Ravennuke as they are loaded during the install process. I am just saying that because you do need ALL the tables that come with the distribution or else something will go wrong at some point.
 
Maclain
PostPosted: Fri Feb 02, 2007 9:59 am Reply with quote

Thats the plan.


Run the RN installation in a fresh database (db1).

Copy my existing phpnuke database(db2) to a third database (umm db3 Smile).

Alter the tables in db3 that i want to keep to match the tables in db1.

replace the tables in db1 with the tables from db3

Easy Smile

Edit: Question. Hmm not sure how to put this one, my sql knowledge is limited. Does the field layout have to be the same?

Example, lets say I have a field user_name in _users table in the RN db that has auto numbers and such, but in my existing phpnuke table the filed sint there, so to add it i'd be doing this:

Alter table `_users` ADD `user_name` TEXT NOT NULL;

would that still work, even though i have not toldit about the auto numbers and waht ever other settings it might have used?
 
Display posts from previous:       
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> Raven's RavenNuke(tm) v2.02.02 Distro

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 ©