phpbb2 database export to a new host..

[drbabbers]

All,

Hopefully I am posting this in the right place.

I am currently using a phpBB2 based forum on a dedicated server of mine, but am now moving across my forum to a shared webhost. I thought this would be a simple task, but it has turned into a headache.

I am exporting the phpbb2 database using the export option in the administration panel, I have my new phpbb2 installation on my new host, I have a working/default/empty forum, I login to the administration panel and restore the database from the backup, everything appears to work with no error, however none of the mysql has actually been uploaded! I can see this when I login to phpmyadmin and the database has none of the restored data present.

Does anyone have any ideas? The old and new installations are both 2.0.22.

Thanks in advance.
D

[Wicher]

When you have installed any mods that created there own tables in your database, then its not a good idea to use the export option in the administrationpanel.
The option will not export any additional tables.

Best way to do this is trough your phpmyadmin panel.
Then you are sure you have a full backup of your database.

Also importing data to your new database can best be done trough your phpmyadmin panel, as long the file to upload is not bigger than 2 mb..
In case your database file is bigger than 2 mb you can use a free nice little program called bigdump.php which can be found here: http://www.hotscripts.com/listing/bigdump/
_________________
My little mods | Statistics Mod 4.x.x (revision of 2.1.5) | My hacks at phpbbhacks

[-Ram-]

Knowledge Base - How to move a phpBB 2.0.x board to a new server

[Wicher]

Good one ram.
_________________
My little mods | Statistics Mod 4.x.x (revision of 2.1.5) | My hacks at phpbbhacks

[the_nothing]

I have never been impressed with load/ save options in ACB either in phpBB2 or phpBB3

phpmyadmin is definitely the way to go

if your host does not provide you with phpmyadmin BY DEFAULT I would like to know why not

found a topic on the official site that may assist you > http://www.phpbb.com/community/viewtopic.php?f=65&t=2037495