Thank you. I had tried Backup/Migrate and gave up. It appears there is a problem with php and phpmyadmin, probably something to do with a data limitation in php. I don't know anything about this other than it has been discussed on the web.
So I ssh into the server and did a mysqldump of the required database , scp the file across to my machine then after installing a copy of the drupal system on my pc I ran mysql to restore the database and everything worked with no errors. Mysql handles the process with ease. Of course none of this is available with shared servers and that's where my next problem will arise. Putting the whole thing onto a shared server with terminal access unavailable. Cheers Roger
I am not sure about the solution to the issues but try using this modulehttp://drupal.org/project/backup_migrate to migrate and see if it works,
On 05/04/2012, Rogerarelem@bigpond.com wrote:
Using Drupal 7.12 I'm building a live site and wish to duplicate the database. I used phpmyadmin to copy the database on the server and cpanel to download to my pc.
I keep running into an error: ERROR 1062 (23000) at line 27: Duplicate entry 'comment_publish_action' for key 'PRIMARY'