02-20-2002
Unix and databases
I had a person ask me if a Sql database can be run with Unix? I don't know can this be done? They only have Sql dba's and no oracle dba but want to use a Unix box????
8 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I have been asked to use ASP on UNIX and I have no idea what the limitations are. I have pages using ASP on NT with SQL7, is there an easy transition for my current pages to work on UNIX? Any help is much appreciated. THX (5 Replies)
Discussion started by: dkropolis
5 Replies
2. Cybersecurity
Help!
SCO Unix 5.05.
A relatievely new system went down on me today. I got the dreaded error:
Out of Space on Device (1/42).
I was able to clear up some space in the /tmp directory, however, when I try to boot, the system prompts me to go into single user mode and I get the... (2 Replies)
Discussion started by: gseyforth
2 Replies
3. UNIX for Dummies Questions & Answers
I want to check which databases are installed on my FreeBSD installation. This is what I did: pkg_info | grep mysql
How do I check all in one go whether also sqlite, postgresql, firebird is installed?
Thanks in advance (3 Replies)
Discussion started by: figaro
3 Replies
4. Solaris
I am facing problems with SVM installed on vmware workstation on intel platform. I have created replicas and a mirror volume using unmountable slices. But when I reboot my hardware I am not able to execute any SVM cmd's getting an error "there are no existing databases."
Below are o/p's of few... (0 Replies)
Discussion started by: rahul_11d
0 Replies
5. Shell Programming and Scripting
Hello,
I have two databases one is student_Name and another is student_Name1...Two tabled contain 200 records each..I found that near 30 names are entered in both databases..I would like to remove the duplicates..and i have to keep the name which is newly added..Please hepl how to remove... (7 Replies)
Discussion started by: Anjali_vee
7 Replies
6. UNIX for Dummies Questions & Answers
How can we compare query results from different databases using Unix diff command from command-line in Ab Initio tool? (1 Reply)
Discussion started by: eshalife
1 Replies
7. Shell Programming and Scripting
Hi Everyone,
I am new to DBA stuff. I wonder if anyone can help me. Task is that, I have 10 databases and need to take backups of all the databases using data pump in Unix/Linux, compress them using gzip and use cron to schedule the job twice a day.
Appreciate if anyone can help me in... (1 Reply)
Discussion started by: sreepriya0987
1 Replies
8. Programming
Hello all again,
How do you guys backup your MySQL databases?
I have a few programs that have an default back up that make an .sql file which is great but I also use OpenX which runs on PHP and has a database. That does not have an auto-back-up feature so do I just download the... (2 Replies)
Discussion started by: AimyThomas
2 Replies
LEARN ABOUT DEBIAN
rt-setup-database-4
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)