i will swap directories 1at time with a bash scritp
#!/bin/bash echo mv $1 $1temp # temporal rename of the folder mv $1 $1temp echo ../../bin/vadduser -c \" $2 \" $1 $3 # creation of the username inside mysql ../../bin/vadduser -c \" $2 \" $1 $3 echo mv $1temp $1 # restoration of the mails mv $1temp $1 usage: ./scritp.sh usernamexx "greco comment" password for each line in the csv file On 10/1/07, Carlos Collart <[EMAIL PROTECTED]> wrote: > > 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 > -- atte. [EMAIL PROTECTED] http://www.danasoft.com/sig/CarlosCollart.jpg
