Re: How do I import a .dmp file?

[Martin Gainty]

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 a .dmp file?
Date: Thu, 22 Jul 2004 14:05:05 -0400
MIME-Version: 1.0
Received: from lists.mysql.com ([213.136.52.31]) by mc5-f29.hotmail.com 
with Microsoft SMTPSVC(5.0.2195.6824); Thu, 22 Jul 2004 11:08:50 -0700
Received: (qmail 17882 invoked by uid 109); 22 Jul 2004 18:05:14 -
Received: (qmail 17863 invoked from network); 22 Jul 2004 18:05:14 -
Received: pass (lists.mysql.com: local policy)
X-Message-Info: JGTYoYF78jH8exqBaPPNR7eb/wfYap36
Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm
List-ID: 
Precedence: bulk
List-Help: <mailto:[EMAIL PROTECTED]>
List-Unsubscribe: 
<mailto:[EMAIL PROTECTED]>
List-Post: <mailto:[EMAIL PROTECTED]>
List-Archive: http://lists.mysql.com/mysql/169527
Delivered-To: mailing list [EMAIL PROTECTED]
Message-ID: <[EMAIL PROTECTED]>
User-Agent: Mozilla Thunderbird 0.7a (Windows/20040614)
X-Accept-Language: en-us, en
References: <[EMAIL PROTECTED]>
In-Reply-To: <[EMAIL PROTECTED]>
X-Virus-Checked: Checked
Return-Path: [EMAIL PROTECTED]
X-OriginalArrivalTime: 22 Jul 2004 18:08:50.0607 (UTC) 
FILETIME=[F0E0C3F0:01C47016]


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 ascii first.

Matt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
_
Don’t just search. Find. Check out the new MSN Search! 
http://search.msn.click-url.com/go/onm00200636ave/direct/01/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: How do I import a .dmp file?

[Paul DuBois]

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 must have come from an
Oracle system, because .dmp files are associated with
Oracle. But I may have been misinformed.

Seems to me that if you don't know what's in the file,
you're going to have a hard time doing anything sensible
with it.  Perhaps your first task is to determine what
it actually contains before you can figure out how to
get it into MySQL?
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How do I import a .dmp file?

[Justin Swanhart]

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 does 5k rows of data
though.

I've never used, nor do I endorse nxtract.  I just found it while
googling around looking for a tool to process oracle exp files.

It might be easier to just connect to the oracle instance (if it still
exists) using perl and extracting the data to insert statements that
way.




On Thu, 22 Jul 2004 15:53:39 -0700 (PDT), David Blomstrom
<[EMAIL PROTECTED]> 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 must have come from an
> Oracle system, because .dmp files are associated with
> Oracle. But I may have been misinformed.
> 
> __
> Do you Yahoo!?
> Vote for the stars of Yahoo!'s next ad campaign!
> http://advision.webevents.yahoo.com/yahoo/votelifeengine/
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> 
>

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: How do I import a .dmp file?

[David Blomstrom]

--- 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 .dmp files are associated with
Oracle. But I may have been misinformed.




__
Do you Yahoo!?
Vote for the stars of Yahoo!'s next ad campaign!
http://advision.webevents.yahoo.com/yahoo/votelifeengine/

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: How do I import a .dmp file?

[Victor Pendleton]

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, 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 archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How do I import a .dmp file?

[matt ryan]

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 archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How do I import a .dmp file?

[David Blomstrom]

--- 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 raw oracle, or
> EBCDIC it wont work, 
> you'll need to convert it to ascii first.

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.

__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How do I import a .dmp file?

[matt ryan]

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 ascii first.

Matt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: How do I import a .dmp file?

[Martin Gainty]

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 import a .dmp file?
Date: Wed, 21 Jul 2004 20:27:33 -0700 (PDT)
MIME-Version: 1.0
Received: from lists.mysql.com ([213.136.52.31]) by mc1-f10.hotmail.com 
with Microsoft SMTPSVC(5.0.2195.6824); Wed, 21 Jul 2004 20:29:29 -0700
Received: (qmail 2005 invoked by uid 109); 22 Jul 2004 03:27:37 -
Received: (qmail 1986 invoked from network); 22 Jul 2004 03:27:37 -
Received: pass (lists.mysql.com: local policy)
X-Message-Info: JGTYoYF78jE6BDzCXfOlHsBTi9i7i5MQ
Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm
List-ID: 
Precedence: bulk
List-Help: 
List-Unsubscribe: 

List-Post: 
List-Archive: http://lists.mysql.com/mysql/169482
Delivered-To: mailing list [EMAIL PROTECTED]
Message-ID: <[EMAIL PROTECTED]>
X-Virus-Checked: Checked
Return-Path: [EMAIL PROTECTED]
X-OriginalArrivalTime: 22 Jul 2004 03:29:29.0989 (UTC) 
FILETIME=[19195B50:01C46F9C]

I know how to import files ending with a .sql
extension with phpMyAdmin. However, I just downloaded
a database table that I want to import into a local
database - but it has a .dmp extension. What's the
best way to get this into a MySQL table?
Am I correct that the .dmp extension suggests
something from an Oracle database? If so, I've found
some software that converts Oracle to MySQL, but it
sounds like I have to have Oracle running on my
computer first. I don't have a clue about Oracle.
Anyway, can someone point me in the right direction?
Thanks.

__
Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages!
http://promotions.yahoo.com/new_mail
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
_
Express yourself instantly with MSN Messenger! Download today - it's FREE! 
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How do I import a .dmp file?

[SGreen]

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 facilities and compare what they 
can read with what you see if you open your downloaded database with a 
text editor.

http://dev.mysql.com/doc/mysql/en/mysqlimport.html
http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html
http://dev.mysql.com/doc/mysql/en/mysqldump.html

If phpMyAdmin has any bulk-import functions/facilities then read up on 
those, too. You may need to preprocess your raw data file to make it 
compatible with any of your available import functions.

http://www.phpmyadmin.net/documentation/#faq (start at 6.4 and 6.5 
and work your way from there)

Yours,
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine


David Blomstrom <[EMAIL PROTECTED]> wrote on 07/21/2004 11:27:33 
PM:

> I know how to import files ending with a .sql
> extension with phpMyAdmin. However, I just downloaded
> a database table that I want to import into a local
> database - but it has a .dmp extension. What's the
> best way to get this into a MySQL table?
> 
> Am I correct that the .dmp extension suggests
> something from an Oracle database? If so, I've found
> some software that converts Oracle to MySQL, but it
> sounds like I have to have Oracle running on my
> computer first. I don't have a clue about Oracle.
> 
> Anyway, can someone point me in the right direction?
> 
> Thanks.
> 
> 
> 
> __
> Do you Yahoo!?
> New and Improved Yahoo! Mail - Send 10MB messages!
> http://promotions.yahoo.com/new_mail 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>