how do dump a database.

Discussion in 'Databases' started by driven, Sep 28, 2006.

  1. #1
    Hey guys, I'm trying to dump my Wordpress database in phpmyAdmin.

    I need to clarify what I need to do in order to avoid being screwed over. php and databases aren't my thing.

    Is this what I should do;

    Go to phpmyAdmin.
    Select the database that I want to delete.
    Check all.

    But what do I select next? Do I select "empty" or "drop" to get rid of the database.
     
    driven, Sep 28, 2006 IP
  2. Colbyt

    Colbyt Notable Member

    Messages:
    3,224
    Likes Received:
    185
    Best Answers:
    0
    Trophy Points:
    210
    #2
    Just go to your cPanel or whatever and delete the sucker. It is gone.

    Now in order to use WP you are going to need to do a new install of the DB.

    Is this what you wanted to do?
     
    Colbyt, Sep 28, 2006 IP
  3. fsmedia

    fsmedia Prominent Member

    Messages:
    5,163
    Likes Received:
    262
    Best Answers:
    0
    Trophy Points:
    390
    #3
    Go to "export" and then select all the tables, then you can choose the options to either export to a file or to straight text and copy it.
     
    fsmedia, Sep 28, 2006 IP
  4. driven

    driven Well-Known Member

    Messages:
    400
    Likes Received:
    14
    Best Answers:
    0
    Trophy Points:
    138
    #4
    Actually, I just hit drop and it's gone. Poof!

    Colbyt- Yes, I am doing a new install of WP.
     
    driven, Sep 28, 2006 IP
  5. Colbyt

    Colbyt Notable Member

    Messages:
    3,224
    Likes Received:
    185
    Best Answers:
    0
    Trophy Points:
    210
    #5
    Yeah! I had to read your post twice to realize you wanted to delete and not do a dump of the DB.

    If it was a reading test I guess I passed.

    Good luck with your new install.
     
    Colbyt, Sep 28, 2006 IP
  6. EGS

    EGS Notable Member

    Messages:
    6,078
    Likes Received:
    438
    Best Answers:
    0
    Trophy Points:
    290
    #6
    You can dump a database through Shell if you uploaded a .sql or .sql.gz file onto your web server. :) It's easier and quicker to do that, IMO, especially if the database is large.

    G'luck! ;)
     
    EGS, Sep 28, 2006 IP
  7. Mystique

    Mystique Well-Known Member

    Messages:
    2,579
    Likes Received:
    94
    Best Answers:
    2
    Trophy Points:
    195
    #7
    Another good, quick option is using a php script, such as bigdump :rolleyes:
     
    Mystique, Sep 28, 2006 IP
  8. driven

    driven Well-Known Member

    Messages:
    400
    Likes Received:
    14
    Best Answers:
    0
    Trophy Points:
    138
    #8
    That sounds like alien speak to me :) Basically, I have no clue as to what you just said. It's ok- i got what I needed done.
     
    driven, Sep 28, 2006 IP