• 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

#1
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.

Error
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
 

Brogan

XenForo moderator
Staff member
#2
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.