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

[Chris W]

Yeah, that was what I was looking for.  Thanks much!


Quoting Shyama Mandal <shyama_mandal@yahoo.com>:

> 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?
> >