SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    Non-Member
    Join Date
    Jan 2004
    Location
    Seattle
    Posts
    4,328
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    How do you import a dump file?

    I know how to import files ending with the .sql extension into an online database using phpMyAdmin. But I just downloaded an enormous database table ending with a .dmp extension and want to import it into my local database.

    I opened phpMyAdmin, then "Query window," like I usually do and browsed to the file on my desktop. I wasn't sure if I should choose Autodetect, None or Gzipped, so I tried all three. Each time I got the message, "No SQL query!"

    So what am I supposed to do with this .dmp file?

  2. #2
    SitePoint Wizard Lats's Avatar
    Join Date
    Jun 2003
    Location
    Melbourne, AU
    Posts
    1,142
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I believe that's a standard output from an Oracle system - you'll need to get it converted.
    Lats...

  3. #3
    Non-Member
    Join Date
    Jan 2004
    Location
    Seattle
    Posts
    4,328
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by Lats
    I believe that's a standard output from an Oracle system - you'll need to get it converted.
    OK, next question:

    How do I convert it?

  4. #4
    He's No Good To Me Dead silver trophybronze trophy stymiee's Avatar
    Join Date
    Feb 2003
    Location
    Slave I
    Posts
    23,449
    Mentioned
    1 Post(s)
    Tagged
    1 Thread(s)
    Here might be a good place to start: http://www.google.com/search?hl=en&i...=Google+Search


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •