Re: Recovery

[Felix Geerinckx]

Justus Singarayan wrote:

> I took a backup of my Database using mysqldump utility.
>
> But I couldn't restore it.I tried it using the followibg command
>
> mysql db_name < backup.sql
>
> it shows an error like this..
>
> ERROR 1064 at line 1: 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 'Enter password:
> DROP TABLE IF EXISTS employeemaster' at line 1

Use a text editor to remove the line that reads 'Enter password:' at the top of your backup.sql file and try again.

How did you invoke the mysqldump command?

--
felix