Answers for "mysql import dump"

linux command line import mysql database

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

import dump mysql

mysql -u username -p database_name < file.sql

import mysql dump command line

mysql -u username -p database_name < file.sql

mysql dump

mysqldump -u username -p --skip-lock-tables database_name > path/filename.sql

mysql load sql from file

mysql> use db_name;
 mysql> source file_name.sql;

how to import mysql database command line

mysql>create database yourDatabaseName;
mysql>use yourDatabaseName;