Web Hosting Talk







View Full Version : moving forum and database


rijeagle
09-04-2003, 12:12 AM
I was wondering if anyone here knows how to move a phpbb2 forum and MySQL 4.0 database from one server host to another using the ensim pro control panel.

akashik
09-04-2003, 07:55 AM
I'd suggest speaking with your current web host and having them 'dump' the database into a .tar file for you into your webspace so you can download it. Your new web host should be able to unpack it again into your account.

Ensim might have the ability from a customer level but I've never touched that panel myself.

DediPlace
09-04-2003, 08:08 AM
Hi,

yes, having a .tar is the best way but I think you still also to need to contact your current webhost to untar it unless you have ssh access.

If you don't want to bother your host, I think you can use the program mysqlfront. Just look for it at google.com

LightningWeb
09-04-2003, 09:42 AM
Ensim pro doesn't have the ability to just back up a db by itself. I'd say go with the suggestions above. Ask your current host to do a mysqldump of the db into a sql file for you, then get your new host to import it into your new db. as for the rest of the files, just keep the directory structure intact and ftp them to your local machine and up them to your new host. One you've done that, just edit the config file to your new database settings and you're all set.

sprintserve
09-04-2003, 10:08 AM
I believe Phpbb also have a function in the administration panel to backup the database. You can also back up the database there, download the sql file, and upload it to your new host and restore it again in the administration panel.

GideonX
09-04-2003, 10:29 AM
last time I checked, there was an add-on in phpBB that allows you to backup your data.

otherwise, request a db dump from your host or do it yourself through phpmyadmin if it is installed.

Kimmikat
09-04-2003, 04:34 PM
rijeagle,

I have successfully moved 3 forums without a hitch from one server to a couple of others. I used mysql-front to download the DBs and phpmyadmin to put it back up.

The funny thing is the DB was orginally on a server with mySQL 4.0 and moved it to a 3.x.x server.

sprintserve
09-04-2003, 04:37 PM
phpmyadmin has limitations if the database is too big. Chances are the databases will time out. it's always better to use shell if you have it and if you know what to do.

SpeedFreak
09-04-2003, 05:01 PM
you should be able to do this with phpmyadmin

the newest version will even dump large DB's

basically it can be done, just make sure you update your config to reflect the new DB details

Cheers

rijeagle
09-04-2003, 10:58 PM
thanks guys for the help, the host moved it for me.