mysqldatabaseubuntubackupmysql-backup

MySQL backup command not working

I'm trying to take a backup of a MySQL database using the following command:

mysql -u "username" -p "databasename" > "somename.sql"

After I enter the password, it doesn't show any output/error. It doesn't show the terminal prompt. No backup file gets created.

I've used the same command successfully before. But I have no clue why it isn't working now. Any ideas?

I work on Ubuntu 14.04 LTS.

Solution

  • You are trying wrong command

    mysqldump -u "username" -p"password" "databasename" > "somename.sql"

    or it 

     mysqldump -u "username" -p "databasename" > "somename.sql"

    and type password when prompt.