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 RestoreWhat 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- 1What is MySQL20 min
- 2The mysql CLI and First Commands25 min
- 3Creating Databases and Tables30 min
- 4Data Types30 min
- 5SELECT and WHERE30 min
- 6Joins35 min
- 7Aggregates and Grouping30 min
- 8Indexes30 min
- 9Transactions and Storage Engines35 min
- 10Stored Procedures and Triggers35 min
- 11EXPLAIN and Query Tuning35 min
- 12mysqldump and Restore25 min
- 13Capstone: Design an Ecommerce Schema50 min
Explore other courses
