Sanav GC-101 Manuel d'installation télécharger pdf (Page 27)

7.4) General Database Administrative Functions

The command "dbAdmin.pl" (only available as a Perl script) can perform various administrative functions on the SQL

database (Note: the command 'bin\dbConfig.bat' is provided for Windows users, and performs a subset of the

operations available to the "dbAdmin.pl" command). Here are a few of the functions that can be performed using the

"dbAdmin.pl" command:

Verify/Update table columns:

/usr/local/OpenGTS_1.2.3> bin/dbAdmin.pl -tables

This command will check the column configuration of all OpenGTS tables and report on any missing columns, or other

anomolies. If an OpenGTS table does not exist, it will be created.

/usr/local/OpenGTS_1.2.3> bin/dbAdmin.pl -tables=c

When upgrading to a newer version of OpenGTS in which new columns have been added to various tables, the above

command will issue the required "ALTER TABLE" commands to the tables as required in order to add any new table

columns. If a specific column 'type' has changed, using "-tables=ca" will cause column types to be altered.

/usr/local/OpenGTS_1.2.3> bin/dbAdmin.pl -tables=ca

Or, on Windows:

C:\OpenGTS_1.2.3> bin\dbConfig.bat -tables:ca

This command should be used whenever upgrading to a newer version of OpenGTS.

Dump tables to disk:

/usr/local/OpenGTS_1.2.3> bin/dbAdmin.pl -dump -dir=/tmp/gts

This command will dump all OpenGTS tables to the directory specified by the "-dir" argument ("/tmp/gts" is the

default destination if the "-dir" option is not specified). If required by your MySQL installation, you may also need to

specify the database root user (ie. as in "-rootUser=<user>"). Individual tables can then later be reloaded with the "-

load=<table>" option.

(Note for Linux users: On some versions of Linux which employ SELinux, you may receive an error indicating that

MySQL is not allowed to write into the specified directory. In these cases, you may need to either specify a directory

that MySQL is allowed to write to, or change the SELinux security settings to provide MySQL with authorization to write

to the "/tmp" directory.)

Load tables from Disk:

/usr/local/OpenGTS_1.2.3> bin/dbAdmin.pl -load=<table> -dir=/tmp/gts

This command will load the specified table from the file previously created by the "-dump" argument. During the table

load, columns are matched where possible. If a column is present in the 'dumped' file, but has been removed in the

current GTS table, a warning will be generated that the column has been dropped. This command is useful when small

table changes need to be made in the column structure. [Note: the square brackets specified above indicate that the

option within the brackets is optional. The square brackets should not be specified literally on the command-line if the

optional argument within the brackets is used].

OpenGTS Configuration and Installation Manual Page 27 of 60

1 2 ... 22 23 24 25 26 27 28 29 30 31 32 ... 59 60

Pas de commentaire

Sanav GC-101 Manuel d'installation Page 27