MySQL 8.0 Release Notes
MySQL 8.0 Source Code Documentation
To reload a dump file written by mysqldump
that consists of SQL statements, use it as input to the
mysql client. If the dump file was created by
mysqldump with the
--all-databases or
--databases option, it
contains CREATE DATABASE and
USE statements and it is not
necessary to specify a default database into which to load the
data:
shell> mysql < dump.sql
Alternatively, from within mysql, use a
source command:
mysql> source dump.sql
If the file is a single-database dump not containing
CREATE DATABASE and
USE statements, create the
database first (if necessary):
shell> mysqladmin create db1Then specify the database name when you load the dump file:
shell> mysql db1 < dump.sqlAlternatively, from within mysql, create the database, select it as the default database, and load the dump file:
mysql> CREATE DATABASE IF NOT EXISTS db1;
mysql> USE db1;
mysql> source dump.sql
Note
For Windows PowerShell users: Because the "<" character is
reserved for future use in PowerShell, an alternative approach
is required, such as using quotes cmd.exe /c "mysql
< dump.sql".