Home / ubuntu / Questions / 1064125
In Process
maria
Asked: 2018-08-11 02:56:18 +0800 CST

Backup of MySQL database

  • 772

Since I'm just a beginner in using Ubuntu 18.04 and MySQL 5.7 on it, which is the best and fastest way to do backup of database using terminal? Or do I need to search for it in some files and whatever...

mysql backup

1 Answers

  1. The default method would be to use mysqldump.

    mysqldump -u {user} -p {database} > {backup.sql}

    and you will get a text based file that holds any SQL related to that that database: table definition, content. The link will list far more options (you can for instance only dump the structure of the database, include procedures, functions and many more)

    • 0