How to manually create tango database ?
|
|
|
|---|---|
|
Dear tangoer I try to install Tango 9.2.1 on Ubuntu 14.04, after configure，make is ok except it could not create tango database in MySQL, the error message is : create_db_tables.sql': Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause so i must firstly to solve create_db_tables.sql file or MySQL configure problem( now i didn't get what cause this problem?, before install tango 8.1.2 all is ok)，then i will create tango database manually (because i don't want to rebuild tango library), but i want to know how to create tango database by using file in tango-9.2.1\cppserver\database directory? mysql version： mysql Ver 14.14 Distrib 5.5.47, for debian-linux-gnu (x86_64) using readline 6.3 Thanks |
|
|
|
|---|---|
|
|
Hi Jimmy, I am using mysql 5.6.28 and I have just try once again. I don't have problem with the create_db_tables.sql script. If you had Tango 8.1.2 running, this means that you have already a database created and configured. In such a case, you should not use the create_db.sh (calling create_db_tables.sql) but rather one of the update database script which will simply update your database to be compatible with Tango 9. look in the README file the chapter "Updating from previous Tango releases" Hoping this help Emmanuel |
|
|
|
|---|---|
|
|
Hi Manu Thanks for your reply The problem arise form It's my mysql 5.5.x restriction |