How to Export Wordpress Database without Admin

Discussion in 'Databases' started by kidblogger, Jul 22, 2007.

  1. #1
    Hi guys,

    I have this problem. Because I can't log-in to my wp-admin so this means I can't do anything.

    I need to get all the posts and reinstall the blog and import all the posts again.

    How do I get the posts by not logging in to my admin? It has something to do with my database I think
     
    kidblogger, Jul 22, 2007 IP
  2. backtoor

    backtoor Guest

    Messages:
    14
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    go to the control panel of your provider and look for phpmyadmin
     
    backtoor, Jul 22, 2007 IP
  3. kidblogger

    kidblogger Active Member

    Messages:
    791
    Likes Received:
    35
    Best Answers:
    0
    Trophy Points:
    70
    #3
    and then? :)
     
    kidblogger, Jul 22, 2007 IP
  4. aRo`

    aRo` Peon

    Messages:
    141
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    In the table wp_users enter your md5-hashed password in the user_pass column.

    you can easely find md5 encryption tools with a simple search in google.
     
    aRo`, Jul 22, 2007 IP
  5. dcristo

    dcristo Illustrious Member

    Messages:
    19,776
    Likes Received:
    1,200
    Best Answers:
    7
    Trophy Points:
    470
    Articles:
    7
    #5
    Using PHPMyAdmin export the database
     
    dcristo, Jul 22, 2007 IP
  6. .me

    .me Peon

    Messages:
    73
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    #6
    - Control Panel > phpMyAdmin > Select Database > Export >
    - Select All tables > Select "Save as file" (Check the compression to "gzipped" if you want) > Go
     
    .me, Jul 22, 2007 IP
  7. agnivo007

    agnivo007 Peon

    Messages:
    4,290
    Likes Received:
    289
    Best Answers:
    0
    Trophy Points:
    0
    #7
    Did you try the "forgot password" link? I mean if your blog is not corrupted itself.
     
    agnivo007, Jul 22, 2007 IP
  8. Ascendancy

    Ascendancy Active Member

    Messages:
    1,721
    Likes Received:
    31
    Best Answers:
    0
    Trophy Points:
    90
    #8
    Ascendancy, Nov 10, 2009 IP
  9. Jalpari

    Jalpari Notable Member

    Messages:
    5,640
    Likes Received:
    137
    Best Answers:
    0
    Trophy Points:
    260
    #9
    cp > phpMyAdmin > ur database > export > select all table > save as file > go
     
    Jalpari, Nov 10, 2009 IP
  10. ebookbusiness

    ebookbusiness Member

    Messages:
    41
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    43
    #10
    If you know your database user name and password, you can also access all of your data from an external script. I had to do this once.
     
    ebookbusiness, Dec 3, 2009 IP
  11. bizguru

    bizguru Peon

    Messages:
    21
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #11
    I have hosting at godaddy and hostgator. Trying to move wp Mysql is a nightmare. You can't do a simple copy and paste of file and restore is only half the battle. You lose permalinks, widgets and other stuff too. Arrrrrggggg
     
    bizguru, Dec 3, 2009 IP