Hello,
I use ClearOs with autoupdate on since 2 or 3 years to publish a Tiki website (and do demos).
My workflow is the following; I setup my configuration on a Tiki software on my local MAMP => mysqldump of the database => copy to the server => mysql < database.
It worked flawlessly a hundred of times.
Since a few days (48h I’m trying) this is not working anymore and I have an error on importing on the ClearOs database server side.
(creation of the first table)
I googled and check basic things like if my database source was innoDB, the default was innoDB, etc.
Seems that everything is ok on the source side and working fine.
I found this : https://dev.mysql.com/doc/refman/5.5/en/fulltext-restrictions.html
What could have changed ?
Can I upgrade my ClearOs mysql version above 5.6?
Bernard
I use ClearOs with autoupdate on since 2 or 3 years to publish a Tiki website (and do demos).
My workflow is the following; I setup my configuration on a Tiki software on my local MAMP => mysqldump of the database => copy to the server => mysql < database.
It worked flawlessly a hundred of times.
Since a few days (48h I’m trying) this is not working anymore and I have an error on importing on the ClearOs database server side.
ERROR 1214 (HY000) at line 25: The used table type doesn't support FULLTEXT indexes(creation of the first table)
I googled and check basic things like if my database source was innoDB, the default was innoDB, etc.
Seems that everything is ok on the source side and working fine.
I found this : https://dev.mysql.com/doc/refman/5.5/en/fulltext-restrictions.html
Full-text searches are supported for MyISAM tables only. (In MySQL 5.6 and up, they can also be used with InnoDB tables.)
What could have changed ?
Can I upgrade my ClearOs mysql version above 5.6?
Bernard
In MySQL Server
Share this post:
Accepted Answer
Assuming you are using ClearOS7, in reality it uses MariaDB and not MySQL so you'll need to upgrade to MariaDB 10+. There are plenty of references on the internet for Centos such as https://www.tecmint.com/install-mariadb-in-centos-7/ and these should be applicable to ClearOS. I have not heard other people doing this in ClearOS, but I would assume it works.
There is no upgrade route directly in ClearOS using ClearOS repos.
There is no upgrade route directly in ClearOS using ClearOS repos.
Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here.
Register Here »