missychic – can you explain a bit more about what other files you may have changed ? This doesn’t sound like a db problem so far
Ok, let me retrace my steps. I did a fresh install on the new website. Then I dropped all tables within the database via phpmyadmin. Then I followed the directions on tamba and codex. After that, I got a white blank page. I noticed that on the wp login page it was plain without the typical WP login page and the links on that login page had the old link to old website.
In my old website, it had different layout, different configurations, and some plugins but I removed those plugins while backing it up to a sql file.
What could have gone wrong?
Just thinking aloud… Did you get a “succeeded” message after the restore? Are the data in your config file updated for the old, imported DB? I mean the username, pw are the same? Are the site_url and home options corrected in your imported BD to reflect its new “home? (see: http://www.tamba2.org.uk/wordpress/site-url/)
moshu
It worked! It’s all in the site url. Thanks so much. I have it up and running smoothly.
I appreciate for all of your help! Again, WP is a great software.
Great! Glad it worked out – happy wordpressing 🙂
I thought I’d post under this thread rather than create a new one.
I was merging with older entries to my new WP and then made a backup. On the other WP, it was a version 1.5 while my current and active WP is 1.5.1.1. I followed the Restoring database from backup and fixing Siteurl procedures exactly. The query was successful. Then I upgraded to 1.5.1.2. Now, my WP is not showing up on main page. I’m not sure what went wrong? The siteurl is correct and I was able to view and edit entries as well as the rest of WP admin without a problem. The main page is the only thing that’s not showing my entries. I’m stumped by this. Help! TIA.
I’m going to bump this thread again. Please take a look at my entry above and I’d be grateful for your assistance. Like others, the Dashboard is blank as well.
I think you’d be better off starting a new thread….