How to import "Employees" sample database in WAMP

Databases
1

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:


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

2

What exactly do you do to import these files?

3

All “employees” database -> (Tables + data)

4

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

5

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

6

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

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?

8

Same problem in PhpMyAdmin also

9

Yeah, well, if you just ignore my questions, I won’t be able to help you.
Maybe someone else.
Goodluck :slight_smile:

10

okay, somebody else

please show the first dozen or so lines of the sql file that you attempted to run in phpmyadmin