| Featured |
Call of Duty 4 PHPNuke Theme, Call of Duty 4 PostNuke Theme, Call of Duty 4 Evo Theme, Call of Duty ...
$19.95
[ Enter Store ]
|
 |
| Main Menu |
|
|
|
| Site Status |
 Welcome Guest
Join us!
 
Registration is free and gives full access to site
 Register | | | |  Login:
|
| | | | | |  | Members: |  | Today New: | 0 | | | Yesterday: | 2 | | | Total: | 6929 | | | Last: | | silver163 |
| | | |  | Online |  | Members: | 0 |  | Guests: | 13 |  | Total: | 13 |
| | | |  | Online Members | | No online members |
|
|
|
|
| Author |
Message |
Bawang |
|
Post subject: How to Import Phpbb2 data to Postnuke for a PNphpbb2 upgrade
 Posted: Dec 06, 2004 - 03:20 AM
|
|
Joined: Nov 28, 2004
Posts: 16
Status: Offline
|
|
Not sure this is the right forum to post this. It's an attempt to repay the wealth of info I've received from reading the pages here. I'm especially greatful to Mars for his generosity.
-----------------------------------------------------------------------------------
How to deal with the data issues in upgrading from a standalone Phpbb2 2.0.10 forum to PNphpBB2 1.2g and Postnuke .750.
For this procedure, I’ll assume that you have Postnuke .750 installed and working properly. I will also assume that, as was my case, you installed Postnuke in a different database than the one used by your Phpbb2 2.0.10 forum.
I had downloaded PNphpBB2. But before installing it I had to take care of the problem of having the Phpbb2 tables in a different database than the Postnuke database. The standalone Phpbb2 tables must be copied into the Postnuke database.
The first thing I did was remove all users from Postnuke except for the admin account created when Postnuke was first installed (userid 2). This is supposed to be done automatically by the PNphpbb2 upgrade procedure but in my case I removed them manually.
Using Phpmyadmin, I exported all the tables in the Phpbb2 database to a gzipped file on my hard disk. We must talk of the matter of the table names in the Phpb2 database. They must all have the phpbb_ prefix for this to work. If they don’t, you must take care of that before you try to install PNphpbb2. I had no problem there as my table names did have the default phpbb_ prefix.
This are the steps to export the Phpbb2 tables:
On the left side of the Phpmyadmin window there’s a pick list with your databases. Pick your Phpbb2 database
At the top of the Phpmyadmin window, these are the options you see:
Structure SQL Export Search Query
Click on the “Export” option.
When you do that, you see a pick list with all your phpbb_ files and with the heading “Export”.
Click on the option “Select all” under the list.
Click on the "gzipped" button at the bottom
Now click on the GO button
This will save a gzipped file with all the Phpbb2 tables on your hard disk.
Now let’s import the tables in that file into the Postnuke database.
This is how I did it:
On the left side of the Phpmyadmin window, pick your Postnuke database.
You’ll again see the following options and a list of the Postnuke tables, which usually have the nuke_ prefix.
Structure SQL Export Search Query
Click on the SQL option:
Click on the “Browse” button, this will let your browse through your hard disk to look for the file you made in the “Export” procedure before.
Click on the "gzipped" button at the bottom
Now click on the GO button
Now cross your fingers. If everything goes well all your Phpbb2 tables will be in your Postnuke database and you’ll be ready to install PNphpbb2.
But that step didn’t work for me. The problem was my server would only give me 5 minutes to carry out the import operation. At the end of the five minutes, I’d get this message:
Fatal error: Maximum execution time of 300 seconds
exceeded in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/read_dump.lib.php
on line 91
My next attempt was to break the exports into smaller groups of tables so that the import could take place in the 5 minute window. This worked until there was one table, phpbb_search_wordmatch, which was simply too big to make it in the 5 min window. It was time for a different approach.
This was my second method for moving the Phpbb2 tables into the Postnuke database:
I only had one table to go, if only I could just copy it directly from one database into another without any export and import. Actually, I found out to my relief this is very easy to do. This is the procedure to copy the tables one by one from one database to another:
Go to Phpmyadmin startup screen with the Database pick list on the left.
Pick the Phpbb2 database
Go down the list and click on the table you to want to copy over to the Postnuke database (phpbb_search_wordmatch in my case)
When you do that you’ll see a long list of options on top ending with: Operations Empty Drop on the right. Stay away from Empty and Drop.
Click on the “Operations” option, - it has a hammer and wrench icon.
Go down to where the Copy table to (database.table): label is:
There are two boxes under that label. The one on the left is already filled in with the name of your Phpbb2 database, but that’s NOT the database you want to copy to.
You must click and pick the Postnuke database.
The text box on the right is empty and you must enter the name of the Phpbb2 table you want to copy. You can just do a copy and paste from the box right on top.
Make sure the Structure and data button is clicked (it is by default).
Click on the GO button.
That’s it. We’re done. Now you’re ready to install PNphpbb2, but I won’t go into that as there’s plenty of documentation for that at http://pnphpbb.com and other support sites.
I looked all over the Internet for just such a step by step procedure and didn’t find it. If I save one person the frustration I went through it’ll be worth it.
Bawang |
|
|
| |
|
|
|
 |
|
mars |
|
|
Post subject: RE: How to Import Phpbb2 data to Postnuke for a PNphpbb2 upg
Posted: Dec 06, 2004 - 10:34 PM
|
|
Site Admin
Joined: Aug 15, 2004
Posts: 3934
Status: Offline
|
|
Nice info!
Thanks for sharing it. |
|
|
| |
|
|
|
|
|
Ray |
|
|
Post subject:
Posted: Dec 07, 2004 - 12:13 AM
|
|
Information Hound
Joined: Aug 17, 2004
Posts: 681
Status: Offline
|
|
| We should add this to the FAQ,s. |
|
|
| |
|
|
|
|
|
|
|
|
|
FAQ
Search
Register
Log in to check your private messages
Log in
