phpMyAdmin is an open source tool written in PHP to handle MySQL administration over the World Wide Web. It can execute SQL statements and manage users and their permissions. However, when it comes to exploiting phpMyAdmin to its full potential, even experienced developers and system administrators are left baffled.Mastering phpMyAdmin 3.3.x for Effective MySQL Management is an easy-to-follow, step-by-step guide that walks you through every facet of this efficient tool. Author Marc Delisle draws on his experience as one of the leading developers and project administrator of phpMyAdmin and uses his unique tutorial approach to take full advantage of its potential. This book is filled with illustrative examples that will help you understand every phpMyAdmin feature in detail.The book helps you get started with installing and configuring phpMyAdmin and looks at its features. You then work on a sample project with two basic tables and perform basic actions such as creating, editing, and deleting data, tables, and databases. You will learn how to create up-to-date backups and import the data that you have exported. You will then explore different search mechanisms and options for querying across multiple tables.The book gradually proceeds to advanced features such as defining inter-table relations and installing the linked-tables infrastructure. Some queries are out of the scope of the interface and this book will show you how to accomplish these tasks with SQL commands.New features of version 3.3.x, such as synchronizing databases on different servers and managing MySQL replication to improve performance and data security, are covered in this book. Towards the end of the book you will learn to document your database, track changes made to the database, and manage user accounts using phpMyAdmin server management features.This book is an upgrade from the previous version that covered phpMyAdmin Version 3.1. Version 3.3.x introduced features such as new import and export modules, tracking changes, synchronizing structure and data between servers, and providing support for replication.
Mastering phpMyAdmin 3.3.x for Effective MySQL Management : A complete guide to get started with phpMyAdmin 3.3 and master its features
Empieza hoy con este libro por 0 €
- Disfruta de acceso completo a todos los libros de la app durante el periodo de prueba
- Sin compromiso, cancela cuando quieras
Autores/as:
Idioma:
Inglés
Formato:
Virtualización de infraestructura tecnológica
Learning AWS IoT : Effectively manage connected devices on the AWS cloud using services such as AWS Greengrass, AWS button, predictive analytics and machine learning
Architecting Google Cloud Solutions : Learn to design robust and future-proof solutions with Google Cloud technologies
Mastering Android Development with Kotlin : Deep dive into the world of Android to create robust applications with Kotlin
Kotlin Quick Start Guide : Core features to get you ready for developing applications
Mastering GitHub Actions : Advance your automation skills with the latest techniques for software integration and deployment
Hands-On Design Patterns with Kotlin : Build scalable applications using traditional, reactive, and concurrent design patterns in Kotlin
How to Build Android Apps with Kotlin : A practical guide to developing, testing, and publishing your first Android apps
Kubernetes Secrets Handbook : Design, implement, and maintain production-grade Kubernetes Secrets management solutions
Android Studio Iguana Essentials - Kotlin Edition : Developing Android Apps Using Android Studio 2023.2.1 and Kotlin
Modern Frontend Development with Node.js : A compendium for modern JavaScript web development within the Node.js ecosystem
Node.js 6.x Blueprints
phpMyAdmin Starter : Get started with this quick introduction to phpMyAdmin, its features, and the community with this book and ebook.
Mastering phpMyAdmin 3.4 for Effective MySQL Management : A complete guide to getting started with phpMyAdmin 3.4 and mastering its features book and ebook
Creating your MySQL Database: Practical Design Tips and Techniques : A short guide for everyone on how to structure your data and set-up your MySQL database tables efficiently and easily.