Sybase Adaptive Server Anywhere for Linux HOWTO
| Revision History | ||
|---|---|---|
| Revision 1.0 | 2001-04-26 | Revised by: al |
| First public release. | ||
- Table of Contents
- 1. Introduction
- 1.1. New versions of this document
- 1.2. Content and Audience
- 1.3. Adaptive Server Anywhere features
- 1.4. Quirks
- 1.4.1. Alt and Function keys
- 1.5. What's a Relational Database?
- 1.5.1. Definition
- 1.5.2. Example
- 1.5.3. Primary and Foreign Keys
- 2. Requirements
- 3. Installation
- 4. Creating, Running and Connecting to Databases
- 4.1. Creating a database
- 4.2. Running a database server and starting databases
- 4.3. Stopping the database server
- 4.4. Stopping databases
- 4.5. Connecting to a database
- 4.5.1. Connection strings
- 4.5.2. Connecting from Interactive SQL
- 4.5.3. Connecting via ODBC
- 4.5.3.1. Setting up ODBC with Adaptive Server Anywhere
- 4.5.3.2. About ODBC data sources
- 4.5.3.3. Connecting to an ODBC data source
- 5. Backing up and Restoring a Database
- 5.1. Creating a Backup of the Database
- 5.1.1. Full vs. Incremental Backups
- 5.1.2. Online vs. Offline Backups
- 5.1.3. Server-side vs. Client-side Backups
- 5.1.4. How to make a backup
- 5.1.4.1. From the command line
- 5.1.4.2. From SQL
- 5.1.4.3. From Sybase Central
- 5.2. Validating the database and its backup
- 5.3. Recovering the database
- 6. Managing a Database
- 6.1. Tables
- 6.1.1. Creating a Table
- 6.1.2. Making Alterations to Tables
- 6.2. Users, permissions, and authorities
- 6.2.1. User IDs
- 6.2.1.1. Special user IDs
- 6.2.1.2. Creating new user IDs
- 6.2.2. Permissions
- 6.2.3. Authorities
- 6.2.3.1. RESOURCE authority
- 6.2.3.2. DBA authority
- 6.2.4. Removing Users and Revoking Permissions
- 6.2.5. Changing Passwords
- 6.3. Making the database more secure
- 7. Where to get more information
- 8. Legalities and Acknowledgements
- 8.1. Copyright and Licenses
- 8.2. Names and Contacts
- 8.3. Acknowledgement
| Next | ||
| Introduction |