Database import issue.

  • purewhitewave

    (@purewhitewave)


    17 years, 7 months ago

    First of all, I apologise if this has been posted as a question but I am pulling my hair out here.

    Preface – not sure if this is part of the problem but just in case it is – my old domain name expired and I recently acquired a new one. For some reason, my ISP couldn’t just point my site to my new domain name so I had to reinstall wordpress and start from scratch. I have my database all backed up thanks to the back up plugin.

    Now… the issue: I am trying to import my backed up database through phpMyAdmin. Importing the database wasn’t the problem though… what ended up happening was that I had two sets of files – one with the prefix word_ and the other with the prefix wp_. But no matter what I do, whenever I try to view my site it always redirects me to my old domain.. which isn’t there anymore 🙁

    I have tried changing wp_config.php to see if it’s the prefix problem but nothing works.

    Can anybody help? I have about 300+ blog entries in that database and I will be rather upset if I can’t get it to work. I will love you forever if you can help.

    Thanks guys.

Viewing 6 replies - 1 through 6 (of 6 total)
  • stvwlf

    (@stvwlf)

    17 years, 7 months ago

    hi

    the default installation of WordPress uses table names that start with wp_. It sound like perhaps your old installation was using the prefix of word_. If that is the case you basically have files from two blogs installed in the same MySQL database.

    I suggest you look at table word_posts and see if your old posts are in there. If they are, that is the set of tables you want to use. In that case, use phpMyAdmin and browse into the word_options table. On the first place you will probably see a reference to your old domain. Change it to point to your new domain. On page 3 in word_options you will see another reference to your old domain. Change that one to your new domain also.

    Then make sure your your wp_config file is set with this line:
    $table_prefix = ‘word_’;

    That should point WP to your old blog entries.

    You will find hard coded references to your old domain in various places in your posts also. You will need to run a SQL update query to change all references to the old domain to the new domain.

    Thread Starter purewhitewave

    (@purewhitewave)

    17 years, 7 months ago

    Both wp_ and word_ are still on the database and thanks to your help, I now have the website pointing to the right domain name.

    BUT… my old archives are still not showing up…

    Any other suggestions?

    stvwlf

    (@stvwlf)

    17 years, 7 months ago

    what is your domain?

    ergonomicchairs

    (@ergonomicchairs)

    17 years, 7 months ago

    I have transferred my blog from a c-panel to a godaddy account recently. almost success….but of course a few problems. I am having the same problem as above.
    I have my two blog files installed on the same mysql database. I have the wp_ default blank wordpress and then the soi_blog tables I created from my transfer of the past sql blog table files.
    When I change my wp-config. files to point to the table prefix of soi-blog instead of wp…..and upload it:
    The page appears totally blank when I refresh it as though I had blank tables? When I restore the wp-config file to the wp_ the default wordpress page appears again so i know that I am on the right track but cannot figure out what I am missing?

    The domain name has not changed so I shouldn’t have to mess with that?
    Any suggestion or help would be most appreciated. You seem very knowledgable. Thanks and have a good one.

    ergonomicchairs

    (@ergonomicchairs)

    17 years, 7 months ago

    my domain name is http://www.sexoffenderissues.org if that helps to view the problem..

    stvwlf

    (@stvwlf)

    17 years, 6 months ago

    hi

    when you host on a GoDaddy server you must change the host line in wp-config.php from localhost to a specific host that godaddy tells you after a new database is created. That may be your problem

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘Database import issue.’ is closed to new replies.