Cannot load the example file

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
fastmike
Forum Commoner
Posts: 32
Joined: Wed Jan 24, 2007 12:52 am

Cannot load the example file

Post 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.
User avatar
califdon
Jack of Zircons
Posts: 4484
Joined: Thu Nov 09, 2006 8:30 pm
Location: California, USA

Re: Cannot load the example file

Post 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.
Post Reply