URGENT: Transfer database and forum

[ana4ever-vids]

I need to change the host (and the database). So I did the database's backup (with the control panel) and the files backup (via ftp).

What shall I do now???

[ckwalsh]

I need to change the host (and the database). So I did the database's backup (with the control panel) and the files backup (via ftp).

What shall I do now???

KB: how to transfer your MODded forum to a different host

[Marshalrusty]

Knowledge Base - Moving a board

That article should tell you everything you need to know. COme back if you have any questions.

[GreyDogz]

Delete the backup you did using the ACP and get one using myphpadmin or some other utilities (bigdump)

Check out this link: http://www.phpbb.com/kb/article.php?article_id=9

You could use this too:

Use this for the backup:

Code: Select all

<?php
include 'config.php';
include 'opendb.php';

$backupFile = $dbname . date("Y-m-d-H-i-s") . '.gz';
$command = "mysqldump --opt -h $dbhost -u $dbuser -p $dbpass $dbname | gzip > $backupFile";
system($command);

include 'closedb.php';
?> 

Use these as the input files:

Code: Select all

<?php
// This is an example of config.php
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = 'password';
$dbname = 'phpcake';
?> 

Code: Select all

<?php
// This is an example opendb.php
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die                      ('Error connecting to mysql');
mysql_select_db($dbname);
?> 

Code: Select all

<?php
// an example of closedb.php
// it does nothing but closing
// a mysql database connection

mysql_close($conn);
?>

[ckwalsh]

Wow... We all giver different articles

I would suggest the articles Marshalrusty and GreyDogz posted, since they are better written.