Blog Documentation Book a Demo

Moving Forum to New Server

powermanafpowermanaf
edited February 2010 in Vanilla 2.0 - 2.8
My hosting plan is about to expire and I'd like to use a different host. Is there any way for me to transfer the forum over to the new host without losing any data?

Thanks!
«1

Comments

  • RoguefoxxRoguefoxx
    Sure there is. Back everything up and transfer it to your new host, including your database.

    I would bet that your new host would have information regarding how to transfer your data to their host without (or very minimal) downtime.
  • powermanafpowermanaf
    So what exactly do I need to change? I've backed up all of the forum files, and exported the MySQL database. Do I just upload them to the new server and change around the configuration files?
  • lucluc ✭✭
    That, the conf cchange should be limited to the paths (except if you change the domain address too).
  • AbacusAbacus
    Where is the configuration file?
  • lucluc ✭✭
    In the directoory strangely named : conf.
  • AbacusAbacus
    :p Okay how about where do I change the administrator?
  • lucluc ✭✭
    What do you mean?
  • AbacusAbacus
    Where do I change the name of the forum administrator?
  • AbacusAbacus
    erm no let me simplify it even further - how do I upgrade a member to admin?
  • lucluc ✭✭
    Create your own subject instead of hickjacking this one for your own purpose.

  • AbacusAbacus
    Hey! Less of the attitude. This is a follow-on from me moving my forum so either give an answer or do us all a service and shut up.
  • lucluc ✭✭
    That's not attitude, that's basic netiquette.

    Moving doesn't imply changing the administrator.
    Reading just a few docs, or clicked just a little bit on your forum and you would have seen how to do it in less than 30 min after your first question, 8 hours ago.

  • AbacusAbacus
    As I thought you don't actually know....
  • RoguefoxxRoguefoxx
    Abacus:
    As I thought you don't actually know....
    Heh, and you expect to get help with that approach? Help is provided here free of charge, as is the software. You aren't entitled to anything.
  • AbacusAbacus
    Help has already arrived in the form of a simple message which enabled me to solve the problem.
  • powermanafpowermanaf
    edited February 2010
    Ok, so I've backed up the database and I uploaded all of the files to the new server, but when I try to import the database file in phpMyAdmin, I get the following error:

    Error
    SQL query:

    --
    -- Database: `ncfixedc_forum`
    --
    -- --------------------------------------------------------
    --
    -- Table structure for table `LUM_Category`
    --
    CREATE TABLE IF NOT EXISTS `LUM_Category` (

    `CategoryID` INT( 2 ) NOT NULL AUTO_INCREMENT ,
    `Name` VARCHAR( 100 ) COLLATE latin1_general_ci NOT NULL DEFAULT '',
    `Description` TEXT COLLATE latin1_general_ci,
    `Priority` INT( 11 ) NOT NULL DEFAULT '0',
    `Subscribeable` INT( 1 ) NOT NULL DEFAULT '0',
    PRIMARY KEY ( `CategoryID` )
    ) ENGINE = MYISAM DEFAULT CHARSET = latin1 COLLATE = latin1_general_ci AUTO_INCREMENT =9;

    MySQL said:

    #1046 - No database selected




    Any ideas?
  • powermanafpowermanaf
    Anyone have a clue? I really need to get this forum back up and running!

    Thanks!
  • lucluc ✭✭
    edited February 2010
    Select a database first, as said by the error.

    via "use plop;" at the top of the dump file, or by usig -D plop on the command line.
  • powermanafpowermanaf
    I'm not sure what you mean by that. Just add the words "use plop;" at the top of my backed up database file?
  • lucluc ✭✭
    Replace plop with the database your tables go in.
    Otherwise, that's it.
Sign In or Register to comment.