|
| Create a database It is recommended that Aanval be installed in its own database, however if the need arises Aanval can be installed in an existing database. (Aanval tables are prefixed with "ids") Three options for creating MySQL databases are shown here. Option A Using the MySQL administrative tools, the following command will create the database named "aanvaldb": "mysqladmin create aanvaldb" Option B Login to your mysql command line client and issue the following command to create the database named "aanvaldb": "create database aanvaldb;" Option C If you use a web-based system management tool such as PLESK, CPANEL, phpMyAdmin or Webmin then please follow the instructions available for these tools to correctly create your database. *Note: After creating an Aanval database, you may need to modify or provide permissions. Change Aanval database settings Aanval uses a standard PHP based configuration file (conf.php) to store the console path and required database credentials using a $name = "value"; variable syntax. Aanval database and path information is stored at the following location (default): /path/to/aanval/conf/conf.php Please use caution when modifying console settings within this file as the contents are highly syntax sensitive. Database listing Once you have successfully connected to MySQL at the command prompt, the following command will provide a list of available databases: "show databases;" You may select any of the listed databases with the following command: "use dbname;" Table listing Once you have successfully connected to MySQL at the command prompt and have selected a database to use, the following command will provide a list of available tables: "show tables;" Delete a database The following instructions will permanently delete an MySQL database and care should be taken to ensure you exactly what you are doing. This action is not reversible. This document demonstrates two options for deleting / dropping an MySQL database. Option A Using the MySQL administrative tools, the following command will delete the database named "aanvaldb": "mysqladmin drop aanvaldb" Option B Login to your mysql command line client and issue the following command to delete the database named "aanvaldb": "drop database aanvaldb;" Logos and trademarks are property of their respective owners. |
