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?
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
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.
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 :)