03-08-2008
I would first try:
pkg_info | grep -i sql
The -i switch will ignore case-sensitive strings (I hope that is correct).
If it does return, example mysql, you can try:
(as root)
find / -name mysql
This should at least tell where mysql has install example: /usr/mysql/somedatabase
and to connect to your mysql database, check to see if mysql is in the $PATH
which mysql # if not add it to your permissions.
Another tool to use and enginneer your database is
Mysql Query Browser
I hope this helps.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
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???? (1 Reply)
Discussion started by: tyranunn
1 Replies
2. Shell Programming and Scripting
I currently use this construction to check whether a certain program is installed:
if ; then
cd /usr/ports/databases/sqlite3 && make install clean
else
echo "sqlite already installed"
fi
Is this method recommended? Is this an effective method, ie sufficiently robust for... (3 Replies)
Discussion started by: figaro
3 Replies
3. Shell Programming and Scripting
Hi,
I am new to linux, and i want to know which mysql dbd is installed on linux,
what is the command to check this.
bash-2.05$ uname -a
Linux SURINT01 2.4.7-10 #1 Thu Sep 6 17:27:27 EDT 2001 i686 unknown
Thanks
Prakash GR (6 Replies)
Discussion started by: prakash.gr
6 Replies
4. AIX
Hello everyone:
I've installed an OS patch into AIX 6.1 by running the following command:
instfix -d /tmp/6100-02-03 -k "IZ41855"
however it seem not installed
instfix -i -k "IZ41855"
There was no data for IZ41855 in the fix database.
what am I doing wrong? (8 Replies)
Discussion started by: edgarvm
8 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. Red Hat
Hey there,
i run 1: on my server (RHEL 6) and getting response that the libodbc is not installed. If i use yum for installation, it tells me, there is no package like this ( 2: ). Since in the description of Definiens is mentioned that the Run-time dependency is unixODBC (libodbc.so.1), I assume... (2 Replies)
Discussion started by: rkirsten
2 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. SCO
Hi, (i'm sorry for my english)
I'm a problem on boot sco unix 5.0.5 open server.
this stop at "Checking protected password and checking subsystem databases"
(See this image )
I'm try this:
1) http://www.digipedia.pl/usenet/thread/50/37093/#post37094
2) SCO: SCO Unix - Server hangs... (9 Replies)
Discussion started by: buji
9 Replies
9. 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
10. UNIX for Beginners Questions & Answers
Hello Forum,
I'm issuing a one line bash command to look for the version of an installed application and saving the result to a variable like so:
APP=application --version
But if the application is not installed I want to return to my variable that the Application is not installed. So I'm... (2 Replies)
Discussion started by: greavette
2 Replies
LEARN ABOUT DEBIAN
cyrus-ctl_cyrusdb
CTL_CYRUSDB(8) System Manager's Manual CTL_CYRUSDB(8)
*
NAME
ctl_cyrusdb - perform operations common to all Cyrus databases
SYNOPSIS
ctl_cyrusdb [ -C config-file ] -r [ -x ]
ctl_cyrusdb [ -C config-file ] -c
DESCRIPTION
Ctl_cyrusdb is used to perform various administrative operations on the Cyrus databases.
Ctl_cyrusdb reads its configuration options out of the imapd.conf(5) file unless specified otherwise by -C. The configdirectory option is
used to determine the default location of the Cyrus databases.
OPTIONS
-C config-file
Read configuration options from config-file.
-r Recover the databases after an application or system failure. Also performs database cleanup like removing mailbox reservations
(and any associated mailbox files).
All mailbox files are also checked to make sure the file format matches the configured database type in imapd.conf. If not, the
file is automatically converted using the same logic as cvt_cyrusdb.
-x Used with -r to recover the database only. (Prevents database cleanup).
-c Checkpoint and archive the databases. Changes to the database which are part of committed transactions are written to disk. Also,
a hot backup of the databases is made and inactive log files are removed.
FILES
/etc/imapd.conf
SEE ALSO
imapd.conf(5), cyrmaster(8)
CMU
Project Cyrus CTL_CYRUSDB(8)