mysql question

[Tru2Chevy]

I want to switch my phpBB 2.0.17 board to vBulletin, so I ran the vb_test.php test on my database last night. It reported the following:

1) vBulletin requires that the mysql username has create, select, update, insert, delete, alter and drop privledges, contact your host and ask them to adjust these privledges.

2) magic_quotes_gpc should be off for optimal performance, ask your host to change this in php.ini

***

1) I emailed my host (Canaca.com), and they asked that I create any database that I need via their admin panel (ensim pro), as they don't give me the rights to do so through phpMyAdmin. I have run several SQL quiries on my database for various phpBB mods, so I know that I can modify the database from phpMyAdmin, I just can't create the database through that tool. Will this be a problem?

2) How important is magic_quotes_gpc?

Thanks for your assistance. I'm still somewhat of a newb when it comes to this sort of thing.

- Justin

[Steve Machol]

1. As long as you can create a db with Ensim Pro this is sufficient.

2. I honestly don't think it's that critical at all.

[Brad.loo]

You can also install vBulletin in an existing database, if you do so you should use a table prefix (you can set that up durring installation). This is to avoid table naming conflicts.

[Tru2Chevy]

Thanks for the quick response Steve :)


You can also install vBulletin in an existing database, if you do so you should use a table prefix (you can set that up durring installation). This is to avoid table naming conflicts.

Do you mean that when I install vBulletin I can just choose to have it use the existing database rather than importing everything? I guess that would be easier, but is there anything to watch out for?

- Justin

[Mr_Bob]

Just be certain you include a table prefix and none of your phpbb tables will be touched. Also as per your previous question I use Canaca myself. Yes, don't listine to the file you do have alter, drop, etc permisions if you have the silver or gold plans (required to run mysql). VB runs perfectly on my site so itt shouldn't be a problem setting up.

[feldon23]

Thanks for the quick response Steve :)



Do you mean that when I install vBulletin I can just choose to have it use the existing database rather than importing everything? I guess that would be easier, but is there anything to watch out for?

- Justin
This is not what is being recommended.

Create a new database using the Ensim control panel.

When you install vBulletin, have it connect to that new database. Keep the phpBB database and the vB database separate unless you are unable to (usually on webhosts that only allow you to have 1 MySQL db).