phpBB2Refugees.com Logo
Not affiliated with or endorsed by the phpBB Group

Register •  Login 

Continue the legacy...

Welcome to all phpBB2 Refugees!Wave Smilie

This site is intended to continue support for the legacy 2.x line of the phpBB2 bulletin board package. If you are a fan of phpBB2, please, by all means register, post, and help us out by offering your suggestions. We are primarily a community and support network. Our secondary goal is to provide a phpBB2 MOD Author and Styles area.

Convert sqldump data only from 2x to 3x?


 
Search this topic... | Search General Support... | Search Box
Register or Login to Post    Index » General Support  Previous TopicPrint TopicNext Topic
Author Message
learnandsay
Board Member



Joined: 05 Jun 2013

Posts: 3



PostPosted: Wed Jun 05, 2013 10:27 am 
Post subject: Convert sqldump data only from 2x to 3x?

Hello,

My provider has deleted my site but I have the phpBB2 2.0.x sqldump file. My new site is installed with 3.0.11
All my previous attempts to install a second 2.x board alongside so that I can run the conversion tool have failed

SQL Error : 1054 Unknown column 'session_logged_in' in 'field list'


I have run the sqldump on the old database and populated it. But I don't want to run it on the new database because I know the two databases are formatted differently. How can I reformat the sqldump data prior to running the file against the new database? (bearing in mind that I can't use the convert webpage)


thanks
Back to top
learnandsay
Board Member



Joined: 05 Jun 2013

Posts: 3



PostPosted: Wed Jun 05, 2013 5:11 pm 
Post subject: Re: Convert sqldump data only from 2x to 3x?

The error went away and a default blue login page appeared.

Nobody had replied to my post so I ran the sql insert statements and now the board appears to be working fine. Feel free to comment if you think there's anything worth saying.
Back to top
lumpy burgertushie
Board Member



Joined: 19 Nov 2008

Posts: 216


flag
PostPosted: Thu Jun 06, 2013 10:02 pm 
Post subject: Re: Convert sqldump data only from 2x to 3x?

does that mean that your phpbb3 board is now running with your phpbb2 data? I don't see how this is possible without running the conversion tool.

the two databases are not compatible.


robert
Back to top
learnandsay
Board Member



Joined: 05 Jun 2013

Posts: 3



PostPosted: Sun Jun 09, 2013 7:22 am 
Post subject: Re: Convert sqldump data only from 2x to 3x?

Well, me neither. But it would appear to be the case.
Back to top
Display posts from previous:   
Register or Login to Post    Index » General Support  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT
 
Jump to:  

Index • About • FAQ • Rules • Privacy • Search •  Register •  Login 
Not affiliated with or endorsed by the phpBB Group
Powered by phpBB2 © phpBB Group
Generated in 0.0067 seconds using 15 queries. (SQL 0.0012 Parse 0.0002 Other 0.0054)
phpBB Customizations by the phpBBDoctor.com
Template Design by DeLFlo and MomentsOfLight.com Moments of Light Logo