Mastering phpMyAdmin 3.4 for Effective MySQL Management
Format: PDF / Kindle (mobi) / ePub
This is a step-by-step instructional guide to get you started easily with phpMyAdmin and teach you to manage and perform database functions on your database. You will first be introduced to the interface and then build basic tables and perform both simple and advanced functions on the created database. The book progresses gradually and you will follow it best by reading it sequentially. If you are a developer, system administrator, or web designer who wants to manage MySQL databases and tables efficiently, then this book is for you. This book assumes that you are already wellacquainted with MySQL basics. This book is a must-read for every serious phpMyAdmin user who would like to use this outstanding application to its full power.
Will help you understand every phpMyAdmin feature in detail. This book jump starts with installing and configuring phpMyAdmin, and then looks into phpMyAdmin's features. This is followed by configuring authentication in phpMyAdmin and setting parameters that influence the interface as a whole, including the new user preferences feature. You will first create two basic tables and then edit, delete data, tables, and databases. As backups are crucial to a project, you will create up-to-date backups.
Following screenshot: Opening a new phpMyAdmin window Sometimes we want to compare data from two tables at once or have other needs for more than one phpMyAdmin window. At the bottom of almost every page, a small icon is available to open another window in phpMyAdmin with the current panel's content. Moreover, this icon can be used to create a browser bookmark that points to the current phpMyAdmin page (but we should log in to access the data). User preferences One instance of.
Table regroups all the data on which we want to search. If the data is scattered in many tables, a database search should be launched instead, and this is covered later in the chapter. Entering the search page The Search page can be accessed by clicking on the Search link in the Table view. This has been done here for the book table: The most commonly used section of the Search interface (query by example) is the one immediately displayed, whereas other dialogs are hidden in a.
The logging system (binlog) records all changes made to the database; however, in this case, the goal is two-fold: To allow master-slave synchronization To enable restoration via the mysqlbinlog command-line utility Tracking in phpMyAdmin phpMyAdmin's tracking system allows the user to specify which table is going to be tracked, so it can be called an opt-in system. By default, no table is tracked unless a developer elects to do so; and when a developer activates tracking for a table,.
It; tracking is done from the birth of a table. An inconvenient side effect of this is that we don't have the possibility of choosing which statements will be tracked; these will be taken from the default list (refer to the Choosing the statements to be tracked section later in this chapter). Other configuration directives will be discussed in the section that relates to them. Principles This section defines important principles on which the tracking mechanism is based: versioning,.