0 purchases
Description:
mysqldump 0.0.10
Mysqldump is a django package to import and export mysql database.
Installation
* pip install mysqldump
* Add 'dbmanager' to your 'settings.py'
* Run the below command to backup all database(s) configured inside *settings.py*
```
$ ./manage.py exportdb
```
setting.py
Installed apps:
Add 'dbmanager' to your 'settings.py'
INSTALLED_APPS = [
'dbmanager',
]
TMP_DIR
Package will use system default tmp directory, if not specified.
TMP_DIR = '/var/www/html/my_project/tmp/'
DUMP_DIR
By default dump file(s) will be stored in project container directory.
Specify the location to store the dumped file(s).
DUMP_DIR = '/var/www/html/my_project/backup_dir/'
Commands
Export Database
exportdb will dump all database(s) specified inside settings.py.
$ ./manage.py exportdb
Running exportdb:
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 exportdb --databases db_name1 db_name2 ....
Running exportdb:
Selected Database: db_name1
Processing file: 20201130095543386091_db_name1.dump
Dump completed on 2020-Nov-30 09:55:43
Running exportdb:
Selected Database: db_name1
Processing file: 20201130095543920698_db_name2.dump
Dump completed on 2020-Nov-30 09:55:43
To archive the dump data with gzip.
-gz, --compress
$ ./manage.py exportdb --compress
Running exportdb:
Selected Database: db_name1
Processing file: 20201130095543386091_db_name1.dump.gz
Dump completed on 2020-Nov-30 09:55:43
To dump specified table from database.
-tbl, --tables
$ ./manage.py exportdb -d db_name1 --tables tbl_name1 tbl_name2
To ignore specified table from database(s).
itbl, --ignore-table
$ ./manage.py exportdb -d db_name1 --ignore-table db_name1.tbl_name1
$ ./manage.py exportdb -d db_name1 db_name2 --ignore-table db_name1.tbl_name1 db_name2.tbl_name2
Import Database
importdb to restore the specified database.
By default package will check project container directory or DUMP_DIR for the file.
-f, --filename
$ ./manage.py importdb dbname1 -f db_name1.dump.gz
Running importdb:
Selected Database: db_name1
Processing file: db_name1.dump.gz
Restore completed on 2020-Nov-30 09:55:43
License
For personal and professional use. You cannot resell or redistribute these repositories in their original state.
Files:
Customer Reviews
There are no reviews.
