Tuesday 21 January 2014

Joomla 2.5 export Mysql error - ERROR * at line * Duplicate entry '*' for key 'idx_link_old'

When transferring the MySql database for Joomla 2.5 I am getting this message.

ERROR * at line * Duplicate entry '*' for key 'idx_link_old' 

After a Google search I found this . Relating to doing this through Command Line Database Transfer

if you are using the command line   just ad -f or --force to your import


However if you're not using command line I found that replacing my 'INSERT' commands for 'INSERT IGNORE' commands in the .sql file does the same thing.

Joomla Development Cornwall

No comments: