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 …/web-lib-funcs.pl line 1332.
Restoring DAV users file …
… copy failed : cp: cannot stat `/tmp/.webmin/658356_2_restore.cgi/acerte.org.br_virtualmin-dav’: Permission denied
Re-starting DNS server …
Applying web server configuration …
… 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?
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?
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.