Description |
1 online resource (1 volume) : illustrations |
Series |
Community experience distilled |
|
Community experience distilled.
|
Note |
Includes index. |
Contents |
Cover -- Copyright -- Credits -- About the Author -- About the Reviewers -- www.PacktPub.com -- Table of Contents -- Preface -- Chapter 1: Installing MariaDB -- Choosing a MariaDB series -- The development series -- The stable series -- The maintenance series -- Installing MariaDB on Windows -- Installing MariaDB on Mac OS X -- Installing MariaDB on Debian, Ubuntu, and Linux Mint -- Installing MariaDB on Fedora, Red Hat, and CentOS -- Installing MariaDB on other Linux distributions -- MariaDB package security -- After the installation -- Troubleshooting installation issues -- Summary -- Chapter 2: Configuring MariaDB -- The MariaDB filesystem layout -- The MariaDB filesystem layout on Windows -- The MariaDB filesystem layout on Linux -- Modular configuration on Linux -- The anatomy of the MariaDB configuration file -- Where is my configuration file? -- Comments -- Groups -- Options that do not require values -- Options that require values -- Option formatting -- Options, options everywhere -- Activating configuration changes -- Summary -- Chapter 3: Securing MariaDB -- Security layers -- Securing MariaDB in 10 seconds -- Connecting safely -- Connecting safely on the command line -- Connecting safely in scripts -- Server security -- Building security -- Internal network security -- Internet security -- Summary -- Chapter 4: Administering MariaDB -- User privileges -- Global administrative user privileges -- Database, table, and column user privileges -- Miscellaneous user privileges and limits -- Creating users -- Granting, revoking, and showing permissions -- Granting permissions -- Revoking permissions -- Showing permissions -- Setting and changing passwords -- Removing users -- Summary -- Chapter 5: Using MariaDB -- Databases and Tables -- The mysql command-line client application -- Connecting to MariaDB -- Using USE to select a database. |
|
Using SHOW to list all databases on a server -- Creating and deleting databases -- Using CREATE DATABASE to create a database -- Using DROP DATABASE to delete a database -- Data, tables, and normalization -- Creating, altering, and dropping tables -- Using CREATE TABLE -- Using CREATE TABLE -- datatypes -- Using CREATE TABLE- other options -- Using CREATE TABLE -- an example -- Using SHOW to display the command used to create a table -- Using DESCRIBE to explore the structure of a table -- Using ALTER TABLE -- Using ALTER TABLE -- basic syntax -- Using ALTER TABLE -- adding a column -- Using ALTER TABLE -- modifying a column -- Using ALTER TABLE -- dropping a column -- Using DROP TABLE -- Summary -- Chapter 6: Using MariaDB -- Inserting, Updating, and Deleting -- Using INSERT -- Inserting complete rows -- Inserting partial rows -- Inserting from another table -- Inserting from a file -- Using UPDATE -- Using DELETE -- Summary -- Chapter 7: Using MariaDB -- Retrieving Data -- Retrieving data -- Retrieving everything -- Retrieving selected columns -- Filtering and searching data -- Filtering by exact values -- Using logical operators -- Using the AND operator -- Using the OR operator -- Evaluation order -- Using the IN operator -- Using the NOT operator -- Searching with LIKE -- Sorting data -- Joining data -- Summarizing data -- The AVG function -- The COUNT function -- The MIN and MAX functions -- The SUM function -- Using GROUP BY with summarized data -- Using HAVING to filter GROUP BY -- Summary -- Chapter 8: Maintaining MariaDB -- MariaDB log files -- The binary log -- The error log -- The general query log -- The slow query log -- Optimizing and tuning MariaDB -- Backing up, importing, and restoring data -- Basic backups with mysqldump -- Restoring backups made with mysqldump -- Making tab-delimited backups with mysqldump. |
|
Restoring and importing data with mysqlimport -- Making backups of MyISAM tables with mysqlhotcopy -- Making backups of XtraDB and InnoDB tables with xtrabackup -- Restoring backups made with xtrabackup -- Making cold backups -- Repairing MariaDB -- Checking and optimizing tables with mysqlcheck -- Repairing tables -- Summary -- Appendix: MariaDB Next Steps -- Index. |
Summary |
This book is for anyone who wants to learn more about databases in general and wants to get started with MariaDB. Prior database experience is not required. |
Subject |
MariaDB.
|
|
MySQL (Electronic resource)
|
|
MariaDB |
|
MySQL (Electronic resource) |
|
Relational databases.
|
|
Database management.
|
|
Bases de données relationnelles. |
|
Bases de données -- Gestion. |
|
Database management |
|
Relational databases |
Added Title |
Getting started with Maria database |
|
Explore the powerful features of MariaDB with practical examples |
Other Form: |
Print version: Bartholomew, Daniel. Getting started with MariaDB : explore the powerful features of MariaDB with practical examples. Second edition. Birmingham, England ; Mumbai, [India] : Packt Publishing, ©2015 ix, 117 pages Community experience distilled. 9781785284120 |
ISBN |
9781782175711 (electronic bk.) |
|
1782175717 (electronic bk.) |
|