How to restore a WP site with only a backup of the database?

Discussion in 'WordPress' started by bigmodo, Oct 25, 2009.

  1. #1
    I only have a copy of my wordpress database which i exported through phpmyadmin. I have no other thing. How can i restore my wordpress site using this. I have imported it through phpmyadmin and i still can not find my wordpress. It still reads error. Can someone direct me on how to fix this properly?
     
    bigmodo, Oct 25, 2009 IP
  2. getadviced

    getadviced Well-Known Member

    Messages:
    557
    Likes Received:
    21
    Best Answers:
    0
    Trophy Points:
    130
    #2
    You can first copy the wordpress files to the new server. Then after that import the database and set the database details into the wp-config.php file.

    It should be fine.
     
    getadviced, Oct 25, 2009 IP
  3. dcristo

    dcristo Illustrious Member

    Messages:
    19,797
    Likes Received:
    1,201
    Best Answers:
    7
    Trophy Points:
    470
    Articles:
    5
    #3
    Are you importing the database correctly? If you are getting errors when importing the db, then you could have a problem with the database file.
     
    dcristo, Oct 25, 2009 IP
  4. deluxdon

    deluxdon Catch Me If You Can...!!!™ Staff

    Messages:
    25,482
    Likes Received:
    1,943
    Best Answers:
    32
    Trophy Points:
    480
    #4
    You need to install fresh wp files there first and then import your old WP DB Backup and change wp_config file as per DB setup.

    DON.
     
    deluxdon, Oct 25, 2009 IP
  5. bigmodo

    bigmodo Well-Known Member

    Messages:
    520
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    108
    #5
    bigmodo, Oct 26, 2009 IP
  6. krishmk

    krishmk Well-Known Member

    Messages:
    1,376
    Likes Received:
    40
    Best Answers:
    0
    Trophy Points:
    185
    #6
    Your database credentials in the wp-config.php file is incorrect.
    When I checked your wp-admin file, I came to know about this error.
    http://modospot.com/review/wp-admin/

    If your username and password is correct, make sure your hostname is correct. Most often it should be "localhost" but may be different with some hosting companies.
     
    krishmk, Oct 26, 2009 IP
  7. aap

    aap Well-Known Member

    Messages:
    1,802
    Likes Received:
    39
    Best Answers:
    2
    Trophy Points:
    120
    #7
    Do like this:
    1) Install fresh new wordpress.
    2) Login in cpanel and go to phpmyadmin
    3) Import the database file OR execute the SQL.

    Your wordpress blog should be restores.
     
    aap, Oct 26, 2009 IP
  8. Cheap SEO Services

    Cheap SEO Services <------DoFollow Backlinks

    Messages:
    16,664
    Likes Received:
    1,318
    Best Answers:
    0
    Trophy Points:
    0
    #8
    It's now showing the install page. You should be able to continue from this point and use the database host, name and password to connect to it correctly.
     
    Cheap SEO Services, Oct 26, 2009 IP
  9. krishmk

    krishmk Well-Known Member

    Messages:
    1,376
    Likes Received:
    40
    Best Answers:
    0
    Trophy Points:
    185
    #9
    Yes now its showing the install page. I guess you are better off from here.
    As you have only the db back up, you should manually install your custom themes/plugins/widgets etc. whatever you had earlier.
     
    krishmk, Oct 26, 2009 IP
  10. bigmodo

    bigmodo Well-Known Member

    Messages:
    520
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    108
    #10
    i have finished installing and creating the wordpress page. Now i am importing my backed up database files from myphpadmin. I will update yall when i am through.
     
    bigmodo, Oct 26, 2009 IP
  11. bigmodo

    bigmodo Well-Known Member

    Messages:
    520
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    108
    #11
    bigmodo, Oct 26, 2009 IP
  12. krishmk

    krishmk Well-Known Member

    Messages:
    1,376
    Likes Received:
    40
    Best Answers:
    0
    Trophy Points:
    185
    #12
    Open up your wp-config.php file and check the following:

    a) Has the php opening tag at the top (<?php)
    b) Has the php closing tag at the last line (?>)

    I had the similar problem earlier, the closing tag was not there in the last line.

    ------------------------------------------------------

    This might be due to some extra whitespace becoz of your plugins.
    Try to remove them through your ftp server or wordpress admin panel and then reinstall them.
     
    Last edited: Oct 26, 2009
    krishmk, Oct 26, 2009 IP
  13. bigmodo

    bigmodo Well-Known Member

    Messages:
    520
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    108
    #13
    The closing tag wasnt there in the last line, but i have fixed it still the site is blank.
     
    bigmodo, Oct 26, 2009 IP
  14. bigmodo

    bigmodo Well-Known Member

    Messages:
    520
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    108
    #14
    am finished. the years hard work is gone. this must be a dream because i cant believe it is happening.
     
    bigmodo, Oct 26, 2009 IP