XF 1.4 phpmyadmin export issue

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


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.