
    si                         d dl Z d dlZ	 ddZy)    Nc           
      L   dd|z   dt        |      z   d|z   ddddd	|z   | g
}t        j                  j                         }|r||d
<   	 t	        j
                  |ddd|      }y# t        j                  $ r}	t        d|	        Y d}	~	yd}	~	wt        $ r t        d       Y yw xY w)a2  
    Create a MySQL database dump using mysqldump.
    
    Args:
        db_name (str): Database name
        username (str): MySQL username
        output_file (str): Output dump file path
        password (str, optional): MySQL password
        host (str): MySQL host
        port (int): MySQL port
    	mysqldumpz--host=z--port=z--user=z--single-transactionz
--routinesz
--triggersz--eventsz--result-file=	MYSQL_PWDT)checktextcapture_outputenvzError creating MySQL dump: NFzLmysqldump command not found. Please ensure MySQL client tools are installed.)	strosenvironcopy
subprocessrunCalledProcessErrorprintFileNotFoundError)
db_nameusernameoutput_filepasswordhostportdump_commandr	   resultes
             </var/www/python-projects/worksol/horilla_backup/mysqldump.pydump_mysql_dbr      s      	DCIH;&L **//
C#K
 (( +A3/0 \]s   A# #B#6B		B#"B#)N	localhosti  )r   r   r        r   <module>r!      s    	  KO0r    