PDA

View Full Version : How Are mySQL Databases Handled?



DVD Plaza
Wed 20th Sep '00, 5:30am
I'm a self tough mySQL user so don't understand it very well at all, just enough to whip up a few nifty systems using it.

With my host I have a database set up called "dvdplaza". I log into that, and within there I have a number of databases set up for a variety of different purposes. Cool.

But...VBulletin enters that and realises there is other stuff in there and for some reason gives an option to clear it out...WHOA...what's the deal here? I have valuable data sitting in other databases within my "dvdplaza" database, why the heck would VBulletin be wanting to blow it all away?

It gives me an option to continue on without doing that, but I'm reluctant to go any further at this stage. I do not want those other databases touched what-so-ever, and when I go to install the full product should I decide to ditch UBB (okay I'm definitely doing that piece of junk, just sussing out what to use instead) I will want to blow away the stuff created by this "lite" version...now in the process is it, as it wants to do now, going to destroy everything else as well?

Note that I sign into mySQL using a particular username and password, and then must after wards do a "use dvdplaza" to switch into my database. I have no idea what that last part means but that's what my host said to do, anything else doesn't work...so it seems I have a subsection, and within that I have all my databases...but VBulletin wants to destroy that?!?!?

Confused and concerned... :(

P.S. I had to use the PHP3 files, PHP reported that I didn't have it installed (though wierd how it can execute to say that?). Why would someone set up a system to use a version number within an extension as it would be obsolete later???

P.S. Awesome, you can edit a post and add/remove e-mail notification at any time...god this product is awesome, can't wait to give it a try...

[Edited by DVD Plaza on 09-20-2000 at 04:39 AM]

eva2000
Wed 20th Sep '00, 5:44am
that's scary... before you do anything backup your existing database stuff just in case :)

i don't know anything on mysql/php so can't give any advice...

maybe ask your host if you can get a separate databse for the forum ?

with the php extension thing

just create a .htaccess file with this in it



AddType application/x-httpd-php3 .php


and place it in the root directory on your server.

as to other awesome features check out this places code hacking forum .... it will blow your mind :D

doron
Wed 20th Sep '00, 6:51am
are you using vbLite?

the reason for wiping is to start with a fresh db. Since you seem to only have one database which is used by various programs it seems (bad practice actaully), you should not do that.

Simply, don't clear it.