1) how do you find the time to help me?
I post very quickly, hence the typos (a fair tradeoff by my estimation).
2) using ws-ftp, i have never once seen my database (although it does get backed up with cpanel) - i searched but can't find it in my gadgetaddict "folder" or however i'm organized on ipowerweb's server.
The database files are stored outside the directory you have access to.
myadmin reports the database with a [email protected]
which i assume is actually the server i'm on, but i've never once been able to directly see it -
I assume that "name" is your username. Localhost just means your local computer as opposed to a remote computer.
You really never "see" the database except through an application that queries the mysql engine. PHPMyAdmin IS "seeing" the database (you can edit a field here and there) and your forums are another way to "see" the database.
The actual database is just a bunch of files that only the mysql engine really understands (with excepotions of course).
so i don't know how i can upload a new one
Aha! Thanks for pointing that out. ipowerweb does not allow you to create your own DBs if I remember correctly. You might need to pay them a $10 one-time fee to set up a new one.
- i can envision backing up the data, and having myadmin create a new database, and then exporting the data back in, which i believe is what you're talking about,
It wasn't what I was talking about but it is a faster way. The downside is that if something goes wrong you can't just ropen the forum while you tinker with the secondary DB.
In any case you CAN do it this way.
but then i don't know how to create the proper directory structure you were referring to - i THOUGHT you had said my database should go in the highest subdirectory i could place it, but maybe i misunderstood, and you really mean the phpbb goes in the highest directory?
Whoa, I must have been typing too fast. All the databases on the server you are on (and there are a few hundred sites on teh server you are on) have their own folder in the mysql directory.
And you do not have access to that directory since you do not have root access.
The directory structure only referrs to the phpbb files you upload.
Your root directory should (IMO) be for your portal and your forum should be a subdirectory.
No no, public_html IS your root directory. The directories above that are for FTP and other things. yourdomain leads directly to the public_html directory.
i.e. i would rename the phpbb2 master directory to be forum, then ws-ftp the whole thing such that forum would become that phpbb2 master...then i'd follow the rest of the install using forum
I'm not sure I follow but lemme say this:
If you want to simply overwrite the database (since you have a backup) you might as well just overwrite the forums directory.
If you do it this way there is the issue I mentioned about not being able to revert to your old forums if there is an error.
But it's faster.
In any case doing it this way means you MUST be SURE that your DB backup performs correctly.
IF you want I can help you verify this.
my plan would be to get the 2.05 system running in vanilla mode, and then start installing your spider mods (thanks again!!!) and finally i'd install phpadsnew - my god that's fully realized program!
IMO you should completely forget about the mods for now. Let's just get your site up. The mods take a few minutes.
5) finally, my intention would be to export the soon to be defunct current database i'm using, and then import into the working vanilla database, and then finally delete the original database - that way the vanilla board would only have a few days of staleness - unless there's a way for me to export only the newer posts and then import them, but that's probably more work than anything else - then again, what do i know?
Hmm, you really can do all of this in less than one hour. But to do so means you need to be prepared.
i could potentially save any major posts between the backup and going live, and then import them via cut and paste or some other manual method
is this a plan? and if you use a pocket pc, lemme know what model and what accessories you'd like
No no, you don't want to add a few posts afterward. It's not just the text of the posts but whole bunches of other things that are inserted.
It would take me longer to figure out how to add a few important posts than to create 25 forums and the potential for error would be big.
BTW, I use an old palm pilot III xe. And the only accessory I want I don't beleiev exists (a USB cradle).