There is an easier path-
you *could buy* a data migration tool such as ispirer
http://www.ispirer.com/products
HTH,
Martin Gainty
(cell) 617-852-7822
From: matt ryan [EMAIL PROTECTED]
To: Martin Gainty [EMAIL PROTECTED]
CC: [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: How do I import
David,
What you use to bulk-import a file has more to do with its format than its
extension. Different products can all produce files with the same
extensions but with totally different formats. Not all SQL and DMP files
are created the same.
Read up on the native MySQL import/export
David
Did you look at MYSQL LOAD DATA INFILE ???
doc is available at
http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html
regards,
Martin Gainty
(cell) 617-852-7822
(e) [EMAIL PROTECTED]
(http)www.laconiadatasystems.com
From: David Blomstrom [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: How do I
David
Did you look at MYSQL LOAD DATA INFILE ???
doc is available at
http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html
regards,
Load data infile only works with a text file going into a table, if the
data is in another format, like raw oracle, or EBCDIC it wont work,
you'll need to convert it to
--- matt ryan [EMAIL PROTECTED] wrote:
David
Did you look at MYSQL LOAD DATA INFILE ???
doc is available at
http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html
regards,
Load data infile only works with a text file going
into a table, if the
data is in another format, like
OK, so if I can convert it into ascii, then it will be
a text file, which I can import using the instructions
at http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html,
right?
Thanks.
Yep, just have the table structure match the ascii file and load it in
Matt
--
MySQL General Mailing List
For list
Are you referring to an Oracle .dmp export file? If so you will also need to
do some parsing.
-Original Message-
From: matt ryan
To: David Blomstrom
Cc: [EMAIL PROTECTED]
Sent: 7/22/04 1:40 PM
Subject: Re: How do I import a .dmp file?
OK, so if I can convert it into ascii
--- Victor Pendleton [EMAIL PROTECTED] wrote:
Are you referring to an Oracle .dmp export file? If
so you will also need to
do some parsing.
* * * * * * * * * *
I don't know; this is the first time I've tangled with
a .dmp file. Someone told me it must have come from an
Oracle system, because
While the extension on the file isn't set in stone, many people add
the .dmp extension to files created with the Oracle exp utility.
You can use a third party utility call nxtract
(http://www.elmbronze.co.uk/nxtract/index.htm) to convert exp files
into tab delimited files. The eval version only
At 15:53 -0700 7/22/04, David Blomstrom wrote:
--- Victor Pendleton [EMAIL PROTECTED] wrote:
Are you referring to an Oracle .dmp export file? If
so you will also need to
do some parsing.
* * * * * * * * * *
I don't know; this is the first time I've tangled with
a .dmp file. Someone told me it
10 matches
Mail list logo