[imp] Moving IMP's MySQL d/b from old to new system

[Shyama Mandal]

1. Backup current table using
SELECT * INTO OUTFILE "table.dat" FIELDS TERMINATED BY
',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY "\n"
FROM table ;

2. Load data into your database using

LOAD DATA INFILE 'table.dat' INTO TABLE table
           FIELDS TERMINATED BY ',' ENCLOSED BY '"'
           LINES TERMINATED BY '\n';


--- Chris W <chuddles@coin.org> wrote:
> Okay, now I see what I really need to ask so someone
> can maybe help 
> out...
> 
> How do I copy my contacts and preferences d/b from
> one system to 
> another?
> 
> Thanks
> 
> > Using
> >  horde-1.2.3
> >  imp-2.2.3
> >  MySQL from php-mysql-3.0.17-1.6.2horde1.i386.rpm
> > 
> 
> -- 
> IMP mailing list: http://horde.org/imp/
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail:
> imp-unsubscribe@lists.horde.org
> 


__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/?.refer=text