Web Hosting Talk







View Full Version : transfer from one host to another


dale rethke
02-13-2002, 05:43 PM
How do you go about transfering from one host to another if you are running a bulletin board?
I mean keeping all your sites and information from being lost?

clocker1996
02-13-2002, 05:47 PM
What bb?

dale rethke
02-13-2002, 05:50 PM
I am thinking about moving from ventures online.
They have not been too good the last 3 weeks. Site always down Very intermitent.
How tough to move everyting to a new host with out losing everything?

Thanks

jw
02-13-2002, 06:59 PM
Its fairly simple, it just requires tarring all your files, then dumping your database to a text file so that you can import it at your new host. phpMyAdmin can dump the database for you, you can write a php script to do it, or if you have shell access you can do it yourself.

bert
02-13-2002, 07:50 PM
Dale,

Dumping your database is pretty easy (considering you have shell access on your account now)

Simply run this from the shell:

bash$ mysqldump -u dbuser -p dbname | gzip > dbname.gz

Change "dbuser" for your database username, change "dbname" for the actual database name and change "dbname.gz" for whatever name you want to give to the file. The example above will dump your database into a file called dbname.gz.


Move the file over to the new server and then do this:

bash$ mysqladmin create dbname
bash$ gunzip < dbname.gz | mysql dbname

The example above will create a database called "dbname" and will then import the database from the file called "dbname.gz" into the database.

Hope this helps :)