I am trying to run the following query against my database:
mysql -u [DBUSER] -p [DBNAME] < folder/folder/folder/folder/store.mysql
where the first ‘folder’ is within the root of my site, and ‘store.mysql’ is a script residing in the ‘store’ subdirectory.
Mysql complains with the following, which I can’t figure out:
#1064 - 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 [DBUSER] -p [DBNAME] < folder/folder/folder/folder/store.mysql’ at line 1
(I have changed the actual text of the error message to hide the db/folder info).
I know a little SQL but I’m very new to MySQL and it appears the issue is probably related to the path, but I tried deleting folder names and got the same results.
Any help you can provide would be sincerely appreciated!