Re: How do I import a .dmp file?
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: 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] _ Dont 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?
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]
RE: How do I import a .dmp file?
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: 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]
Re: How do I import a .dmp file?
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?
--- 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?
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?
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?
--- 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?
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?
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]