xxxxxxxxxx
zcat /path/to/file.sql.gz | mysql -u 'root' -p your_database
xxxxxxxxxx
mysql> create new_database;
mysql> use new_database;
mysql> source (Here you need to import the path of the SQL file);
E.g.:
mysql> source E:/test/dump.sql;
xxxxxxxxxx
mysql -u database_user -p --default-character-set=utf8 [db_name] < database_file.sql
xxxxxxxxxx
#!/bin/sh
mysql -u root --password="${MYSQL_ROOT_PASSWORD}" --database=projectdb </tmp/projectdb.sql &&
rm /tmp/projectdb.sql
xxxxxxxxxx
cat /path/to/file_table.sql.gz | gunzip | pv | mysql -u root -p --batch your_database