Download for free
Backup & Restore ubuntudebiancentos intermediate

MySQL Export

Export specified database to SQL file

Overview

Export specified database to SQL file

Commands

This will export the database, enter password, continue?

mysqldump -u root -p {database_name} > backup_$(date +%Y%m%d_%H%M%S).sql

Use Cases

Scheduled database backup, export before migration.

Prerequisites

MySQL client is installed.

  • Import MySQL Database