Dear Edwin,

I tried to backup and restore files and database of one of my slave site with your script.
Backuping worked fine.
With SSH commands I could restore the files.
But I couldn't restore the database.
Doesn't matter how I tried (two ways, with the command and in PHPMyAdmin import)
in both of the cases I get this message below
ERROR 1227 (42000) at line 15963: Access denied; you need the SUPER privilege for this operation
The site seems to work as tables would be cretaed in the database, but without database contents.

What can be the problem here, and what is the solution?

Thank you for your help!

[SOLVED]
Please don't care! The issue was because of some old tables in the table that should has long to be deleted.

Jozsef

Concerning the restore DB, as the message mentioned to you, you need the MySQL root user to create the DB and restore its content.

Perhaps you had "old table" but I suspect that the DB restore tried to restore them (or link to them) and that a "MySQL root" user would had help you restore the missing info.

Glad to see that you solved the issue yourself.

Thank you for the answer!
Actually that is the privilege what is owned by the server supplier and I cannot get it.

You probably have to remove the "create Database" statement present in the backup to allow restoring with a less MySQL privileges.

Thanks for the advice!