How to backup my wordpress database and view using my computer's WAMP?

Discussion in 'Databases' started by wptheme, Nov 19, 2009.

  1. #1
    Hi, I have installed WAMP and installed a new fresh wordpress on my PC. I have a wordpress blog on my webhosting that I would like to download and install at my pc. Is there any certain guide? I know that I should import my sql data from my webhosting and also download the blog files and place it at my WAMP subfolder.
    However when I uploaded the sql database to my newly fresh installed wordpress at my when I tried opening it it only came out a blank white page.
    Is there any certain guide on this? Would be appreciated some help. Thanks
     
    wptheme, Nov 19, 2009 IP
  2. ilook

    ilook Well-Known Member

    Messages:
    1,602
    Likes Received:
    15
    Best Answers:
    1
    Trophy Points:
    165
  3. wptheme

    wptheme Well-Known Member

    Messages:
    4,051
    Likes Received:
    346
    Best Answers:
    0
    Trophy Points:
    180
    #3
    I already know how to backup just how to setup n view it at my pc.
     
    wptheme, Nov 19, 2009 IP
  4. averyz

    averyz Well-Known Member

    Messages:
    1,228
    Likes Received:
    167
    Best Answers:
    2
    Trophy Points:
    115
    #4
    You might try using the tools-import sometimes just moving the sql files to a local host can keep the wrong address in the files.
     
    averyz, Nov 19, 2009 IP
  5. wptheme

    wptheme Well-Known Member

    Messages:
    4,051
    Likes Received:
    346
    Best Answers:
    0
    Trophy Points:
    180
    #5
    Well I am using to import the sql database from import ay phpmyadmin but does not seems to work on my PC.
     
    wptheme, Nov 19, 2009 IP
  6. averyz

    averyz Well-Known Member

    Messages:
    1,228
    Likes Received:
    167
    Best Answers:
    2
    Trophy Points:
    115
    #6
    Try the import tool in WP in the dashboard, it will rewrite some of the address in the database info.

     
    averyz, Nov 19, 2009 IP
  7. wptheme

    wptheme Well-Known Member

    Messages:
    4,051
    Likes Received:
    346
    Best Answers:
    0
    Trophy Points:
    180
    #7
    where do I get the xml?
     
    wptheme, Nov 20, 2009 IP
  8. meno

    meno Active Member

    Messages:
    121
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    60
    #8
    backup sql but without table "wp-options"
    its work for me....
    because wp-option contain web url setting....
     
    meno, Nov 20, 2009 IP
    wptheme likes this.
  9. averyz

    averyz Well-Known Member

    Messages:
    1,228
    Likes Received:
    167
    Best Answers:
    2
    Trophy Points:
    115
    #9
    What I think might be happening (not sure just a guess) is the info in your database still has your web url, sometimes that will make it come up as a blank screen.

    WP import tool will rewrite this or you can do it manually.

    Try checking your SQL database

    - Wp_options - (open this) – the 2nd item down should be - "site url" - this should be "http://localhost/yoursitename"

    Not sure if this is what the trouble is but it is worth checking out.
     
    averyz, Nov 20, 2009 IP
    wptheme likes this.
  10. wptheme

    wptheme Well-Known Member

    Messages:
    4,051
    Likes Received:
    346
    Best Answers:
    0
    Trophy Points:
    180
    #10
    K. thanks everyone. Will try again. rep added to all replied here.
    Cheerio :)
     
    wptheme, Nov 21, 2009 IP
  11. viron86

    viron86 Active Member

    Messages:
    426
    Likes Received:
    6
    Best Answers:
    0
    Trophy Points:
    60
    #11
    export the database from wordpress
    then open php my admin and import it
     
    viron86, Nov 21, 2009 IP
  12. wptheme

    wptheme Well-Known Member

    Messages:
    4,051
    Likes Received:
    346
    Best Answers:
    0
    Trophy Points:
    180
    #12
    what do you mean with the above BOLD
     
    wptheme, Nov 21, 2009 IP