Restore DB problem

[Robbin]

Hello,

If i want to restore an database I get the following error:

Error Restoring database

Details

Unable to restore database debierpi_bierpier : ERROR 1045 (28000): Access denied for user 'debierpi'@'localhost' (using password: YES) gunzip: stdout: Broken pipe


This the way i have treid to backup and restoor the database.

Stap 1: Loging in to DA (user mode)
Stap 2: I press MYSQL Management
Stap 3: I saw the follow screen
Picture 1
Stap 4: I press the download button
Picture 2
Stap 5: I save the file
Stap 6: I press 'browse' and press on the file
Picture 3
Stap 7: I press the button upload
Stap 8: Then i saw the following screen
Picture 4

I hope anyone can help me

 

[albatroz]

Hi!
I am getting the same error.

Did you solve your problem?

 

[nobaloney]

Check this thread to see if it helps.

Jeff

 

[Robbin]

I solve the problem to delete the database
and add a new one.
then i restore the old database and it works.

Good luck

 

[XYZed]

Getting the same error here.

Unable to restore database username_dbname.sql to username_dbname : ERROR 1045 (28000): Access denied for user 'username'@'localhost' (using password: NO)

So the DA backup / restore tool does not seem to want to create the MySQL user.

The only way is to re-create the database in the users control panel and then import the database via phpmyadmin, or tar then untar the DB.

Problem is it's fine if you know the users passwords etc (although very time consuming) but what if you don't?

I'm glad we opted for a dummy run otherwise we'd have people screaming at us. Both old and new server have the same MySQL verions etc etc. da_admin has the same password (and confirmed working).

I've restored in the past without this problem many times, so has something changed to the script recently?

Any ideas? as the old server is on it's last legs.

Thanks.

 

[XYZed]

After formats, reinstalls, updates and hair loss I found the problem.

There was no /etc/my.cnf file on the new server.

Simply copied the my.cnf file from the old server to new and restores finally worked again.

Can I go to sleep now