Importing Large Databases with Extended Inserts

Discussion in 'MySQL' started by Anduril66, Feb 5, 2007.

0
  1. #1
    Hello. I uploaded a large mysql dump to my webhost, and I would like to import it into my database. I can't use BigDump.php because my dump uses extended inserts. Do you know what I can do? Thanks.
     
    Anduril66, Feb 5, 2007 IP
  2. circuscircus

    circuscircus Peon

    Messages:
    240
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Upload the file first and you would have to use SSH and I believe the command is

    mysql -u {username} -p {database} {name_of_file.sql}

    I'm not sure if you can but I guess if they don't allow SSH, use PHP to run the command
     
    circuscircus, Feb 5, 2007 IP
  3. Anduril66

    Anduril66 Well-Known Member

    Messages:
    390
    Likes Received:
    17
    Best Answers:
    0
    Trophy Points:
    108
    #3
    Ok thanks for the help. Yeah, I have a HostGator account, and they don't have SSH access, and I thhink I was timing out with the PHP command, but I emailed my host and the imported the database quickly for me.
     
    Anduril66, Feb 5, 2007 IP