Moving Forum to New Server
  • Vote Up0Vote Down powermanafpowermanaf February 2
    Posts: 7

    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!

  • 23 Answers sorted by
  • Vote Up0Vote Down RoguefoxxRoguefoxx February 2
    Posts: 134

    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.

  • Vote Up0Vote Down powermanafpowermanaf February 3
    Posts: 7

    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?

  • Vote Up0Vote Down lucluc February 3
    Posts: 315

    That, the conf cchange should be limited to the paths (except if you change the domain address too).

  • Vote Up0Vote Down AbacusAbacus February 3
    Posts: 91

    Where is the configuration file?

  • Vote Up0Vote Down lucluc February 3
    Posts: 315

    In the directoory strangely named : conf.

  • Vote Up0Vote Down AbacusAbacus February 4
    Posts: 91

    :p Okay how about where do I change the administrator?

  • Vote Up0Vote Down lucluc February 4
    Posts: 315

    What do you mean?

  • Vote Up0Vote Down AbacusAbacus February 4
    Posts: 91

    Where do I change the name of the forum administrator?

  • Vote Up0Vote Down AbacusAbacus February 4
    Posts: 91

    erm no let me simplify it even further - how do I upgrade a member to admin?

  • Vote Up0Vote Down lucluc February 4
    Posts: 315

    Create your own subject instead of hickjacking this one for your own purpose.

  • Vote Up0Vote Down AbacusAbacus February 4
    Posts: 91

    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.

  • Vote Up0Vote Down lucluc February 4
    Posts: 315

    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.

  • Vote Up0Vote Down AbacusAbacus February 5
    Posts: 91

    As I thought you don't actually know....

  • Vote Up0Vote Down RoguefoxxRoguefoxx February 5
    Posts: 134

    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.

  • Vote Up0Vote Down AbacusAbacus February 5
    Posts: 91

    Help has already arrived in the form of a simple message which enabled me to solve the problem.

  • Vote Up0Vote Down powermanafpowermanaf February 10
    Posts: 7

    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?

  • Vote Up0Vote Down powermanafpowermanaf February 11
    Posts: 7

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

    Thanks!

  • Vote Up0Vote Down lucluc February 12
    Posts: 315

    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.

  • Vote Up0Vote Down powermanafpowermanaf February 14
    Posts: 7

    I'm not sure what you mean by that. Just add the words "use plop;" at the top of my backed up database file?

  • Vote Up0Vote Down lucluc February 15
    Posts: 315

    Replace plop with the database your tables go in.
    Otherwise, that's it.

  • Vote Up0Vote Down powermanafpowermanaf February 15
    Posts: 7

    It gives me a #1044 error when I try to use that command.

  • Vote Up0Vote Down lucluc February 15
    Posts: 315

    Use a user with the appropriate rights granted for the database you want to put your tables in.

    All this, you can just google for it and find answers pretty quickly.
    Last answer from me if you don't even do a little bit of homework.

  • Vote Up0Vote Down powermanafpowermanaf February 15
    Posts: 7

    Alright, sorry for asking so many questions, I am not familiar with SQL commands so I don't know how to grant permission. I will Google it all from now on.

    Thanks for you answers.

Add a Comment

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership

Tagged

In this Discussion