I have gone through this 3 times now just to make sure.
Here is what I do:
Delete the entire wordpress install folder
Via phpmyadmin, drop entire DB having B/U already (700k sql file)
Create new DB "blogs" via
verify "wordpress" user has full perms on local host
for all DBs
extract 2.8.5.tar.gz in its own sub folder in my user folder on LAMP
Rename the resulting "WordPress" folder to custom name
surf to the correct domain/subfolder (after adjusting apache2.conf for correct path for WP location
I get the expected "create a config file" page.
Following the few steps inthe next page including
DB name
user
pass
local host
and prefix
It calls me "Sparky" and I click Install
Title and Email address filled in
note the new pwd and log in to the dash board.
Looks good.
Note that the DB is now populate with all 10 tables albiet pretty empty looking. Obviously.
Via phpadmin again, I restore with the sql file..it indicates success
still on the dashboard, if I click "visit site" I get the classic blank page.
If I go back and click on any of the management links on the left Appearance, Tools etc, I get Not Found as it is going to the wrong sub directory. Even thoughthe mouse-overs on them show a correct path
If I manually type in the /wp-admin/admin.php as it has been suggested in order to clear out custom Themes, which I DID have running when I exported the B/U i am restoring from, I get the same Not Found redirect thing. mydomain/blog/xxxxx instead of the mydomain/kenb/ which I keep setting up and is config'd in the Apache2.conf
Sry to be wordy, but I have gone through this a few times now and clearly, I am still missing something...
Thanks.