Unable to import MySQL database due to syntax error

But why? I imported it in OS X and on another Linux machine, this one, however, refuses ..

Where am I going wrong?

Conclusion:

mysql> mysql -u root -p expl </tmp/explore.sql;

ERROR 1064 (42000): You have an error in the SQL syntax; check the manual that matches your MySQL server version for the correct syntax to use next to 'mysql -u root -p research </tmp/explore.sql' on line 1

+3
source share
2 answers

shell MySQL. BASH ( ), MYSQL.

Linux:

$ mysql -u root -p explore < /tmp/explore.sql;

Windows:

C:\> mysql -u root -p explore < c:\tmp\explore.sql;
+4

source /tmp/explore.sql;

mysql

mysql, , , .

+1

Source: https://habr.com/ru/post/1777661/


All Articles