• Registered: 2005-12-02
  • Posts: 3

Topic: Moving PunBB from one domain to another

Hi all,

I would like to move PunBB from one virtual server (domain name) to another domain name. I would like to preserve the existing messages and users.

Are there any notes on how to do this?

Thanks

Duncan

2 Reply by hcgtv

  • hcgtv
  • hcgtv
  • Senior Member
  • Offline
  • From: Charlotte, NC
  • Registered: 2004-06-25
  • Posts: 1,991

Re: Moving PunBB from one domain to another

Hi Duncan,

You have to save off the database and your PunBB installation.

a) Use phpMyadmin to export your database to a file.
b) Use FTP to copy off your PunBB installation to your local computer.
c) Use phpMyadmin to import your database to the new location.
d) On your local computer, change the config.php to reflect your new database name, user, password.
e) Upload your local PunBB copy to your new location.
f) Sign on to your new host, go into PunBB administration, in options change: Base URL

I think that's it, that's how I do it.

PHPCrossRef . TXP Make . TXP Themes . TXP Tags . TXP Planet . We Love TXP

hcgtv's Website

  • Smartys
  • Former PunBB Developer
  • Offline
  • Registered: 2004-04-30
  • Posts: 7,844

Re: Moving PunBB from one domain to another

Oh, and one note: if you set $cookie_domain in config.php to anything but '', you need to adjust it for the new domain smile

  • Registered: 2005-12-02
  • Posts: 3

Re: Moving PunBB from one domain to another

Thanks for your help - that worked fine. phpMyadmin dumps the file to the local machine and lets you upload it from there also so that was easy.

I used tar to bundle the files from the old installation.

Cheers

Duncan

  • Registered: 2005-12-13
  • Posts: 6

Re: Moving PunBB from one domain to another

Hello,

yes this probably works, but my site with forum has only external MySQL access (e.g. MyOdbc) and no PHPmyadmin. There seems not to exist a PHPMYADMIN Windows-client version to execute above described method.

In other words perhaps this should be a feature of the administration of PunBB to export all data and import it in another installation?
(not to say that competing forum developers have such option!!!)

Anyone ideas how to move forums except the only idea I have that is to manually (of course by some sort of queries or something) copy tables through MyOdbc? This is a big long adventure to do...and there is another problem, that second site I have doesn't allow to connect externally through MyOdbc. So in other words the situation sucks.

Best greetings,

Jacek L.

  • From: 127.0.0.1
  • Registered: 2001-11-02
  • Posts: 9,167

Re: Moving PunBB from one domain to another

jacklat: You should be able to use MySQL's own MySQL Administrator.

"Programming is like sex: one mistake and you have to support it for the rest of your life."

Rickard's Website

  • Registered: 2005-12-13
  • Posts: 6

Re: Moving PunBB from one domain to another

Hello Rickard,

I might be dumb, but the MySQL administrator in fact can connect from my external system but only to the service where I can switch on the external SQL connection. On other 2 hosts which I rent I can only use PHPMyAdmin which seems not to have any SQL import option except raw text table.

In other words still moving forums isn't possible in my case.

Greetings,

Jacek L.

  • Smartys
  • Former PunBB Developer
  • Offline
  • Registered: 2004-04-30
  • Posts: 7,844

Re: Moving PunBB from one domain to another

You can import a backup into phpMyAdmin, I do it all the time wink

  • Registered: 2005-12-13
  • Posts: 6

Re: Moving PunBB from one domain to another

Are you guys sure that export file from MySQL Administrator (1.1.5) is compatible with import syntax from PHPMyAdmin?
Between PHPmyadmins the sql text file works fine but trying to import sql text file from MySQL administrator results in errors. There are some syntax problems. Perhaps I used some wrong dump options?

Help!

J.

  • Registered: 2006-05-12
  • Posts: 28

Re: Moving PunBB from one domain to another

Boy, that was easy.