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

Issues exporting database and importing

Discussion in 'Server Configuration and Hosting' started by xSpeced, Aug 2, 2014.

  1. xSpeced

    xSpeced Member

    Hi guys and gals

    I am trying to move my xenforo database from a shared linux host to my own windows apache+mysqlCE based server.

    Now here's the problem when I exported (via phpmyadmin) the Xenforo database and tried importing it to the Windows mysql server.

    Here's the query both PMA and Mysql workbench seems to use
    Code:
    --
    -- Dumping data for table `EWRporta_blocks`
    --
    
    INSERT INTO `EWRporta_blocks` (`block_id`, `title`, `version_string`, `version_id`, `url`, `install_callback_class`, `install_callback_method`, `uninstall_callback_class`, `uninstall_callback_method`, `cache`, `display`, `groups`, `locked`, `active`) VALUES
    ('BoardTotals', 'Forum Statistics', '1.0.0', 1, 'http://8wayrun.com/', '', '', '', '', '+1 hours', 'show', '', 0, 1),
    ('FaceBook', 'Facebook FanBox', '1.0.0', 1, 'http://8wayrun.com/', '', '', '', '', '+1 days', 'show', '', 0, 1),
    ('OnlineUsers', 'Members Online Now', '1.0.0', 1, 'http://8wayrun.com/', '', '', '', '', 'now', 'show', '', 0, 1),
    ('RecentNews', 'Recent News Article', '1.0.0', 1, 'http://8wayrun.com/', '', '', '', '', '+1 hours', 'show', '', 0, 1),
    ('RecentThreads', 'Recently Active Threads', '1.0.0', 1, 'http://8wayrun.com/', '', '', '', '', 'now', 'show', '', 0, 1),
    ('SharePage', 'Share This Page', '1.0.0', 1, 'http://8wayrun.com/', '', '', '', '', '+1 days', 'show'[...]
    and the mysql error:
    #1062 - Duplicate entry 'BoardTotals' for key 'PRIMARY'
     
  2. AndyB

    AndyB Well-Known Member

    Do you have terminal access to your server? If you do use mysqldump to backup your database.
     
  3. RoldanLT

    RoldanLT Well-Known Member

Share This Page