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 fullPerforming 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
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
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
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
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
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
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
Disaster Recovery in MySQL for Python
by
Albert Lukaszewski, PhD | September 2010 | MySQL Open Source
One thing that is certain in computing is that hardware will fail even if the software is written soundly. For this reason, a disaster recovery plan should be implemented for every database server. Even if you are not the administrator of the server, this article will show you how to back up the data you use.
In this article, Albert Lukaszewski, PhD, author of MySQL for Python, we will have covered:
- When to implement one of several kinds of database backup plans
- What methods of backup and disaster recovery MySQL supports
- How to use Python to back up databases
Inserting Multiple Entries with MySQL for Python
by
Albert Lukaszewski, PhD | September 2010 | MySQL Open Source
When we deal with large amounts of data that are all going into the same database, running single instances of individual INSERT commands can take a ridiculous amount of time and waste a considerable amount of I/O. What we need is a way to insert multiple items in one go.
In this article, Albert Lukaszewski, PhD, author of MySQL for Python, we will look at the following:
- How iteration can help us execute several individual INSERT statements rapidly
- Using executemany() to submit several INSERT statements in one go
- When not to use executemany()
- Throttling how much data is inserted at a time
