Can I use 2 different 'databases'?

[Grover]

Hi,

I have a database 'limelights' on my virtual server, which is in use by Vbulletin:


mysql> show tables;
+----------------------+
| Tables_in_limelights |
+----------------------+
| access
| adminlog
| adminutil
| announcement
| attachment
| avatar
| bbcode
| calendar_events
| customavatar
| forum
| forumpermission
| icon
| moderator
| poll
| pollvote
| post
| privatemessage
| profilefield
| replacement
| replacementset
| search
| searchindex
| session
| setting
| settinggroup
| smilie
| style
| subscribeforum
| subscribethread
| template
| templateset
| thread
| threadrate
| user
| useractivation
| userfield
| usergroup
| usertitle
| word
+----------------------+
39 rows in set (0.00 sec)

mysql>


Now, I also want to create another database which can be accesed by our visitors. The database contains, let say, information on all hairdressers in the Netherlands. I will create the database with MS Access and will learn to write a php/mysql script for it, so people can access the database on the website through this script.

So, what I would like to know is: can I add a table to the 'limelights'-database without any problems concerning Vbulletin??? I mean, the database 'limelights' is now only in use by Vbulletin and I wonder if I will get into any trouble during upgrading VBulletin or something if I add a new table to the database, which Vbulletin does not use?

Do you have any information on this?

Thank you,
~Grover.

[Kaizen]

As far as I know adding a table to a vbulletin databse shouldn't be a problem.

Always do a backup to make sure - or whenever u make changes to the database.

[rebby]

why not just create a new database and put all your other info in there???

[Grover]

I cannot create another database.

Originally posted by rebby
why not just create a new database and put all your other info in there???

Because I have a virtual server and I cannot create a(nother) database myself. I have just one database, and that's it.

~Grover.

[rebby]

Re: I cannot create another database.

Originally posted by Grover


Because I have a virtual server and I cannot create a(nother) database myself. I have just one database, and that's it.

~Grover.

i c, that makes sense

[tubedogg]

As long as there are no duplicate table names there should not be a problem doing this.

That said...why are hosts so frigging stingy? It takes literally 10 seconds to create a database and assign permissions; it can be done automatically by the end-user with something like CPanel or WHM. It's not like it costs them more; it's just that they are greedy.

[Kaizen]

or too make the more expensive deals with more than one mysql database look more impressive and get people to shell out for those instead!

[Grover]

I need to be 100% sure.

Tubedogg,

I need to be 100% sure on this:

- I CAN add tables to my database and it will NOT effect VBulletin in any way?
- Future versions of Vbulletin will be able to work with a database which contains additional tables???? I do not want to get in any trouble in the future.

Thanx,
Grover.

[tubedogg]

I cannot guarantee that in the future there will not be new tables with names that are the same as tables you add now, but for right now, there is no problem with adding additional tables to the database as long as they do not have the same names as vBulletin tables.