Moving Forum to New Server
  • powermanafpowermanaf
    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!
  • RoguefoxxRoguefoxx
    Posts: 138
    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
    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?
  • lucluc
    Posts: 983
    That, the conf cchange should be limited to the paths (except if you change the domain address too).
  • AbacusAbacus
    Posts: 124
    Where is the configuration file?
  • lucluc
    Posts: 983
    In the directoory strangely named : conf.
  • AbacusAbacus
    Posts: 124
    :p Okay how about where do I change the administrator?
  • lucluc
    Posts: 983
    What do you mean?
  • AbacusAbacus
    Posts: 124
    Where do I change the name of the forum administrator?
  • AbacusAbacus
    Posts: 124
    erm no let me simplify it even further - how do I upgrade a member to admin?
  • lucluc
    Posts: 983
    Create your own subject instead of hickjacking this one for your own purpose.

  • AbacusAbacus
    Posts: 124
    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
    Posts: 983
    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
    Posts: 124
    As I thought you don't actually know....
  • RoguefoxxRoguefoxx
    Posts: 138
    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
    Posts: 124
    Help has already arrived in the form of a simple message which enabled me to solve the problem.
  • powermanafpowermanaf
    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?
  • powermanafpowermanaf
    Posts: 7
    Anyone have a clue? I really need to get this forum back up and running!

    Thanks!
  • lucluc
    Posts: 983
    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
    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?
  • lucluc
    Posts: 983
    Replace plop with the database your tables go in.
    Otherwise, that's it.
  • powermanafpowermanaf
    Posts: 7
    It gives me a #1044 error when I try to use that command.
  • lucluc
    Posts: 983
    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.
  • powermanafpowermanaf
    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!

Login with Facebook Sign In with Google Sign In with OpenID Sign In with Twitter
Sign In Apply for Membership

Categories

In this Discussion

Who's Online 6

AltazarIdanglownashirax00xvik