Import Sql File Mysql Command Line System
Import Sql File Mysql Command Lines
Mysql Import Sql File Command Line Ubuntu
Import Sql File Mysql Command Line Download
Import Sql File Mysql Command Line Windows

Active29 days ago

I have a .sql file with an export from phpMyAdmin. I want to import it into a different server using the command line.

From the normal command line, you can import the dump file with the following command: mysql -u username -p new_database sql username is the username you can log in to the database with.

H ow do I import a MySQL.SQL text file to MySQL database sever using command line or gui tools? You can import a MySQL script (or.sql) file into MySQL server using Unix / Linux shell prompt.
Method #2: Use the mysql program. You can import a MySQL database from the command line using the mysql program. To do this, follow these steps: Transfer the dbexport.sql file to your A2 Hosting account using SCP, SFTP, or FTP. Log in to your A2 Hosting account using SSH.

I have a Windows Server 2008 R2 installation. I placed the .sql file on the C drive, and I tried this command

It is not working. I get syntax errors.

How can I import this file without a problem?
Do I need to create a database first?

Peter Mortensen

14.4k19 gold badges88 silver badges117 bronze badges

JaylenJaylen

14.2k30 gold badges88 silver badges162 bronze badges

45 Answers

12 next

Try:

Check MySQL Options.

Note-1: It is better to use the full path of the SQL file file.sql.

Note-2: Use -R and --triggers to keep the routines and triggers of original database. They are not copied by default.

Note-3 You may have to create the (empty) database from mysql if it doesn't exist already and the exported SQL don't contain CREATE DATABASE (exported with --no-create-db or -n option), before you can import it.

bansibansi

39.1k6 gold badges33 silver badges44 bronze badges

A common use of mysqldump is for making a backup of an entire database:

You can load the dump file back into the server like this:

UNIX

The same in Windows command prompt:

PowerShell

MySQL command line

Black

5,35514 gold badges65 silver badges131 bronze badges

vladkrasvladkras

11.2k2 gold badges27 silver badges45 bronze badges

Regarding the time taken for importing huge files: most importantly, it takes more time because the default setting of MySQL is autocommit = true. You must set that off before importing your file and then check how import works like a gem.

You just need to do the following thing:

Hexaholic

2,1736 gold badges26 silver badges32 bronze badges

Paresh BehedeParesh Behede

3,5971 gold badge12 silver badges10 bronze badges

Among all the answers, for the problem above, this is the best one:

Manoj KumarManoj Kumar

2,5981 gold badge11 silver badges23 bronze badges

We can use this command to import SQL from command line:

For example, if the username is root and password is password. And you have a database name as bank and the SQL file is bank.sql. Then, simply do like this:

Remember where your SQL file is. If your SQL file is in the Desktop folder/directory then go the desktop directory and enter the command like this:

And if your are in the Project directory and your SQL file is in the Desktop directory. If you want to access it from the Project directory then you can do like this:

Peter Mortensen

14.4k19 gold badges88 silver badges117 bronze badges

Amrit DhunganaAmrit Dhungana

2,7265 gold badges26 silver badges34 bronze badges

Open the MySQL command line
Type the path of your mysql bin directory and press Enter
Paste your SQL file inside the bin folder of mysql server.
Create a database in MySQL.
Use that particular database where you want to import the SQL file.
Type source databasefilename.sql and Enter
Your SQL file upload successfully.

Peter Mortensen

14.4k19 gold badges88 silver badges117 bronze badges

user4412947user4412947

If you already have the database, use the following to import the dump or the sql file:

if you don't you need to create the relevant database(empty) in MySQL, for that first log on to the MySQL console by running the following command in terminal or in cmd

And when prompted provide the password.

Next, create a database and use it:

Then import the sql or the dump file to the database from

Note: if your terminal is not in the location where the dump or sql file exists, use the relative path in above.

Peter Mortensen

Import Sql File Mysql Command Line System

14.4k19 gold badges88 silver badges117 bronze badges

Kasun SiyambalapitiyaKasun Siyambalapitiya

1,6333 gold badges19 silver badges37 bronze badges

Peter Mortensen

14.4k19 gold badges88 silver badges117 bronze badges

ShiksShiks

Go to the directory where you have the MySQL executable. -u for username and -p to prompt for the password:

Peter Mortensen

14.4k19 gold badges88 silver badges117 bronze badges

Tanmay PatelTanmay Patel

Easiest way to import into your schema: