What you'll learn

Moving data to and from a large number of systems is a must in today's dynamic businesses. In this course, Database Administration: Importing and Exporting Data, you’ll learn to import and export data from one of the most popular relational databases, MySQL; a trusted datastore for many e-commerce and other transactional business needs. First, you’ll explore MySQL Workbench, a robust MySQL client, and perform data imports and exports manually. Next, you’ll discover how to run import and export tasks using mysqldump. Finally, you’ll learn how to perform mysqldump operations using standard operating-system mechanisms, like crontab. When you’re finished with this course, you’ll have the skills and knowledge of handling import/export operations for a relational database needed to manipulate external and internal data to meet business needs and advance your career.