Mysql command returns no errors and doesn't import the sql file. Why?

Question

I'm executing on a Centos Linux server this command:

mysql -u root -p mydatabase < dump.sql

I enter the password. It seems that all is ok because I absolutely get no errors, no messages that something happened. But sadly, the file is not imported!

Tryed in different ways: -Putting the sql file in another location. -Creating the DB first and than without the DB. -Avoiding the dbname -Adding max_allowed_packet=800M in /etc/my.cnf (because the file is 490mb) -Restarted Mysql. But nothing to do. No errors, no import. I'm stuck and in panic. What to do? ?

Mukesh S · Accepted Answer · 2013-07-19 21:23:08Z

1

If you have already created database then use below steps to import data from .sql file

DataBase to use:

 use DataBaseName;

Give the source file path

source /path/to/dump.sql;

Hope this will help

answered Jul 19, 2013 at 21:23

Mukesh S

2,88619 silver badges24 bronze badges

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

3 Comments

Claudio Ferraro Over a year ago

This led me to the answer but I had to split the database in different SQL files too. Imported it in MySqlWorkbench and exported again. I think that it was related to some errors in the SQL but very strange that no errors displayed at all.

Mukesh S Over a year ago

This might be because your dump file have more than one database in it, if this the case then you need to create separate dump files for each DB then source it using the above steps.

Mai Elshiashi Over a year ago

I have the same problem and I tried this command and I see that rows are inserted but when I check the tables of the database I find nothing. Any idea why this happens?

Abishek · Accepted Answer · 2023-05-19 11:08:33Z

-1

please check your dump file it may be empty

answered May 19, 2023 at 11:08

Abishek

1

1 Comment

Community Over a year ago

Your answer could be improved with additional supporting information. Please edit to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers in the help center.

Collectives™ on Stack Overflow

Mysql command returns no errors and doesn't import the sql file. Why?

2 Answers 2

3 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related