Answers for "how to import database using mysql command line"

linux command line import mysql database

# if your database is not locally hosted
mysql -u username -p -h dbhost dbname < filename.sql

Posted by: Guest on June-25-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 "how to import database using mysql command line"