|
Free ebooks
 Free database ebooks SQL Mastering phpMyAdmin 2.8 for Effective MySQL Management
|
 Chapter 1 is an introduction to phpMyAdmin, its history, and main features.Chapter 2 provides detailed coverage of the different installation and configuration options, including installing one copy of phpMyAdmin for multiple users, and configuring it to manage many servers. Security issues are also discussed in this chapter. Chapter 3 is an overview of the graphical interface of phpMyAdmin. A more detailed examination of the various panels and windows is provided in the following chapters. In Chapter 4 we see how to create our first database and table and its various fields. In Chapter 5 we cover deleting single and multiple rows, tables, and databases. This chapter also covers data-editing operations, such as handling Null values and applying MySQL functions to data. Chapter 6 focuses on the various options of phpMyAdmin for changing table structure. These include adding field types such as TEXT, BLOB, ENUM, and SET, uploading binary data into BLOB fields, and managing indexes. phpMyAdmin can be used to backup data and take intermediary snapshots during development and production phases. Chapter 7 shows how to perform these tasks using the export feature of phpMyAdmin. The various data formats that can be exported are also explained. The focus of Chapter 8 is that phpMyAdmin can also import data. Importing SQL and CSV files, and phpMyAdmin’s handing of compressed files are covered here. In addition to its user friendly browsing features, phpMyAdmin allows us to easily search through our data. Chapter 9 covers searching databases and single tables. The previous chapters dealt mostly with table fields. Chapter 10 focuses on operations that affect tables or databases as a whole. Repairing and optimizing tables, changing the various table attributes, and copying and moving tables to another database are all explained here, as well as database renaming or copying. In Chapter 11, we start reading about phpMyAdmin’s more advanced features. We see how to install the linked-tables infrastructure, which is required for using various advanced features. Both single- and multi-user installations are covered. Defining inter-table relations is also explained. In addition to letting us perform various database operations through its graphical interface, phpMyAdmin also allows us to run complex SQL commands for tasks that cannot be performed through the graphical interface. This feature is covered in Chapter 12. Chapter 13, which covers multi-table search, complements Chapter 9 and shows how to search single tables and a whole database. Chapter 14 covers phpMyAdmin’s powerful feature of query bookmarks, which is one of the linked-tables features that were covered in Chapter 11. The chapter shows how to record, manipulate, and pass parameters to bookmarks. Creating and maintaining good documentation about data structure is crucial, particularly for team projects. phpMyAdmin allows us to do this, and this feature is covered in Chapter 15. The chapter shows how to generate simple table and column lists, use data dictionaries for complete column lists, and generate custom-made relational schema for tables in the PDF format. phpMyAdmin can perform MIME-based transformation on column contents. Transformation of both text and images is covered in Chapter 16. Chapter 17 covers character sets and collations in detail. Chapter 18 shows how system administrators can use phpMyAdmin for user account and privileges management and server status verification. The chapter also covers how non-administrators can obtain information about the server. Chapter 19, the last chapter of the ebook, covers various troubleshooting and support issues. It covers the most common error messages and configuration problems. The chapter also includes information on how and where you can get technical support. Download free pdf ebooks on sql:Mastering phpMyAdmin 2.8 for Effective MySQL Management
|
