Here is an interesting one.
My old domain expired, but I was able to pull a complete MySQL database backup. I've registered and hosted a new domain at Dreamhost. For the sake of expediency, I opted for the One-Click WordPress install.
The new blog is: http://www.grabbingsand.org/wordpress/
But I can see that the Tables created by the One-Click install do not match the Tables in my backup. (I understand, of course, that my backup has some Tables from plug-ins not yet installed.)
For example, where my old backup has "WP_links" -- the new install has created "wp_c4s7mf_links" ... this continues for "WP_options" and "WP_posts" and so on.
I'm pretty certain that the WordPress install will fail if I simply drop the "wp_c4s7mf_" tables and replace them with the old tables. So what is best to do? Open the backup and do a Find & Replace for "WP_links" (and other such Tables) to replace "WP_" with "wp_c4s7mf_"?
Thanks for your attention.