MySQL

Administrating the MySQL Server with phpMyAdmin

by Marc Delisle | October 2010 | MySQL Open Source PHP

This article, Marc Delisle, author of Mastering phpMyAdmin 3.3.x for Effective MySQL Management, discusses how a system administrator can use the phpMyAdmin server management features for day-to-day user account maintenance, server verification, and server protection. The subject of how non-administrators can obtain server information from phpMyAdmin is also covered. Server administration is mostly done via the Server view, which is accessed via the menu tabs available on phpMyAdmin's home page.

Server administration is mostly done via the Server view, which is accessed via the menu tabs available on phpMyAdmin's home page.

This article specifically covers:

  • Managing users and their privileges
  • Database information
  • Server information
Read Administrating the MySQL Server with phpMyAdmin in full

Installing phpMyAdmin

by Marc Delisle | October 2010 | MySQL Open Source PHP

In this article, by Marc Delisle, author of Mastering phpMyAdmin 3.3.x for Effective MySQL Management, we will cover:

  • Installing phpMyAdmin
  • Configuring phpMyAdmin
  • Upgrading phpMyAdmin
Read Installing phpMyAdmin in full

Importing Structure and Data in phpMyAdmin 3.3.x for Effective MySQL Management

by Marc Delisle | October 2010 | MySQL Open Source PHP

In this article, by Marc Delisle, author of Mastering phpMyAdmin 3.3.x for Effective MySQL Management, we will learn how to import data that we have exported for backup or transfer purposes. Exported data may also come from authors of other applications, and could contain the whole foundation structure of these application along with some sample data.

The current phpMyAdmin version (3.3) can import:

  • Files containing MySQL statements (usually having a .sql suffx, but not necessarily so)
  • CSV files (comma-separated values, although the separator is not necessaria comma); these files can be imported by phpMyAdmin itself or via the MySQL LOAD DATA INFILE statement, which enables the MySQL Server to handle the data directly rather than having phpMyAdmin parse it frst
  • Open Document Spreadsheet files
  • Excel files (from versions 97 to 2007)
  • XML files (generated by phpMyAdmin)

The binary feld upload can be said to belong to the import family. Future versions might be able to import files in more formats.

Importing and uploading are synonyms in this context.

Read Importing Structure and Data in phpMyAdmin 3.3.x for Effective MySQL Management in full

Performing Table and Database Operations in phpMyAdmin 3.3.x for Effective MySQL Management

by Marc Delisle | October 2010 | MySQL Open Source PHP

In this article, by Marc Delisle, author of Mastering phpMyAdmin 3.3.x for Effective MySQL Management, we will learn how to perform some operations that influence tables or databases as a whole. We will cover table attributes and how to modify them, and will also discuss multi-table operations.

This article specifically covers:

  • Maintaining a table
  • Changing table attributes
  • Renaming, moving, and copying tables
  • Multi-table operations
  • Database operations
Read Performing Table and Database Operations in phpMyAdmin 3.3.x for Effective MySQL Management in full

Advanced aspects of Inserting and Deleting data in MySQL

by Daniel Schneller Udo Schwedt | September 2010 | Cookbooks MySQL Open Source

In this article, by Daniel Schneller & Udo Schwedt, authors of MySQL Admin Cookbook

  • Inserting new data and updating data if it already exists
  • Inserting data based on existing database content
  • Deleting all data from large tables
  • Deleting all but a fragment of a large table's data
  • Deleting all data incrementally from large tables
Read Advanced aspects of Inserting and Deleting data in MySQL in full

Running Multiple MySQL Server Instances in Parallel on a Linux Server

by Daniel Schneller Udo Schwedt | September 2010 | Cookbooks MySQL Open Source

In the previous article, MySQL Admin: Configuring InnoDB and Installing MySQL as a Windows Service, we covered the configuring InnoDB and installing MySQL as a windows service.

In this article, by Daniel Schneller & Udo Schwedt, authors of MySQL Admin Cookbook, we will cover:

  • Running multiple MySQL server instances in parallel on a Linux server
  • Preventing invalid date values from being stored in DATE or DATETIME columns
Read Running Multiple MySQL Server Instances in Parallel on a Linux Server in full

MySQL Admin: Configuring InnoDB and Installing MySQL as a Windows Service

by Daniel Schneller Udo Schwedt | September 2010 | Cookbooks MySQL Open Source

In this article, by Daniel Schneller & Udo Schwedt, authors of MySQL Admin Cookbook, we will cover:

  • Configuring the InnoDB redo log
  • Understanding and configuring important MySQL and InnoDB timeout options
  • Adjusting table and database name letter case handling for better platform independence
  • Installing MySQL as a Windows service with custom options
Read MySQL Admin: Configuring InnoDB and Installing MySQL as a Windows Service in full

Exception Handling in MySQL for Python —A Sequel

by Albert Lukaszewski, PhD | September 2010 | MySQL Open Source

In the previous article, Inserting Multiple Entries with MySQL for Python, we learned about exception handling in Python.

This article, Albert Lukaszewski, PhD, author of MySQL for Python, is a sequel of the previous article which discusses ways to handle errors and warnings that are passed from MySQL for Python and the differences between them.

In this article we will specifically cover:

  • Types of errors
  • Customizing for catching
  • Creating a feedback loop
  • Project: Bad apples
Read Exception Handling in MySQL for Python —A Sequel in full

Creating Your Own Functions in MySQL for Python

by Albert Lukaszewski, PhD | September 2010 | MySQL Open Source

Comparing MySQL's string functions to Python's, you will notice that Python supports the capitalize() and capwords() functions. These capitalize the initial letter of the string and the first letter of each word, respectively. MySQL has no built-in capability to do this. It either returns all uppercase, all lowercase, or the original format of the string value. To put the onus of capitalization on the MySQL server, we need to define our own functions.

In this article, Albert Lukaszewski, PhD, author of MySQL for Python, we will cover the following topics:

  • Hello()
  • Capitalise()
  • DELIMITER
Read Creating Your Own Functions in MySQL for Python in full

Exception Handling in MySQL for Python

by Albert Lukaszewski, PhD | September 2010 | MySQL Open Source

Any application that is used by multiple users in a production environment should have some level of exception handling implemented.

In this article, by Albert Lukaszewski, PhD, author of MySQL for Python, we will look at the following topics:

  • Why errors and warnings are good for you
  • Errors versus warnings: there's a big difference
  • The two main errors in MySQLdb
  • Warnings in MySQL for Python
  • Handling exceptions passed from MySQL
  • Catching different types of exceptions
Read Exception Handling in MySQL for Python in full
Syndicate content
Code Download and Errata
Packt Anytime, Anywhere
Register Books
Print Upgrades
eBook Downloads
Video Support
Contact Us
Awards Voting Nominations Previous Winners
Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
Resources
Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software