Using an old database with a new install

Get help with installation and running phpBB 3.2.x here. Please do not post bug reports, feature requests, or extension related questions here.
Post Reply
mathijslemmers
Registered User
Posts: 1
Joined: Mon Aug 20, 2018 4:51 pm

Using an old database with a new install

Post by mathijslemmers »

My father is the administrator and asked me to make a local version.
Having no knowledge whatsoever of PHPBB I found the topic below which made it seem super easy.

viewtopic.php?f=466&t=2416276

Sadly, I didn't have much luck executing the steps.
- Install a clean version of PHPBB;
- Overwrite the newly generated database files with the export from the forum;
- Update by visiting /install.

The forum is pretty much empty and when I login I get redirected to the live website.
Could anyone tell me what I'm missing? My guess would be that there are things in the database that I have to change manually, but I could be totally off here.

Should any more information be required please let me know!

Best regards,
Mathijs Lemmers
Attachments
Screenshot of what my local forum currently looks like.
Screenshot of what my local forum currently looks like.
User avatar
janus_zonstraal
Registered User
Posts: 6418
Joined: Sat Aug 30, 2014 1:30 pm

Re: Using an old database with a new install

Post by janus_zonstraal »

What version is the old board?
- Install a clean version of PHPBB;
Was the new board working?
Sorry! My English is bat ;) !!!
User avatar
warmweer
Jr. Extension Validator
Posts: 11234
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Bel ... gium
Contact:

Re: Using an old database with a new install

Post by warmweer »

mathijslemmers wrote: Mon Aug 20, 2018 5:01 pm My father is the administrator and asked me to make a local version.
With "a local version" he probably means making a perfect copy of your forum on localhost (= your computer).
For that you would have to have access to the database of your live forum in order to make a backup (either using the backup utility form phpBB itself, or with phpMyAdmin - or whatever is installed on the server).
Restore that backup on your local host.
Copy the phpBBfiles from your server (where the live forum is hosted) to your PC.
Change the config.txt to reflect you localhost.
In the database, look for the phpbb_config table and change couple of fields to reflect the change to localhost. (phpBB_ is the prefix and may be different in your case)
The reason you were directed to your live-forum is because the php_config table still pointed to your live forum.


Since you've already exported and replaced the "new" database, my guess is all you need to do is to change a couple of fieldvalues in the phpbb_config tabel.your database
Spelling is freeware, which means you can use it for free.
On the other hand, it is not open source, which means you cannot change it or publish it in a modified form.


Time flies like an arrow, but fruit flies like a banana.
User avatar
canonknipser
Registered User
Posts: 2096
Joined: Thu Sep 08, 2011 4:16 am
Location: Germany
Name: Frank Jakobs
Contact:

Re: Using an old database with a new install

Post by canonknipser »

warmweer wrote: Mon Aug 20, 2018 8:13 pm Change the config.txt to reflect you localhost.
It's config.php :roll:
Greetings, Frank
phpbb.de support team member
English is not my native language - no support via PM or mail
New arrival - Extensions and scripts for phpBB
User avatar
warmweer
Jr. Extension Validator
Posts: 11234
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Bel ... gium
Contact:

Re: Using an old database with a new install

Post by warmweer »

canonknipser wrote: Tue Aug 21, 2018 5:49 am
warmweer wrote: Mon Aug 20, 2018 8:13 pm Change the config.txt to reflect you localhost.
It's config.php :roll:
Oops *brainmalfunction* :oops:
Spelling is freeware, which means you can use it for free.
On the other hand, it is not open source, which means you cannot change it or publish it in a modified form.


Time flies like an arrow, but fruit flies like a banana.
User avatar
Mick
Support Team Member
Support Team Member
Posts: 26508
Joined: Fri Aug 29, 2008 9:49 am

Re: Using an old database with a new install

Post by Mick »

mathijslemmers wrote: Mon Aug 20, 2018 5:01 pmMy father is the administrator and asked me to make a local version
There’s no need to be installing phpBB and importing old databases to it, just follow the relevant sections of Transferring Your Board to a New Host or Domain (backup and restore) and then you can follow Installing and Setting Up Your Own Web Server if you want to run the copy locally.
  • "The more connected we get the more alone we become" - Kyle Broflovski©
  • "The good news is hell is just the product of a morbid human imagination.
    The bad news is, whatever humans can imagine, they can usually create.
    " - Harmony Cobel
Post Reply

Return to “[3.2.x] Support Forum”