Initialize the database
Before you can connect to your database from a CLC Workbench or Server it must be initialized. The initialization creates the required tables for holding objects, and prepares an index used for searching. Initialization is performed with the CLC Bioinformatics Database Tool (see figure 2.1).
Figure 2.1: The CLC Bioinformatics Database tool
- Download the CLC Bioinformatics Database Tool from http://www.clcbio.com/products/clc-bioinformatics-database-tool-direct-download/
- Install the CLC Bioinformatics Database Tool on a client machine, and start the program.
- Fill in the fields with the required information.
- Hostname: The fully-qualified hostname of the server running the database.
NOTE: The same hostname must be used every time you connect to the database - Port: The TCP/IP listening port on the database server
- Database name: The name of the database you created in the previous section
- Username: the name of the user/role you created in the previous section
- Password: the password for the user/role.
- Hostname: The fully-qualified hostname of the server running the database.
- To re-initializing an existing CLC database you must check the "Delete Existing..." checkbox.
NOTE: ANY DATA ALREADY STORED IN THE CLC DATABASE WILL BE DELETED. - Click the Initialize Database button to start the process.
While the program is working the progress-bar will show the status and the transcript will show a log of actions, events and problems. If anything goes wrong, please consult the transcript for more information. If you need assistance, please contact support@clcbio.com, and include the contents of transcript.
If the initialization is successful, the status bar will display this message: Database successfully initialized. You can now close the CLC Bioinformatics Database Tool.