Mysql Database Import Tutorial with Examples
Mysqlimport command is used to load data infile into Mysql or Mariadb servers. Mysqlimport is generally used by providing sql file.
mysqlimport is like below.
mysqlimport OPTIONS DBNAME FILE
OPTIONis used provide detailed configuration
DBNAMEis the name of the database we want to import
FILEis the file which contains the data and schema
The first example is simply importing the data file into mysql database. We will provide the username with
-u and insert into database name
students the sql file named
$ mysqlimport -uroot students newstudents.sql
Provide Password Interactively
We may need to provide the password for the user. We can use
-p option to provide the password. In this example we will use user
ismail and provide password interactively.
$ mysqlimport -u ismail -p students newstudents.sql
Provide Password Batch Mode in Clear Text
Another practical way to provide password is batch mode. But keep in mind this is a security violation for the most of the situations. We will provide the password in cleartext with
-p option. In this example the password is
$ mysqlimport -u ismail -p sosecret students newstudents.sql
Import From Mysql Interactive Shell
We can use mysql shell in order to import sql files. In order to use mysql interactive shell for sql file import we should open the shell.
$ mysql -u root -p
and then we will select the database we want to import given sql file.
and the last step is specifying the sql file with