Re: error while importing database
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