- Getting Started with MariaDB Second Edition
- Table of Contents
- Getting Started with MariaDB Second Edition
- Credits
- About the Author
- About the Reviewers
- www.PacktPub.com
- Preface
- 1. Installing MariaDB
- Choosing a MariaDB 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
- 2. Configuring MariaDB
- 3. Securing MariaDB
- 4. Administering MariaDB
- 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
- Data, tables, and normalization
- Creating, altering, and dropping tables
- Summary
- 6. Using MariaDB – Inserting, Updating, and Deleting
- 7. Using MariaDB – Retrieving Data
- 8. Maintaining MariaDB
- MariaDB log files
- 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
- Summary
- A. MariaDB Next Steps
- Index
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.