Tony Earnshaw 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.
--Tonni
Hi,
I've been trying to find the dbconvert.pl file but a search for that on
the lists does not come up with anything apart from this message.
I found the old script at:
http://cvs.sf.net/viewcvs.py/squirrelmail/squirrelmail/contrib/flat2sql.pl?rev=1.5&view=log
although that seems to be also maintained. Is that now the recommended
flat -> sql conversion script?
Also has anyone started on a plugin to have this script run and insert
the sql into the database when the user logs in? This avoid having to
manually export and reimport thousands of user pref and abook files.
Daniel
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
--
squirrelmail-users mailing list
Posting Guidelines:
http://www.squirrelmail.org/wiki/MailingListPostingGuidelines
List Address: squirrelmail-users@lists.sourceforge.net
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
