Importing

[stephen]

Is it possible to take a ASCI delimited file that is sitting on my hard drive and import the values to mySQL sitting on my server?

I don't think phpMyAdmin 2.0.1 has a utility to do this so Im just wondering the process it would take to get the job done.

Thanks

[Anon]

Use the command LOAD DATA INFILE, more information found here:

http://www.mysql.com/doc/L/O/LOAD_DATA.html

Hope that helps

Chris King

[adilbasha]

hello,

There r 3 types of import.
1.table import mode.
syntax
imp userid=userid/password tables=(tablename)
file=.dmp

2.user import mode.
imp userid=userid/password fromuser=(username) touser=(username) file=.dmp

3.Full Database impot mode
imp userid=userid/password full=y file=.dmp

Hope u will get the output with this.
my mailid is [e-mail]