Can't restore mysqldump database backup in Ubuntu 12.04 I'm trying to restore a database backup created using mysqldump. If I do:

    $ mysqldump -u ROOT -p DATABASE_NAME &lt; DATABASE.SQL


the database remains empty, even though I get some screen output and the line "Dump completed...", followed by a timestamp. I could not spot any error messages in the output

I made sure I quit MySQL before attempting the restore and I have tried to include the password in the command line, with no success. However, if I try:

    mysql&gt;source /path_to_dump_file/DATABASE.SQL


it works just fine.

Any thoughts?

Many thanks in advance.
Try 

mysql -u ROOT -p DATABASE_NAME &lt; DATABASE.SQL


instead of

mysqldump -u ROOT -p DATABASE_NAME &lt; DATABASE.SQL