the CSV only contain username,gecos, and clear text password. i need to build the pw_passwd<http://localhost/phpmyadmin/sql.php?db=vpopmail&table=aduanett_hn&server=2&token=c46d27c471e70da8bd9cd1cca0758e35&sql_query=SELECT+%2AFROM+%60aduanett_hn%60++ORDER+BY+%60aduanett_hn%60.%60pw_passwd%60+ASC>
On 10/1/07, Quey <[EMAIL PROTECTED]> wrote: > > 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'; > > > -- atte. [EMAIL PROTECTED] http://www.danasoft.com/sig/CarlosCollart.jpg
