[support] duplicating Database problem

[Roger]

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, 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'