Tomas Kuliavas wrote:
to den 13.10.2005 Klokka 13:02 (-0700) skreiv Laurent Saplairoles:
On 13 Oct 2005 at 22:44, Tomas Kuliavas wrote:
Hi everyone
I am working with SquirrelMail 1.51 latest CVS (2005-10-13).
I am upgrading my mail server to a more powerfull machine and have
decided to move all user settings, address books, global address
books, calendar, bookmarks... to a MYSQL back-end.
Creating the different databases and tables is, so far, relatively
straight-forward.
However, I have an important question: how can I import all the
existing information from my old SM install (everything is in
\\data\) to the MYSQL database? I particularly need to preserve user
preferences and address book entries.
Thanks in advance for your help.
Check 1.5.1cvs contrib directory. Please make sure that you have
backup of your data directory, before you use flat2sql.pl script.
Script is experimental. I don't give any warranties. If script
corrupts existing data files, you are on your own.
Thank you Tomas.
I'll try your script and report back on the results
One thing: 't'ain't his script, it's Michael Blandford and Tal Yardenis'
and if Tomas served it to you as the original flat2sql.pl, IT WON'T
WORK. That version's the original Norwegian Blue, it's dead.
I modified it after pointers from Paul L. (bless him), renamed it as
dbconvert.pl, posted the modified version to this ML and my version
*does* work. Obviously it doesn't corrupt input data, since it simply
reads that.
http://article.gmane.org/gmane.mail.squirrelmail.user/23504/match=flat2sql
....
open(ABOOK, ">$data_dir/$filename") or
You mean it should be:
open(ABOOK, ">$data_dir/$filename", O_RDONLY); ? Then somebody, please,
like Tomas, put that in ...
....
Recheck script that you have posted on mailing list.
It don't clobber anything, anyway ;) BTW, I only found out a bit about
Perl recently ...
--Tonni
--
Mail: [EMAIL PROTECTED]
http://www.billy.demon.nl
-------------------------------------------------------
This SF.Net email is sponsored by:
Power Architecture Resource Center: Free content, downloads, discussions,
and more. http://solutions.newsforge.com/ibmarch.tmpl
--
squirrelmail-users mailing list
Posting Guidelines:
http://squirrelmail.org/wiki/wiki.php?MailingListPostingGuidelines
List Address: [email protected]
List Archives:
http://news.gmane.org/thread.php?group=gmane.mail.squirrelmail.user
List Archives: http://sourceforge.net/mailarchive/forum.php?forum_id=2995
List Info: https://lists.sourceforge.net/lists/listinfo/squirrelmail-users
