farmerswife

Welcome
Login  Sign up

MySQL settings

The WIFE Server can create an assortment of typically used data within MySQL 5.0 (or later), as an interface to the data stored within WIFE’s own proprietary database.

To properly use it contact farmerswife Support and be prepared to first build and test it in a separate test environment, as well as reading all details in the separate MySQL_Info manual.

  • Use MySQL

Select Yes to enable this feature.

  • Bidirectional

By default this setting is disabled. By enabling it, the MySQL interface can be used to manipulate data within the WIFE System.

Please note that enabling Bidirectional can result in database corruption.

  • Use UTF-8 Encoding

Set this to Yes when data in WIFE is entered in a different language than English; e.g. if you depend on having non-standard characters (e.g. å, ä, æ, etc.) to be correctly displayed in the SQL-dump result. Using this feature will slowdown a FULL dump.

  • User Name

Enter here the user name to be used by the WIFE Server to authenticate with your MySQL Server. This user requires read, write and create database permission in MySQL.

  • Password

Enter the password of the above mentioned WIFE-Server-SQL-user.

  • Port

The default value “3306” is the “default SQL Port”; verify if your MySQL Server is set to use the same.

  • Database Name

Enter here the name of the MySQL-database the WIFE Server is to create and/or use in your local MySQL installation.

  • Database Host name/ip

Enter here the “path” to where your MySQL server is hosted. For example if it’s running on the same machine as the WIFE Server you can use the static local IP or the local host IP 127.0.0.1.

Please see attached manuals for more details.

Did you find it helpful? Yes No