NukeCoder

Repeat Offender Joined: May 27, 2008 Posts: 25

Here is a question that I have and I’ve looked high and low for an answer.

Is it possible to restore a site from a 'control panel FULL BACKUP', I believe its possible for a host to do this but a user?
The database is generally one massive file, obviously the root directory structure of the nuke site is easy to restore but the database, well its a different kettle....
Basically I have a site backed up (for those who know, the one with 300 errors / sec) It is rammed with posts and content that I would like to transfer to the new site running at 8.1, the problem is now that ive kind of got the new one established and new members I will need to merge the two Db’s together, and with this introduction of Raven Nuke, well maybe its time to do all the changes.
What would be your suggestions, my idea would be to purchase more webspace and run the two sites parallel until I have the second (the new merged one) up and running totally the way I like it and then close or redirect the traffic to the new one. My domain name is held with 123reg.com so it would be easy to make the switch, however the data manipulation is not.

Code Authors · Mr. Awesome Joined: Dec 09, 2006 Posts: 234

As you mentioned in another post, XAMPP is pretty good for testing a fill install.
The problem is not so much synching the structure as that is fairly simple but if you are also going to try anf synch the data as well, that can get pretty messy if you have not done anything like that before.
The problem stems from each row of data having a unique id and that id might be used to fetch data from yet another table etc tec, so if you are not extremely careful, it can get messy and you'll end up with a well and truly broken database.

For the database structure I use the utlity I have on my site but there are other more 'professional' and free utilities like mysqldiff.

Repeat Offender Joined: May 27, 2008 Posts: 25

Yeah it does sound very complicated.

I may run the old site from my PC and transfer data, as 'new posts'.
May take a lifetime but is less likely to kill the sql database.

The members list is another problem. Any ideas on how to sort this one Guardian?

Code Authors · Mr. Awesome Joined: Dec 09, 2006 Posts: 234

Depends what you mean by members list Wink

If I remember correctly, the members list (as in the Member List module) takes it's data from the forum tables ( nuke_bbusers - or something like that) but the nuke registered users are taken from the nuke_users table (admins are in the nuke_authors table).
You would need to add your nuke users then identify which user 'id' correlated to the same 'id' for the nuke bbuser.
If I get a chance later, I will try and take a look but I'm pretty tied up with some RavenNuke work at the moment.

Repeat Offender Joined: May 27, 2008 Posts: 25

No worries Guardian, just if you get time, I know how busy working on forums can be....

Code Authors · Mr. Awesome Joined: Dec 09, 2006 Posts: 234

godfather wrote:

No worries Guardian, just if you get time, I know how busy working on forums can be....

Tell me about it - that's on top of the 18 websites of my own I have to maintain plus script installation <sigh>

Newbie Joined: Jun 02, 2008 Posts: 2

Hello.. if i may interfear...

If your old db "structure" is the same as the new one , then i recommend to use bigdump.
once filled up your new db with the old data you maby can do a user/data comparsion.
The point is.. if you use your old data ( from what i readed it is a huge sql file), it then might be go faster to add the new data to the old , assuming the new is much lesser data.
You could also make comparsion for users or even create a importer script what do check for if user exist.
Your main problem isnt the users, but the forum , its topics and sub forums.I assume you already created the forum and maby even named the forums same as old, even when each have theire unique Id , it can bring aloth of confusion, but theres hope for you.
You could take your new forum content , add its data to a dummy site, rename all topics like "(original)put all for themes in this forum"
"(new) put all for themes in this forum DUMMY"
Now then you goto your phpmyadmin and let start the increments AFTER the last id of your old forum data asssuming your last forum id = 1120 then let start your new forum data with 1121.
Anyway.. as i am more a do guy as an explaining guy.. you have to figure out what i mean yourself.( in dutch i could explain better)