9 More Discussions You Might Find Interesting
1. Solaris
Hello,
I've just started using a Solaris machine with SunOS 5.10.
After the machine is turned on, I open a Console window and at the prompt, if I execute a pwd command, it tells me I'm at my home directory (someone configured "myuser" as default user after init).
... (2 Replies)
Discussion started by: egyassun
2 Replies
2. UNIX for Dummies Questions & Answers
Hello All,
I am writing the below unix script to email the result of a small pl sql procedure:
#!/bin/bash
ORACLE_HOME=/opt/oracle/orcts/product/9.2.0; export ORACLE_HOME
SQLPLUS=$ORACLE_HOME/bin/sqlplus
sqlplus -s user/pass@Db_instance<<EOF
set echo off
set feedback off
set pages 0... (9 Replies)
Discussion started by: Bunty bedi
9 Replies
3. Shell Programming and Scripting
Hi,
I am not too familiar with Unix scripting but I have to write code to find all the files under all the sub directories under a parent directory of unix location and move them to the corresponding Windows location.
For eg: I have \home\sreenu\Files\
Under neath this I have multiple sub... (3 Replies)
Discussion started by: raj.sreenu
3 Replies
4. 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
5. Shell Programming and Scripting
Hi everyone,
I am new to unix and bash and in need of some help.
I am writing a script that will execute a SQL query. The script runs and the SQl query runs, but I cannot figure out how to save the results as a file that can be emailed to a user. Here is my scripts thus far:
#!/bin/sh
SID=$1... (2 Replies)
Discussion started by: alpinescott
2 Replies
6. Solaris
Hi,
I've created solaris user which has both FTP and SFTP Access. Using the "ftpaccess" configuration file options "guest-root" and "restricted-uid", i can restrict the user to a specific directory. But I'm unable to restrict the user when the user is logged in using SFTP.
The aim is to... (1 Reply)
Discussion started by: sftpuser
1 Replies
7. UNIX for Dummies Questions & Answers
Hi
what is the difference between the directory named /home and the user's home directory?
can anyone plz reply?
really confuse about it!!!!!!!!
thank you (1 Reply)
Discussion started by: nokia3100
1 Replies
8. Solaris
I know I can use ufsdump to backup a full device, but can I use it to just backup specified directories within the device? If so , how? (The man pages do not mention how to do that).
If ufsdump can not do it, what are my choices?
Thank you! (5 Replies)
Discussion started by: FredSmith
5 Replies
9. HP-UX
When I try to connect to databse from HP box using the following command
sqlplus <username>@<databasename>
I get this error message:
ksh: <database name> : not found
I can connect to the database outside the UNIX box using sqlplus though.
Looks like the problem is the way HP Unix is... (4 Replies)
Discussion started by: dtonse
4 Replies
Alzabo::MySQL(3pm) User Contributed Perl Documentation Alzabo::MySQL(3pm)
NAME
Alzabo::MySQL - Alzabo and MySQL
DESCRIPTION
This documentation is about what special support Alzabo has for MySQL, as well as what is lacking.
MySQL support is based on the 3.23.* release series, with some support for features that are starting to appear in the 4.0.* releases.
Earlier versions of MySQL will probably work with Alzabo, though Alzabo cannot magically make these releases support new features like
fulltext indexes.
Indexes
o Alzabo supports the ability to specify prefixes when adding an index. Prefixes are required when attempting to index any sort of text
or blob column.
o Alzabo supports the creation of fulltext indexes and their use in SELECT and WHERE clauses. This includes the ability to get back the
score given for a match as part of a select, using the "function" or "select" methods of either table or schema objects.
Reverse Engineering
o When reverse engineering a schema, Alzabo knows that MySQL has "default defaults" for certain column types. For example, if a DATE
column is specified as NOT NULL but is not assigned a default, MySQL gives this column a default of '0000-00-00'.
Because Alzabo knows about this, it will ignore these defaults when reverse engineering an RDBMS.
o Similarly, Alzabo knows that MySQL assigns default "lengths" to many column types. For example, if given INTEGER as a column type,
MySQL will convert this to INTEGER(11) or INTEGER(10), depending on the version of MySQL being used.
Again, Alzabo ignores these lengths when reverse engineering a schema.
o All of this may lead to apparent inconsistencies when using the with the "Alzabo::Create::Schema->sync_backend" or "Alzabo::Cre-
ate::Schema->sync_backend_sql" methods. If you are using this feature from the web based schema creator, you will see that even imme-
diately after running the "sync_backend()" method, Alzabo may still think there are differences between the two schemas. This is not a
problem, as running the SQL Alzabo generates will not actually change your database.
Transactions
Alzabo will try to use transactions whenever appropriate. Unfortunately, there is no way to determine whether or not a given table
supports transactions so Alzabo simply calls DBI's "begin_work()" method, whether or not this will actually do anything.
Constraints and Foreign Keys
o Column constraints are treated as column attributes.
o Foreign key constraints are not generated when generating SQL for a MySQL schema. This will probably change in the future.
Table Types
These can be specified as a table attribute.
perl v5.8.8 2007-12-23 Alzabo::MySQL(3pm)