ajoo Posted November 9, 2019 Share Posted November 9, 2019 HI, Why can't I import a table into my existing DB using the command below: mysql -u root -p mydatabase < file.sql; This has always worked but now I get the following error. Quote 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.27, for Linux (x86_64) using EditLine wrapper Copy' at line 1 mysql version is Quote vagrant@vagrant:~$ mysql --version mysql Ver 14.14 Distrib 5.7.25, for Linux (x86_64) using EditLine wrapper Thanks ! Quote Link to comment https://forums.phpfreaks.com/topic/309498-import-a-table-into-a-db/ Share on other sites More sharing options...
ajoo Posted November 9, 2019 Author Share Posted November 9, 2019 Hi, Kindly ignore the question. I think the sql is incorrect. Thanks. Quote Link to comment https://forums.phpfreaks.com/topic/309498-import-a-table-into-a-db/#findComment-1571404 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.