Ok thank you veery mutch Now i understand -----Ursprungligt meddelande----- Från: squirrelmail-users-bounces@xxxxxxxxxxxxxxxxxxxxx [mailto:squirrelmail-users-bounces@xxxxxxxxxxxxxxxxxxxxx] För Tomas Kuliavas Skickat: den 23 maj 2007 17:51 Till: squirrelmail-users@xxxxxxxxxxxxxxxxxxxxx Ämne: Re: help with the tool flat2sql.pl >>> >>> i try to use the tool flat2sql.pl but i don't understand how to use >>> it. can someone help me thanks. >> >> Copy SquirrelMail data directory to some place. >> >> Make sure that *.pref, *.abook and *.si? files are readable by your >> user. >> >> Execute command 'flat2sql.pl --data_dir=path-to-data-directory > >> import.sql' without single quotes. >> >> Replace 'path-to-data-directory' with path to your copy of >> SquirrelMail data directory. Don't use flat2sql.pl on real data_dir >> or make sure that you have backups. >> >> flat2sql.pl outputs SQL code. Command redirects all output to >> import.sql. This import.sql file can be imported into your database. >> For example 'mysql -u some-user -p squirrelmail < import.sql' command >> will prompt for password and import data into squirrelmail database >> on default MySQL server. >> >> Run flat2sql.pl without arguments to see other possible configuration >> options. > > I use windows how should the datadir searchstring be writen? Hope anny > understand. 1. Install activeperl (http://www.activestate.com) and make sure that perl is available in PATH 2. create c:\import directory and save flat2sql.pl there 3. copy SquirrelMail data directory to c:\import\data 3. start -> run -> cmd 4. cd c:\import 5. perl flat2sql.pl --data_dir="c:\import\data" > import.sql if you don't want to go into command prompt, 3. create text file named import.bat. Please note that file must be named import.bat and not import.bat.txt. 4. Open import.bat in text editor and write text perl flat2sql.pl --data_dir="c:\import\data" >import.sql 2>error.log in that file. Then save it. 5. Double click on import.bat in order to execute it. Command should generate import.sql file. If error.log is not empty, it should contain command execution errors. ------------------------------------------------------------------------ - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ -- squirrelmail-users mailing list Posting Guidelines: http://www.squirrelmail.org/wiki/MailingListPostingGuidelines List Address: squirrelmail-users@xxxxxxxxxxxxxxxxxxxxx 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 ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ -- squirrelmail-users mailing list Posting Guidelines: http://www.squirrelmail.org/wiki/MailingListPostingGuidelines List Address: squirrelmail-users@xxxxxxxxxxxxxxxxxxxxx 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
