Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

rt-setup-database-4(8) [debian man page]

rt-setup-database(8)					     Request Tracker Reference					      rt-setup-database(8)

NAME
rt-setup-database - Set-up the database for Request Tracker SYNOPSIS
rt-setup-database --action ... OPTIONS
action Several actions can be combined using comma separated list. init Initialize the database. This is combination of multiple actions listed below. Create DB, schema, setup acl, insert core data and initial data. upgrade Apply all needed schema/acl/content updates (will ask for version to upgrade from) create Create the database. drop Drop the database. This will ERASE ALL YOUR DATA. schema Initialize only the database schema To use a local or supplementary datafile, specify it using the '--datadir' option below. acl Initialize only the database ACLs To use a local or supplementary datafile, specify it using the '--datadir' option below. coredata Insert data into RT's database. This data is required for normal functioning of any RT instance. insert Insert data into RT's database. By default, will use RT's installation data. To use a local or supplementary datafile, specify it using the '--datafile' option below. datafile file path of the data you want to action on e.g. "--datafile /path/to/datafile" datadir Used to specify a path to find the local database schema and acls to be installed. e.g. "--datadir /path/to/" dba dba's username dba-password dba's password prompt-for-dba-password Ask for the database administrator's password interactively skip-create for 'init': skip creating the database and the user account, so we don't need administrator privileges root-password-file for 'init' and 'insert': rather than using the default administrative password for RT's "root" user, use the password in this file. perl v5.14.2 2013-05-22 rt-setup-database(8)

Check Out this Related Man Page

mysql_import_combined_log.pl(1) 			      General Commands Manual				   mysql_import_combined_log.pl(1)

NAME
mysql_import_combined_log.pl - Imports an Apache combined log into a MySQL database. SYNOPSIS
mysql_import_combined_log.pl -d <database name> -t <table name> [-h <host name>] [-u <user name>] [-p <password>] [-f <filename>] OPTIONS
--host|-h <host name> The host to connect to. Default is localhost. --database|-d <database name> The database to use. Required. --username|-u <username> The user to connect as. --password|-p <password> The user's password. --table|-t <table name> The name of the table in which to insert data. --logfile|-f <file name> The file to read from. If not given, data is read from stdin. --help|-? Print out this help message. --version Print out the version of this software. AUTHOR
Aaron Jenson Updated to work under Perl 5.6.1 by Edward Rudd MAN PAGE CREATED BY
Michael A. Toth <lirul.lists@gmail.com> - based on content of script COMMENTS
This man page was written using xml2man (1) by the same author. Manuals User mysql_import_combined_log.pl(1)
Man Page

15 More Discussions You Might Find Interesting

1. Solaris

file wont remove

check this out ls -l nmo* -rwsr-s--- 1 root dba 19312 Mar 31 14:44 nmo -rw-r----- 1 oracle dba 0 May 19 2004 nmo0 -rwxr-x--- 1 oracle dba 16512 Mar 31 14:44 nmocat # rm nmo0 nmo0: No such file or directory # id uid=0(root) gid=1(other) what... (8 Replies)
Discussion started by: csaunders
8 Replies

2. UNIX for Dummies Questions & Answers

awk to find the status and send an email

Hi, I have a datafile which has the following data and it can have much more records. The data set is as follows: ISA~00~ ~00~ ~ZZ~F159B ~ZZ~U1CAD ~051215~184 3~U~00200~000011432~0~P~< GS~FA~TC11A~U1CAD~051215~1843~000011432~X~002002 ST~997~0001... (6 Replies)
Discussion started by: isingh786
6 Replies

3. UNIX for Dummies Questions & Answers

Sed questions-Please Help

I am using this command to replace a text string in a data file: sed -e 's/ab/test2/g' -e 's/abcxyz/test1/g' datafile datafile contains: ab abcxyz My results: test2 test2cxyz I want my results to be: test2 test1 (7 Replies)
Discussion started by: bobo
7 Replies

4. UNIX for Advanced & Expert Users

How do we know which processis creating a datafile

Hi, Is there any way we can find out which process is creating a partucular datafile.I know the user and group but i am just curios to know is there any way to find the process. Thanks (7 Replies)
Discussion started by: ukatru
7 Replies

5. Windows & DOS: Issues & Discussions

How to Recover windows administrator password?

HI, Can anybody tell me..about recovering windows administrator password in case of Forget it. Now in Unix OS and any database,there is a fascility of recovering root/admin password.... Can window provide any such kind of fascility?....Also tell me any other normal users password recovery... (5 Replies)
Discussion started by: jagdish.machhi@
5 Replies

6. Shell Programming and Scripting

To Read a File and Insert a part of the lines into the database

Hi Guys I need to have a shell script which reads a log file and insert a part of each line into the database. Some sample lines in the file are as below. 20091112091359 MED_RQACK : user_data=60173054304,100232120,20091112091359,;ask_status=0;ask_reason=OK;msg_id=20091112091319... (5 Replies)
Discussion started by: Somanadh
5 Replies

7. UNIX for Advanced & Expert Users

Solution for the Massive Comparison Operation

Hi We have 50 million records in mainframes DB2. We have a requirement to Record the Change Data Capture(CDC) records. i.e New Records or Updated Records that were added into the DB2. Unfortunately we dont have any column indicators to give the details of the changes made to the records. ... (8 Replies)
Discussion started by: raghav288
8 Replies

8. UNIX for Advanced & Expert Users

RINT -----

Hi, on AIX 6.1 I have : -rwx------ 1 oracle dba 1263 Dec 8 02:43 initMYDB.ora -rwx------ 1 oracle dba 1263 Dec 16 10:44 initOURDB.ora RINT------ 1 oracle dba 1263 Dec 16 10:42 initMYDB.ora I havr never seen RINT------ Do you know... (14 Replies)
Discussion started by: big123456
14 Replies

9. Shell Programming and Scripting

Format Fields

I have a CSV file like this: abc ,def ghi ,jkl mno ,pqr stu ,vwx Desired Output: Field 1: abc mno Field 2: def ghi pqr stu Field 3: jkl vwx This does not work: for i in `cat file.txt` do Field1=`echo $i | awk -F ',' '{print $1}'| sed 's/^ *// ; s/ *$//'`... (8 Replies)
Discussion started by: shellguy
8 Replies

10. Shell Programming and Scripting

Help with datafile parsing and creating spreadsheet

I have a datafile containing data in the following format name1,employee_number1,cell1,home1,fax1 name2,employee_number2,cell2,home2,fax2 name3,employee_number3,cell3,home3,fax3 name4,employee_number4,cell4,home4,fax4 name5,employee_number5,cell5,home5,fax5 ... ... .... I would like... (6 Replies)
Discussion started by: inditopgun
6 Replies

11. UNIX for Dummies Questions & Answers

How to convert relative path to absolute path?

Hello Everyone, I want to convert Relative Path - /home/stevin/data/APP_SERVICE/../datafile.txt to Absolute Path - /home/stevin/data/datafile.txt Is there a built-in tool in Unix to do this or any good ideas as to how can I implement this. -Steve (5 Replies)
Discussion started by: qwarentine
5 Replies

12. Shell Programming and Scripting

Insert value to db from text file

Hi, I have a single value in insertval file. I want to load that value to database with the current date. I tried the below code but it is inserting <NULL> to database and echo $c is also null. cat insertval | awk -F ' ' '{print $1}' > c echo c=$c data=`sqlplus -s user/pwd@hostname <<EOF ... (5 Replies)
Discussion started by: Neethu
5 Replies

13. UNIX for Advanced & Expert Users

Using xml to run db2 commands

Hi, Strange problem I'm having here and not sure what to do. I have here a xml that is supposed to execute the next value in the schema but it isn't do the job it's supposed to do. I'm not a dba or a developer so I'm sorry in advance if there are some things i don't understand. when we run... (5 Replies)
Discussion started by: techy1
5 Replies

14. Web Development

Web Interface for a database

Hi Gents, What is the best way to create a web interface for mysql database? That I can manage my data for root user and for normal user as well according to their privileges? Assuming that I use Linux as a server and Apache as a web server and my database is mysql. Thanks in advance (5 Replies)
Discussion started by: leo_ultra_leo
5 Replies

15. Programming

Help writing SQL query

Hello All, I hope I'm posting this in the right section. I have zero sql query writing skill, in fact, I've never done it before, but for some reason, a request came across my desk to get information from one of our databases. I have about 200 ticket numbers that have no information attached,... (8 Replies)
Discussion started by: bbbngowc
8 Replies