EasyEnv
Engineering/Courses/Catalog/MySQL/mysqldump and Restore
MySQL
IntermediateLesson 12 of 1325 min · hands-on

mysqldump and Restore

Part of the MySQL course

The nightly job has been writing a file to disk for eight months and nobody has ever opened it. That is not a backup, that is a hopeful file. A backup only becomes a backup the first time you restore it and watch your data come back, which is why this lesson has you drop a database on purpose before it tells you anything else.

MySQL's standard tool for this is mysqldump. It produces a logical backup: a plain text file of SQL statements that rebuild your database when replayed. You can read it, grep it, edit it and replay it against any MySQL server, which is a very different proposition from a binary copy of the data files. ...

Want to learn MySQL mysqldump and Restore in a real environment?

Click below, get a fresh Linux box with MySQL ready to go, and work through mysqldump and Restore hands-on with an AI tutor that knows your code.

Start this lessonmysqldump and Restore

What you'll learn

  • Mysqldump
  • Redirecting to .sql
  • Restoring with mysql client
  • --single-transaction for InnoDB
  • --no-data for schema only
  • --all-databases

Read this lesson in your language

All lessons in this course

13 lessons
  1. 1What is MySQL20 min
  2. 2The mysql CLI and First Commands25 min
  3. 3Creating Databases and Tables30 min
  4. 4Data Types30 min
  5. 5SELECT and WHERE30 min
  6. 6Joins35 min
  7. 7Aggregates and Grouping30 min
  8. 8Indexes30 min
  9. 9Transactions and Storage Engines35 min
  10. 10Stored Procedures and Triggers35 min
  11. 11EXPLAIN and Query Tuning35 min
  12. 12mysqldump and Restore25 min
  13. 13Capstone: Design an Ecommerce Schema50 min

Explore other courses

mysqldump and Restore - MySQL (English) | Engineering Courses