as newb a qiestion at they come

Worker Joined: Jun 09, 2007 Posts: 172

I have 8 up and runnng, but sfter playing with this some I like the way it works handles and stuff.
Now I am modded pretty heavy, and my froms are using a newer bbcode that you have for nuke.
What I cannot find is a program that will convert the nuke8 dataabase, or should i just overwrite with rn and see what happns!

If you tell me that you these is posted in another area, please show me the link so i may try to read up on this.

thanks

Posted: Sat Jun 30, 2007 3:11 am

You will need to downgrade your database first. Take a look at the following post: http://www.ravenphpscripts.com/posts11921-highlight-downgrade+database.html

RN also comes with instructions to help you downgrade as well.

I hope this helps.

P.S. The search feature for the forums works quite well. Wink

Posted: Sat Jun 30, 2007 10:38 am

well I went the to post you directed and if you read at the bottom the downgrade of the database didnt work and I couldnt find any more post on the subject with the search feature.
The reason I am considering rn is because I installed it for someone else and liked the way it was setup and the ease of getting it prepared for the first run. I am still doing more research on what can be done and what others are saying about their experence with rn and trying to find out if it will work with the blocks and addons i have with phpnuke 8 right now. If I find out that everything will work then I will continue to find away to convert, if not then I will probally stay with what I have and try to learn more about keeping it up.

I thank you for your time reading all this, and if there is another post that covers exactally what I am saying here, please show me, as I couldnt find any Sad

registered · Posted: Sat Jun 30, 2007 11:18 am

It is indeed possible to convert from PHP-Nuke 8 to RN. Many people have done it. You must convert your database tables to the format expected by RN first (if you want to keep your data).

Posted: Sat Jun 30, 2007 11:28 am

how? please show me where I cant find the program to do this? the one that was posted someone said it didnt work. that is why i made the comment in the last post. The link that was shown in the post before had a link to where someone created a convert of the sql files and then another post said that it didnt work and was showing a sql error that they were getting. This is why I was trying to follow up with the questions.

Posted: Sat Jun 30, 2007 11:35 am

You can use a tool such as mySQLdiff to compare two databases and this should also generate the SQL to alter the database.

Take RN database and compare it to your 8.0 database and this should tell you what is different.

Posted: Sat Jun 30, 2007 11:55 am

I would like to say it is easy, but if you have a lot of MODS etc. it will take a bit of time, but it can be done. I would recommend setting up a test site and taking it one step at a time. Wink

Posted: Sat Jun 30, 2007 11:55 am

should this be only to the new install database? to see the difference between the tables of a new install?
could i just take the sql file to add for 8 and for rn and do the compare and it create the changes? or will the program only read from the database itself?
I am not trying to ask for you to teach me how to use mySQLdiff but I am trying to figure the easiest way to get it accomplished.

btw, was this the same thing that the person from *darklords* did and offered for a dl?

Posted: Sat Jun 30, 2007 12:10 pm

I found the post I was thinking of, but it's for 7.9 not 8.0. The principal should be the same though. http://www.ravenphpscripts.com/posts12962-highlight-mysqldiff+downgrade.html

You need to have them as databases to do the compare.

You could do this manually, but it might take a while.

Not sure how darklord created his.

Posted: Sat Jun 30, 2007 12:33 pm

Jakec - thank you for the link, this is giving me some info that will help me. I will have to work with the mysqldiff to make sure I dont mess things up to much. It looks like i can do these changes one file at a time so i shouldnt have to worry much about alot of the addons i have.
I guess it would be good for me to do a fresh install of rn and add all the stuff i have to 8 and when I get it working then figure the database files that I would need to move over to keep the userbase and and forums
wouldnt it be great if all i would have to do is install rn over what I have and it all work Smile

*sorry thinking out loud*

I would also like to say that the responce to all my questions have been a shock, since alot of places that I have worked with sometimes takes days, weeks or not at all to respond to questions.

thank you

Posted: Sat Jun 30, 2007 12:54 pm

Get yourself XAMPP so you can do all this locally without messing up your real site. The 7.9 downgrader script has been reported to work with 8.0. Alternatively, get yourself mysqldiff and create your own conversion script.

Posted: Sat Jun 30, 2007 6:27 pm

I installed the xampp and it seems to be working, its just getting everything working with it so i can see it with windows.

Posted: Sat Jun 30, 2007 6:38 pm

I installed the xampp and it seems to be working, its just getting everything working with it so i can see it with windows. I have the site on my computer and moved it into the folder that it says, and then I dumped the sql database an placed it in the database it makes using myphp. and this is where I am so far. now its figuring out how and what name i need to setup for the config to see the database i guess

Posted: Sat Jun 30, 2007 8:26 pm

Sounds like you are on your way. I'd download mysqldiff next and compare the two databases. A tip from me, ignore any changes it recommends with regard to changing field collation or dropping indices. Good luck.

Posted: Sat Jun 30, 2007 8:53 pm

well i finally got it to work, took me forever to know what to use for the username and password hehe, but I finally got it working. I also downloaded the database from the site and have everything working.
Now to make sure that I am on the right trail, I will install and have rn working, after that i will need to install the mysqldiff.
Now when i am doing the compare, my site will be the main and i am compairing it to rn? and when i do this *not used mysqldiff yet* will it look at the entire database or just a single part of the database? as an example not to be exact on my site there could be nuke_config and it would only compare with nuke_config on rn? or would it load all i have in my database and compare all that is in rn and then ignoring the changes it recomends that you suggested, let it create a sql fix and run it?

I know I am asking before I am doing anything yet, but I am really looking to get closer to a mindset to what needs to be done.. could save alot of time Smile

Posted: Sat Jun 30, 2007 9:06 pm

Read the docs for mysqldiff. It compares two databases (all the tables within them) and generates SQL to bring one in line with the other.

When I ran mine it generated a few lines of garbage that I had to manually correct. So look out for that.

I posted the SQL I got from Nuke 7.9 here:
http://www.ravenphpscripts.com/posts12962-highlight-mysqldiff.html