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

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

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

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

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

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

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

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

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

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

How do I import a .dmp file?

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