7.5

Create a New Search Profile that Uses a MySQL Database
This procedure describes how to create a search profile that uses an MySQL database.
Pre-Requisites for MySQL database connectivity:
l A MySQL driver must be installed on the system (available on MySQL.com)
l The currently logged on user must have access to the MySQLserver through the network.
l A database must be created on the MySQLserver. It is suggested to call the database Search.
l Ausername and password must be defined in the user options and this username must have access to the
MySQLserver and full privileges on the Search database (see Set User Options).
To create a new search profile that references a MySQLserver database:
1. In PlanetPress Search, choose File | New | MySQL Profile.
2. In the Server name dialog, type in the server name or IPAddress of your MySQLserver, then click OK.
3. In the Database name dialog, type in the name of the database to be used, then click OK.
PlanetPress Search will now attempt to logon to the server and database specified.
4. If the connection is successful, a Save As dialog appears. Use this dialog to save the Search Profile file to a specific loca-
tion on the hard drive. While a network path or mapped drive can be typed in manually in this dialog, it is strongly rec-
ommended to use a search profile on a local drive, for performance reasons.
PlanetPress Search, when opened, will automatically load the default search profile (ppsearch.prf)located in
C:\Documents and Settings\(current login username)\Application Data\Objectif
Lune\PlanetPress Suite X\PlanetPress Search\ . If the search profile is located somewhere
else, it will need to be opened manually each time PlanetPress Search is opened.
Once your profile is created, additional actions may be done on the profile:
l To share a profile on the network between multiple users, see Sharing A Profile On The Network.
l To edit the profile manually to change additional options, see Search Profile Contents Line by Line.
Build the Contents of a Database for the First Time
The procedure here describes how to build the contents of a database for the first time. You also use this procedure if you
want to modify the list of archive folders an existing database includes.
The procedure assumes the search profile that references the database you want to build is loaded in PlanetPress Search and
permits rebuilds of its database. In a network installation, it is common for the administrator to control database updates. See
"Database Considerations in a Network Installation" (page 42).
To build the contents of a database for the first time:
1. If necessary, choose Options | User Options, click Databaseoptions, and adjust the settings for the database. In
particular, you may want to adjust the Unattended database creation/update option. See "Set User Options" (page 15).
2. Choose Options | Set Search Folders and use the Search Folders Configuration dialog box that appears to select
the PlanetPress Image archive folders to include in the database.
Note that in a network installation, you should verify that each folder you include is accessible to all users of this search
profile. If a folder is not accessible, users cannot view any search result that references a PDF in that folder.
Search Profiles And Databases
©2010 Objectif Lune Inc - 22 -