1
elevator
Database prefix and security
  • 2005/7/18 4:09

  • elevator

  • Just popping in

  • Posts: 21

  • Since: 2004/8/24


Question: Is there a way to change the table prefix (default xoops_) after the site has gone live? I'd like to change the prefix from its current value to something new but I don't know what it involves. I probably need to manually change the names of the tables to reflect this new prefix, but is there anything in the actual XOOPS code or config files that must be changed?

Thanks,
Elev.

2
JMorris
Re: Database prefix and security
  • 2005/7/18 4:47

  • JMorris

  • XOOPS is my life!

  • Posts: 2722

  • Since: 2004/4/11


I believe the Protector module will change the database tables for you, but you'll need to edit mainfile.php manually.

Quote:

If you want to change prefix, edit /path/to/xoops/root/mainfile.php manually.


Change:
// This prefix will be added to all new tables created to avoid name conflict in the database. If you are unsure, just use the default 'xoops'.
    
define('XOOPS_DB_PREFIX''xoops');


To:
// This prefix will be added to all new tables created to avoid name conflict in the database. If you are unsure, just use the default 'xoops'.
    
define('XOOPS_DB_PREFIX''desired_prefix');


Hope this helps.

JMorris
Insanity can be defined as "doing the same thing over and over and expecting different results."

Stupidity is not a crime. Therefore, you are free to go.

Login

Who's Online

372 user(s) are online (266 user(s) are browsing Support Forums)


Members: 0


Guests: 372


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits