From: Laurent S. <ls...@me...> - 2005-10-18 17:25:22
|
On 18 Oct 2005 at 8:13, Tomas Kuliavas wrote: > > > > > > 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. > >> > > > > OK, I've downloaded the file located at > > http://cvs.sf.net/viewcvs.py/squirrelmail/squirrelmail/contrib/flat2 > > sql.pl?rev=1.5&view= log (version 1.5, revised Sept 20, 2005) > > > > How do I use it now? I tried running the script from the data > > directoty but it did not do anything. As I do not know Perl, would > > someone be kind enough to tell me whether I need to edit anything in > > the file and if yes, what and how! > > > > Do you use directory hashing in your setup? > No. flat files only. -- Laurent |