List:General Discussion« Previous MessageNext Message »
From:SGreen Date:July 22 2004 12:58pm
Subject:Re: How do I import a .dmp file?
View as plain text  
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 <david_blomstrom@stripped> 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/mysql?unsub=1
> 

Thread
How do I import a .dmp file?David Blomstrom22 Jul
  • Re: How do I import a .dmp file?SGreen22 Jul
RE: How do I import a .dmp file?Martin Gainty22 Jul
  • Re: How do I import a .dmp file?matt ryan22 Jul
    • Re: How do I import a .dmp file?David Blomstrom22 Jul
      • Re: How do I import a .dmp file?matt ryan22 Jul
RE: How do I import a .dmp file?Victor Pendleton22 Jul
  • RE: How do I import a .dmp file?David Blomstrom23 Jul
    • Re: How do I import a .dmp file?Justin Swanhart23 Jul
    • RE: How do I import a .dmp file?Paul DuBois23 Jul
Re: How do I import a .dmp file?Martin Gainty23 Jul