Loading...
 
Architecture / Installation

Architecture / Installation


Re: error while importing database

posts: 1563 Germany

Hi nicosal,

I want to add some points to Tom Jarvis answer, to make it a bit clearer for you

Your approach to test-upgrade by using a copy of the databaseis absolutely right!

BUT you made it in the wrong order.

So checking out a new Tiki 13.1 in a seperate directory and applying a new subdomain alike "test.mydomain.com" is fine and you can use this directory.

But as Tom said, you have to start your work with a copy of the existing 12.x database. make a dump (or use the dump you already made).

  • FIRST you import the (Ti 12.x) dump to a clean database
    => for that as Tom said, delete all tables of your testing_database
     
  • SECOND run the installer test.yourdomain.com/tiki-install.php
     
  • THIRD click through the installer and at about half way you will be asked for the database credential, respectively to use the existing database connection (as you already have a file db/local.php created in your previous attempt).

    Here you are asked to upgrade your database. Do that.

    Finish the installer, lock and enter your Tiki.

Now everything should alright. In case you have custom files like logos, favicons etc. you might want to copy them from your existing Tiki 12.x to the new installion in the appropriate directories.

In case you have files storage neither in the database, nor in the tikiroot (not recommended), but instead outside the tkiroot (recommended), then you have to copy the files directories "sides" your testing installation. Depending on your directory structure, you aswell could use the existing files directory, but I would not recommend to do that, as then you have o way to keep both databases in sync, if you any upload or delete or reallocate files in one of the both installations so better copy all or test witht files.

Regards,
Torsten

There are no comments at this time.

Upcoming Events

1)  18 Apr 2024 14:00 GMT-0000
Tiki Roundtable Meeting
2)  16 May 2024 14:00 GMT-0000
Tiki Roundtable Meeting
3)  20 Jun 2024 14:00 GMT-0000
Tiki Roundtable Meeting
4)  18 Jul 2024 14:00 GMT-0000
Tiki Roundtable Meeting
5)  15 Aug 2024 14:00 GMT-0000
Tiki Roundtable Meeting
6)  19 Sep 2024 14:00 GMT-0000
Tiki Roundtable Meeting
7) 
Tiki birthday
8)  17 Oct 2024 14:00 GMT-0000
Tiki Roundtable Meeting
9)  21 Nov 2024 14:00 GMT-0000
Tiki Roundtable Meeting
10)  19 Dec 2024 14:00 GMT-0000
Tiki Roundtable Meeting