PDA

View Full Version : mysql database restore



aclass
11-17-2005, 01:46 PM
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
11-17-2005, 02:03 PM
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