Answers for "mysql import file to database"

mysql import sql file

mysql -u username -p database_name < file.sql

Posted by: Guest on February-10-2020

mysql import from sql file

mysql -u username -p database_name < file.sql
; OR
 mysql> use db_name;
 mysql> source file_name.sql;

Posted by: Guest on August-26-2020

import database mysql

#!/bin/sh
mysql -u root --password="${MYSQL_ROOT_PASSWORD}" --database=projectdb </tmp/projectdb.sql &&
  rm /tmp/projectdb.sql

Posted by: Guest on September-18-2021

Code answers related to "mysql import file to database"