How can I import a database with MySQL from terminal

Question

How can I import a database with mysql from terminal   I cannot find the exact syntax

User · Answer

From Terminal   mysql -uroot -p --default-character-set utf8 database name  lt  database path database sql

User · Answer

There has to be no space between -p and password  mysql -u  dbusername  -p dbpassword   databasename   lt   home serverusername public html restore db database file sql   I always use it  it works perfectly  Thanks to ask this question  Have a great day  Njoy

User · Answer

Assuming you re on a Linux or Windows console   Prompt for password   mysql -u  lt username gt  -p  lt databasename gt   lt   lt filename sql gt    Enter password directly  not secure    mysql -u  lt username gt  -p lt PlainPassword gt   lt databasename gt   lt   lt filename sql gt    Example   mysql -u root -p wp users  lt  wp users sql  mysql -u root -pPassword123 wp users  lt  wp users sql   See also   4 5 1 5  Executing SQL Statements from a Text File    Note  If you are on windows then you will have to cd  change directory   to your MySQL bin directory inside the CMD before executing the command

User · Answer

Preferable way for windows    Open the console and start the interactive MySQL mode use  lt name of your database gt   source  lt path of your  sql gt

User · Answer

Before running the commands on the terminal you have to make sure that you have MySQL installed on your terminal   You can use the following command to install it   sudo apt-get update sudo apt-get install mysql-server   Refrence here   After that you can use the following commands to import a database   mysql -u  lt username gt  -p  lt databasename gt   lt   lt filename sql gt

User · Answer

mysql -u  lt USERNAME gt  -p  lt DB NAME gt   lt   lt dump file path gt   -u - for Username  -p - to prompt the Password  Eg  mysql -u root -p mydb  lt   home db backup sql  You can also provide password preceded by -p but for the security reasons it is not suggestible  The password will appear on the command itself rather masked

User · Answer

After struggling for sometime I found the information in https   tommcfarlin com importing-a-large-database    Connect to Mysql  let s use root for both username and password    mysql -uroot -proot  Connect to the database  let s say it is called emptyDatabase  your should get a confirmation message    connect emptyDatabase    3 Import the source code  lets say the file is called mySource sql and it is in a folder called mySoureDb under the profile of a user called myUser   source  Users myUser mySourceDB mySource sql

User · Answer

in the terminal type   mysql -uroot -p1234  use databasename  source  path filename sql

User · Answer

Directly from var www html  mysql -u username -p database name  lt   path to file sql   From within mysql   mysql gt  use db name  mysql gt  source backup-file sql

User · Answer

Open Terminal Then   mysql -u root -p   eg - mysql -u shabeer -p   After That Create a Database   mysql gt  create database  Name     eg - create database INVESTOR    Then Select That New Database  INVESTOR    mysql gt  USE INVESTOR    Select the path of sql file from machine   mysql gt  source  home shabeer Desktop new file sql    Then press enter and wait for some times if it s all executed then   mysql gt  exit

User · Answer

The simplest way to import a database in your MYSQL from the terminal is done by the below-mentioned process -   mysql -u root -p root database name  lt  path to your  sql file   What I m doing above is     Entering to mysql with my username and password  here it is root  amp  root  After entering the password I m giving the name of database where I want to import my  sql file  Please make sure the database already exists in your MYSQL The database name is followed by  lt  and then path to your  sql file  For example  if my file is stored in Desktop  the path will be  home Desktop db sql   That s it  Once you ve done all this  press enter and wait for your  sql file to get uploaded to the respective database

User · Answer

mysql -u username -ppassword dbname  lt   path file-name sql   example  mysql -u root -proot product  lt   home myPC Downloads tbl product sql   Use this from terminal

User · Answer

Explanation    First create a database or use an existing database  In my case  I am using an existing database Load the database by giving  lt name of database gt    ClassicModels in my case and using the operator  lt  give the path to the database   sakila-data sql By running show tables  I get the list of tables as you can see     Note   In my case I got an error 1062  because I am trying to load the same thing again

User · Answer

Below command is working on ubuntu 16 04  I am not sure it is working or not other Linux platforms  Export SQL file    mysqldump -u  user name  -p  database name   gt   database name sql      Example    mysqldump -u root -p max development  gt  max development sql  Import SQL file    mysqldump -u  user name  -p  database name   lt   file name sql    Example  mysqldump -u root -p max production  lt  max development sql  Note SQL file should exist same directory

User · Answer

Open the MySQL Command Line Client and type in your password Change to the database you want to use for importing the  sql file data into  Do this by typing   USE your database name  Now locate the  sql file you want to execute  If the file is located in the main local C  drive directory and the  sql script file name is currentSqlTable sql  you would type the following      C  currentSqlTable sql   and press Enter to execute the SQL script file

User · Answer

I usually use this command to load my SQL data when divided in files with names   000-tableA sql  001-tableB sql  002-tableC sql   for anyvar in   sql  do  lt path to your bin gt  mysql -u lt username gt  -p lt password gt    lt database name gt   lt   anyvar  done   Works well on OSX shell

User · Answer

In Ubuntu  from MySQL monitor  you have already used this syntax   mysql gt  use  lt dbname gt  -  The USE statement tells MySQL to use dbname as the default database for subsequent statements  mysql gt  source  lt file-path gt    for example   mysql gt  use phonebook   mysql gt  source  tmp phonebook sql    Important  make sure the sql file is in a directory that mysql can access to like  tmp

User · Answer

If you are using sakila-db from mysql website  It s very easy on the Linux platform just follow the below-mentioned steps  After downloading the zip file of sakila-db  extract it  Now you will have two files  one is sakila-schema sql and the other one is sakila-data sql      Open terminal Enter command mysql -u root -p  lt  sakila-schema sql Enter command mysql -u root -p  lt  sakila-data sql Now enter command mysql -u root -p and enter your password  now you have entered into mysql system with default database  To use sakila database  use this command use sakila  To see tables in sakila-db  use  show tables command     Please take care that extracted files are present in home directory

[mysql] How can I import a database with MySQL from terminal?

Examples related to mysql

Examples related to import