XF 1.4 phpmyadmin export issue

[theshadyonehd]

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 saidocumentation
#1068 - Multiple primary key defined

 

[Paul B]

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.

 

[AndyB]

I am trying to export a database

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.