Move or copy a Forum with MYSQL, PHP

[DJkC]

How to move a PHP,Mysql forum from one host to another? I mean i have a Vbulletin or PHPBB on webhost.
But the same time i want to keep a backup in my PC. I know those forums support stuff like database backup(they give a SQL file not a workable database),
but i want a working copy in my pc.(I have personal webserver installed with all PHP,MySQL..stuff)

If i install same forum in my PWS and contact my host and copy MySQL database directory, and copy it in my PWS MySQL
database directory. It seems to me most of the forums don't change their PHP files, but save changes in MYSQL and run as you want.
So what you guys think?

If you know anyother way to move or copy forum to another host, pl tell me?:D

[amz]

Originally posted by DJkC
If you know anyother way to move or copy forum to another host, pl tell me?:D [/B]


Usually you only need to transfer all the application files
and directories for your forum and then transfer your
database.

If your current host offers a phpmyadmin interface for
the MySQL, it should be very easy to make a complete
copy of your database with all structures and data.
(It is only about 3 mouse clicks)

The only items you may need to look at on the new
server ... irregardless as to it being a new provider
or your own pc ... is the directory and database
settings. Simply double check those configuration
items once you move everything over.

If you are having problems at the new location, it
is likely you either have a different file path than
the old server or a different database login name
that needs to be updated.

Overall though, transferring forums is usually a
very easy task

:cool2:

[22host]

If your host (current) can do a MySQLdump and give you the resulting .sql file then you will have a copy of your forum database. In the past there have been issues with PHPMyAdmin timing out, and sometimes it doesnt get the whole database if it is big.
If you also give your host (current) an ftp account for your new hosting account then they can often upload the .sql file straight there for you saving you of having to download it and then upload it again :D, plus they can usually do it about 50 times faster than you

James

[amz]

Originally posted by 22host
In the past there have been issues with PHPMyAdmin timing out, and sometimes it doesnt get the whole database if it is big.
James


I have never seen PHPMyAdmin time out on a dump on our
database servers. Sounds like the provider either configured
it with very short timeouts or there is some kind of problem in
the connection stability to that server.

[22host]

hmmm.... maybe just the servers I have been having dealings with then.

James