partial mysql dump?

Discussion in 'MySQL' started by medicalhumor, May 15, 2007.

0
  1. #1
    what is the command to do a mysql dump of only a portion of a database?

    I have a large db that I would like to make a dump for only a certain section.

    Let's say make a dump for only rows 10,000 - 25,000

    or based on column "ID" values 10,000 - 25,000
     
    medicalhumor, May 15, 2007 IP
  2. Clive

    Clive Web Developer

    Messages:
    4,507
    Likes Received:
    297
    Best Answers:
    0
    Trophy Points:
    250
    #2
    Why not just use phpMyAdmin available tools to do what you're up to without having to know the command line? Or is it not available?
     
    Clive, May 15, 2007 IP
  3. medicalhumor

    medicalhumor Peon

    Messages:
    1,393
    Likes Received:
    115
    Best Answers:
    0
    Trophy Points:
    0
    #3
    I didn't see any options in phpMyAdmin to export a partial db. besides, the database is over 1.2GB and the section I want to export is probably well over 200mb. phpmyadmin usually times out for me at around 130mb
     
    medicalhumor, May 15, 2007 IP
  4. Clive

    Clive Web Developer

    Messages:
    4,507
    Likes Received:
    297
    Best Answers:
    0
    Trophy Points:
    250
    #4
    On the phpMyAdmin page, you have the option to:

    Dump X row(s) starting at record # X
     
    Clive, May 15, 2007 IP
    medicalhumor likes this.
  5. medicalhumor

    medicalhumor Peon

    Messages:
    1,393
    Likes Received:
    115
    Best Answers:
    0
    Trophy Points:
    0
    #5
    ahh, now I see it. Thanks Clive for pointing that out to me.
     
    medicalhumor, May 15, 2007 IP
    Clive likes this.
  6. Clive

    Clive Web Developer

    Messages:
    4,507
    Likes Received:
    297
    Best Answers:
    0
    Trophy Points:
    250
    #6
    Sure, you're welcome there :)
     
    Clive, May 15, 2007 IP