Download for free
Backup & Restore ubuntudebiancentos intermediate

MySQL Import

Restore database from SQL file

Overview

Restore database from SQL file

Commands

This will import the database, data will be overwritten, continue?

mysql -u root -p {database_name} < {sql_file}

Use Cases

Database restore, restore development/test environments.

Prerequisites

The target database must already exist (or use a CREATE DATABASE statement).

  • Export MySQL Database