You are missing our premiere tool bar navigation system! Register and use it for FREE!

NukeCops  
•  Home •  Downloads •  Gallery •  Your Account •  Forums • 
Readme First
- Readme First! -

Read and follow the rules, otherwise your posts will be closed
Modules
· Home
· FAQ
· Buy a Theme
· Advertising
· AvantGo
· Bookmarks
· Columbia
· Community
· Donations
· Downloads
· Feedback
· Forums
· PHP-Nuke HOWTO
· Private Messages
· Search
· Statistics
· Stories Archive
· Submit News
· Surveys
· Theme Gallery
· Top
· Topics
· Your Account
Who's Online
There are currently, 198 guest(s) and 0 member(s) that are online.

You are Anonymous user. You can register for free by clicking here
Nuke Cops :: View topic - phpBB to Nuke [ ]
 Forum FAQ  •  Search  •   •  Memberlist  •  Usergroups   •  Register  •  Profile •    •  Log in to check your private messages  •  Log in

 
Post new topic  Reply to topicprinter-friendly view
View previous topic Log in to check your private messages View next topic
Author Message
sjmiller85
Nuke Soldier
Nuke Soldier


Joined: May 15, 2007
Posts: 16


PostPosted: Mon May 14, 2007 6:10 pm Reply with quoteBack to top

I have never attempted this, for fear of things going terribly wrong, but I was wondering how difficult, or how I would go about updating a site that has the phpBB forums, preserving all the tables containing user account and post, washing the site clean (with the exception of those tables), and doing a fresh install only this time using PHPNuke (with phpBB of course)? Is it as simple as backing up a few tables then dumping all my tables, install Nuke, then uploading my saved tables back into phpMyAdmin? Thankyou for all your help.
Find all posts by sjmiller85View user's profileSend private message
Evaders99
Site Admin
Site Admin


Joined: Aug 17, 2003
Posts: 12482


PostPosted: Mon May 14, 2007 7:19 pm Reply with quoteBack to top

More or less, yes. Remember that you'll need to be using the same phpNuke/phpBB versions, otherwise your tables may not match.

You'd have to save all the forums tables (the ones starting with nuke_bb) along with the users table (since that is what phpNuke and the forums both use).

_________________
Helping those that help themselves
Read FIRST or DIE!

"Fighting is terrible, but not as terrible as losing the will to fight."
Star Wars Rebellion Network - Need Help? Evaders Squadron Coding
Find all posts by Evaders99View user's profileSend private messageVisit poster's websiteAIM Address
sjmiller85
Nuke Soldier
Nuke Soldier


Joined: May 15, 2007
Posts: 16


PostPosted: Wed May 16, 2007 9:20 pm Reply with quoteBack to top

I'll give the whole predicament so it will hopefully better explain the situation in hopes of finding a solution.

My cousin has a website:

http://stickonlinegame.com

I am offering to scrap the site and recreate it with PHPNuke. He agrees that this would be a GREAT improvement, he only asks that he keeps all the posts on his PHPBB portal, which would also imply that i need to carry over the users table as Evaders99 has mentioned. The problem with this, as far as I can tell is that the tables are named differently for phpBB as opposed to the similar tables for phpBB in Nuke. The second problem, and we are trying our hardest to get to a resolution on this, is that he does not have access to phpMyAdmin. Someone else set up the site on his own server, and gave no information for accessing a control panel or phpMyAdmin. My cousin knows practically nothing about PHP/MySQL, and that is why I am offering to help. I cannot access the database to pull the tables, so he is attempting to export the full DB through the admin section on phpBB, which isn't proving very fruitfull. the full database can be found at http://www.stickonlinegame.com/phpbb_db_backup.sql This database is very scrambled compared to when one would export a database off of phpMyAdmin. I couldn't sort any tables out of it, and in a last ditch effort, I simply tried to import the entire DB into phpMyAdmin, which would not load (maybe due to it being over 18 MB in size). Is there any work around way for getting the tables? Once I find a way, is there any script I can run to convert the db tables? Thank you for your help!!!
Find all posts by sjmiller85View user's profileSend private message
Evaders99
Site Admin
Site Admin


Joined: Aug 17, 2003
Posts: 12482


PostPosted: Thu May 17, 2007 5:28 am Reply with quoteBack to top

If you cannot import the tables with phpMyAdmin, use the Big Dump script

_________________
Helping those that help themselves
Read FIRST or DIE!

"Fighting is terrible, but not as terrible as losing the will to fight."
Star Wars Rebellion Network - Need Help? Evaders Squadron Coding
Find all posts by Evaders99View user's profileSend private messageVisit poster's websiteAIM Address
sjmiller85
Nuke Soldier
Nuke Soldier


Joined: May 15, 2007
Posts: 16


PostPosted: Thu May 17, 2007 11:15 am Reply with quoteBack to top

well, I ran BigDump using the exported DB from the phpBB admin, and it seemed to transfer over only the post counts, different forums, pretty much everything, except for the users, therefor the post counts would appear in BB, but when I actually access the forums, they are blank.
Find all posts by sjmiller85View user's profileSend private message
Evaders99
Site Admin
Site Admin


Joined: Aug 17, 2003
Posts: 12482


PostPosted: Thu May 17, 2007 11:42 am Reply with quoteBack to top

phpNuke cannot run directly on the phpBB tables. You still need to run a database conversion script

I have one here: http://evaders.swrebellion.com/forums/postt25.html

_________________
Helping those that help themselves
Read FIRST or DIE!

"Fighting is terrible, but not as terrible as losing the will to fight."
Star Wars Rebellion Network - Need Help? Evaders Squadron Coding
Find all posts by Evaders99View user's profileSend private messageVisit poster's websiteAIM Address
sjmiller85
Nuke Soldier
Nuke Soldier


Joined: May 15, 2007
Posts: 16


PostPosted: Fri May 18, 2007 3:16 pm Reply with quoteBack to top

Thanks, is there any way to pull tables without accessing phpMyAdmin and without using the forum DB backup utility?
Find all posts by sjmiller85View user's profileSend private message
Evaders99
Site Admin
Site Admin


Joined: Aug 17, 2003
Posts: 12482


PostPosted: Sat May 19, 2007 9:18 pm Reply with quoteBack to top

Command line Smile
That's assuming you have ssh access to your server and mysql permissions. Really that's less likely than phpMyAdmin

_________________
Helping those that help themselves
Read FIRST or DIE!

"Fighting is terrible, but not as terrible as losing the will to fight."
Star Wars Rebellion Network - Need Help? Evaders Squadron Coding
Find all posts by Evaders99View user's profileSend private messageVisit poster's websiteAIM Address
sjmiller85
Nuke Soldier
Nuke Soldier


Joined: May 15, 2007
Posts: 16


PostPosted: Sun May 20, 2007 4:59 pm Reply with quoteBack to top

unfortunately I don't have ssh access. Bah, this isn't looking to promising.

I am trying to back up the DB via the phpBB admin, and for some reason, I am not getting the whole backup (I only get about 2/3 of the tables). The file is exceeding 18 MB, which I am not sure if that the immense size is cause for error in this, but it is proving to be an immense pain.
Find all posts by sjmiller85View user's profileSend private message
Evaders99
Site Admin
Site Admin


Joined: Aug 17, 2003
Posts: 12482


PostPosted: Sun May 20, 2007 8:09 pm Reply with quoteBack to top

I've never had a problem with phpMyAdmin. It works very reliably, better than the forums admin. If you can install phpBB, you can install phpMyAdmin

_________________
Helping those that help themselves
Read FIRST or DIE!

"Fighting is terrible, but not as terrible as losing the will to fight."
Star Wars Rebellion Network - Need Help? Evaders Squadron Coding
Find all posts by Evaders99View user's profileSend private messageVisit poster's websiteAIM Address
Display posts from previous:      
Post new topic  Reply to topicprinter-friendly view
View previous topic Log in to check your private messages View next 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



Powered by phpBB © 2001, 2005 phpBB Group

Ported by Nuke Cops © 2003 www.nukecops.com
:: FI Theme :: PHP-Nuke theme by coldblooded (www.nukemods.com) ::
Powered by TOGETHER TEAM srl ITALY http://www.togetherteam.it - DONDELEO E-COMMERCE http://www.DonDeLeo.com - TUTTISU E-COMMERCE http://www.tuttisu.it
Web site engine's code is Copyright © 2002 by PHP-Nuke. All Rights Reserved. PHP-Nuke is Free Software released under the GNU/GPL license.
Page Generation: 0.232 Seconds - 166 pages served in past 5 minutes. Nuke Cops Founded by Paul Laudanski (Zhen-Xjell)
:: FI Theme :: PHP-Nuke theme by coldblooded (www.nukemods.com) ::