From: dju <dj...@dj...> - 2002-03-02 02:23:13
|
just a little bash script to transfer old files pref and abook with new mysql database ---- #!/bin/sh # dju 02/03/2002 squirrelmail 1.2.4 file.pref to squirrelmail 1.2.5 mysql database pref #set -x DBNAME='squirrelmail' DBUSER='root' DBPASSWD='topsecret' # hum for hash pref and abook this script don't work # recurse on directories SOURCEFILE='/usr/local/htdocs/webmail.mydomain.org/data/' # create database printf "__Create database ${DBNAME}\n" /usr/bin/mysqladmin --password=${DBPASSWD} --force drop $DBNAME /usr/bin/mysqladmin --password=${DBPASSWD} --force create $DBNAME # create tables printf "__Create tables address & userprefs\n" /usr/bin/mysql --password=${DBPASSWD} --force $DBNAME --batch << END # Table structure for table 'address' DROP TABLE IF EXISTS address; CREATE TABLE address ( owner varchar(128) NOT NULL, nickname varchar(64) NOT NULL, firstname blob NOT NULL, lastname blob NOT NULL, email blob NOT NULL, label blob NOT NULL, PRIMARY KEY (owner, nickname) ); # -------------------------------------------------------- # # Table structure for table 'userprefs' DROP TABLE IF EXISTS userprefs; CREATE TABLE userprefs ( user varchar(128) NOT NULL, prefkey varchar(64) NOT NULL, prefval blob NOT NULL, PRIMARY KEY (user, prefkey) ); END # begin with pref files # create pref sql printf "__Create pref sql\n" for i in ${SOURCEFILE}*.pref do printf "___for ${USER}\n" USER=`basename $i .pref` /bin/vi $i -c 1,\$s/^/INSERT\ INTO\ userprefs\ VALUES\ \(\ \'${USER}\'\,\ \'/g -c %s/\=/\'\ \,\'/g -c 1,\$s/\$/\'\)\;/g -c w${SOURCEFILE}${USER}pref.sql -c q\! done # after abook # create abook sql printf "__Create abook sql\n" for i in ${SOURCEFILE}*.abook do printf "___for ${USER}\n" USER=`basename $i .abook` /bin/vi $i -c 1,\$s/^/INSERT\ INTO\ address\ VALUES\ \(\ \'${USER}\'\,\ \'/g -c %s/\|/\'\ \,\'/g -c 1,\$s/\$/\'\)\;/g -c w${SOURCEFILE}${USER}abook.sql -c q\! done # Add data on database printf "__Add data on database\n" for i in ${SOURCEFILE}*.sql do printf "___for ${USER}\n" /usr/bin/mysql --password=${DBPASSWD} --force $DBNAME --batch < $i done # rm ${SOURCEFILE}*.sql ---- -- -dju- |