Page 1 of 1

Cannot load the example file

Posted: Fri Feb 02, 2007 12:44 pm
by fastmike
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.

Re: Cannot load the example file

Posted: Sat Feb 03, 2007 1:34 pm
by califdon
source c:\temp\learning_sql.sql;
it gives me error all the time says error 1064 check the manual?.
So did you? :?

Usually that error says something like:
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 ...
That should give you a clue as to where the syntax is wrong.

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.