dr_dumb99 — 2010-04-27T07:10:40-04:00 — #1
I want ot import "Employees" sample database. Iam have tried following two files to import with same result. Files are :
Iam receving followin error:
Error occured at:2010-04-27 10:07:33
Error Code: 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 'source load_departments.dump' at line 1
Iam using WAMP version (2.0) and Mysql version (5.1.36)
Thanks in advance
guido2004 — 2010-04-27T07:46:39-04:00 — #2
What exactly do you do to import these files?
dr_dumb99 — 2010-04-27T07:51:36-04:00 — #3
All "employees" database -> (Tables + data)
guido2004 — 2010-04-27T08:22:06-04:00 — #4
No, I mean how do you do it technically.
Do you use PHPMyAdmin? A PHP script?
What command/query do you run?
graspit — 2010-04-27T15:26:22-04:00 — #5
Try to empty the database before importing your sql sample file.
dr_dumb99 — 2010-04-27T23:59:55-04:00 — #6
1- Iam using SQLYOG for importing MYSQL dump.
2- I deleted the 'employess' database and recreated it from scratch, still getting same error.
guido2004 — 2010-04-28T02:59:02-04:00 — #7
I don't know sqlyog, but from their site it seems to me you pay for it. Don't they give some support?
Do you use some option (button or whatever) to do the import? Or do you run a query? What query?
dr_dumb99 — 2010-04-28T04:37:51-04:00 — #8
Same problem in PhpMyAdmin also
guido2004 — 2010-04-28T05:11:58-04:00 — #9
Yeah, well, if you just ignore my questions, I won't be able to help you.
Maybe someone else.
r937 — 2010-04-28T07:55:21-04:00 — #10
okay, somebody else
please show the first dozen or so lines of the sql file that you attempted to run in phpmyadmin