1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

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