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

XF 1.3 Importing my Database.sql into forum

Discussion in 'Installation, Upgrade, and Import Support' started by Blue chummer, Jun 5, 2014.

  1. Blue chummer

    Blue chummer Active Member

    Hi .
    I have been building my forum content on my pc using Xaamp . I am ready to open import the database.sql file
    into the forum via the cpanel file manager. I have the file already. Anyone know where to import to exactly? I don't want to screw it up. thanks
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    Click on phpMyAdmin from the cPanel home page, select the datatbasae, then Import.
     
  3. Blue chummer

    Blue chummer Active Member

    thanks Brogan. I just imported my bluechum.sql file using phpadmin to the bluechum_mydb folder . It imported fine -but all my catagories and topics aren't showing on the forum page. Should I have just imported into bluechum_forum?
     
  4. Brogan

    Brogan XenForo Moderator Staff Member

    You have to import into the database which is connected with your installation.

    You can check that in the library/config.php file.
     
  5. Blue chummer

    Blue chummer Active Member

    thanks Brogan. Still getting the hang of this :)
     
  6. Blue chummer

    Blue chummer Active Member

    HI Brogan, thanks I found the info -my db is bluechum_forum
    I tried importing and get this error:

    SQL query:
    --
    -- Dumping data for table `xf_phrase`
    --
    INSERT INTO `xf_phrase` (`phrase_id`, `language_id`, `title`, `phrase_text`, `global_cache`, `addon_id`, `version_id`, `version_string`) VALUES
    (1, 0, 'user_field_gtalk', 'Google Talk', 1, '', 0, ''),
    (2, 0, 'user_field_gtalk_desc', '', 0, '', 0, ''),
    (3, 0, 'user_field_aim', 'AIM', 1, '', 0, ''),
    (4, 0, 'user_field_aim_desc', '', 0, '', 0, ''),
    (5, 0, 'user_field_icq', 'ICQ', 1, '', 0, ''),
    (6, 0, 'user_field_icq_desc', '', 0, '', 0, ''),
    (7, 0, 'user_field_skype', 'Skype', 1, '', 0, ''),
    (8, 0, 'user_field_skype_desc', '', 0, '', 0, ''),
    (9, 0, 'user_field_yahoo', 'Yahoo! Messenger', 1, '', 0, ''),
    (10, 0, 'user_field_yahoo_desc', '', 0, '', 0, ''),
    (11, 0, 'user_field_facebook', 'Facebook', 1, '', 0, ''),
    (12, 0, 'user_field_facebook_desc', '', 0, '', 0, ''),
    (13, 0, 'user_field_twitter', 'Twitter', 1, '', 0, ''),
    (14, 0, 'user_field_twitter_desc', '', 0, '', 0, ''),
    (15, 0, 'trophy_1_description', 'Post a message somewhere on the site [...]
    MySQL said: [​IMG]
    #1062 - Duplicate entry '1' for key 'PRIMARY'


    Any idea on this one? thanks
     
  7. Brogan

    Brogan XenForo Moderator Staff Member

    Sounds like you are trying to import into a database which already has content.

    You will need to empty the database first.
     
  8. Blue chummer

    Blue chummer Active Member

    that makes sense , I wasn't sure if it would overwrite or add to the existing db (which is just a 1 topic test forum) thanks again
     

Share This Page