P
P
photosho2019-12-20 16:51:40
linux
photosho, 2019-12-20 16:51:40

Error unpacking database?

Unpacking the database via the command line using the mysql command:
mysql -uusername -ppassword database < file.sql
The command line gives the following error:

ERROR 1064 (42000) at line 1: 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 Ver 14.14 Distrib 5.7.28, for Linux (x86_64) using EditLine wrapper Copy' at line 1

What is the problem? MySQL version mismatch? How to decide?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
V
Vitaly Karasik, 2019-12-20
@photosho

Send us the output
of head -5 file.sql
or just take a look for yourself.
It seems to me that there is some kind of crooked header in the file before the real dump.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question