With that last few WordPress installs I have done (when moving data like this) that is what I have done.
(*chuckle*)... You mean you used the Wordpress Import/Export options or you used the PHPMyAdmin method working with the raw database? Sorry, I'm unclear on exactly what you meant...
As for exactly what I did:
1) Before I deleted my old blog, I used PHPMyAdmin to export the database to an .sql file. I also exported a .zip and .gzip file just to be safe but I didn't need them.
2) I uninstalled my old Wordpress installation using Fantastico.
3) Downloaded Wordpress 2.51
4) Unzipped it and renamed the wp-config-sample.php file to wp-config.php
5) Went to cPanel >> MySQL databases and created a new database called wrdp1 (which creates a database called "username_wrdp1")
6) Created a database user called wrdp1 (which creates a user called "username_wrdp1") and a password.
7) Added the "username_wrdp1" user to the "username_wrdp1" database (clicked to check "All Privileges")
8) Modified the wp-config.php file with the database name, database user and the password.
9) Uploaded all the Wordpress 2.51 files to my blog directory
11) Uploaded the Wordpress theme I was using to the themes directory (VERY IMPORTANT! This is where I got stuck.. I forgot to do this initially and I kept getting a completely blank page when I loaded my blog and I spent a lot of time thinking it was a misconfiguration with the database name, username or password)
12) Back in cPanel >> MySQL Databases >> PHPMyAdmin, I accessed the username_wrdp1 database and then imported my saved .sql file (saved in step 1)
11) Went to
http://mydomain.com/blogrootdirectory/wp-admin/ in my browser. From there (after logging in) I got prompted to update the database (click on Continue). This is normal. I've seen it before.
And then my blog was finally up and running with Wordpress 2.51. (phew!)
All in all, a royal bleepin' PITA (not blaming Lunarpages.. that's just the nature of Wordpress..)