Chapter 10. Importing and Exporting Data

Section 10.0.  Introduction

Recipe 10.1.  Importing Data with LOAD DATA and mysqlimport

Recipe 10.2.  Specifying the Datafile Location

Recipe 10.3.  Specifying the Structure of the Datafile

Recipe 10.4.  Dealing with Quotes and Special Characters

Recipe 10.5.  Importing CSV Files

Recipe 10.6.  Reading Files from Different Operating Systems

Recipe 10.7.  Handling Duplicate Key Values

Recipe 10.8.  Obtaining Diagnostics About Bad Input Data

Recipe 10.9.  Skipping Datafile Lines

Recipe 10.10.  Specifying Input Column Order

Recipe 10.11.  Preprocessing Input Values Before Inserting Them

Recipe 10.12.  Ignoring Datafile Columns

Recipe 10.13.  Exporting Query Results from MySQL

Recipe 10.14.  Exporting Tables as Text Files

Recipe 10.15.  Exporting Table Contents or Definitions in SQL Format

Recipe 10.16.  Copying Tables or Databases to Another Server

Recipe 10.17.  Writing Your Own Export Programs

Recipe 10.18.  Converting Datafiles from One Format to Another

Recipe 10.19.  Extracting and Rearranging Datafile Columns

Recipe 10.20.  Using the SQL Mode to Control Bad Input Data Handling

Recipe 10.21.  Validating and Transforming Data

Recipe 10.22.  Using Pattern Matching to Validate Data

Recipe 10.23.  Using Patterns to Match Broad Content Types

Recipe 10.24.  Using Patterns to Match Numeric Values

Recipe 10.25.  Using Patterns to Match Dates or Times

Recipe 10.26.  Using Patterns to Match Email Addresses or URLs

Recipe 10.27.  Using Table Metadata to Validate Data

Recipe 10.28.  Using a Lookup Table to Validate Data

Recipe 10.29.  Converting Two-Digit Year Values to Four-Digit Form

Recipe 10.30.  Performing Validity Checking on Date or Time Subparts

Recipe 10.31.  Writing Date-Processing Utilities

Recipe 10.32.  Using Dates with Missing Components

Recipe 10.33.  Importing Non-ISO Date Values

Recipe 10.34.  Exporting Dates Using Non-ISO Formats

Recipe 10.35.  Importing and Exporting NULL Values

Recipe 10.36.  Guessing Table Structure from a Datafile

Recipe 10.37.  Exchanging Data Between MySQL and Microsoft Access

Recipe 10.38.  Exchanging Data Between MySQL and Microsoft Excel

Recipe 10.39.  Exporting Query Results as XML

Recipe 10.40.  Importing XML into MySQL

Recipe 10.41.  Epilogue