Mysqldump is a django package that is used to generate the logical backup of the MySQL database
Project description
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
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
mysqldump-0.0.7.tar.gz
(9.6 kB
view hashes)