mysqldump 0.0.7

Mysqldump is a django package that is used to generate the logical backup of the MySQL database

Mysqldump is a django package used to generate the database backup(s) and to restore it.

Installation

* pip install mysqldump
* Add 'backupdb' to your 'settings.py'
* Run the below command to backup all database(s) configured inside *settings.py*
    * ./manage.py backupdb

setting.py

---

** Installed apps: **

    INSTALLED_APPS = [
        'backupdb',
    ]

** TMP_DIR **

    TMP_DIR = '/var/www/html/my_project/tmp/'

By default package will use system tmp directory.

** DUMP_DIR **

    DUMP_DIR = '/var/www/html/my_project/backup_dir/'

Specify the location to store the dumped data.

Commands

---

if you use the backupdb option alone, entire database(s) are dumped.

    ./manage.py backupdb

Running backupdb:
Selected Database: db_name1
Processing file: 20201130095543386091_db_name1.dump
Dump completed on 2020-Nov-30 09:55:43

To dump specified database using database name.

-d, --databases

    ./manage.py backupdb --databases db_name1 db_name2 ....

Running backupdb:
Selected Database: db_name1
Processing file: 20201130095543386091_db_name1.dump
Dump completed on 2020-Nov-30 09:55:43
Running backupdb:
Selected Database: db_name1
Processing file: 20201130095543920698_db_name2.dump
Dump completed on 2020-Nov-30 09:55:43

To compress the dump data with gzip.

-gz, --compress

    ./manage.py backupdb --compress

Running backupdb:
Selected Database: db_name1
Processing file: 20201130095543386091_db_name1.dump.gz
Dump completed on 2020-Nov-30 09:55:43