Download SmartForm User Manual_new

Transcript
SmartForm User Manual 1.1
2:
Installation of the SmartForm Database
This section covers installation of the database, assuming that the database has been
successfully downloaded from www.betwise.co.uk
Notes on installing MySQL are also provided when the database is downloaded. If you
have followed the installation process from the website, you can ignore this section.
Email support on database installation is also available at www.betwise.co.uk/contact.
This section therefore provides a summary of the installation process.
Installing on Windows
1. Install mysql at www.mysql.com/downloads Choose Community Edition (the free
download) and the correct version for your operating system.
2. Create a Smartform database, for example:
a) Type the following to log into the mysql monitor at the command prompt ( > below):
>mysql –u root –p
b) You should now enter your password, provided that one was set up during the
installation of MySQL
>Enter password:
Whereupon you will successfully be logged in
Welcome to the MySQL monitor.
Commands end with ; or \g.
c) Next, set up the database access as follows:
>CREATE DATABASE smartform;
Then, grant access to your user name for the Smartform database.
>GRANT ALL ON smartform.* TO ‘your_account_name’@’localhost’;
Log off from the MySQL monitor to return to the shell prompt:
>exit;
3.
Download the smartform data, extracted to the C:\Smartform directory and load it into
the database. Step 4 explains how.
4. Provided that the database download file has been unzipped to smartform.ql, building
the database can be done from the command line as follows:
Copyright Betwise Limited 2008.
5