mysql database restore

[aclass]

Hello Everyone,
I hope someone can help, I have a site sith a mysql database running on an DA server.
I am moving the site to another server also running DA
I have done a backup then a restore to the new server.
All goes over fine except the database will not restore to the new server.
I have tried restoring database seperatley but this is the error I get:


Unable to restore database auctionnz_main : ERROR 1045: Access denied for user: 'auctionnz@localhost' (Using password: YES) gunzip: stdout: Broken pipe


Please help, it will be very much appreciated

 

[aclass]

also got this error when trying to restore database through userpanel in DA:
Thanks again

Unable to restore database auctionnz_main.sql to auctionnz_main : ERROR 1064 at line 21 in file: '/home/auctionnz/backups/backup/auctionnz_main.sql': You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1' at line 18