FeedZcollector Support

How can I configure FeedZcollector for a MySQL database?

1. 
   
2. Install FeedZcollector on your Windows PC or server.
   
3. Be sure that you have ‘administrator’ access to a MySQL server.
   
4. Open the folder where FeedZcollector is installed. The default folder is c:/Program Files/FeedZcollector.
   
5. Run the script ‘FeedZcollector.sql’ on this server. A new database named ‘FeedZcollector’ will be created. The database contains the tables ‘Feeds’, ‘Items’ and ‘Enclosures’.
   
6. Open the file ‘fcs.exe.config’ in the resources directory.
   This directory is located at c:/Program Files/FeedZcollector/Resources/.
   
7. Comment out the line containing the MS Access Database connection string (line 5).
   
8. Remove the substrings '<!--' at the beginning, and '-->' at the end of the line containing the MySQL Database connection string (line 6).
   
9. Change the value of the key ‘Database’ to ‘MySQL’.
   
10. Change the value of the key ‘Connectionstring’. It already contains a MySQL database connection string example.
    Only three parameters have to be changed before FeedZcollector can gain access to the database
    
    1. 
       
    2. SERVER=[Hostname]: Replace '[Hostname]' by the name or the ip-address of the server where the MySQL database is hosted
       
    3. UID=root: Replace 'root' by a string containing the name of the MySQL account that gives access to the database
       
    4. PASSWORD=: Fill in the string containing the appropriate password
       
    5. Leave the rest as it is.
       
    
    
11. Save and close the configuration file.
    
12. Restart FeedZcollector using the FeedZcollector administrator. If correctly configured, the icon in the system tray should turn 'green'. Otherwise it stays ‘red’.
    

Related support information:
» Where can I download the default config file (fcs.exe.config)?