Where you install WordPress (web-root or a sub-folder of web-root) has nothing to do with where your database is located, or what the name of your database happens to be. Note: in many hosting situations you really have NO control WHERE the MySQL database is located.
You should review Moving WordPress, Changing_The_Site_URL, Installing WordPress, Backing_Up_Your_Database, and Restoring_Your_Database_From_Backup.
Thread Starter
pmars
(@pmars)
Thanks for the info….
I have edited this post 3 times in the last 30 minutes. Trying to explain my situation.
I am using the Fantastico install procedure. Problem is I do not have the old database. So I must keep the new database. Not sure how to modify the new database to suit. As of yet, I cannot get the blog to appear at all.
I realize the blog will not have my posts, but I would like to figure out how to get it running with all my tweaks, font changes, colors, header banner, etc.
I do have all the regular FTP saved files
Thanks
Thread Starter
pmars
(@pmars)
If I have an index.php page, shouldn’t it load? The address is domain.com/diary/wp/index.php… I can’t even get a basic page to load
I cannot get anything to display in a browser at all. I have edited the database.sql file and changed to all the correct URL’s, emails, etc.
I cannot use the basic fantastico install location because my pages in Google already have an address and I would like to maintain that. So I change the url’s and it still does not work. I have double checked several times. I have even purged all rows in “wp-comments” after getting the SQL error about conflicting comments during database import. (I exported the default database, changed the info, then imported)
Themes are loaded, plugins loaded, content re-loaded.
Help!
Problem is I do not have the old database.
If you don’t have the old database then what is the database.sql file?
You might ask your host for help in getting the initial Fantastico installed and running, then you can try importing that database.
Thread Starter
pmars
(@pmars)
I did get the Fantastico install to work. I wanted to use a different location url to match the original. Fantastico only does root + 1 level (domain.com/diary/)
I need root + 2 levels (domain.com/diary/wp/) and this causes it to not work.
Changing the site url in the database (exported from new Fantastico setup) does not work.
The Fantastico install does work, and if I upload my plugins and themes, I can get the appearance of the original site, but without all the extra pages I created.
I really wanted to keep the exact Google search url of the site. As it stands now, clicking on search results for my site leads no where. That’s the unfortunate part of all this. My pages were ranked, now they do not exist. Even the home page does not exist (as far as Google is concerned) 🙁
I don’t understand why Fantastico Install will not allow a url like domain.com/abc/def/ghi/jkl/….. or whatever I prefer.
I contend that if I were able to recreate the original sites exact url, basic functionality should be as simple as uploading my entire FTP backup folder.
Content, themes, css tweaks, pages, all should just work.
Thread Starter
pmars
(@pmars)
Originally I posted about the ‘localhost” parameter in wp-config. Instructions say to “stop modifications” at this point, but ‘localhost’ seems like it is begging to be changed to an actual url. I have tried it both ways with no success.
Since you know WordPress works, then make a copy of the wp-config.php for example, delete the Fantastico install, and then follow the instructions in Installing WordPress.