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.
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.
Enter the password of the above mentioned WIFE-Server-SQL-user.
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.