Buy Mastering phpMyAdmin 3.3.x for Effective MySQL Management
close menu
Bookswagon
search
My Account
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Home > Computing and Information Technology Books > Information technology: general topics > Mastering phpMyAdmin 3.3.x for Effective MySQL Management: A complete guide to get started with phpMyAdmin 3.3 and master its features
Mastering phpMyAdmin 3.3.x for Effective MySQL Management: A complete guide to get started with phpMyAdmin 3.3 and master its features

Mastering phpMyAdmin 3.3.x for Effective MySQL Management: A complete guide to get started with phpMyAdmin 3.3 and master its features


     4  |  2 Reviews 
5
4
3
2
1



Out of Stock


Notify me when this book is in stock
X
About the Book

A complete guide to get started with phpMyAdmin 3.3 and master its features

Key Features
  • The best introduction to phpMyAdmin available
  • Written by the project leader of phpMyAdmin, and improved over several editions
  • A step-by-step tutorial for manipulating data with phpMyAdmin
  • Learn to do things with your MySQL database and phpMyAdmin that you didn't know were possible!
Book DescriptionphpMyAdmin 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.What you will learn
  • Upload phpMyAdmin to your web server and upgrade to the latest version
  • Manage multiple servers using a single copy of phpMyAdmin
  • Protect authentication credentials according to the needs of a users group and secure your phpMyAdmin installation using the various available authentication types
  • Export a table s structure and data for backup purposes and also use it as a gateway to another application
  • Import back a table s structure and data, provided the chosen format is supported by phpMyAdmin
  • Search for entries in a single-table by specifying the search criteria and also perform a search in the whole database
  • Define inter-table relations in a relational system and install the linked-tables infrastructure for keeping special metadata
  • Enter your own SQL queries into phpMyAdmin to perform actions that are beyond the scope of the interface and keep a history of these queries
  • Produce and maintain good documentation that explains the structure of your databases using the tools offered by phpMyAdmin
  • Apply transformations to data, in order to customize its format at view time
  • Administer a MySQL server by managing user accounts and privileges
  • Troubleshoot some common problems encountered in phpMyAdmin and prevent some of these problems from reoccurring
  • Save time while retrieving queries by storing them as bookmarks
Who this book is for

If you are a developer or system administrator or web designer who wants to manage MySQL databases and tables efficiently, this book is for you. This book assumes you already are well acquainted 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.



Table of Contents:
Table of Contents


    About the Author :
    Marc Delisle was awarded "MySQL Community Member of the year 2009" because of his involvement with phpMyAdmin. He started to contribute to the project in December 1998, when he made the multi-language version. He is still involved with phpMyAdmin as a developer and project administrator. Marc is a system administrator at Cegep de Sherbrooke, Qubec, Canada. He has been teaching networking, security, and web application development. In one of his classes, he was pleased to meet a phpMyAdmin user from Argentina. Marc lives in Sherbrooke with his wife and they enjoy spending time with their four children.


    Best Sellers


    Product Details
    • ISBN-13: 9781849513555
    • Publisher: Packt Publishing Limited
    • Publisher Imprint: Packt Publishing Limited
    • Edition: Digital original
    • No of Pages: 412
    • ISBN-10: 1849513554
    • Publisher Date: 13 Jan 2025
    • Binding: Digital (delivered electronically)
    • Language: English
    • Sub Title: A complete guide to get started with phpMyAdmin 3.3 and master its features


    Similar Products

    Add Photo
    Add Photo

    Customer Reviews

         4  |  2 Reviews 
    out of (%) reviewers recommend this product
    Top Reviews
    Rating Snapshot
    Select a row below to filter reviews.
    5
    4
    3
    2
    1
    Average Customer Ratings
         4  |  2 Reviews 
    00 of 0 Reviews
    Sort by :
    Active Filters

    00 of 0 Reviews
    SEARCH RESULTS
    1–2 of 2 Reviews
      BoxerLover2 - 5 Days ago
      A Thrilling But Totally Believable Murder Mystery

      Read this in one evening. I had planned to do other things with my day, but it was impossible to put down. Every time I tried, I was drawn back to it in less than 5 minutes. I sobbed my eyes out the entire last 100 pages. Highly recommend!

      BoxerLover2 - 5 Days ago
      A Thrilling But Totally Believable Murder Mystery

      Read this in one evening. I had planned to do other things with my day, but it was impossible to put down. Every time I tried, I was drawn back to it in less than 5 minutes. I sobbed my eyes out the entire last 100 pages. Highly recommend!


    Sample text
    Photo of
      Media Viewer

      Sample text
      Reviews
      Reader Type:
      BoxerLover2
      00 of 0 review

      Your review was submitted!
      Mastering phpMyAdmin 3.3.x for Effective MySQL Management: A complete guide to get started with phpMyAdmin 3.3 and master its features
      Packt Publishing Limited -
      Mastering phpMyAdmin 3.3.x for Effective MySQL Management: A complete guide to get started with phpMyAdmin 3.3 and master its features
      Writing guidlines
      We want to publish your review, so please:
      • keep your review on the product. Review's that defame author's character will be rejected.
      • Keep your review focused on the product.
      • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
      • Refrain from mentioning competitors or the specific price you paid for the product.
      • Do not include any personally identifiable information, such as full names.

      Mastering phpMyAdmin 3.3.x for Effective MySQL Management: A complete guide to get started with phpMyAdmin 3.3 and master its features

      Required fields are marked with *

      Review Title*
      Review
        Add Photo Add up to 6 photos
        Would you recommend this product to a friend?
        Tag this Book Read more
        Does your review contain spoilers?
        What type of reader best describes you?
        I agree to the terms & conditions
        You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

        CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

        These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


        By submitting any content to Bookswagon, you guarantee that:
        • You are the sole author and owner of the intellectual property rights in the content;
        • All "moral rights" that you may have in such content have been voluntarily waived by you;
        • All content that you post is accurate;
        • You are at least 13 years old;
        • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
        You further agree that you may not submit any content:
        • That is known by you to be false, inaccurate or misleading;
        • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
        • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
        • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
        • For which you were compensated or granted any consideration by any unapproved third party;
        • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
        • That contains any computer viruses, worms or other potentially damaging computer programs or files.
        You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


        For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


        All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

        Accept


        Inspired by your browsing history


        Your review has been submitted!

        You've already reviewed this product!