Support for mysql dropped in FDSE version 2.0.0.0064
As of FDSE version 2.0.0.0064, the "mysql" data storage option is no longer supported.
Options for mysql users
If you are currently using FDSE version 2.0.0.0063 or older with the "mysql" data storage option, here are your options:
Continue using mysql with your current version of FDSE. You will not be able to upgrade past 0063, but you may continue using your current configuration indefinitely.
If you had already upgraded past build 0064, and then discovered that mysql was no longer supported, then I'm terribly sorry for the inconvenience. You will need to downgrade to your previous build to continue with mysql.
You may migrate your mysql data to the text format, by going to Admin Page => Data Storage => Migrate. (You will need to take this action in your old version of FDSE.)
Once migrated, you should change your data storage option from mysql to text. Then, upgrade to the latest version of FDSE.
You may also choose to perform a clean install of the latest version of FDSE. You will need to re-customize your settings and re-define your search indexes when performing a clean install. In most cases, these steps only take a few minutes.
I regret any inconvenience to mysql users. As always, I will gladly assist by performing the data migration and upgrades for you if you wish. And, if you feel FDSE no longer meets your needs without mysql, I will gladly provide a full refund to you.
Reasons for this change
Support for mysql data storage was added in FDSE version 2.0.0.0023, in November 2000. This functionality was experimental. After several months of testing and attempts at refinement, it was concluded that mysql could not be made to work with FDSE in the same way that text files were used. mysql is a relational database and is only powerful when used as a relational database. When a mysql table is used as a simple replacement for a multi-column text file, the text file will always be faster and more straight-forward to use. This is particularly true when using Perl, which has been optimized for scanning text files.
The mysql code was too slow to be of value. In retrospect, it should have been removed immediately. However, several users developed an attachment to the mysql data storage option and requested that it remain. It was kept for reverse compatibility, though new users were advised to not use it. Starting with version 2.0.0.0054 in June 2002, all copies of FDSE included the text: "Note: all mysql code will be removed from FDSE in an upcoming future release. Please use the file system storage method instead (which is the default configuration.) In the far future, the mysql code may be re-written and added back in, but in the meantime the current mysql code is slower and has many bugs."
Though mysql remained in the product, the speed issues were never addressed. As bugs were fixed and new features added to FDSE over the years, only the code paths related to text data storage were updated. Thus, the mysql code paths became less and less functional. Support for mysql continued to generate support traffic in terms of bug reports and help requests. It also cost some new users in frustration and lost time. In addition, having the support for mysql, even though it wasn't used, increased the FDSE admin code footprint by about 25%.
During the development of build 0064, a user requested help with mysql data storage. A brief inquiry revealed just how fundamentally non-functional the mysql code had become, prompting its long overdue removal from the product.
"Support for mysql dropped in FDSE version 2.0.0.0064" https://www.xav.com/scripts/search/help/1188.html