Rick Widmer wrote:
Carlos Collart wrote:
I am the dumbest person alive, and in charge of a vpopmail server,
I manage to drop database vpopmail
Not good... Before you do anything else it might be wise to stop
qmail, and all qmail-smtp processes then back up the mail store.
the system was a production one, under the domain xx_at_aduanett_dot_hn
I have a backup with the username, name, password in a CVS format
Just one domain, or many?
how could i re-poblate the mysql directly?
insert values(xxx,hash(xxx),xx,xx) into 'aduanett.hn
<http://aduanett.hn>'.vpopmail or crypt?
This may be the easiest method available. You will have to write a
Perl, php or whatever program to populate the database. The password
hash method depends on your ./configure options. It is pretty easy
unless you have to track down hashed directories.
He could use mysql itself, depending on making sure the fields are in
the right order, and one user per line
mysql, use database vpopmail, then :
LOAD DATA INFILE '/path/to/FILENAME.CSV' INTO TABLE vpopmail FIELDS
TERMINATED BY ',' LINES TERMINATED BY '\n';