2
   

Migrating phpbb forum from host to host

 
 
Reply Tue 15 Feb, 2005 05:01 am
I am moving my website to a new host. Could someone point me to a resource detailing how I should go about this.

Any help will be highly appreciated.
  • Topic Stats
  • Top Replies
  • Link to this Topic
Type: Discussion • Score: 2 • Views: 3,326 • Replies: 5
No top replies

 
Craven de Kere
 
  1  
Reply Wed 16 Feb, 2005 12:15 am
You will need to backup the database and files and transfer them.

Here's a basic outline:

1) Download all the files through FTP.

2) Backup the database (if it's really big it may need to be done through SSH, if not you can get an SQL dump from something like phpMyAdmin or the phpBB feature. Non-shell options are unreliable for large databases).

3) Upload the files on the new host.

4) Create a database and restore the data there (through SSH or your DB Admin tool).

5) Edit config.php to reflect the details of your new database (password etc).
0 Replies
 
husker
 
  1  
Reply Wed 16 Feb, 2005 12:19 am
Good points - I think I missed-up on points 4 and 5 a little, but eventually got it squared away.
0 Replies
 
clubafrika
 
  1  
Reply Wed 16 Feb, 2005 03:39 am
Craven:

Your instructions are very clear. I have followed them exactly as laid out and I get errors when importing. When I try importing to a new database that I created on the new server (or am I doing something wrong here) I get the following errors:

==================================
Database clubafri_phpBBForums running on localhost
Error

SQL-query :

CREATE DATABASE `phpBB-Forums` DEFAULTCHARACTER SET latin1 COLLATE latin1_swedish_ci

MySQL said:

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci' at line
Back
==================================

My old server runs: phpMyAdmin 2.6.1 and MySQL 4.1.7 - globat.com
My new server runs: phpMyAdmin 2.4.0 and MySQL 4.0.16 - ipowerweb.com

I have a feeling there is an incompatibility issue here. I have notified ipowerweb and the issue has been bumped up to their databse people.

Meanwhile, If you have encountered the same problem before, perhaps you could shed some light into it...

Thanks for your help.
0 Replies
 
Craven de Kere
 
  1  
Reply Wed 16 Feb, 2005 03:52 am
Your SQL shouldn't attempt to create a database, use iPowerweb's vDeck control panel to create the database and db user.

Then use the sql dump to create and populate the tables in the database.

To do what I described you might need to remove the database creation from your sql.

If this is a mission critical website it might be time to let someone who is familiar with databases do it, see if the ipowerweb folk will help.
0 Replies
 
clubafrika
 
  1  
Reply Wed 16 Feb, 2005 05:49 am
Thanks Craven, I will let them deal with it.
0 Replies
 
 

Related Topics

In How much time a website can be developed? - Question by aussiejumpingcastle
Webdevelopment and hosting - Question by harisit2005
Showing an Ico File - Discussion by Brandon9000
how to earn money in internet - Discussion by rizwanaraj
The version 10 bug. Worse then Y2K! - Discussion by Nick Ashley
CSS Border style colors - Question by meesa
There is no Wisdom in Crowds - Discussion by ebrown p
THANK YOU CRAVEN AND NICK!!! - Discussion by dagmaraka
I'm the developer - Discussion by Nick Ashley
 
  1. Forums
  2. » Migrating phpbb forum from host to host
Copyright © 2021 MadLab, LLC :: Terms of Service :: Privacy Policy :: Page generated in 0.03 seconds on 07/28/2021 at 09:05:07