Hi,
I've just done that but I had restored the db as well and somehow, I'm now getting the welcome to WordPress Installation page when accessing my blog. Seems like the database table names might not have been correctly restored? These are the tables names I can see:
| wp_kiu4h0_comments__20080912_103056__20081108_0__20081108_081715 |
| wp_kiu4h0_comments__20081108_073651__20081108_081715 |
| wp_kiu4h0_links__20080912_103056__20081108_0736__20081108_081715 |
| wp_kiu4h0_links__20081108_073651__20081108_081715 |
| wp_kiu4h0_ngg_pictures__20081108_073651__20081108_081715 |
| wp_kiu4h0_openid_associations__20080912_103056___20081108_081715 |
| wp_kiu4h0_openid_identities__20080912_103056__2__20081108_081715 |
| wp_kiu4h0_openid_identities__20081108_073651__20081108_081715 |
| wp_kiu4h0_openid_nonces__20080912_103056__20081__20081108_081715 |
| wp_kiu4h0_options__20080912_103056__20081108_07__20081108_081715 |
| wp_kiu4h0_options__20081108_073651__20081108_081715 |
| wp_kiu4h0_podpress_statcounts__20081108_073651__20081108_081715 |
| wp_kiu4h0_podpress_stats__20081108_073651__20081108_081715 |
| wp_kiu4h0_postmeta__20080912_103056__20081108_0__20081108_081715 |
| wp_kiu4h0_postmeta__20081108_073651__20081108_081715 |
| wp_kiu4h0_posts__20080912_103056__20081108_0736__20081108_081715 |
| wp_kiu4h0_posts__20081108_073651__20081108_081715 |
| wp_kiu4h0_term_relationships__20080912_103056____20081108_081715 |
| wp_kiu4h0_term_relationships__20081108_073651__20081108_081715 |
| wp_kiu4h0_term_taxonomy__20080912_103056__20081__20081108_081715 |
| wp_kiu4h0_term_taxonomy__20081108_073651__20081108_081715 |
| wp_kiu4h0_terms__20080912_103056__20081108_0736__20081108_081715 |
| wp_kiu4h0_terms__20081108_073651__20081108_081715 |
| wp_kiu4h0_usermeta__20080912_103056__20081108_0__20081108_081715 |
| wp_kiu4h0_usermeta__20081108_073651__20081108_081715 |
| wp_kiu4h0_users__20080912_103056__20081108_0736__20081108_081715 |
| wp_kiu4h0_users__20081108_073651__20081108_081715 |
I suppose that I have to either modify table names for a set of them (with the same timestamp in the end) and remove the timestamp from it:
i.e. wp_kiu4h0_users__20081108_073651__20081108_081715 -> wp_kiu4h0_users
Or configure wordpress somehow to use the tables with timestamp I define?