04-15-2002
The example in the book is a little confusing because few people would have a database in their home directory
![Smilie Smilie](https://www.unix.com/images/smilies/smile.gif)
A more practical example would be a MySQL user who has the database located in /usr/local/mysql/data and is running an application than requires mirroring...... then you might have the mirror on /mirror/mysql/data.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I have a script that needs to run under ID say "xyz". the way I do normally is to "su" to the id, enter the password of "xyz" and run the process. However, is there any way run the process under "xyz" without "su" to the ID. A person with root access would be able to run any process under any ID as... (4 Replies)
Discussion started by: ucbus
4 Replies
2. UNIX for Dummies Questions & Answers
how would i go about creatng a backup of a file everytime a script is run so that the next time it is run the old backup gets pushed back and the most recent backup is 1st.
(new)backup.1
(old)backup.2
that kind of idea?? (4 Replies)
Discussion started by: knc9233
4 Replies
3. UNIX for Dummies Questions & Answers
hi
i'm a bit stuck trying to find the correct syntax in order to run a cron job which just truncates all info from a single table in my database
i have a main database - db1
and i have a table in that database - userips
i wish to create a cron job that truncates or removes all the info... (9 Replies)
Discussion started by: wingchun22
9 Replies
4. Solaris
Hi everbody,
Can anyone let me know the resources for list of network, process, database related commands of solaris10 possibly with little bit of explanation.
Thanks in advance,
Chandra Sekhar. (1 Reply)
Discussion started by: chandoo.java
1 Replies
5. Shell Programming and Scripting
get email notification from from system when a process from XXXX user takes longer than 15 min run.Let me know the time estimation for the same.
hi ,any one please tell me , how to write a script to get email notification from system when a process from as mentioned above a xxxx user takes... (1 Reply)
Discussion started by: kirankrishna3
1 Replies
6. Shell Programming and Scripting
Hi I have a perl script where i created 3 nmap scans and the results will output to a text file. But when i run the code the first ip address gets scanned then the others after, but i want to be able to choose which ip address to scan.
Here is my code:
(`nmap -v -r 99.xxx.xxx -p... (0 Replies)
Discussion started by: kingbp
0 Replies
7. Shell Programming and Scripting
I need to run a SQL select query in Oracle database and have to capture the list of retrieved records in shell script. Also i would like to modify the query for certain condition and need to fetch it again. How can i do this?
Is there a way to have a persistent connection to oracle database... (9 Replies)
Discussion started by: vel4ever
9 Replies
8. UNIX and Linux Applications
Hi,
we currently having a issue where when we send jobs to the server for the application lawson, it is taking a very long time to complete. here are the last few lines of the database log.
2012-09-18-10.35.55.707279-240 E244403536A576 LEVEL: Warning
PID : 950492 ... (1 Reply)
Discussion started by: techy1
1 Replies
9. Shell Programming and Scripting
Thank you for taking the time to read my issue. I need to set up a script to run from a wagon wheel type toplogy where 1 server needs to query about 10 to 15 remote servers for duplicate values in a database table. If a duplicate value is found, send an email to me( or wall command to console).... (5 Replies)
Discussion started by: lutador72
5 Replies
10. HP-UX
Hi,
A database (Oracle) replication process was executed by the DBA team in one server (serverX). However, this replication process gets terminated, and there are no errors in the replication log. But there is error in the OS log files (syslog.log) :
Aug 8 16:51:47 L28dre02 sshd: subsystem... (1 Reply)
Discussion started by: anaigini45
1 Replies
LEARN ABOUT DEBIAN
grass-mesql
grass-mesql(1grass) Grass User's Manual grass-mesql(1grass)
NAME
grass-mesql - MySQL embedded driver
MySQL embedded driver MySQL embedded driver in GRASS MySQL database driver in GRASS enables GRASS to store vector attributes in MySQL
embedded database without necessity to run MySQL server.
Driver and database name
GRASS modules require 2 parameters to connect to a database. Those parameters are 'driver' and 'database'. For MySQL embedded driver the
parameter 'driver' should be set to value 'mesql'. The parameter 'database' is a full path to the directory where database tables are
stored. The best place is a directory in the mapset. The directory must be created before use of the driver. In the name of database it is
possible to use 3 variables:
$GISDBASE - path to current GISBASE
$LOCATION_NAME - name of current location
$MAPSET - name of current mapset
Examples of connection parameters:
db.connect driver=mesql database='$GISDBASE/$LOCATION_NAME/$MAPSET/mysql'
db.connect driver=mesql database=/home/user1/db
Data types, indexes
For more informations about supported data types and indexes see the documentation for MySQL (mysql) driver
Database type
Because database closing was found very slow if InnoDB was used, the InnoDB storage is disabled by default (hardcoded '--skip-innodb'
server option).
Note
The embedded server is started with hardcoded '--bootstrap' option to avoid warning about missing mysql.time_zone_leap_second table. This
can be fixed in future.
SEE ALSO
db.connect, SQL support in GRASS GIS
Credits
Development of the driver was sponsored by Faunalia (Italy) as part of a project for ATAC.
AUTHOR
Radim Blazek
Last changed: $Date: 2011-02-07 18:59:50 +0100 (Mon, 07 Feb 2011) $
Help Index
GRASS 6.4.2 grass-mesql(1grass)