How to import "Employees" sample database in WAMP

**dr_dumb99** · Apr 27, 2010 04:10

Hi!
I want ot import "Employees" sample database. Iam have tried following two files to import with same result. Files are :
- employees.sql
- employees_partitioned.sql

Iam receving followin error:

Code:

Query:
source load_departments.dump 

Error occured at:2010-04-27 10:07:33
Line no.:108
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** · Apr 27, 2010 04:46

What exactly do you do to import these files?

**dr_dumb99** · Apr 27, 2010 04:51

All "employees" database -> (Tables + data)

**guido2004** · Apr 27, 2010 05:22

No, I mean how do you do it technically.
Do you use PHPMyAdmin? A PHP script?
What command/query do you run?

**graspit** · Apr 27, 2010 12:26

Try to empty the database before importing your sql sample file.

**dr_dumb99** · Apr 27, 2010 20:59

1- Iam using SQLYOG for importing MYSQL dump.
2- I deleted the 'employess' database and recreated it from scratch, still getting same error.

**guido2004** · Apr 27, 2010 23:59

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?