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 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
    SEMrush
     
    wptheme, Nov 19, 2009 IP
    SEMrush
  2. ilook

    ilook Well-Known Member

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

    wptheme Well-Known Member

    Messages:
    4,052
    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:
    166
    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,052
    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:
    166
    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,052
    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:
    166
    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,052
    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,052
    Likes Received:
    346
    Best Answers:
    0
    Trophy Points:
    180
    #12
    what do you mean with the above BOLD
     
    wptheme, Nov 21, 2009 IP