> 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 .... Recheck script that you have posted on mailing list. -- Tomas ------------------------------------------------------- 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
