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.
--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
