How i can import my database dump file in mysql in ubuntu server

Question

i am executing query for importing sql dump in ubuntu

 mysql -u username - p passsword databasenme < var/www/sql.sql;
error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql -u

exit first if you have login in mysql from your terminal. fire your command from your home. hit exit command first. — Nitin Dhomse
– Nitin Dhomse, Commented Feb 1, 2016 at 12:25

mansoor.khan · Accepted Answer · 2016-02-01 12:32:09Z

3

There should not be any blank space between -p and the password.

mysql -u username -p<PASSWORD HERE> databasenme < var/www/sql.sql;

UPDATE:

I assumed you weren't logged in to mysql already. If you are, you should exit from mysql console and then retry.

edited Feb 1, 2016 at 12:32

answered Feb 1, 2016 at 12:17

mansoor.khan

2,66629 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mr Lister · Accepted Answer · 2016-02-07 21:36:32Z

3

You can import .sql file using :

mysql -u <user> -p<password> <dbname> < mysqlfile.sql

Note: There shouldn't space between -p and <password>

Reference: http://dev.mysql.com/doc/refman/5.0/en/mysql-batch-commands.html

Time taken for importing huge files most importantly it takes more time is because default setting of mysql is "autocommit = true", you must set that off before importing your file.

First open MySQL:

mysql -u root -p

Then, You just need to do following :

mysql>use your_db

mysql>SET autocommit=0 ; source the_sql_file.sql ; COMMIT ;

edited Feb 7, 2016 at 21:36

Mr Lister

46.8k15 gold badges118 silver badges156 bronze badges

answered Feb 1, 2016 at 12:27

Ninju

2,5322 gold badges16 silver badges21 bronze badges

2 Comments

Sarjerao Ghadage Over a year ago

i have relogged to database and use my database but when i fire query it give same error

Ninju Over a year ago

If you set a password for your user, you have to add -p parameter, regardless if you specify it on command line or in virtual mode. mysql -u yourUserName -poptionallyYourPassword_no_space_here_if_you_specify_one -h localhostOrWhatever yourDatabaseName < b3.sql

Rogin Thomas · Accepted Answer · 2016-02-01 12:27:57Z

2

You are logged in to mysql. press ctl+z to exit and try again.

answered Feb 1, 2016 at 12:27

Rogin Thomas

7729 silver badges17 bronze badges

Comments

esperant · Accepted Answer · 2016-02-02 10:44:10Z

1

don't write user's password on this line, type only flag -p , and in new line enter password:

$ mysql -u user -p database_name < your_file.sql
Enter password:

EDIT:

Check .sql file for syntax, maybe have a syntax error in the file.

edited Feb 2, 2016 at 10:44

answered Feb 1, 2016 at 12:39

esperant

16311 bronze badges

3 Comments

Sarjerao Ghadage Over a year ago

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near

esperant Over a year ago

@Raj, can you show .sql file, i think you have a syntax error in the file. Check file for syntax

esperant Over a year ago

@Raj, Click the green outlined checkmark to the left of the answer that solved your problem. This marks the answer as "accepted", and by extension the question as "has an accepted answer". p.s It is necessary for those who are faced with the same problem.

Collectives™ on Stack Overflow

How i can import my database dump file in mysql in ubuntu server

4 Answers 4

Comments

2 Comments

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

2 Comments

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related