Recommended Procedure for db prefix change

Support
1

Is there a recommended procedure on how to change the database prefix for a given site? (Without incurring data loss).

site: example.com
current prefix: exa_
desired prefix: exa1_

I am aware that apiscp can only affect changes on the db server level and that configuration files of webapps would have to be manually modified.

2

Change mysql,dbaseprefix. Unit test circa 2022 that covers this.

3

This is causing issues. Its reproducable on two independant hosts.
Tested with a test-site rather than productive data. Missing Mysql grants after this.

steps to reproduce:

  1. Create new testsite (ie: mydbtest.tld)
  2. Use installer to throw a wordpress on it (so we have a test db with data)
  3. edit domain to have a different prefix (ie: -c ‘mysql,dbaseprefix’=‘mydbtest_’ )
  4. Log into nexus, go to mysql manager. See new DB - BUT you cannot assign any rights, as the grants are missing.

No grants found in database on mydbtest_.....' for user …’

4

Reproduced. I’ll look into this tomorrow :+1:

5

Thanks for the bug report. This has been fixed in edge at this time. I’ve expanded tests to ensure old users are properly converted as well.