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 -0000
Received: (qmail 1986 invoked from network); 22 Jul 2004 03:27:37 -0000
Received: pass (lists.mysql.com: local policy)
X-Message-Info: JGTYoYF78jE6BDzCXfOlHsBTi9i7i5MQ
Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm
List-ID: <mysql.mysql.com>
Precedence: bulk
List-Help: <mailto:[EMAIL PROTECTED]>
List-Unsubscribe: <mailto:[EMAIL PROTECTED]>
List-Post: <mailto:[EMAIL PROTECTED]>
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]
