xxxxxxxxxx
mysql -h hostname -u root -p databasename < path/filename.sql;
xxxxxxxxxx
mysql -u username -p database_name < file.sql
; OR
mysql> use db_name;
mysql> source file_name.sql;
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