Database Prefix

Hello!

Is it possible to enter a prefix for all database tables during the installation?

e.g. “ocs_access_keys” instead of “access_keys”

I’d like to use a database with existing content. The prefix should avoid total mess.

Greetings!

Hi @danielbrohm,

there was this ticket: https://pkp.sfu.ca/bugzilla/show_bug.cgi?id=2287, but it seems like this hasn’t been implemented yet…

Hi @danielbrohm,

No, we don’t support database table prefixes. I would suggest running the software in its own database – this is generally a good idea anyway – and if you need to e.g. query across databases, use SQL query syntax for cross-database queries.

Regards,
Alec Smecher
Public Knowledge Project Team

Hi @ojsbsb & @asmecher!
Thanks for your answers.
I decided to use extra databases for each project!
Have a good week!
Daniel

This would be useful, or if not, SQLite support. I just wanted to test OJS on my host that only supports a single MySQL database. However, I could not, since there’s neither table prefix nor SQLite support. So there’s no way to test OJS on a simple setup before committing to obtaining more serious hosting with a dedicated database.