No announcement yet.

Transfer vbulletin to a new server

  • Filter
  • Time
  • Show
Clear All
new posts

  • Transfer vbulletin to a new server

    hi there,

    I am running my vbulletin for more than a half year now and have over 8000 postings in it.
    There are about 1000 registered users.
    Now I want to transfer the WHOLE Board including all the registered users of course to a new webserver. A mySQL-database is installed on this server. How can I do this? Can I do a back-up of the board and copy this backup to the new server? What is the best way of doing it without losing any data?

    Thanx a lot for your help



  • #2
    Step One - Backup current database:
    • Telnet into your system
    • from the root directory, type mysqldump -uUSERNAME -pPASSWORD databasename > /path/to/dump.sql
    • this should only take about than 30 seconds to a few minutes, depending on your database size
    • when it is completed, it will bring you back to the prompt
    • verify that you have a dump.sql in the /path/to area you specified
    Step Two - Transfer to new server
    • telnet into machine1, and from the command prompt type 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.sql (should take no more than 30 seconds to a few minutes, depending in the file size)
    • ftp> close
    • ftp> quit
    • verify dump.sql is in the /path/to/new area on the new server
    Step Three - Install vBulletin on new server creating a dummy database (won't be used - you can delete later)
    • (I figure you know how to do that!)
    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.sql
    • this takes a couple of minutes depending on your database size, 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"
    Microsoft Beta Team


    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.