Metadata-Version: 2.1
Name: mysqldump
Version: 0.0.10
Summary: Mysqldump is a django package to import and export mysql database.
Home-page: UNKNOWN
Author: Nandhakumar D
Author-email: dnandhakumars@gmail.com
License: MIT
Description: 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
        
        ```
Keywords: mysqldump,backup,restore
Platform: UNKNOWN
Classifier: Development Status :: 4 - Beta
Classifier: Intended Audience :: Developers
Classifier: Operating System :: POSIX :: Linux
Classifier: License :: OSI Approved :: MIT License
Classifier: Programming Language :: Python :: 3
Classifier: Framework :: Django :: 3.0
Requires-Python: >=3.6
Description-Content-Type: text/markdown
