restore operation failing, virtualmin-dav: Permission denied, please help

Hello all,

Last night I had a HD crash, and I lost all the data for about 50 domains.

I’d setup a daily full backup, to another CentOS 5.4 Virtualmin box. So on the other Virtualmin box I have all the gz files for each domain.

When I try to restore those files, some domains work, but most of them I get two errors:

Creating MySQL database joomla_97fmfrutalmaster …
… MySQL database failed! : SQL desc db failed : Can’t create/write to file ‘/tmp/#sql_32e8_0.MYI’ (Errcode: 13) at …/ line 1332.

Restoring DAV users file …
… copy failed : cp: cannot stat `/tmp/.webmin/658356_2_restore.cgi/’: Permission denied

Re-starting DNS server …
… done
Applying web server configuration …
… done

… failed! See the progress output above for the reason why.

What can I do?
Please help! I’m desperate.


There’s some thoughts on the particular error you’re getting here:

Does any of the information on there help with the problem you’re seeing?


Thank’s Eric,

I don’t know how that happened, but the problem was that after I restored the first domain, my /tmp folter became his.

drwx------ 13 user user 4096 May 22 21:57 tmp

So I chowned it to

drwxrwxrwx 13 root root 4096 May 22 21:57 tmp

After that I could restore 80 virtual servers, only 2 with the following problem:

Restoring Mailman mailing lists …
… no lists found in backup

Re-creating mail and FTP users …
Restore failed : SQL insert into user (host, user, password) values (’%’, ‘hotelrecantodosi’, ‘11bfe8e320b20aba’) failed : Duplicate entry ‘%-hotelrecantodosi’ for key 1

Any idea what that may be?

Thank you

Ahh, nice catch with the /tmp permissions.

Well, the first message you shared suggests that it’s not seeing any Mailman lists… did you have any setup?

The second message looks like it’s having trouble re-importing a database entry… but it appears to be saying it already exists. Do things by chance work for you?


Yes, there wasn’t any Mailman lists.

But to be able to restore those two virtual servers, I had to do it in two steps:

  • First a normal full restore, it fails with the above SQL error, and mail users are not restored (but MySQL database IS restored correctly)
  • Then a restore using “Only create servers with selected features”, I selected everything but “Contents of server’s MySQL databases”.

It was restored successfully then.

Thank you