How to create a mysql backup from command line

MySQL provides a great command line utility to take backups of your MySQL database. mysqldump command line utility is available with MySQL installation (bin directory) and can be used to achieve this.

  1. Login to your server with root user

  2. Use following command for taking backup of your MySQL database using mysqldump utility.


mysqldump –u[user name] –p[password] [database name] > [dump file]

Our support team will also help you with backup management and can setup automated backups for you. You can always open a ticket with us for further help.
  • 0 Users Found This Useful
Was this answer helpful?