MySQL and MySQL Community information

Importing and Backing Up with mysqldump

The mysqldump utility lets you 'dump' table contents to text, either for backup purposes or for importing into other databases. mysqldump supports two types of database backup

  • Physical backup which preserves only the data, typically in comma separated (CSV) or other delimited text files but also in XML format.
  • Logical backup which contains SQL statements that can reproduce table structure, table data or both

To learn about importing and exporting data as well as other key topics for getting started on a MySQL database, take the MySQL for Beginners training course.

You can take this 4-day course through the following formats:

  • Training-on-Demand: Start training within 24 hours of registration, following lecture material through streaming video and booking access to perform hands on exercises when suits your schedule.
  • Live-Virtual Event: Attend a live event from your own desk, no travel required. Choose from a selection of events on the schedule to suit different timezones; 24 May, 1 June, 2 June, 4 August and 20 October 2015 in English and 15 September and 15 December 2015 in German.
  • In-Class Event: Travel to an education center to attend a class. Below is a selection of the events already on the schedule.

 Location  Date  Delivery Language
Brussels, Belgium
18 May 2015 English
Sao Paolo, Brazil
6 July 2015 Brazilian Portuguese
London, England
1 September 2015 English
Berlin, Germany
27 April 2015 German
Hamburg, Germany
21 September 2015 German
Munich, Germany
27 July 2015 German
Jakarta, Indonesia
1 June 2015 English
Rome, Italy
14 September 2015 Italian
Turin, Italy
8 June 2015 Italian
Darul Eshan, Malaysia
10 August 2015 English
Kuala Lumpur, Malaysia
8 June 2015 English
Petaling Jaya, Malaysia
5 May 2015 English
Pulau Pinang, Malaysia
2 June 2015 English
Mexico City, Mexico
25 May 2015 Spanish
Utrecht, Netherlands
18 May 2015 English
Lisbon, Portugal
21 September 2015 European Portuguese
Capetown, South Africa
11 August 2015 English
Johannesburg, South Africa
11 August 2015 English
Pretoria, South Africa
27 July 2015 English
Madrid, Spain
6 July 2015 Spanish
Bangkok, Thailand 8 June 2015 English
To register for an event or learn more about the authentic MySQL curriculum, go to http://education.oracle.com/mysql.

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.