[support] duplicating Database problem

[Mutuku Ndeti]

I am not sure about the solution to the issues but try using this
module http://drupal.org/project/backup_migrate to migrate and see if
it works,

On 05/04/2012, Roger <arelem at 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'
>
> I have tried mysql -uname -pword database < copied_data.sql copied the
> structure,
> have copied the structure only then tried to insert the data but get the
> same error.
> I tried deleting the offending INSERT INTO table but the error simply
> transfers to the next INSERT.
> Haven't run into this before!
> Where should I look for help please.
> Thanks
> Roger
> --
> [ Drupal support list | http://lists.drupal.org/ ]
>


-- 
Tel:254- 722-490994
www.agile.co.ke | www.jipambe.com