Kiwitrees on Twitter

    MAC, folder, survey, tab, 500, 1939 Register, Default record, blocks, census assistant, duplicates, GEDCOM errors, styles, updates, multiple marriages, beta, lists individuals families, googlemaps, dropbox. token, privacy, dates, mobile, message contactform, 3.2.2, errors, Export/Import, ID notes, custom text, NCHI, drag, living, family, married, login failure, Require visitor authentication, burial, 3.3.0, logout, Search and replace, 5.6, save settings, gettext, tags, prefix, translate, default individual, index, fact, xenea, users, abbreviate, batch update, kiwitrees 2.0.2, illegitimate, transifex, person, data errors, 7.2, theme, spouse, locked out

    Topic:   Tables import  

    This topic contains 1 reply, has 2 voices, and was last updated by kiwi kiwi 10 months, 3 weeks ago.

    Viewing 2 posts - 1 through 2 (of 2 total)
    • Author
    • #10206

      466 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: 01 Apr 2018]
      MacOS: 10.11.6  (El Capitan)
      Safari  11.1;  Firefox 59.0.2

      PHP 7.1 Fast CGI
      mySQL server: 5.1.56

      "The Royals 3.3.3 (03)" <>

      "Rebbes of Ger 3.3.3 (03)" <private>

      "Uncle Ummie's Journal 3.3.3 (03)" <private>


      1679 posts

      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.

      My personal kiwitrees site is
    Viewing 2 posts - 1 through 2 (of 2 total)

    You must be logged in to reply to this topic.