|
|
|
|
| LEADER |
06043nmm a2200505 u 4500 |
| 001 |
EB001922432 |
| 003 |
EBX01000000000000001085334 |
| 005 |
00000000000000.0 |
| 007 |
cr||||||||||||||||||||| |
| 008 |
210123 ||| eng |
| 020 |
|
|
|a 9781782175711
|
| 050 |
|
4 |
|a QA76.9.D3
|
| 100 |
1 |
|
|a Bartholomew, Daniel
|
| 245 |
0 |
0 |
|a Getting started with MariaDB
|b explore the powerful features of MariaDB with practical examples
|c Daniel Bartholomew
|
| 246 |
3 |
1 |
|a Explore the powerful features of MariaDB with practical examples
|
| 246 |
3 |
1 |
|a Getting started with Maria database
|
| 250 |
|
|
|a Second edition
|
| 260 |
|
|
|a Birmingham, UK
|b Packt Publishing
|c 2015
|
| 300 |
|
|
|a 1 volume
|b illustrations
|
| 505 |
0 |
|
|a 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
|
| 505 |
0 |
|
|a 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
|
| 505 |
0 |
|
|a 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
|
| 653 |
|
|
|a MariaDB / fast
|
| 653 |
|
|
|a MySQL (Electronic resource) / http://id.loc.gov/authorities/names/n2004021601
|
| 653 |
|
|
|a Bases de données / Gestion
|
| 653 |
|
|
|a Bases de données relationnelles
|
| 653 |
|
|
|a MySQL (Electronic resource) / fast
|
| 653 |
|
|
|a Relational databases / fast
|
| 653 |
|
|
|a MariaDB. / http://id.loc.gov/authorities/names/n2011046345
|
| 653 |
|
|
|a Database management / http://id.loc.gov/authorities/subjects/sh85035848
|
| 653 |
|
|
|a Relational databases / http://id.loc.gov/authorities/subjects/sh86007768
|
| 653 |
|
|
|a Database management / fast
|
| 041 |
0 |
7 |
|a eng
|2 ISO 639-2
|
| 989 |
|
|
|b OREILLY
|a O'Reilly
|
| 490 |
0 |
|
|a Community experience distilled
|
| 500 |
|
|
|a Includes index
|
| 776 |
|
|
|z 1782175717
|
| 776 |
|
|
|z 9781782175711
|
| 776 |
|
|
|z 9781785284120
|
| 776 |
|
|
|z 1782175717
|
| 776 |
|
|
|z 1785284126
|
| 856 |
4 |
0 |
|u https://learning.oreilly.com/library/view/~/9781785284120/?ar
|x Verlag
|3 Volltext
|
| 082 |
0 |
|
|a 658
|
| 082 |
0 |
|
|a 005.75/65
|
| 520 |
|
|
|a 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
|