Create a new database

This chapter describes how to create a new database

• Entryname: Write in the name of your entry as you would like it to appear in the list of databases available to you. For example, the demo database in the list is called "demo" but the actual database name is "lcamediabase_demo".
  
  
• Database Type: LCAMediabase supports two database engines: MySQL and SQLite.
  To use a MySQL database you need to have access to a MySQL database server (either running on your computer or accessible through a network connection).
  MySQL is recommended for professional use; most users will select SQLite.
  If you select SQLite then skip to 'Description'.
  
  
• Host: If the MySQL server that you use is in your local computer, then enter 'localhost' here. If your MySQL server is on a remote computer in your network, then enter the IP address of that computer.
  
  
• Database Name: Enter the name of the database that you are creating.
  Note 1: If the database does not yet exist then make sure you have the permission to create a database. It is advisable to check with your database administrator if this applies to your situation.
  Note 2: If the (empty) database has already been created, then make sure you have permission to create tables
  
  
• Login: Enter your user name. (optional)
  
  
• Password: Enter your password. (optional)
  
  
• Login prompt: Place a check mark in the box if you require a password but do not wish to save it. Each time you log in you will be prompted for the login name and password. If you do not place a check mark in this box your password will be saved to disk.
  
  
• Connection type: If your MySQL server runs on your local machine and you are using Windows NT,2000 or XP, then you can use 'Named Pipe' for the connection type. "Named Pipe" is somewhat faster and more reliable. "Named Pipe" should also be used if the IP network protocol is not installed.
  
  

• Description: Write a short line that describes the database (optional).
  
  
• Thumbnail Size: If you are going to store images or movies, enter the size of the 'thumbs' that are stored in the database. The value is in pixels and should be between 20 and 300.
  
  
• Thumbnail JPEG quality: The thumbs are compressed into Jpeg images before they are stored in the database. This number determines the image quality of the thumb. The amount of space required is determined by the percentage number i.e. the smaller the percentage number, the smaller the amount of disk space required.
  
  
• Maintain Dictionary: Place a check mark here if you want to maintain a dictionary. The dictionnary will include all words in the text fields for the items and keywords in the database. The purpose of the dictionary is to provide you with a list of words contained within the database. Do not use this option if you plan to store large amounts of text in the database.
  Note: Only words of four letters and longer are stored.
  
  
• Allow digits in dictionary words: Place a check mark here if you want to search for numbers in the text fields.
  
  
• Exact Filenames: Some filing systems such as "LINUX" and most Webservers discriminate between upper and lower case in filenames.>br> Place a check mark here if you use such a filing system to store files.