How do I move my forum to anther server?

[voigts]

Hi,
I´m moving my Domain to another server (old server is still running). Do I have to reinstall the whole forum and import my custom styles?
How do I get my old db to work on my new server (drop_table and upload to my new server?).
Is there a function included in 2.0.0 beta 5 to import styles and db?
Thanks in advance for your help.

cu
Frank

[Wayne Luke]

Moving Servers (completed step by step - for dummies) By Me2Be
Okay, now that I've been able to successfully backup and restore my test VB (all 59MB worth) on my UNIX system, I wanted to put down the instructions so that
someone else may benefit from it and I'll have a written copy of it.

Thanks to firewire, Chris S, Ed, doron, Martin and everyone else who helped me figure this out!

Step One - Backup current database
· telnet into your system
· from the root directory, type mysqldump -uUSERNAME -pPASSWORD databasename > /path/to/dump.txt;
· this should only take no more than 30 seconds
· when it is completed, it will bring you back to the prompt
· verify that you have a dump.txt in the /path/to area you specified

Step Two - Transfer to new server
Telnet into machine1, and from the command prompt do the following:
· machine1$ cd /path/to/yourbackupdirectory
· machine1$ ftp machine2 (IP or host) - this should open a connection and ask for your username/password
· ftp> bin
· ftp> cd /path/to/newdirectory
· ftp> put dump.txt (should take no more than 30 seconds)
· ftp> close
· ftp> quit
· verify dump.txt is in the /path/to/new area on the new server

Step Three - Install Vb on new server creating a dummy database (won't be used - you can delete later)

Step Four - Restore to new server
· Telnet into machine
· Create new database on the MySQL (either via phpMyAdmin or telnet)
· From the root, type:
mysql -uUSERNAME -pPASSWORD newdbname < /path/to/dump.txt
· This takes a couple of minutes, but you can track the progress either by FTP (checking the /mysql/data/newdbname and see the files appearing) or by phpMyAdmin (you should see the files appearing there)
· When it is completed, it will bring you back to the prompt


Step Five - Bringing it back online
· Go into your config.php and change the database name to the database name you created in Step 4.
· Upload config.php
· Go into your admin/index.php and then click on "options" and change the URLs and verify the options and click "submit"

That's it! - If I can get this to work, I'm sure anyone else can. If I missed something, please let me know and I'll correct it!
Moving Servers (completed step by step - for dummies) By Me2Be 1

[Kwesi]

couldn't this be done without using tellnet?

[Steve Machol]

Not easily. You would have to ask your hosts to backup and restore the database for you.