{"id":6270,"date":"2018-01-19T19:35:36","date_gmt":"2018-01-19T19:35:36","guid":{"rendered":"http:\/\/goofy-trucks.flywheelsites.com\/mastering-phpmyadmin-for-effective-mysql-management\/"},"modified":"2018-01-19T19:36:19","modified_gmt":"2018-01-19T19:36:19","slug":"mastering-phpmyadmin-for-effective-mysql-management","status":"publish","type":"post","link":"https:\/\/phpbuilder.com\/mastering-phpmyadmin-for-effective-mysql-management\/","title":{"rendered":"Mastering phpMyAdmin for Effective MySQL Management"},"content":{"rendered":"<div class=\"phpbuilder-content\">\n<div class=\"phpbuilder-meta\">\n<div class=\"\">By damian carvill<\/div>\n<div class=\"\">on June 18, 2004<\/div>\n<\/p><\/div>\n<div id=\"overflow-content\">\n<p>This book is a comprehensive guide helping you to unlock the full potential of phpMyAdmin. Whether you are an experienced developer, system administrator, web designer or new to MySQL and phpMyAdmin, this book will show you how to increase your productivity and control when working with your MySQL.<\/p>\n<p>What you will learn from this book Whether you are an experienced developer, system administrator, web designer or new to MySQL and phpMyAdmin, this book will show you how to increase your productivity and control when working with your databases. You will learn how to:\n<\/p>\n<p>* Administer MySQL users and privileges, and get statistics about MySQL servers and databases<br \/>\n* Manage databases, table data and structures, and indexes<br \/>\n* Use bookmarks and metadata<br \/>\n* Generate multiple SQL queries<br \/>\n* Generate better documentation of evolving table structures<\/p>\n<p>\nAlong the way youll build a more detailed understanding of SQL and how it works in MySQL.\n<\/p>\n<p>\nAs an application developer youll learn how to use phpMyAdmin to:<\/p>\n<p>\n* Effectively perform day-to-day database and table management.<br \/>\n* Create better database tables and relational structures<br \/>\n* More easily document your evolving data structure\n<\/p>\n<p>\nAs a MySQL server administrator, youll benefit from the in-depth and practical coverage of:<\/p>\n<p>\n* Using phpMyAdmin to manage users and privileges<br \/>\n* Getting server and database statistics<\/p>\n<p>\nAll database users will expand and refine their knowledge of SQL in a MySQL context through using phpMyAdmin to track SQL execution and results.<\/p>\n<p>\nApproach<br \/> <br \/>\nThe book begins with a comprehensive tutorial of phpMyAdmin that systematically explains and demonstrates the potential of this tool. It then goes on to show the less well known and generally under-used features and capabilities of phpMyAdmin in depth.<\/p>\n<p>\nIn the book youll learn about:<\/p>\n<p>\n* Installing, configuring, and customizing phpMyAdmin<br \/>\n* MySQL administration<br \/>\n* Managing databases, table data and, structures<br \/>\n* Managing indexes<br \/>\n* Exporting databases and table data and structures<br \/>\n* Searching databases and tables <br \/>\n* Using metadata and bookmarks<br \/>\n* Generating multiple SQL queries<br \/>\n* Documenting table structures<br \/>\n* Mime-based transformation<\/p>\n<p>Who this book is written for?<br \/>\nphpMyAdmin is a must have tool for everyone who needs to manage MySQL databases and tables. This book is a must read for every serious phpMyAdmin user who would like to use this outstanding application to its full power.<\/p>\n<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"<p>This book is a comprehensive guide helping you to unlock the full potential of phpMyAdmin. Whether you are an experienced developer, system<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-6270","post","type-post","status-publish","format-standard","hentry","category-news"],"_links":{"self":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/6270","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/comments?post=6270"}],"version-history":[{"count":1,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/6270\/revisions"}],"predecessor-version":[{"id":7095,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/6270\/revisions\/7095"}],"wp:attachment":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/media?parent=6270"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/categories?post=6270"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/tags?post=6270"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}