mySQL

[loudmouth_92804]

The company that I would like to host my site tells me that they only support tables in mySQL and not databases. Will vbulletin LIte still work if I install.


Thank You,

[JimF]

I don't see why not; as long as there are no existing tables set up with the same names; and as long as nobody wants to use those table names in the future. You can't easily change the names of the tables in vBulletin, so that's not an option.

Who is your hosting company? I think that having all users use tables inside of one database is insecure, unsafe, inefficent, I could go on and on. I would move hosting companies if I were you - they don't sound very smart...

But to answer your question, yes conceivably it would work - but there couldn't be any other tables with the same names in there. And also if you don't mind other people having access to all of your data.

-jim

[Mike Sullivan]

I'm confused. MySQL is a RDBMS. Relational DataBase Management System. (Or something along those lines) How could they NOT support databases?

[JimF]

That's what I thought at first, too, Ed/Mike/Scott. But what I finally realized was that the host doesn't allocate databases to the users; they allocate tables inside of a database to them. Unless I am misunderstanding totally, I think this is what loudmouth meant.

My host, for example, allocates 6 MySQL databases with the package I have that I can use for anything. Whereas loudmouth's host says "Your database is called user_database; this is where you should build your tables" or something like that. It seems VERY strange to me...

-jim