Abstract
Back in the Stone Age, cavemen never really had any issues with data incompatibility, as stones and one’s own memory were the only storage medium. Copying data involved pulling out the old chisel and getting busy on a new slab of granite. Now, of course, the situation is much different. Hundreds of data storage strategies exist, the most commonplace of which include spreadsheets and various types of databases. Working in a complex, often convoluted fashion, you often need to convert data from one storage type to another, say between a spreadsheet and a relational database, or between an Oracle database and MySQL. If this is done poorly, you could spend hours, and even days and weeks, massaging the converted data into a usable format. This chapter seeks to eliminate that conundrum, by introducing MySQL’s data import and export utilities, as well as various techniques and concepts central to lessening the pain involved in performing such tasks.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2008 W. Jason Gilmore
About this chapter
Cite this chapter
(2008). Importing and Exporting Data. In: Beginning PHP and MySQL. Apress. https://doi.org/10.1007/978-1-4302-0299-8_38
Download citation
DOI: https://doi.org/10.1007/978-1-4302-0299-8_38
Publisher Name: Apress
Print ISBN: 978-1-59059-862-7
Online ISBN: 978-1-4302-0299-8
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books