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

XF 1.4 phpmyadmin export issue

Discussion in 'Troubleshooting and Problems' started by theshadyonehd, May 15, 2015.

  1. theshadyonehd

    theshadyonehd New Member

    My shared host does not allow SSH access. I am trying to export a database using phpmyadmin and import onto a new server. I keep getting this error and i am not sure how to fix it. Any help is appreciated.

    SQL query:
    ----Indexesfor dumped tables
    ------Indexesfor table `EWRporta_blocks`--
    ALTER TABLE `EWRporta_blocks` ADD PRIMARY KEY (`block_id`),
    ADD KEY `title`(`title`);
    MySQL said:Documentation
    #1068 - Multiple primary key defined
  2. Brogan

    Brogan XenForo Moderator Staff Member

    As I said in your ticket, using phpMyAdmin is prone to errors when dumping and restoring.
    It shouldn't be used, as you can see from the problems you are experiencing, including the other issue you had related to the ACP log in.
    borbole likes this.
  3. AndyB

    AndyB Well-Known Member

    Are you moving to a new web hosting?

    Ask your current web host to backup your database and provide you a backup.sql file. Remember the /data/ and /internal_data folders also need to be copied.

Share This Page