1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Changing Servers

Discussion in 'Server Configuration and Hosting' started by Charlie J, May 6, 2015.

  1. Charlie J

    Charlie J Active Member

    Hello,
    i have just changed my whole xenforo to another server and have downloaded the mysql file, how can i get xenforo to use the .sql file i downloaded from phpmyadmin
     
  2. kaieivindm

    kaieivindm Active Member

    Asume you have created a new database at your new hosting company, and then imported your sql file.

    You can ftp into your host, change /library/config.php and enter the new information there.

    <?php

    $config['db']['host'] = 'sql_server';
    $config['db']['port'] = 'port_nr';
    $config['db']['username'] = 'username';
    $config['db']['password'] = 'password';
    $config['db']['dbname'] = 'databasename';


    $config['superAdmins'] = '1';

    With that the forum should read your database information again.
     
  3. Charlie J

    Charlie J Active Member

    i used to have a DB on hostgator however i want to eliminate that and just stick to my dedicated server, i downloaded my .sql file from PHPMyAdmin and would like to be able to somehow still use this data but on my dedicated server.
     
  4. Brogan

    Brogan XenForo Moderator Staff Member

    You need to export and import the database.

    I recommend doing it via shell, rather than phpMyAdmin.
     
  5. Charlie J

    Charlie J Active Member

    Your not getting me... :/
    i have a dedicated server from SoYouStart, they just give me 32gb ram and storage and its Linux CENTOS thats it..
     
  6. Brogan

    Brogan XenForo Moderator Staff Member

    If your server is self managed then presumably you know how to create the database, etc.

    If not, you should consider employing the services of a sysadmin.
     
  7. Charlie J

    Charlie J Active Member

    Right i imported my MYSQL database, now what do i do
     
  8. Brogan

    Brogan XenForo Moderator Staff Member

  9. Charlie J

    Charlie J Active Member

    yeah thnks but its all through linux i made the file then imported it but idk how i can set the user of it etc i still get this DB error
     
  10. Tracy Perry

    Tracy Perry Well-Known Member

    With MySQL you will have to create the DB (as root typically) then create a user and assign said user a password. Then you will assign that DB to the user you just created with all privileges.
    You will then need to import the SQL file (and hope it's not corrupted) that you exported from phpMyAdmin into the new DB you created (either as the user or as root).
    If you aren't familiar with doing this, then I would suggest an unmanaged dedicated server might not be the best option to go live with at this time unless you have some additional help that is familiar with those processes.
     
  11. WSWD

    WSWD Well-Known Member

    Honestly, it sounds like you should have stayed with a host, or got cPanel on your new server. No way should you be using an unmanaged dedicated server if you don't know how to do these sorts of tasks.
     
    hellreturn likes this.
  12. Charlie J

    Charlie J Active Member

    Ah alright ill try thanks, also how can i get it to automatically place a thread prefix in a certain forum, because i have something for my MC server called Staff Applications and i would like that when they post it places that automatically as currently im manually doing it
     
  13. Charlie J

    Charlie J Active Member

    also
    Not Found
    The requested URL /login/ was not found on this server.
     
  14. Brogan

    Brogan XenForo Moderator Staff Member

    I have replied to your ticket about that.
    It is a FURLs issue.
     
    Charlie J likes this.
  15. Charlie J

    Charlie J Active Member

    Ah thanks, could you do it for me as idk how, i provided my FTP details
     
  16. Brogan

    Brogan XenForo Moderator Staff Member

    That's not something which is covered by ticket support.
     
  17. Charlie J

    Charlie J Active Member

    I contacted my host but they have not done anything yet, im using OVH (so you start)
     
  18. MattW

    MattW Well-Known Member

    SoYouStart are UNMANAGED. They won't do anything for you.
     
  19. Charlie J

    Charlie J Active Member

    Oh wow, well if you could help if not would help ALOT,
    i moved my xenforo from HostGator to my dedicated server i use for my mc server on SYS
    However since i moved everything is fine except
    The following error occurred:
    Not Found
    The requested URL /login/ was not found on this server.

    Apache/2.2.15 (CentOS) Server Port 80
     
  20. Charlie J

    Charlie J Active Member

    I need this ASAP due to going on holiday tommorrow and wont have PC access
     

Share This Page