hi. i bought a book php with mysql and installed everything. mysql, easyphp, apache. everything is working fine. i used the winestore example database from the book also. i bought another book learningSQL and they have asked us to download the learning_sql file which contains the bank database. so i went into my shell command as a root and i am trying to load the sql file by this command.
source c:\temp\learning_sql.sql;
it gives me error all the time says error 1064 check the manual?.
OUTFILE disables.
please anyone help me out in loading this database. i appeciate all your help.
Cannot load the example file
Moderator: General Moderators
Re: Cannot load the example file
So did you?source c:\temp\learning_sql.sql;
it gives me error all the time says error 1064 check the manual?.
Usually that error says something like:
That should give you a clue as to where the syntax is wrong.ERROR 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 ...
I have had problems transferring a database with an sql file due to the difference in versions between the MySQL installation that created the file and the installation to which I'm transferring. In my case, I had to do a lot of editing of the sql file to remove syntax that wasn't supported in the (older) version of MySQL that I was transferring the database to.