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 -0000
Received: (qmail 17863 invoked from network); 22 Jul 2004 18:05:14 -0000
Received: pass (lists.mysql.com: local policy)
X-Message-Info: JGTYoYF78jH8exqBaPPNR7eb/wfYap36
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/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]
