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 to Export Wordpress Database without Admin

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

0
  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,199
    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