I have use Ubuntu 14.04, in mysql, not able to login through phpmyadmin. So, i need to backup mysql database. How can i do this. any one help for this issues.

advanced thanks.

By Udaya Kumar-PHP


1 Answer 1


That is easily done by going to a terminal window by pressing Ctrl+Alt+T and typing:

For a single database:

mysqldump -u szUserName -p szDatabaseName > /path/to/file

For multiple databases:

mysqldump -u szUserName -p --databases szDatabaseName1  szDatabaseName2 szDatabaseName3 > /path/to/file 

For all databases:

mysqldump -u szUserName -p --all-databases > /path/to/file 

Where szUserName is obviously your username, szDatabaseName1 is *your database name and /path/to/file is the path to the export file E.G. ./dump/db_backup.sql

  • 1
    Welcome to Ask Ubuntu! ;-) You just received an edit and your first upvote! 0:-) Could you please review my edits and also review the editing help to improve the readability of your answers in the future... ;-)
    – Fabby
    Commented Jun 25, 2019 at 12:15

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .