Announcement

Collapse
No announcement yet.

Transfer vbulletin to a new server

Collapse
X
 
  • 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

    Regards

    Alexandra

  • #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"
    MCSE, MVP, CCIE
    Microsoft Beta Team

    Comment

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