Posts

my old SQL tables used kiwi_ as the prefix. I’d like to change when I import to new server. Or is it complicated? Not sure to ask you or web host.

----- [updated: 31Aug2023]

 Alter-Drukarsh connections |The Garelicks|Journal 3.3.12 -  PHP Version 8.1.17 - mySQL 8.1
The Royals |The Kennedys|The Gerrer Rabbis  3.3.12 -  PHP Version 8.1.17 - mySQL 8.1

It’s very easy (assuming you have access to the database, and preferably using PhpMyAdmin). But there are TWO things you must do. Either one on its own will render your data (temporarily) unavailable.

Before you start, log out of kiwitrees, and close its window in your browser.

1 – Change the prefixes. In PhpMyAdmin select all the tables (there is selection option below the list of tables to “select all”). Then in the “with selected:” drop-down there is an option to “Replace table prefix”. Fill in the required details, click ‘continue’ and the job is done.

2 – Now you must tell kiwitrees about the change. For that you must edit the file /data/config.ini.php. SImply alter the line containing the table prefix to match the updated prefix and save it.

Nigel
My personal kiwitrees site is www.our-families.info