Support » Localhost Installs » WordPress Migration And Localhost

  • Resolved Buxykay

    (@buxykay)


    Hi, I need help fast if possible. I had this bad luck to be hacked and the hosting service had to delete my database. Fortunately(or unfortunately), I have a mysql database backup since my last post.

    Now since the database and my site are no longer on the hosting, I installed wordpress on my localhost on my computer with the intention to export the posts in xml format and then import it on another wordpress installation on another host. I want to use the same domain name.

    After importing the database into phpmyadmin on my computer, I wanted to see what I have done and this is where problems started. The front page(home page) showed a list of recent posts as well as the widgets on the side bar although the theme is different. As I clicked the links to the posts, they returned error. I wanted to go to the admin panel but I was redirected to the url with “Error establishing a database connection”.

    Please I need help how I can use the database backup to retrieve my posts which are well over 300.

    PLEASE HELP ME SOMEBODY!

Viewing 6 replies - 1 through 6 (of 6 total)
  • are you sure the local wp-config.php has the correct database details?

    Thread Starter Buxykay

    (@buxykay)

    Thanks Samuel for your reply. I configured the localhost wp-config.php exactly as the one on the hosting. The same Database name, the same user and password.

    that may be the problem
    on my xampp installs (and I understand wamp is the same) the databse user is root and there is no password

    use the db creation part of this guide to create another database and test
    http://tamba2.org.uk/wordpress/xampp/

    Thread Starter Buxykay

    (@buxykay)

    Yes I first created a database on my xampp and then imported the database back up. When I installed the new wordpress the posts urls were displayed but on clicking them they directed me to the former url and displayed the error message.

    If you don’t change the values of siteurl and home in the wp_options table, WordPress will redirect you to whatever domain was originally specified.

    Set those two records in the database to http://localhost/whatever-the-path-is

    Thread Starter Buxykay

    (@buxykay)

    Thanks Kionae and Samuel B. I finally succeeded to retrieve my posts. Thanks for your support.

    This is what I did:
    1. Opened up the sql file in wordpad

    2. I then used the Edit –> Replace function which replaced the new url with the old one

    3. Imported the sql file into pühpmyadmin. This created a database on my localhost with the same name and data.

    4. Launched wordpress from my localhost and then

    5. In the admin panel Tools –> Export –> All contents in xml format.
    Now this is where I met with problem again. As I wanted to import the generated xml file into my new server, I got error that the limit is 2M and the xml is 2.1M. Is there a way round this?

    I decided to export and import by categories which was time consuming but I made a few then I got tired doing this and wanted to know if there is an easier method.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘WordPress Migration And Localhost’ is closed to new replies.