How to transfer phpbb forum from wamp to lamp?

Questions about other topics - please check if your question fits better in another category before posting here
Forum rules
Before you post please read this

How to transfer phpbb forum from wamp to lamp?

Postby eiger3970 on Fri Aug 03, 2012 6:24 am

Does anyone know how to transfer my phpbb forum from wamp to lamp?

I went to my WAMP 3.5.1,
selected my database name: forum,
selected Export,
Export Method: Quick - display only the minimal options.
Format: SQL
selected Go

I copied the downloaded file forum.sql to my USB.

Placed USB in new machine with LAMP.
I went to Linux Mint 13 Maya Mate,
selected Menu,
selected Applications,
selected Internet,
selected Google Chrome,
entered localhost/phpmyadmin.

In the newly opened phpMyAdmin,
selected forum,
selected Import,
selected Choose File,
selected the USB with the file forum.sql
selected Go.

I'm assuming this carried all the tables and whatever else is needed to simply make a functioning phpBB forum like on the WAMP server.

I then went to localhost to see my website and selected the forum link, which gives the error:
General Error
SQL ERROR [mysql4]
Access denied for user 'root'@'localhost' (using password: NO) [1045]
An sql error occurred while fetching this page. Please contact an administrator if this problem persists.

Is there anything else I need to do as I'm a Linux noob?
My machine specs:
Linux Mint 16 MATE 64-bit.
Copyright (c) 1997-2011 GNOME developers.
2 x Intel(R) Pentium(R) CPU G850 @ 2.90GHz
12222MB (2146MB used)
1280x1024 pixels
ATI Radeon HD 5700 Series (It's the 5770 card)
eiger3970
Level 3
Level 3
 
Posts: 115
Joined: Thu Jul 19, 2012 9:48 am

Linux Mint is funded by ads and donations.
 

Re: How to transfer phpbb forum from wamp to lamp?

Postby DataMan on Sat Aug 04, 2012 8:34 am

For starters, did you set a root password in MySQL in your WAMP install and no root password for root in LAMP?

My first choice suggestion is to rebuild phpBB from scratch in LAMP. Once it's rebuilt then export your table contents from WAMP and do a import using phpMyAdmin in the database for phpBB in LAMP. If the version of phpBB is the same in both installations, theoretically, you should have no problems... :idea: .


=DataMan
Linux'd since 2005 Linux ID 422356 Ubuntu ID 15015
User avatar
DataMan
Level 6
Level 6
 
Posts: 1199
Joined: Thu Dec 04, 2008 6:47 am
Location: Carmel, Indiana USA at /var/www

Re: How to transfer phpbb forum from wamp to lamp?

Postby eiger3970 on Sat Aug 04, 2012 11:30 pm

Thanks.

I still receive an error when going to : Mint 13 MATE Maya/Menu/Applications/Internet/Browser: localhost/forum

Not found.
The requested URL/forum\index.php was not found on this server.
Apache/2.2.22 (Ubuntu) Server at localhost Port 80.


I have gone through all the walkthroughs
viewtopic.php?f=46&t=2158966&p=13170553#p13170553

and

http://www.phpbb.com/kb/article/rebuild ... gphp-file/

Here's what I've done so far:

1. Linux Mint 13 MATE 64-bit install.
CD Linux Mint 13 MATE 64-bit into CD drive/Maya/Menu/Quit/Restart/press Delete key every ½ second/set BIOS boot order with CD drive 1st/Exit BIOS/allow several minutes for LinuxMint to setup/Maya desktop/Install Linux Mint CD icon/right click/Open/English: Continue/Preparing to install Linux Mint: Continue/Installation type: Replace Linux Mint 13 Maya (13) with Linux Mint: Continue/Replace Linux Mint 13 Maya (13) with Linux Mint: Install Now/Where are you?: Continue/Keyboard layout: Continue/Who are you?: enter name/select Log in automatically (allows remote desktop into Maya with tightVNC)/Continue/Restart.

2. LAMP server. (Linux version of Apache2, MySql and Php5).
Linux Mint 13 MATE Maya/Menu/Terminal:
2.1. sudo apt-get update
2.2. sudo apt-get install lamp-server^ (Credit to Maya chat, Glebihan).
New password for the MySQL “root” user: u…/OK
Repeat password for the MySQL “root” user: u…/OK
Linux Mint 13 MATE Maya/Menu/Applications/Internet/Browser: localhost (should see It works!).

3. Website files.
3.1. In Windows computer with website files go to Start\All Programs\WinSCP\WinSCP\Host name: 192.168.1.112\User name: root\Password: u…\Login\Skip\drag website files from E:\<FILEPATH>\<FILEPATH>\<FILEPATH>\<FILEPATH> to /var/www/
3.2. Linux Mint 13 MATE Maya/Menu/Terminal: sudo chown www-data:www-data –R /var/www (Gives correct permissions for the www-data user if you created the files as root).
3.3. Linux Mint 13 MATE Maya/Menu/Applications/Internet/Browser: localhost (should see your website).

4. Transferring phpBB from WAMP to LAMP.
4.1.Forum install and database creation.

Linux Mint 13 MATE Maya/Menu/Terminal: sudo apt-get install phpmyadmin (lamp should have already installed php?).
Web server to reconfigure automatically: apache2/Ok
Configure database for phpmyadmin with dbconfig-common?/Yes.
Linux Mint 13 MATE Maya/Menu/Applications/Internet/Browser: localhost/phpmyadmin/enter Username: root and Password: u…/Go.
phpMyAdmin/Databases/Create new database: forum/Create.
phpMyAdmin/forum/Import/Browse…/select forum.sql/Go.

4.2. Administration Control Panel.
Windows\Start\Browser: localhost:8080/forum.html/Login/Username: admin, Password: u…/Login/Administration Control Panel (at bottom of the forum page you logged into as admin)/Password: u… (re-authenticate the admin password)/Login.

4.3. Backup phpBB files. (what runs the forum).
Administration Control Panel/General tab/Server settings/Force server URL settings: No/Board settings/Disable board: Yes/Submit/Go to: E:\<FILEPATH>\<FILEPATH>\<FILEPATH>\<FILEPATH>\www and copy the forum folder to the desktop (backing up the phpBB files).

4.4. Backup phpMyAdmin files. (forum settings).
Windows\Start\Browser: localhost:8080/phpmyadmin /Export/Custom – display all possible options radio button/select Database: forum/Output: Save output to a file/File name template: forum settings backup/Character set of the file: utf-8/Compression: None/Format: SQL/Format-specific options: Dump table: structure and data/Go.

4.5. Backup phpMyAdmin files. (forum user data database).
Windows\Start\Browser: localhost:8080/phpmyadmin /select phpMyAdmin database name: forum/Export/Custom – display all possible options/Table(s): Select All/Output: Save output to a file/File name template: forum user data database backup/Format: SQL/Format-specific options: Dump table: structure and data/Object creation options: Add statements: check all: Add DROP TABLE VIEW PROCEDURE FUNCTION EVENT statement and 5 check boxes below/Go.

4.6. Restore phpMyAdmin
Linux Mint 13 MATE Maya/Menu/Applications/Internet/Browser: localhost/phpmyadmin /forum/Import/Browse…/USB file: forum user data database backup.sql/Character set of the file: utf-8/Format: SQL/Go
My machine specs:
Linux Mint 16 MATE 64-bit.
Copyright (c) 1997-2011 GNOME developers.
2 x Intel(R) Pentium(R) CPU G850 @ 2.90GHz
12222MB (2146MB used)
1280x1024 pixels
ATI Radeon HD 5700 Series (It's the 5770 card)
eiger3970
Level 3
Level 3
 
Posts: 115
Joined: Thu Jul 19, 2012 9:48 am

Re: How to transfer phpbb forum from wamp to lamp?

Postby DataMan on Sun Aug 05, 2012 7:02 am

A couple of things to take a look at:

1. When you use the filebrowser of choice verify that you are seeing the phpBB files in var/www/forum.

2. Did you set your permissions properly in var/www?

3. Are you seeing your database for the forum properly populated via phpMyAdmin after you ran your sql build statements from Windows?

-DataMan
Linux'd since 2005 Linux ID 422356 Ubuntu ID 15015
User avatar
DataMan
Level 6
Level 6
 
Posts: 1199
Joined: Thu Dec 04, 2008 6:47 am
Location: Carmel, Indiana USA at /var/www


Return to Other topics

Who is online

Users browsing this forum: No registered users and 4 guests